Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <Resource name="jdbc/example"
- url="JDBC URL"
- username="userName"
- password="password"
- factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
- auth="Container"
- type="javax.sql.DataSource"
- driverClassName="oracle.jdbc.OracleDriver"
- maxActive="60"
- initialSize="2"
- minIdle = "2"
- jmxEnabled="true"
- maxWait="-1"
- timeBetweenEvictionRunsMillis="180000"
- minEvictableIdleTimeMillis="180000"
- logAbandoned="false"
- testOnBorrow="true"
- testOnConnect="true"
- suspectTimeout="120"
- validationQuery="select 1 from dual"
- validationInterval="200"
- initSQL="select 1 from dual"
- removeAbandoned="true"
- removeAbandonedTimeout="180"
- maxAge ="180000"
- accessToUnderlyingConnectionAllowed="true"/>
- java.sql.SQLRecoverableException: Closed Connection
- at oracle.jdbc.driver.OracleStatement.ensureOpen(OracleStatement.java:4051)
- at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4705)
- at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1376)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement