I think its better to direct these questions to the dbcp guys; dbcp is, as is usual for Jakarta stuff, extremely undocumented - but _someone_ must know the answers to these questions.
I *don't*; I've ALWAYS used an appserver datasource in production. If you can't get definitive answers from dbcp guys, try out c3p0 or proxool. I *know* that Steve Waldman will support c3p0 properly. > Connections only time out late at night or over the weekend when the web > app in question is not being used. > > 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 > ------------------------------------------------------- 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