Return-Path: 
 <user-java-return-9182-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 60415 invoked from network); 26 Sep 2006 15:26:45 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 26 Sep 2006 15:26:45 -0000
Received: (qmail 46485 invoked by uid 500); 26 Sep 2006 15:26:27 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 46474 invoked by uid 500); 26 Sep 2006 15:26:27 -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 46399 invoked by uid 99); 26 Sep 2006 15:26:27 -0000
Received: from idunn.apache.osuosl.org (HELO idunn.apache.osuosl.org)
 (140.211.166.84)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 26 Sep 2006 08:26:27 -0700
Authentication-Results: idunn.apache.osuosl.org
 smtp.mail=anantatman@gmail.com; spf=pass
Authentication-Results: idunn.apache.osuosl.org
 header.from=anantatman@gmail.com; domainkeys=good
X-ASF-Spam-Status: No,
 hits=2.5 required=5.0 tests=DNS_FROM_RFC_ABUSE,HTML_MESSAGE
Received-SPF: pass (idunn.apache.osuosl.org: domain gmail.com designates
 66.249.82.238 as permitted sender)
DomainKey-Status: good
X-DomainKeys: Ecelerity dk_validate implementing
 draft-delany-domainkeys-base-01
Received: from [66.249.82.238] ([66.249.82.238:22156]
 helo=wx-out-0506.google.com)
	by idunn.apache.osuosl.org (ecelerity 2.1.1.8 r(12930)) with ESMTP
	id 7D/00-13339-D9649154 for <user-java@ibatis.apache.org>;
 Tue, 26 Sep 2006 08:26:22 -0700
Received: by wx-out-0506.google.com with SMTP id h30so2490700wxd
        for <user-java@ibatis.apache.org>;
 Tue, 26 Sep 2006 08:26:18 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:reply-to:sender:to:subject:in-reply-to:mime-version:content-type:references:x-google-sender-auth;
        b=qdaS79SAekLFCQGaendI4o5KDbd4nKDVWtjx/L3CC3AsGBzpwdmk+DakSgTxE2QKwOMSZ07C23VtakWoHHGlU9j+Rqt8E7gDWpGKLATuFMfHgVr5qFlOsrRtzCRXVMFyXg/kejCg3LcSoGRsqUXqSGSAwiTgioRwWbu8ikYIuPg=
Received: by 10.70.31.6 with SMTP id e6mr926183wxe;
        Tue, 26 Sep 2006 08:26:17 -0700 (PDT)
Received: by 10.70.111.18 with HTTP; Tue, 26 Sep 2006 08:26:17 -0700 (PDT)
Message-ID: <e1c5f9e0609260826n6e39a1a3m3d68ed70d2ec951d@mail.gmail.com>
Date: Tue, 26 Sep 2006 11:26:17 -0400
From: "Rahul Singh ( Anant )" <rahul.singh@anant.us>
Reply-To: rahul.singh@anant.us
Sender: anantatman@gmail.com
To: user-java@ibatis.apache.org
Subject: Re: JavaScript + iBATIS
In-Reply-To: <16178eb10609251112t116b7da1t2399eae650f33ad1@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_8894_21921178.1159284377716"
References: <a10a823c0609250836n51d29509i9b29023cb5352449@mail.gmail.com>
	 <01aa01c6e0ba$c5398d60$0302a8c0@rinaldo>
	 <019701c6e0c3$938e5120$baaaf360$@com>
	 <16178eb10609251112t116b7da1t2399eae650f33ad1@mail.gmail.com>
X-Google-Sender-Auth: 3ed7e9043a941cbb
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

------=_Part_8894_21921178.1159284377716
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Has this functionality filtered down to the .NET version yet?

Rahul

