Re: [Hibernate] DBCP Connection Pooling

[Dave Tilley]

Mark Woon,

	Mucho Gracias!  I will give this a try!  Thank you muchly!!

Gavin - thanks for your help and comments. I will ask the DBCP folks for 
more details per your suggestion, since their online doc is pretty thin.

I guess I was under the impression that lots of Hibernate users make use 
of 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 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.
Dave,

Here's a list of all the extra params I have to configure DBCP.  It's 
not formatted for hibernate.cfg.xml, but you'll get the idea:

           <parameter>
             <name>maxActive</name>
             <value>5</value>
           </parameter>
           <parameter>
             <name>maxIdle</name>
             <value>3</value>
           </parameter>
           <parameter>
             <name>maxWait</name>
             <!-- should be less than your HTTP timeout -->
             <value>500</value>
           </parameter>
           <parameter>
             <name>defaulAutoCommit</name>
             <value>false</value>
           </parameter>
           <parameter>
             <name>validationQuery</name>
             <value>select 1 from dual</value>
           </parameter>
           <!-- abandoned connections properties, time in seconds -->
           <parameter>
             <name>removeAbandoned</name>
             <value>true</value>
           </parameter>
           <parameter>
             <name>removeAbandonedTimeout</name>
             <value>60</value>
           </parameter>
           <parameter>
             <name>logAbandoned</name>
             <value>true</value>
           </parameter>
Hope that helps,
-Mark


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