This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes Commons dbcp pooling problems... Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Commons dbcp pooling problems..." Watch "Commons dbcp pooling problems..." New topic

Commons dbcp pooling problems...

Kerry Wilson
Ranch Hand

Joined: Oct 29, 2003
Posts: 254
Pooling does not seem to be working, every request to specific url executes 5 queries and opens 5 connections and leaves them open once 50 connections are open ( maxActive setting ). I get timeout error here are my settings see if there is any thing wrong. ( Followed jakarta website ):
( Tomcat / MySQL )

From what I have read the above code should work, but it doesn't please help...
[ November 08, 2004: Message edited by: Kerry Wilson ]
SCJP 1.4
Luis F Garcia

Joined: Oct 20, 2004
Posts: 6
Hi Kerry,

I've had the same problem with commons dbcp, and spent some time reviewing my code and config files. Somehow through google found that it was a bug within some version of commons dbcp. This could be your case.

As soon as I replaced the buggy jar with some older one, everything worked just fine.

Cheers !!

Luis F.
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link:
subject: Commons dbcp pooling problems...
It's not a secret anymore!