On 9/25/06, Clinton Begin <clinton.begin@gmail.com> wrote:
>
> Yep.  XML it is.  The JavaScript/DOM APIs are pretty simple for processin=
g
> results from XML.  JSON is good too...but XML is supported more widely an=
d
> by more tools.
>
> In iBATIS it's as simple as:
>
> <select id=3D"GetEmployeeXML" parameterClass=3D"string" resultClass=3D"xm=
l">
>
> No beans, no maps, nothing.  You can also use xml as a parameter or a
> string as a result depending on how simple or complex your needs are.
>
> Cheers,
> Clinton
>
> On 9/25/06, Levan Dvalishvili <dvalishvili@verticali.com> wrote:
> >
> >
> > Don't want to go into  off topic but I would prefer more feature
> > full  Yahoo
> > UI over GWT.
> >
> > anyways, the reason I think  Ibatis will do AJAX well in XML vs JSON is
> > :
> > I could get my persistence layer to give me XML ( which is possible wit=
h
> >
> > Ibatis, P.S Never tried it but documentation says so :))
> > for example if I get domain Object "A" in so and so XML format, I don't
> > even
> > need JSON, this XML (as is or transformed ) can hit as full or partial
> > AJAX
> > respond back to client . so Unless Ibatis can return JSON, as yet
> > another
> > alternative to Bean and/or XML, I would say XML format is quite enough
> > and
> > suitable already, so there is no need to "jsonize" bean or xml I think =
I
> > am
> > even thinking there s no need for JSON  at all. Am I on right thinking
> > path
> > ? :)
> >
> > Levan .
> >
> >
> > -----Original Message-----
> > From: Rinaldo [mailto:rbonazzo@sardiniapoint.it ]
> > Sent: Monday, September 25, 2006 11:54 AM
> > To: user-java@ibatis.apache.org; lmeadors@apache.org
> > Subject: R: JavaScript + iBATIS
> >
> > You can find some json example using gwt
> >
> > http://code.google.com/webtoolkit/documentation/examples/
> >
> > Rinaldo
> >
> > -----Messaggio originale-----
> > Da: larry.meadors@gmail.com [mailto:larry.meadors@gmail.com] Per conto
> > di
> > Larry Meadors
> > Inviato: luned=EC 25 settembre 2006 17.37
> > A: user-java@ibatis.apache.org
> > Oggetto: Re: JavaScript + iBATIS
> >
> > One approach that I have seen with good results is working with JSON to
> > create javascript objects with jsp.
> >
> > Larry
> >
> >
> > On 9/25/06, Levan Dvalishvili <dvalishvili@verticali.com> wrote:
> > > I would say returning XML instead of java bean and sending it to
> > > client would be one of the straight forward ways to do it would not
> > > it? Maybe running a little XSL filter prior ?
> > >
> > >
> > > Levan Dvalishvili
> > > Support LeadUS
> > > Verticali,Inc
> > > (646) 736 - 6075
> > >
> > >
> > > -----Original Message-----
> > > From: Fred Janon [mailto:fjanon@yahoo.com]
> > > Sent: Sunday, September 24, 2006 10:35 PM
> > > To: user-java@ibatis.apache.org
> > > Subject: JavaScript + iBATIS
> > >
> > > Hi Clinton,
> > >
> > > I am very interested in seeing what you did with JavaScript & iBATIS.
> > > I am working on a Javascript framework and iBatis seems an appealing
> > > option to
> > do
> > > the peristence part of it
> > >
> > > Fred
> > >
> > > --- Clinton Begin <clinton.begin@gmail.com> wrote:
> > >
> > > > Hi there,
> > > >
> > > > I don't have any plans.  But I just did my iBATIS/Ajax demo in a
> > > > talk at NFJS yesterday.  It is pretty cool.  I may put together a
> > > > more complete example to publish somewhere.  I'd be interested in
> > > > knowing if people would considering building apps this way...
> > > >
> > > > Think just JavaScript + iBATIS.
> > > >
> > > > Clinton
> > > >
> > > > On 9/24/06, levan Dvalishvili < admin@amostudio.com> wrote:
> > > > >
> > > > >  Hi Clinton,  I saw list of events on the website, is there any
> > > > plans
> > > > > visiting New York, in near  future,monthly meetings of
> > > > www.*nyjavasig*
> > > > > .com/would be good place to give speech, "Ibatis Does AjAX
> > > > presentation "
> > > > > would be a bliss. (please J )
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > *From:* nando.dev [mailto:nando.dev@gmail.com]
> > > > > *Sent:* Saturday, September 23, 2006 3:41 PM
> > > > > *To:* user-java@ibatis.apache.org
> > > > > *Subject:* Re: question with boolean types..
> > > > >
> > > > >
> > > > >
> > > > > Hi Esperanza, the problem do you have is the type boolean of
> > > > > pl/sql
> > > > isn=B4t
> > > > > standard of JDBC, so do you have to write a wrapper to this
> > > > function.
> > > > >
> > > > > 2006/6/26, Esperanza.Echeverria@steria.es
> > > > <Esperanza.Echeverria@steria.es
> > > > > >:
> > > > >
> > > > >
> > > > > please, can anyone help me?
> > > > > my problem is calling a stored procedure in ibatis and this
> > > > functioncalled in pl/sql returns a boolean and i don=B4t know what =
are
> >
> > > > the correct
> > > > > types in this case to be put in for no obtain an error ...
> > > > >
> > > > > <parameterMap id=3D"misParametros" class=3D"java.util.HashMap" >
> > > > >     <parameter property=3D"parametro1" jdbcType=3D"VARCHAR" javaT=
ype=3D"
> > > > > java.lang.Boolean" mode=3D"OUT"/>
> > > > >     <parameter property=3D"parametro2" jdbcType=3D"VARCHAR" javaT=
ype=3D"
> >
> > > > > java.lang.String" mode=3D"IN"/>
> > > > >     <parameter property=3D"parametro3" jdbcType=3D"VARCHAR" javaT=
ype=3D"
> > > > > java.lang.String" mode=3D"IN"/>
> > > > >     <parameter property=3D"parametro4" jdbcType=3D"VARCHAR" javaT=
ype=3D"
> > > > > java.lang.String" mode=3D"IN"/>
> > > > >     <parameter property=3D"parametro5" jdbcType=3D"VARCHAR" javaT=
ype=3D"
> >
> > > > > java.lang.String" mode=3D"IN"/>
> > > > >   </parameterMap>
> > > > >  <procedure id=3D"ejecutaTieneDuplicados"
> > > > parameterMap=3D"misParametros" >
> > > > >     {? =3D call report.tiene_duplicados(?,?,?,?)}
> > > > >   </procedure>
> > > > >
> > > > > the out parameter tells me an error :
> > > > > DEBUG - {conn-100021} Connection
> > > > > DEBUG - {pstm-100022} PreparedStatement: {? =3D call
> > > > report.tiene_duplicados
> > > > > (?,?,?,?)}
> > > > > DEBUG - {pstm-100022} Parameters: [JOSELUIS, sip97.rep,
> > > > VCENTRO=3D90101,
> > > > > 19-06-2006]
> > > > > DEBUG - {pstm-100022} Types: [java.lang.String, java.lang.String,
> > > > > java.lang.String, java.lang.String] DEBUG - Initializing,
> > > > config=3D'org.apache.struts.action.LocalStrings ',
> > > > > returnNull=3Dtrue
> > > > > 06/06/26 08:47:37 DaoException
> > > > > ERROR - Ha ocurrido un error con la base de datos
> > > > > com.ibatis.dao.client.DaoException: Failed to execute
> > > > queryForObject - id
> > > > > [ejecutaTieneDuplicados], parameterObject
> > > > [{parametro4=3DVCENTRO=3D90101,
> > > > > parametro2=3DJOSELUIS, parametro3=3Dsip97.rep , parametro1=3Dtrue=
,
> > > > > parametro5=3D19-06-2006}].  Cause:
> > > > > com.ibatis.common.jdbc.exception.NestedSQLException:
> > > > > --- The error occurred in
> > > > > com/ibatis/sip/persistence/sqlmapdao/sql/Lis.xml.
> > > > > --- The error occurred while applying a parameter map.
> > > > > --- Check the Lis.misParametros.
> > > > > --- Check the statement (update procedure failed).
> > > > > --- Cause: java.sql.SQLException: ORA-06550: l=EDnea 1, columna 1=
3:
> > > > > PLS-00382: el tipo de la expresi=F3n no es correcto
> > > > > ORA-06550: l=EDnea 1, columna 7:
> > > > > PL/SQL: Statement ignored
> > > > >
> > > > >
> > > > >
> > > > >  *Esperanza Echeverr=EDa de Miguel*
> > > > > Steria Espa=F1a http://www.steria.es C/Men=E9ndez y Pelayo,3 bis =
46010
> > > > > Valencia
> > > > > Tel: + 34 96 393 87 50 Fax: +34 96 393 87 51
> > > > > esperanza.echeverria@steria.es
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > >
> > >
> >
> >
> >
>


