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.
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