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

Products

• Service Virtualization

Issue/Introduction

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(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)

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

Environment

Release : 10.6, 10.7

Component : DevTest Workstation

Cause

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

Resolution

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