--=20
Rahul Singh
CEO, Anant
http://www.anant.us

Office: 7033723268
Mobile: 7036555652

------=_Part_8894_21921178.1159284377716
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Has this functionality filtered down to the .NET version yet? <br>
<br>
Rahul<br><br><div><span class=3D"gmail_quote">On 9/25/06, <b class=3D"gmail=
_sendername">Clinton Begin</b> &lt;<a href=3D"mailto:clinton.begin@gmail.co=
m">clinton.begin@gmail.com</a>&gt; wrote:</span><blockquote class=3D"gmail_=
quote" style=3D"border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt =
0pt 0.8ex; padding-left: 1ex;">
Yep.&nbsp; XML it is.&nbsp; The JavaScript/DOM APIs are pretty simple
for processing results from XML.&nbsp; JSON is good too...but XML is
supported more widely and by more tools.<br><br>In iBATIS it's as simple as=
:<br><br>&lt;select id=3D&quot;GetEmployeeXML&quot; parameterClass=3D&quot;=
string&quot; resultClass=3D&quot;xml&quot;&gt;
<br><br>No beans, no maps, nothing.&nbsp; You can also use xml as a
parameter or a string as a result depending on how simple or complex
your needs are.<br><br>Cheers,<br><span class=3D"sg">Clinton</span><div><sp=
an class=3D"e" id=3D"q_10de62d93cdb31d8_2"><br><br><div><span class=3D"gmai=
l_quote">On 9/25/06,=20
<b class=3D"gmail_sendername">Levan Dvalishvili</b> &lt;<a href=3D"mailto:d=
valishvili@verticali.com" target=3D"_blank" onclick=3D"return top.js.OpenEx=
tLink(window,event,this)">dvalishvili@verticali.com</a>&gt; wrote:</span><b=
lockquote class=3D"gmail_quote" style=3D"border-left: 1px solid rgb(204, 20=
4, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">

