Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 95691 invoked from network); 6 Mar 2006 21:58:22 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 6 Mar 2006 21:58:22 -0000 Received: (qmail 66399 invoked by uid 500); 6 Mar 2006 21:58:20 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 66382 invoked by uid 500); 6 Mar 2006 21:58:19 -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 66371 invoked by uid 99); 6 Mar 2006 21:58:19 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 06 Mar 2006 13:58:19 -0800 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=HTML_MESSAGE,SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: domain of Eric.Williams@active.com designates 207.158.7.53 as permitted sender) Received: from [207.158.7.53] (HELO active.com) (207.158.7.53) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 06 Mar 2006 13:58:17 -0800 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C64169.0433D492" Subject: Columns missing/duplicated in result set Date: Mon, 6 Mar 2006 13:57:52 -0800 Message-ID: <7A90E4832E25A543AE2D5F3D6A1587B0172042@SD-EXCH01.lj.active.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Columns missing/duplicated in result set Thread-Index: AcZBaQP2P6sDddpnRGKZ/v2MwjxwRQ== From: "Eric Williams" To: X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N This is a multi-part message in MIME format. ------_=_NextPart_001_01C64169.0433D492 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable Hi all, =20 I have a stored proc in SQL Server 2000 that only ever returns one row. I've tried using the select and procedure statements, with and without result maps, but I'm getting duplicate and missing columns no matter what I do. =20 If I execute the stored procedure against my DB, I'll get back rows like "A, B, C, D, E, F". iBATIS always returns "A, A, B, B, D". =20 It's always been doubling up columns on me for some reason, but now columns are starting to disappear. This only happened after I changed the data-type of a column (this is one of the columns not showing up, but other unchanged columns have disappeared, too). =20 My XML looks like this: =20 =20 {call productGet ?} =20 I've gone as far as using an explicit result map with column index values, to no avail. =20 Any help would be much appreciated! =20 Thanks, Eric =20 ------_=_NextPart_001_01C64169.0433D492 Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable

Hi all,

 

I have a stored proc in SQL Server 2000 that only = ever returns one row. I’ve tried using the select and procedure statements, = with and without result maps, but I’m getting duplicate and missing columns = no matter what I do.

 

If I execute the stored procedure against my DB, = I’ll get back rows like “A, B, C, D, E, F”. iBATIS always returns = “A, A, B, B, D”.

 

It’s always been doubling up columns on me for = some reason, but now columns are starting to disappear. This only happened = after I changed the data-type of a column (this is one of the columns not = showing up, but other unchanged columns have disappeared, = too).

 

My XML looks like this:

 

         =    <parameterMap id=3D"productGetParameterMap" = class=3D"map">

         =             &= nbsp;  <parameter property=3D"id" jdbcType=3D"GUID" javaType=3D"java.util.UUID" = mode=3D"IN"/>

         =    </parameterMap>

         =   

         =    <procedure id=3D"productGet"

         =             &= nbsp;  = parameterMap=3D"productGetParameterMap"

         =             &= nbsp;  = resultClass=3D"com.test.Product">

         =             &= nbsp;  {call productGet ?}

         =    </procedure>

 

I’ve gone as far as using an explicit result = map with column index values, to no avail.

 

Any help would be much = appreciated!

 

Thanks,

Eric

 

------_=_NextPart_001_01C64169.0433D492--