javax.sql.DataSource.getConnection() locks system

Posted by Ryan Elkins on Stack Overflow See other posts from Stack Overflow or by Ryan Elkins
Published on 2010-05-07T21:11:59Z Indexed on 2010/05/07 21:18 UTC
Read the original article Hit count: 400

Filed under:

apache-commons-dbcp

|

commons-dbcp

|

java

I'm using the Apache Commons DBCP library for connection pooling in a desktop application. I've done this before and never had a problem but the latest application has started sometimes locking up on the call to getConnection() on my DataSource. The application just hangs after that call.

I'm closing up my resources when I'm done with them. Is there any known reason why this might happen? I'm not even sure where to being troubleshooting this now that I've got it narrowed down to this method. It doesn't always hang - sometimes it happens fairly quickly, sometimes it takes a long time. Sometimes it doesn't happen at all, although lately I can get it to happen within a few minutes.

© Stack Overflow or respective owner

Related posts about apache-commons-dbcp

OSGI & Apache Commons-DBCP Classloading Issue

as seen on Stack Overflow - Search for 'Stack Overflow'
I inherited some code that is using the Apache commons-dbcp Connection pools in an OSGi bundle. This code works fine with Eclipse/Equinox OSGi version 3.4.3 (R34x_v20081215), commons-dbcp 1.2.2 and the postgres jdbc3 8.3.603 bundles from springsource.org. I wanted to modernize, maybe this was my… >>> More
Cannot get a connection, pool error Timeout waiting for idle object :sakai

as seen on Stack Overflow - Search for 'Stack Overflow'
iam using sakai 2.9.1 after a few operations the server stops responding and prints log:- 2014-02-20 12:48:47,085 WARN http-bio-8080-exec-18 org.sakaiproject.db.impl.BasicSqlService - Sql.dbRead: sql: select SAKAI_SITE.SITE_ID,SAKAI_SITE.TITLE,SAKAI_SITE.TYPE,SAKAI_SITE.SHO RT_DESC,SAKAI_SITE.DESCRIPTION… >>> More
javax.sql.DataSource.getConnection() locks system

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm using the Apache Commons DBCP library for connection pooling in a desktop application. I've done this before and never had a problem but the latest application has started sometimes locking up on the call to getConnection() on my DataSource. The application just hangs after that call. I'm closing… >>> More
In the java DBCP connection pool - what is an idle connection?

as seen on Stack Overflow - Search for 'Stack Overflow'
A colleague at work insists that a DBCP idle connection is a connection that has lain unused for 30 minutes. I believe a dbcp idle connection is a connection that is in the pool available to be borrowed, and an active connection is one that is borrowed. Looking through the code I found no reference… >>> More
Hive metadata permission issue

as seen on Server Fault - Search for 'Server Fault'
We are getting this error on Hive, while creating a DB / table hive> CREATE TABLE pokes (foo INT, bar STRING); FAILED: Error in metadata: javax.jdo.JDOFatalDataStoreException: Cannot get a connection, pool error Could not create a validated object, cause: A read-only… >>> More

Related posts about commons-dbcp

OSGI & Apache Commons-DBCP Classloading Issue

as seen on Stack Overflow - Search for 'Stack Overflow'
I inherited some code that is using the Apache commons-dbcp Connection pools in an OSGi bundle. This code works fine with Eclipse/Equinox OSGi version 3.4.3 (R34x_v20081215), commons-dbcp 1.2.2 and the postgres jdbc3 8.3.603 bundles from springsource.org. I wanted to modernize, maybe this was my… >>> More
Cannot get a connection, pool error Timeout waiting for idle object :sakai

as seen on Stack Overflow - Search for 'Stack Overflow'
iam using sakai 2.9.1 after a few operations the server stops responding and prints log:- 2014-02-20 12:48:47,085 WARN http-bio-8080-exec-18 org.sakaiproject.db.impl.BasicSqlService - Sql.dbRead: sql: select SAKAI_SITE.SITE_ID,SAKAI_SITE.TITLE,SAKAI_SITE.TYPE,SAKAI_SITE.SHO RT_DESC,SAKAI_SITE.DESCRIPTION… >>> More
javax.sql.DataSource.getConnection() locks system

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm using the Apache Commons DBCP library for connection pooling in a desktop application. I've done this before and never had a problem but the latest application has started sometimes locking up on the call to getConnection() on my DataSource. The application just hangs after that call. I'm closing… >>> More
In the java DBCP connection pool - what is an idle connection?

as seen on Stack Overflow - Search for 'Stack Overflow'
A colleague at work insists that a DBCP idle connection is a connection that has lain unused for 30 minutes. I believe a dbcp idle connection is a connection that is in the pool available to be borrowed, and an active connection is one that is borrowed. Looking through the code I found no reference… >>> More
Hive metadata permission issue

as seen on Server Fault - Search for 'Server Fault'
We are getting this error on Hive, while creating a DB / table hive> CREATE TABLE pokes (foo INT, bar STRING); FAILED: Error in metadata: javax.jdo.JDOFatalDataStoreException: Cannot get a connection, pool error Could not create a validated object, cause: A read-only… >>> More