<br>Don't want to go into&nbsp;&nbsp;off topic but I would prefer more feat=
ure full&nbsp;&nbsp;Yahoo<br>UI over GWT.<br><br>anyways, the reason I thin=
k&nbsp;&nbsp;Ibatis will do AJAX well in XML vs JSON is :<br>I could get my=
 persistence layer to give me XML ( which is possible with
<br>Ibatis, P.S Never tried it but documentation says so :))<br>for example=
 if I get domain Object &quot;A&quot; in so and so XML format, I don't even=
<br>need JSON, this XML (as is or transformed ) can hit as full or partial =
AJAX
<br>respond back to client . so Unless Ibatis can return JSON, as yet anoth=
er<br>alternative to Bean and/or XML, I would say XML format is quite enoug=
h and<br>suitable already, so there is no need to &quot;jsonize&quot; bean =
or xml I think I am
<br>even thinking there s no need for JSON&nbsp;&nbsp;at all. Am I on right=
 thinking path<br>? :)<br><br>Levan .<br><br><br>-----Original Message-----=
<br>From: Rinaldo [mailto:<a href=3D"mailto:rbonazzo@sardiniapoint.it" targ=
et=3D"_blank" onclick=3D"return top.js.OpenExtLink(window,event,this)">
rbonazzo@sardiniapoint.it
</a>]<br>Sent: Monday, September 25, 2006 11:54 AM<br>To: <a href=3D"mailto=
:user-java@ibatis.apache.org" target=3D"_blank" onclick=3D"return top.js.Op=
enExtLink(window,event,this)">user-java@ibatis.apache.org</a>; <a href=3D"m=
ailto:lmeadors@apache.org" target=3D"_blank" onclick=3D"return top.js.OpenE=
xtLink(window,event,this)">
lmeadors@apache.org</a><br>Subject: R: JavaScript + iBATIS
<br><br>You can find some json example using gwt<br><br><a href=3D"http://c=
ode.google.com/webtoolkit/documentation/examples/" target=3D"_blank" onclic=
k=3D"return top.js.OpenExtLink(window,event,this)">http://code.google.com/w=
ebtoolkit/documentation/examples/
</a><br><br>Rinaldo<br><br>-----Messaggio originale-----
<br>Da: <a href=3D"mailto:larry.meadors@gmail.com" target=3D"_blank" onclic=
k=3D"return top.js.OpenExtLink(window,event,this)">larry.meadors@gmail.com<=
/a> [mailto:<a href=3D"mailto:larry.meadors@gmail.com" target=3D"_blank" on=
click=3D"return top.js.OpenExtLink(window,event,this)">
larry.meadors@gmail.com</a>] Per conto di<br>Larry Meadors<br>Inviato: lune=
d=EC 25 settembre 2006=20
17.37<br>A: <a href=3D"mailto:user-java@ibatis.apache.org" target=3D"_blank=
" onclick=3D"return top.js.OpenExtLink(window,event,this)">user-java@ibatis=
.apache.org</a><br>Oggetto: Re: JavaScript + iBATIS<br><br>One approach tha=
t I have seen with good results is working with JSON to
<br>create javascript objects with jsp.
<br><br>Larry<br><br><br>On 9/25/06, Levan Dvalishvili &lt;<a href=3D"mailt=
o:dvalishvili@verticali.com" target=3D"_blank" onclick=3D"return top.js.Ope=
nExtLink(window,event,this)">dvalishvili@verticali.com</a>&gt; wrote:<br>&g=
t; I would say returning XML instead of java bean and sending it to
<br>&gt; client would be one of the straight forward ways to do it would no=
t
<br>&gt; it? Maybe running a little XSL filter prior ?<br>&gt;<br>&gt;<br>&=
gt; Levan Dvalishvili<br>&gt; Support LeadUS<br>&gt; Verticali,Inc<br>&gt; =
(646) 736 - 6075<br>&gt;<br>&gt;<br>&gt; -----Original Message-----<br>

