DevTest JDBC step insert fails: java.sql.SQLRecoverableException: Closed Connection
search cancel

DevTest JDBC step insert fails: java.sql.SQLRecoverableException: Closed Connection


Article ID: 248984


Updated On:


Service Virtualization


When trying to do an SQL insert statement, the following error is shown: 
SQLException: java.sql.SQLRecoverableException: Closed Connection

java.sql.SQLRecoverableException: Closed Connection
    at oracle.jdbc.driver.PhysicalConnection.needLine(
    at oracle.jdbc.driver.OracleStatement.closeOrCache(
    at oracle.jdbc.driver.OracleStatement.close(
    at oracle.jdbc.driver.OracleStatementWrapper.close(
    at oracle.jdbc.driver.OraclePreparedStatementWrapper.close(
    at com.itko.lisa.jdbc.JDBCNode.makeGenericCall(
    at com.itko.lisa.jdbc.JDBCNode.executeSQL(
    at com.itko.lisa.jdbc.JDBCNodeEditor.doExec(
    at com.itko.lisa.jdbc.JDBCNodeEditor$6.doCallback(
    at com.itko.util.swing.panels.ProcessingDialog$

The insert should insert the value of a property into a table.


Release : 10.6, 10.7

Component : DevTest Workstation


Having 'Returns Result Set' ticked for an insert statement causes the SQLRecoverableException
'Returns Result Set' should be ticked when doing a select statement.


To insert a value of a property into a table use a SQL statement similar to:
insert into table1 (column1) values ( ? )
A string parameter needs to be added and the value of the parameter can be the property to be inserted.

For an insert statement, the 'Returns Result Set' needs to be unticked.
If not unticked, this will show the error: SQLException: java.sql.SQLRecoverableException: Closed Connection