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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]