&gt; From: Fred Janon [mailto:<a href=3D"mailto:fjanon@yahoo.com" target=3D=
"_blank" onclick=3D"return top.js.OpenExtLink(window,event,this)">fjanon@ya=
hoo.com</a>]<br>&gt; Sent: Sunday, September 24, 2006 10:35 PM<br>&gt; To: =
<a href=3D"mailto:user-java@ibatis.apache.org" target=3D"_blank" onclick=3D=
"return top.js.OpenExtLink(window,event,this)">
user-java@ibatis.apache.org</a>
<br>&gt; Subject: JavaScript + iBATIS<br>&gt;<br>&gt; Hi Clinton,<br>&gt;<b=
r>&gt; I am very interested in seeing what you did with JavaScript &amp; iB=
ATIS.<br>&gt; I am working on a Javascript framework and iBatis seems an ap=
pealing
<br>&gt; option to<br>do<br>&gt; the peristence part of it<br>&gt;<br>&gt; =
Fred<br>&gt;<br>&gt; --- Clinton Begin &lt;<a href=3D"mailto:clinton.begin@=
gmail.com" target=3D"_blank" onclick=3D"return top.js.OpenExtLink(window,ev=
ent,this)">
clinton.begin@gmail.com</a>&gt; wrote:<br>&gt;<br>&gt; &gt; Hi there,
<br>&gt; &gt;<br>&gt; &gt; I don't have any plans.&nbsp;&nbsp;But I just di=
d my iBATIS/Ajax demo in a<br>&gt; &gt; talk at NFJS yesterday.&nbsp;&nbsp;=
It is pretty cool.&nbsp;&nbsp;I may put together a<br>&gt; &gt; more comple=
te example to publish somewhere.&nbsp;&nbsp;I'd be interested in
<br>&gt; &gt; knowing if people would considering building apps this way...=
<br>&gt; &gt;<br>&gt; &gt; Think just JavaScript + iBATIS.<br>&gt; &gt;<br>=
&gt; &gt; Clinton<br>&gt; &gt;<br>&gt; &gt; On 9/24/06, levan Dvalishvili &=
lt;
<a href=3D"mailto:admin@amostudio.com" target=3D"_blank" onclick=3D"return =
top.js.OpenExtLink(window,event,this)">admin@amostudio.com</a>&gt; wrote:<b=
r>&gt; &gt; &gt;<br>&gt; &gt; &gt;&nbsp;&nbsp;Hi Clinton,&nbsp;&nbsp;I saw =
list of events on the website, is there any
<br>&gt; &gt; plans<br>&gt; &gt; &gt; visiting New York, in near&nbsp;&nbsp=
;future,monthly meetings of
<br>&gt; &gt; www.*nyjavasig*<br>&gt; &gt; &gt; .com/would be good place to=
 give speech, &quot;Ibatis Does AjAX<br>&gt; &gt; presentation &quot;<br>&g=
