Re: [Hibernate] DBCP Connection Pooling

[Mark Woon]

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