Howdy,
I've been having trouble getting Connection Pooling working with either
C3P0 or DBCP and using MySQL... the connection dies after some number of
hours and the next time the webapp is used, it hangs, and an ioException
is logged with a connection failure.
I have been told there is some
Ok,
So it seems to me that to use C3P0, you must set the following four
paramaters.
hibernate.c3p0.max_size =maximum connection pool size
hibernate.c3p0.min_size = minimum connection pool size
hibernate.c3p0.timeout = maximum idle time
hibernate.c3p0.max_statements =size of statement cache
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 g
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 he
DBCP -- i see now maybe that is not so true! Later on, i will get to
use an appserver datasource for the web app in question, but for now,
we're not using one quite yet.
thanks again,
-dave
Mark Woon wrote:
Dave Tilley wrote:
I would *really* appreciate some guidance with this -- i
