Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 91116 invoked from network); 6 Jan 2007 00:37:10 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 6 Jan 2007 00:37:10 -0000 Received: (qmail 33442 invoked by uid 500); 6 Jan 2007 00:37:10 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 33434 invoked by uid 500); 6 Jan 2007 00:37:10 -0000 Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user-java@ibatis.apache.org Delivered-To: mailing list user-java@ibatis.apache.org Received: (qmail 33423 invoked by uid 99); 6 Jan 2007 00:37:10 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 05 Jan 2007 16:37:10 -0800 X-ASF-Spam-Status: No, hits=2.0 required=10.0 tests=HTML_MESSAGE X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: local policy) Received: from [140.185.212.88] (HELO ptmexu03os.ptc.pentagon.mil) (140.185.212.88) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 05 Jan 2007 16:37:01 -0800 Received: by ptmexu03os.ptc.pentagon.mil with Internet Mail Service (5.5.2656.59) id ; Sat, 6 Jan 2007 00:35:00 -0000 Message-ID: From: "Yee, Richard K CTR DMDC" To: "'user-java@ibatis.apache.org'" Subject: RE: Handle to ResultSet Date: Sat, 6 Jan 2007 00:36:39 -0000 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2656.59) Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C7312A.AD2768B4" X-Virus-Checked: Checked by ClamAV on apache.org This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C7312A.AD2768B4 Content-Type: text/plain Can you tell us what 'post-processing' you need to do on the result set? -Richard -----Original Message----- From: Satish Kumar [mailto:csatk@yahoo.com] Sent: Friday, January 05, 2007 4:34 PM To: user-java@ibatis.apache.org Subject: Re: Handle to ResultSet I did see that entry, but the example provided there maps the resultSet to a resultMap. I need the handle to the raw ResultSet. Thanks for your reply. Rgds Satish ----- Original Message ---- From: Jan Vissers To: user-java@ibatis.apache.org Sent: Friday, January 5, 2007 3:41:03 PM Subject: Re: Handle to ResultSet 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 > > > http://ibatis.apache.org/dtd/sql-map-2.dtd" ;> > > > > > jdbcType="ORACLECURSOR" mode="OUT"/> > > > > {call listError(?,?)} > > > > 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 __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ------_=_NextPart_001_01C7312A.AD2768B4 Content-Type: text/html Message
Can you tell us what 'post-processing' you need to do on the result set?
 
-Richard
-----Original Message-----
From: Satish Kumar [mailto:csatk@yahoo.com]
Sent: Friday, January 05, 2007 4:34 PM
To: user-java@ibatis.apache.org
Subject: Re: Handle to ResultSet

I did see that entry, but the example provided there maps the resultSet to a resultMap. I need the handle to the raw ResultSet.

Thanks for your reply.

Rgds
Satish

----- Original Message ----
From: Jan Vissers <Jan.Vissers@cumquat.nl>
To: user-java@ibatis.apache.org
Sent: Friday, January 5, 2007 3:41:03 PM
Subject: Re: Handle to ResultSet

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




__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
------_=_NextPart_001_01C7312A.AD2768B4--