java - Statement Closed: Next Oracle Migration 11g -
i migrating application oracle 10g oracle 11g , having trouble on method included on "osubjectsqlmapdao" (the application uses ibatis 2).
public list retrievelist(string user, string flag)throws exception { try{ logger.info("retreving list"); java.sql.resultset rs = null; map map = new hashmap(); map.put("user",user); map.put("flag",flag); map.put("listretrieved",null); list listretrieved = new arraylist(); queryforobject("dblistretrieved",map); rs = (java.sql.resultset)map.get("listretrieved"); logger.info("hasmap map " + map.size()); logger.info("hasmap map " + map.isempty()); logger.info("listretrieved map " + map.get("listretrieved ")); logger.info("listretrieved map getclass" + map.get("listretrieved ").getclass()); osubject subject = null; while (rs.next()) { subject = new oasuntos(); subject.setuser(rs.getstring(1)); subject.setcdode(rs.getstring(2)); subject.setdescrip(rs.getstring(3)); listretrieved .add(subject ); } return listretrieved ; }catch(exception e){ logger.error(e.getmessage()); throw new exception (e.getmessage()); } }
the osubject .xml defined following:
<parametermap id="parametermapretrievelist" class="map"> <parameter property="listretrieved" javatype="java.lang.object" jdbctype="oraclecursor" mode="out"/> <parameter property="user" jdbctype="varchar" javatype="java.lang.string" mode="in"/> <parameter property="flag" jdbctype="varchar" javatype="java.lang.string" mode="in"/> </parametermap> <procedure id="dblistretrieved" parametermap="parametermapretrievelist"> { ? = call as.pck_list.f_retrievelist(?,?)} </procedure>
the method worked in oracle 10g not work after migration of ddbb. besides, map list class according log oracle.jdbc.driver when not using driver , think not being referenced or exist on application.
the log trace is:
retreving list 2014-06-25 14:54:55,098 info osubjectsqlmapdao (osubjectsqlmapdao .java:1268) - hasmap map 3 2014-06-25 14:54:55,099 info osubjectsqlmapdao (osubjectsqlmapdao .java:1270) - hasmap map false 2014-06-25 14:54:55,099 info osubjectsqlmapdao (osubjectsqlmapdao .java:1273) - listretrieved map oracle.jdbc.driver.oracleresultsetimpl@4efd9ac2 2014-06-25 14:54:55,100 info osubjectsqlmapdao (osubjectsqlmapdao .java:1276) - listretrieved map getclassclass oracle.jdbc.driver.oracleresultsetimpl 2014-06-25 14:54:55,104 error osubjectsqlmapdao (osubjectsqlmapdao .java:1294) - closed statement: next
it helpful if lend me hand. in advance.
Comments
Post a Comment