Return-Path: 
 <user-java-return-17715-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 68726 invoked from network); 8 Sep 2009 14:26:01 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3)
  by minotaur.apache.org with SMTP; 8 Sep 2009 14:26:01 -0000
Received: (qmail 77037 invoked by uid 500); 8 Sep 2009 14:26:00 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 77003 invoked by uid 500); 8 Sep 2009 14:26:00 -0000
Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-java-help@ibatis.apache.org>
List-Unsubscribe: <mailto:user-java-unsubscribe@ibatis.apache.org>
List-Post: <mailto:user-java@ibatis.apache.org>
List-Id: <user-java.ibatis.apache.org>
Reply-To: user-java@ibatis.apache.org
Delivered-To: mailing list user-java@ibatis.apache.org
Received: (qmail 76964 invoked by uid 99); 8 Sep 2009 14:26:00 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 08 Sep 2009 14:26:00 +0000
X-ASF-Spam-Status: No, hits=2.2 required=10.0
	tests=HTML_MESSAGE,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of nathan.maves@gmail.com
 designates 74.125.92.144 as permitted sender)
Received: from [74.125.92.144] (HELO qw-out-1920.google.com) (74.125.92.144)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 08 Sep 2009 14:25:50 +0000
Received: by qw-out-1920.google.com with SMTP id 14so775342qwa.60
        for <user-java@ibatis.apache.org>;
 Tue, 08 Sep 2009 07:25:29 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=gamma;
        h=domainkey-signature:mime-version:received:in-reply-to:references
         :from:date:message-id:subject:to:content-type;
        bh=dlhWdJMQRH432p9gG9MAstltvv2mdJdg7PBC2gA/g8E=;
        b=l7YYkFW6i8+de6JCtrwn/QgL4nLXHPurLcbAxXPL5i/6H8tMpKhi+UNpwRbJKEtWb1
         5jUGOcolnEGr2xvls19jcsS60huMTPWjOPNsHCG9krLLhrqID3D+cWoefP8ZP8fNRr4E
         rRBJq42SE7wsNB6SvKlBODiILagKeEDy7GwCg=
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:from:date:message-id:subject:to
         :content-type;
        b=PwJFAHhgRJWiNmfzJAIfzG5iDGtQ5kLxFnBM6pJkTikMVqkC9ljUxseowSxTX/rb0o
         G5y7MGHvc0lzd0WmDHrpcb3SRRxtkEyRyIAHShWYrKpRnL4SsccPwHwZluN6RL1h1CZh
         S7hclVs736qA1HDGl4cSpog8swRyvTXVaIH+4=
MIME-Version: 1.0
Received: by 10.224.4.131 with SMTP id 3mr9874112qar.141.1252419926698; Tue,
	08 Sep 2009 07:25:26 -0700 (PDT)
In-Reply-To: <25346833.post@talk.nabble.com>
References: <25346833.post@talk.nabble.com>
From: Nathan Maves <nathan.maves@gmail.com>
Date: Tue, 8 Sep 2009 08:25:03 -0600
Message-ID: <2f55db670909080725r7a85c7ccqad690fbbe7dc3ec5@mail.gmail.com>
Subject: Re: IBatis + Stored Procedures
To: user-java@ibatis.apache.org
Content-Type: multipart/alternative; boundary=00c09f851b21d7fbd9047311bc4b
X-Virus-Checked: Checked by ClamAV on apache.org

--00c09f851b21d7fbd9047311bc4b
Content-Type: text/plain; charset=UTF-8

Post your parameter map and the actual exception you are getting.

On Tue, Sep 8, 2009 at 7:59 AM, jimmymac <james.mcguigan@sungardps.com>wrote:

>
> I seem to be having an issue with mapping and stored procedures. I'm
> passing
> in a value " O'Malley ". Shouldn't the use of  a prepared statement handle
> the apostrophe? The API is returning a message of invalid character O' from
> the DB2 database.
>
> [code]
>  <procedure id="SwipedCreditCard_insert"
> parameterMap="SwipedCreditCard_procedureMap">
>     {call ${sp.lib}.KLSCCAPI(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,  ?, ?, ?, ?, ?)}
>   </procedure>
>  [/code]
> --
> View this message in context:
> http://www.nabble.com/IBatis-%2B-Stored-Procedures-tp25346833p25346833.html
> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
> For additional commands, e-mail: user-java-help@ibatis.apache.org
>
>

--00c09f851b21d7fbd9047311bc4b
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Post your parameter map and the actual exception you are getting.<br><br><d=
iv class=3D"gmail_quote">On Tue, Sep 8, 2009 at 7:59 AM, jimmymac <span dir=
=3D"ltr">&lt;<a href=3D"mailto:james.mcguigan@sungardps.com">james.mcguigan=
@sungardps.com</a>&gt;</span> wrote:<br>

<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex;"><br>
I seem to be having an issue with mapping and stored procedures. I&#39;m pa=
ssing<br>
in a value &quot; O&#39;Malley &quot;. Shouldn&#39;t the use of =C2=A0a pre=
pared statement handle<br>
the apostrophe? The API is returning a message of invalid character O&#39; =
from<br>
the DB2 database.<br>
<br>
[code]<br>
=C2=A0&lt;procedure id=3D&quot;SwipedCreditCard_insert&quot;<br>
parameterMap=3D&quot;SwipedCreditCard_procedureMap&quot;&gt;<br>
 =C2=A0 =C2=A0 {call ${sp.lib}.KLSCCAPI(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,=
 ?, ?, ?,<br>
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, =C2=A0?, ?, ?, ?, ?)}<br>
 =C2=A0 &lt;/procedure&gt;<br>
=C2=A0[/code]<br>
<font color=3D"#888888">--<br>
View this message in context: <a href=3D"http://www.nabble.com/IBatis-%2B-S=
tored-Procedures-tp25346833p25346833.html" target=3D"_blank">http://www.nab=
ble.com/IBatis-%2B-Stored-Procedures-tp25346833p25346833.html</a><br>
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.<br>
<br>
<br>
---------------------------------------------------------------------<br>
To unsubscribe, e-mail: <a href=3D"mailto:user-java-unsubscribe@ibatis.apac=
he.org">user-java-unsubscribe@ibatis.apache.org</a><br>
For additional commands, e-mail: <a href=3D"mailto:user-java-help@ibatis.ap=
ache.org">user-java-help@ibatis.apache.org</a><br>
<br>
</font></blockquote></div><br>

--00c09f851b21d7fbd9047311bc4b--