Guest User

Untitled

a guest
Jan 3rd, 2019
166
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.43 KB | None | 0 0
  1. <property name="maxActive" value="100"/>
  2. <property name="maxIdle" value="30"/>
  3. <property name="maxWait" value="1000"/>
  4. <property name="defaultAutoCommit" value="true"/>
  5. <property name="removeAbandoned" value="true"/>
  6. <property name="removeAbandonedTimeout" value="60"/>
  7.  
  8. 06:05:58,239 WARN [JDBCExceptionReporter] SQL Error: 17008, SQLState: null
  9. 06:05:58,239 ERROR [JDBCExceptionReporter] Closed Connection
  10. 06:05:58,244 ERROR [JDBCTransaction] JDBC rollback failed
  11. java.sql.SQLException: ORA-02396: exceeded maximum idle time, please connect again
  12.  
  13. <?xml version="1.0" encoding="UTF-8"?>
  14. <!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN"
  15. "http://www.springframework.org/dtd/spring-beans.dtd">
  16.  
  17. <beans>
  18. <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
  19. <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/>
  20.  
  21.  
  22. <property name="url" value="jdbc:oracle:thin:@192.168.0.12:1521/testSID"/>
  23. <property name="username" value="test"/>
  24. <property name="password" value="test"/>
  25. <property name="maxActive" value="1500"/>
  26. <property name="maxIdle" value="1000"/>
  27. <property name="maxWait" value="20000"/>
  28. <property name="defaultAutoCommit" value="true"/>
  29. <property name="removeAbandoned" value="true"/>
  30. <property name="removeAbandonedTimeout" value="3600"/>
  31. </bean>
  32. </beans>
Add Comment
Please, Sign In to add comment