tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nikola Milutinovic <Nikola.Milutino...@ev.co.yu>
Subject Re: How to set auto-commit to false on a Tomcat Connection-Pool?
Date Tue, 02 Aug 2005 13:01:27 GMT
Allistair Crossley wrote:

>I found this on the web for Struts using org.apache.commons.dbcp.BasicDataSource which
I believe Tomcat also uses. Therefore perhaps you can try defaultAutoCommit instead.
>
><data-source key="homeDS" type="org.apache.commons.dbcp.BasicDataSource">
><set-property property="driverClassName" value="oracle.jdbc.driver.OracleDriver" />
><set-property property="url" value="jdbc:oracle:thin:@localhost:1521:DBLOCAL" />
><set-property property="username" value="user" />
><set-property property="password" value="pwd" />
><set-property property="maxActive" value="10" />
><set-property property="maxWait" value="5000" />
><set-property property="defaultAutoCommit" value="false" />
><set-property property="defaultReadOnly" value="false" />
><set-property property="validationQuery" value="SELECT SYSDATE FROM DUAL" />
></data-source> 
>  
>

All of these are documented on Jakarta Commons-DBCP page.

Nix.

---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Mime
View raw message