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

Reply via email to