t; &gt; &gt; would be a bliss. (please J )<br>&gt; &gt; &gt;<br>&gt; &gt; &=
gt;
<br>&gt; &gt; &gt;<br>&gt; &gt; &gt;<br>&gt; &gt; &gt;<br>&gt; &gt; &gt; *F=
rom:* nando.dev [mailto:<a href=3D"mailto:nando.dev@gmail.com" target=3D"_b=
lank" onclick=3D"return top.js.OpenExtLink(window,event,this)">nando.dev@gm=
ail.com
</a>]<br>&gt; &gt; &gt; *Sent:* Saturday, September 23, 2006 3:41 PM
<br>&gt; &gt; &gt; *To:* <a href=3D"mailto:user-java@ibatis.apache.org" tar=
get=3D"_blank" onclick=3D"return top.js.OpenExtLink(window,event,this)">use=
r-java@ibatis.apache.org</a><br>&gt; &gt; &gt; *Subject:* Re: question with=
 boolean types..
<br>&gt; &gt; &gt;<br>&gt; &gt; &gt;<br>&gt; &gt; &gt;<br>
&gt; &gt; &gt; Hi Esperanza, the problem do you have is the type boolean of=
<br>&gt; &gt; &gt; pl/sql<br>&gt; &gt; isn=B4t<br>&gt; &gt; &gt; standard o=
f JDBC, so do you have to write a wrapper to this<br>&gt; &gt; function.
<br>
&gt; &gt; &gt;<br>&gt; &gt; &gt; 2006/6/26, <a href=3D"mailto:Esperanza.Ech=
everria@steria.es" target=3D"_blank" onclick=3D"return top.js.OpenExtLink(w=
indow,event,this)">Esperanza.Echeverria@steria.es</a><br>&gt; &gt; &lt;<a h=
ref=3D"mailto:Esperanza.Echeverria@steria.es" target=3D"_blank" onclick=3D"=
return top.js.OpenExtLink(window,event,this)">
Esperanza.Echeverria@steria.es
</a><br>&gt; &gt; &gt; &gt;:<br>&gt; &gt; &gt;<br>&gt; &gt; &gt;<br>&gt; &g=
t; &gt; please, can anyone help me?<br>&gt; &gt; &gt; my problem is calling=
 a stored procedure in ibatis and this<br>&gt; &gt; functioncalled in pl/sq=
