Meaningless Drivel is fun!*
The moose likes JDBC and the fly likes Problem: Unable to allocate a connection Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Problem: Unable to allocate a connection " Watch "Problem: Unable to allocate a connection " New topic
Author

Problem: Unable to allocate a connection

Gabriel Tomoloju
Greenhorn

Joined: Feb 23, 2004
Posts: 20
Hello,
I was accessing ingres directly via a Java application, using jdbc-odbc.
But, i sometimes get this error:

failed to set isolation level: Unable to allocate a connection

NOTE: I am using the Caribou Lake driver

Any ideas?
Thanks.
Sutham Rojanusorn
Greenhorn

Joined: Jul 10, 2004
Posts: 4
I think you should consult with your jdbc driver document for this
to see .. whether you can set database transaction.
Manish M Malhotra M
Greenhorn

Joined: Jul 06, 2004
Posts: 6
Hello,
I was accessing ingres directly via a Java application, using jdbc-odbc.
But, i sometimes get this error:

failed to set isolation level: Unable to allocate a connection

NOTE: I am using the Caribou Lake driver

Any ideas?
Thanks.
--------------------------------------------------------------------------------
Posts: 11 | Registered: Feb 2004 | IP: Logged

Sutham Rojanusorn
greenhorn
Member # 76563
posted July 10, 2004 10:13 AM
--------------------------------------------------------------------------------
I think you should consult with your jdbc driver document for this
to see .. whether you can set database transaction
===========================================================================
***************************************************************************
From Manish:

I think Sutham is correct, refer the jdbc driver doc. May be you need to set the transaction level. And what is the default transaction level with this driver would be helpful for you.

regards,
Manish
SE, PCS


Its difficult to break a hard nut but its not impossible.
arnel nicolas
Ranch Hand

Joined: Dec 16, 2003
Posts: 149
i guess this happens when you try to create multiple SQL statement in the same instance of the connection. The JDBC-ODBC bridge does not support this. If you want, you can create another instance on your JDBC connection then create your other SQL statement to this connection(resource intensive activity). Other than that try using the JDBC driver that comes with your database, besides JDBC-ODBC bridge has limitted functionality.
 
 
subject: Problem: Unable to allocate a connection
 
Similar Threads
EJB application fails to load in WAS5.0
Control the Connections in the Connection Pool?
Unable to allocate shared memory
Unable to locate shared memory
J2CA0020E : Is it important to select the correct DB2 JDBC Provider