Ya, c3p0 is better anyways. And Steve is always ready to help.

Travis

Gavin King wrote:

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

.




------------------------------------------------------- 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

Reply via email to