l returns a boolean and i don=B4t know what are
<br>&gt; &gt; the correct<br>&gt; &gt; &gt; types in this case to be put in=
 for no obtain an error ...<br>&gt; &gt; &gt;<br>&gt; &gt; &gt; &lt;paramet=
erMap id=3D&quot;misParametros&quot; class=3D&quot;java.util.HashMap&quot; =
&gt;
<br>&gt; &gt; &gt;&nbsp;&nbsp;&nbsp;&nbsp; &lt;parameter property=3D&quot;p=
arametro1&quot; jdbcType=3D&quot;VARCHAR&quot; javaType=3D&quot;<br>&gt; &g=
t; &gt; java.lang.Boolean&quot; mode=3D&quot;OUT&quot;/&gt;<br>&gt; &gt; &g=
t;&nbsp;&nbsp;&nbsp;&nbsp; &lt;parameter property=3D&quot;parametro2&quot; =
jdbcType=3D&quot;VARCHAR&quot; javaType=3D&quot;
<br>&gt; &gt; &gt; java.lang.String&quot; mode=3D&quot;IN&quot;/&gt;<br>&gt=
; &gt; &gt;&nbsp;&nbsp;&nbsp;&nbsp; &lt;parameter property=3D&quot;parametr=
o3&quot; jdbcType=3D&quot;VARCHAR&quot; javaType=3D&quot;<br>&gt; &gt; &gt;=
 java.lang.String&quot; mode=3D&quot;IN&quot;/&gt;
<br>&gt; &gt; &gt;&nbsp;&nbsp;&nbsp;&nbsp; &lt;parameter property=3D&quot;p=
arametro4&quot; jdbcType=3D&quot;VARCHAR&quot; javaType=3D&quot;<br>&gt; &g=
t; &gt; java.lang.String&quot; mode=3D&quot;IN&quot;/&gt;<br>&gt; &gt; &gt;=
&nbsp;&nbsp;&nbsp;&nbsp; &lt;parameter property=3D&quot;parametro5&quot; jd=
bcType=3D&quot;VARCHAR&quot; javaType=3D&quot;
<br>&gt; &gt; &gt; java.lang.String&quot; mode=3D&quot;IN&quot;/&gt;<br>&gt=
; &gt; &gt;&nbsp;&nbsp; &lt;/parameterMap&gt;<br>&gt; &gt; &gt;&nbsp;&nbsp;=
&lt;procedure id=3D&quot;ejecutaTieneDuplicados&quot;<br>&gt; &gt; paramete=
rMap=3D&quot;misParametros&quot; &gt;
<br>&gt; &gt; &gt;&nbsp;&nbsp;&nbsp;&nbsp; {? =3D call report.tiene_duplica=
dos(?,?,?,?)}<br>&gt; &gt; &gt;&nbsp;&nbsp; &lt;/procedure&gt;<br>&gt; &gt;=
 &gt;<br>&gt; &gt; &gt; the out parameter tells me an error :<br>&gt; &gt; =
&gt; DEBUG - {conn-100021} Connection
<br>&gt; &gt; &gt; DEBUG - {pstm-100022} PreparedStatement: {? =3D call<br>=
&gt; &gt; report.tiene_duplicados<br>&gt; &gt; &gt; (?,?,?,?)}<br>&gt; &gt;=
 &gt; DEBUG - {pstm-100022} Parameters: [JOSELUIS, sip97.rep,<br>&gt; &gt; =
VCENTRO=3D90101,
<br>&gt; &gt; &gt; 19-06-2006]<br>&gt; &gt; &gt; DEBUG - {pstm-100022} Type=
s: [java.lang.String, java.lang.String,<br>&gt; &gt; &gt; java.lang.String,=
 java.lang.String] DEBUG - Initializing,<br>&gt; &gt; config=3D'org.apache.=
