java.sql.SQLException: Closed Connection in Windows7

Closed Connection; nested exception is java.sql.SQLException: Closed Connection
     [java]     at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLEx
ceptionTranslator.java:83)
     [java]     at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLEx
ceptionTranslator.java:80)
     [java]     at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLEx
ceptionTranslator.java:80)
     [java]     at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:607)
     [java]     at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:792)
     [java]     at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:850)
     [java]     at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:858)
     [java]     at  
  [java]     at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
     [java]     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
     [java]     at java.lang.Thread.run(Thread.java:619)
     [java] Caused by: java.sql.SQLException: Closed Connection
     [java]     at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
     [java]     at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
     [java]     at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:199)
     [java]     at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:263)
     [java]     at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:271)
     [java]     at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:445)
     [java]     at oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:3127)
     [java]     at oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:3042)
     [java]     at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:281)
     [java]     at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource
.java:313)
     [java]     at org.springframework.jdbc.core.JdbcTemplate$SimplePreparedStatementCreator.createPreparedStatement(JdbcT
emplate.java:1322)
     [java]     at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:585)
     [java]     ... 13 more
     [java]
     [java] [2013-06-28 17:24:51,532] ERROR

 

If you are facing such problem while running a Java Application in Windows 7 environment then you will be required to add following argument while running the Application in the jvmarg tag 

 

 -Doracle.net.disableOob=true





Comments

Post a Comment

Popular Posts