ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jan Vissers" <Jan.Viss...@cumquat.nl>
Subject Re: Handle to ResultSet
Date Fri, 05 Jan 2007 23:41:03 GMT
Note sure whether you followed this Wiki entry:
http://opensource.atlassian.com/confluence/oss/pages/viewpage.action?pageId=5653


> Hi,
>
> I am a new user of iBATIS Ver 2.3.0. I have a requirement to get the
> handle to the ResultSet from iBATIS for post-processing.
>
> The ResultSet is from a Oracle Ref Cursor returned by a stored procedure.
> I followed the examples mentioned on the iBATIS Wiki and mailing lists,
> but have not had success.
>
> I am using JDK 1.5, the latest version of Oracle 10g JDBC drivers.
>
> Below is the SQLMap
>
> <?xml version="1.0" encoding="UTF-8" ?>
> http://ibatis.apache.org/dtd/sql-map-2.dtd">
>
> <sqlMap>
>     <parameterMap id="listErrorParameters" class="java.util.Map">
>         <parameter property="serverId" jdbcType="NUMERIC" mode="IN"/>
>         <parameter property="resultSet" javaType="java.sql.ResultSet"
> jdbcType="ORACLECURSOR" mode="OUT"/>
>     </parameterMap>
>
>     <procedure id="listError" parameterMap="listErrorParameters" >
>         {call listError(?,?)}
>     </procedure>
> </sqlMap>
>
> Sample Program:
>
>     public static main(String[] args) {
>         try{
>         String resource;
>         Reader reader;
>
>         SqlMapClient sqlMap;
>         resource = "sqlMap-config.xml";
>         reader = Resources.getResourceAsReader (resource);
>         sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);
>
>         Map paramsMap = new HashMap();
>         paramsMap.put("id", "1000");
>
>         sqlMap.queryForObject("listError", paramsMap);
>
>         System.out.println("resultSet: " + paramsMap.get("resultSet"));
>
>         }catch(Exception aoExec)
>         {
>             aoExec.printStackTrace();
>         }
>     }
>
> In the above program paramsMap.get("resultSet") always returns null, and I
> am not sure why?
>
> Any help would be greatly appreciated.
>
> Thanks
> Satish
>
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com



Mime
View raw message