Hibernate Community • View topic - DBCP 1.2 connection pool trouble

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

DBCP 1.2 connection pool trouble

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

alphafoo

Post subject: DBCP 1.2 connection pool trouble

Posted: Fri Jul 09, 2004 5:38 pm

Newbie

Joined: Thu Jun 03, 2004 1:52 pm
Posts: 6

I'm having some trouble using the new DBCP 1.2 with hibernate2.1.3, in that the connections do not seem to return to the pool. Every call to hibernate effectively opens a new connection, and of course this exhausts the database's resources. Reverting to DBCP1.1 and Pool1.1 fixes the problem, but I was hoping to use DBCP1.2.

Perhaps there are some properties in DBCP1.2 that aren't exposed in the current version of the DBCPConnectionProvider?

I see in various posts that C3PO is recommended by the hibernate team. That's something I'll look into using, but I'd also like to evaluate the new DBCP1.2 to see how it stacks up. Do I need to write my own version of the connection provider to do this?

Top

oneway

Post subject:

Posted: Fri Jul 09, 2004 6:14 pm

Beginner

Joined: Sun Sep 14, 2003 10:54 am
Posts: 36

That's strange. We are using DBCP 1.2 without any problems, though with HB 2.1.2

Out settings:

Code:

## connection pool

hibernate.dbcp.maxActive 50
hibernate.dbcp.whenExhaustedAction 1
hibernate.dbcp.maxWait 60000
hibernate.dbcp.maxIdle 10

## prepared statement cache

hibernate.dbcp.ps.maxActive 100
hibernate.dbcp.ps.whenExhaustedAction 1
hibernate.dbcp.ps.maxWait 60000
hibernate.dbcp.ps.maxIdle 100

HTH

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum