#340 PreparedStatement and Result set close but Table is still op

[Atilla İlhan KARTAL]

Dear All;

I am working on a web application with GWT and AS400 iSeries. I closed all ResultSet and Prepared Statement on connection. (But connection is open for reuse) I look connection with wrkactjob 5 -> 14 (Display Open File). My used file is still open.

My Connection URL.
"jdbc:as400://" + getDBConfig().getServer() + "/" + getDBConfig().getDatabase() + ";naming=sql;errors=full;extended metadata=true;reuse objects=false;lazy close=true;"

I have performance problem.

[John Eberhard]

The cursor for the file has probably been pseudo-closed.

See the following for more details.

http://wiki.midrange.com/index.php/SQL#IBM_Support_Document_18874457