Normally, the web app is used heavily during the day until about 9pm and then no more until the next day.
I want to take advantage of pooling with Hibernate when the app is being used heavily, but i do not want it to drop the connection afterwards when it is idle.
I simply would like some good docs for how to properly set up DBCP with Hibernate and the validation query. Such docs do not seem to exist on the Hibernate site and various mailing list postings seem to contain contradictory information about how to do this.
thanks,
-dave
Juozas Baliuka wrote:
Why do you need pooling if connections are time out. Close connection after transaction and open a new one before transaction without any kind of pooling. It must be very trivial to implement this kind of DataSource, a few lines of code.
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
------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ hibernate-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibernate-devel
------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ hibernate-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibernate-devel
