File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Websphere and the fly likes Unable to get PooledConnection Exception Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Products » Websphere
Bookmark "Unable to get PooledConnection Exception" Watch "Unable to get PooledConnection Exception" New topic
Author

Unable to get PooledConnection Exception

Karthik Krishnamurthy
Ranch Hand

Joined: Feb 04, 2005
Posts: 118
Hi,
I am using MYSQL, WAS4.0 for development of a project. i am using the mysql 3.0.16 connector as driver (since was4.0 supports on jdk 1.3 I had to use the earlier verion) I am getting the following exception. Details of my configuration also follow.

Hi,
I changed the mysql driver to an earlier version and am not getting the savepoint exception anymore.
But I am now getting the following:

Method createManagedConnctionWithMCWrapper caught an exception during creation of the ManagedConnection for resource jdbc/gemstone, throwing ResourceAllocationException. Original exception: com.ibm.ws.exception.WsException: DSRA8100E: Unable to get a PooledConnection from the DataSource.

I have configured my dataqsource in websphere with 6 custom properties :

databaseName java.lang.String <database-name>?autoReconnect=true

factory java.lang.String com.mysql.jdbc.jdbc2.optional.MysqlDataSourceFactory

password java.lang.String <password>

port java.lang.String 3306

serverName java.lang.String mysql

user java.lang.String <user-name>


I have also specified the implementation classname as com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource

The datasource helper class name i have used is com.ibm.websphere.rsadapter.ConnectJDBCDataStoreHelper.

Any help will be appreciated.

thx
Karhtik
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Unable to get PooledConnection Exception