Oracle JDBC connection with Weblogic 10 datasource mapping, giving problem java.sql.SQLException: Cl

Posted by gauravkarnatak on Stack Overflow See other posts from Stack Overflow or by gauravkarnatak
Published on 2010-03-15T07:03:39Z Indexed on 2010/03/15 7:09 UTC
Read the original article Hit count: 751

Filed under:
|
|
|

Oracle JDBC connection with Weblogic 10 datasource mapping, giving problem java.sql.SQLException: Closed Connection

I am using weblogic 10 JNDI datasource to create JDBC connections, below is my config

http://www.bea.com/ns/weblogic/920.xsd"> XL-Reference-DS jdbc:oracle:oci:@abc.XL.COM oracle.jdbc.driver.OracleDriver user DEV_260908 password password dll ocijdbc10 protocol oci oracle.jdbc.V8Compatible true baseDriverClass oracle.jdbc.driver.OracleDriver 1 100 1 true SQL SELECT 1 FROM DUAL ReferenceData OnePhaseCommit

When I run a bulk task where there are lotsa connection made and closed, sometimes it gives connection closed exception for any of the task in the bulk task.

Below is detailed exception'

java.sql.SQLException: Closed Connection at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:207) at oracle.jdbc.driver.OracleStatement.ensureOpen(OracleStatement.java:3512) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3265) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3367)

Any pointers ?

Thanks in advance, Gaurav

© Stack Overflow or respective owner

Related posts about weblogic

Related posts about 10