Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <property name="maxActive" value="100"/>
- <property name="maxIdle" value="30"/>
- <property name="maxWait" value="1000"/>
- <property name="defaultAutoCommit" value="true"/>
- <property name="removeAbandoned" value="true"/>
- <property name="removeAbandonedTimeout" value="60"/>
- 06:05:58,239 WARN [JDBCExceptionReporter] SQL Error: 17008, SQLState: null
- 06:05:58,239 ERROR [JDBCExceptionReporter] Closed Connection
- 06:05:58,244 ERROR [JDBCTransaction] JDBC rollback failed
- java.sql.SQLException: ORA-02396: exceeded maximum idle time, please connect again
- <?xml version="1.0" encoding="UTF-8"?>
- <!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN"
- "http://www.springframework.org/dtd/spring-beans.dtd">
- <beans>
- <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
- <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/>
- <property name="url" value="jdbc:oracle:thin:@192.168.0.12:1521/testSID"/>
- <property name="username" value="test"/>
- <property name="password" value="test"/>
- <property name="maxActive" value="1500"/>
- <property name="maxIdle" value="1000"/>
- <property name="maxWait" value="20000"/>
- <property name="defaultAutoCommit" value="true"/>
- <property name="removeAbandoned" value="true"/>
- <property name="removeAbandonedTimeout" value="3600"/>
- </bean>
- </beans>
Add Comment
Please, Sign In to add comment