struts.action.LocalStrings

',<br>&gt; &gt; &gt; returnNull=3Dtrue<br>&gt; &gt; &gt; 06/06/26 08:47:37 =
DaoException<br>&gt; &gt; &gt; ERROR - Ha ocurrido un error con la base de =
datos<br>&gt; &gt; &gt; com.ibatis.dao.client.DaoException: Failed to execu=
te
<br>&gt; &gt; queryForObject - id<br>&gt; &gt; &gt; [ejecutaTieneDuplicados=
], parameterObject<br>&gt; &gt; [{parametro4=3DVCENTRO=3D90101,<br>&gt; &gt=
; &gt; parametro2=3DJOSELUIS, parametro3=3Dsip97.rep , parametro1=3Dtrue,<b=
r>&gt; &gt; &gt; parametro5=3D19-06-2006}].&nbsp;&nbsp;Cause:
<br>&gt; &gt; &gt; com.ibatis.common.jdbc.exception.NestedSQLException:<br>=
&gt; &gt; &gt; --- The error occurred in<br>&gt; &gt; &gt; com/ibatis/sip/p=
ersistence/sqlmapdao/sql/Lis.xml.<br>&gt; &gt; &gt; --- The error occurred =
while applying a parameter map.
<br>&gt; &gt; &gt; --- Check the Lis.misParametros.<br>&gt; &gt; &gt; --- C=
heck the statement (update procedure failed).<br>&gt; &gt; &gt; --- Cause: =
java.sql.SQLException: ORA-06550: l=EDnea 1, columna 13:<br>&gt; &gt; &gt; =
PLS-00382: el tipo de la expresi=F3n no es correcto
<br>&gt; &gt; &gt; ORA-06550: l=EDnea 1, columna 7:<br>&gt; &gt; &gt; PL/SQ=
L: Statement ignored<br>&gt; &gt; &gt;<br>&gt; &gt; &gt;<br>&gt; &gt; &gt;<=
br>&gt; &gt; &gt;&nbsp;&nbsp;*Esperanza Echeverr=EDa de Miguel*<br>&gt; &gt=
; &gt; Steria Espa=F1a=20
<a href=3D"http://www.steria.es" target=3D"_blank" onclick=3D"return top.js=
.OpenExtLink(window,event,this)">http://www.steria.es</a> C/Men=E9ndez y Pe=
layo,3 bis 46010<br>&gt; &gt; &gt; Valencia<br>&gt; &gt; &gt; Tel: + 34 96 =
393 87 50 Fax: +34 96 393 87 51
<br>&gt; &gt; &gt; <a href=3D"mailto:esperanza.echeverria@steria.es" target=
=3D"_blank" onclick=3D"return top.js.OpenExtLink(window,event,this)">
esperanza.echeverria@steria.es</a><br>&gt; &gt; &gt;<br>&gt; &gt; &gt;<br>&=
gt; &gt; &gt;<br>&gt; &gt; &gt;<br>&gt; &gt; &gt;<br>&gt; &gt; &gt;<br>&gt;=
 &gt; &gt;<br>&gt; &gt; &gt;<br>&gt; &gt; &gt;<br>&gt; &gt;<br>&gt;<br>

&gt;<br><br><br></blockquote></div><br>

</span></div></blockquote></div><br><br clear=3D"all"><br>-- <br>Rahul Sing=
h<br>CEO, Anant<br><a href=3D"http://www.anant.us">http://www.anant.us</a><=
br><br>Office: 7033723268<br>Mobile: 7036555652

------=_Part_8894_21921178.1159284377716--