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

Popular posts from this blog

google api - Incomplete response from Gmail API threads.list -

Installing Android SQLite Asset Helper -

Qt Creator - Searching files with Locator including folder -