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

Reply via email to