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

Products

• Service Virtualization

Issue/Introduction

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)

Environment

Release : 10.6

Component : DevTest Workstation

Cause

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

Resolution

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.