tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nikola Milutinovic <>
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" />

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


To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message