Dave Tilley
2003-08-28 12:41:03 UTC
Ok, I am trying to get DBCP connection pooling working reliably (and not
dropping connections)...so far i am not having much success. After a
period of several hours of non-use, Hibernate will generate the familiar
ioExcpetion when the connections are timed out.
With that in mind, can someone give me a definitive list of DBCP params
that are required to be set to get this working, along with some
reasonable values???
Right now, i'm using:
"hibernate.dbcp.maxActive"
"hibernate.dbcp.maxIdle"
"hibernate.dbcp.maxWait"
"hibernate.dbcp.testOnBorrow" -> true
"hibernate.dbcp.testOnReturn" -> true
"hibernate.dbcp.validationQuery"
Do i need to set any others???? Are there any other tricks to getting
DBCP working with Hibernate that i need to know?
I have tried using C3P0 and also fooled around with this
autoreconnect=true URL, but i have given up on both of these options and
would like to get DBCP configured "the right way".
I would *really* appreciate some guidance with this -- i will be happy
to summarize what i learn and submit it for a FAQ or something if that
will help so others will have this well-documented online somewhere.
Many thanks,
-dave
dropping connections)...so far i am not having much success. After a
period of several hours of non-use, Hibernate will generate the familiar
ioExcpetion when the connections are timed out.
With that in mind, can someone give me a definitive list of DBCP params
that are required to be set to get this working, along with some
reasonable values???
Right now, i'm using:
"hibernate.dbcp.maxActive"
"hibernate.dbcp.maxIdle"
"hibernate.dbcp.maxWait"
"hibernate.dbcp.testOnBorrow" -> true
"hibernate.dbcp.testOnReturn" -> true
"hibernate.dbcp.validationQuery"
Do i need to set any others???? Are there any other tricks to getting
DBCP working with Hibernate that i need to know?
I have tried using C3P0 and also fooled around with this
autoreconnect=true URL, but i have given up on both of these options and
would like to get DBCP configured "the right way".
I would *really* appreciate some guidance with this -- i will be happy
to summarize what i learn and submit it for a FAQ or something if that
will help so others will have this well-documented online somewhere.
Many thanks,
-dave