"java.sql.SQLRecoverableException: Closed Connection" error in DevTest JDBC step
search cancel

"java.sql.SQLRecoverableException: Closed Connection" error in DevTest JDBC step


Article ID: 248984


Updated On:


Service Virtualization


The following error is shown for a DevTest JDBC step:
SQLException: java.sql.SQLRecoverableException: Closed Connection

java.sql.SQLRecoverableException: Closed Connection
    at oracle.jdbc.driver.PhysicalConnection.needLine(PhysicalConnection.java:4220)
    at oracle.jdbc.driver.OracleStatement.closeOrCache(OracleStatement.java:1431)
    at oracle.jdbc.driver.OracleStatement.close(OracleStatement.java:1410)
    at oracle.jdbc.driver.OracleStatementWrapper.close(OracleStatementWrapper.java:102)
    at oracle.jdbc.driver.OraclePreparedStatementWrapper.close(OraclePreparedStatementWrapper.java:82)
    at com.itko.lisa.jdbc.JDBCNode.makeGenericCall(JDBCNode.java:486)
    at com.itko.lisa.jdbc.JDBCNode.executeSQL(JDBCNode.java:394)
    at com.itko.lisa.jdbc.JDBCNodeEditor.doExec(JDBCNodeEditor.java:483)
    at com.itko.lisa.jdbc.JDBCNodeEditor$6.doCallback(JDBCNodeEditor.java:417)
    at com.itko.util.swing.panels.ProcessingDialog$2.run(ProcessingDialog.java:195)
    at java.lang.Thread.run(Thread.java:748)


Release : 10.6

Component : DevTest Workstation


The error may occur for incorrect syntax or if 'Returns Result Set' is incorrectly ticked.


For an INSERT statement, untick the 'Returns Result Set'
The following SQL Statement can be used:
insert into table1 (column1) values ( ? )
Add a Parameter in the parameter section for the ?

For a DB Procedure call in the JDBC step, all parameters should be listed in the Parameter panel and not in the SQL Statement itself.
Syntax in the SQL Statement panel should look like:
call mydbprocedure

Notes regarding the DB procedure syntax:
No begin, end syntax.
No braces at the end of the procedure ()
No semicolon
No curly braces

Also for a DB procedure 'Return Result Set' should not be ticked.