Meaningless Drivel is fun!
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
JavaRanch » Java Forums » Products » Websphere
Bookmark "Unable to get PooledConnection Exception" Watch "Unable to get PooledConnection Exception" New topic

Unable to get PooledConnection Exception

Karthik Krishnamurthy
Ranch Hand

Joined: Feb 04, 2005
Posts: 118
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.

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: 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

Any help will be appreciated.

I agree. Here's the link:
subject: Unable to get PooledConnection Exception
It's not a secret anymore!