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]

Reply via email to