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

Reply via email to