ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "jeremy jardin" <jeremy.jar...@newtec.caisse-epargne.fr>
Subject RE : RE : RE : RE : RE : request using beanExample
Date Thu, 13 Jul 2006 08:38:55 GMT
I think that I'am understanding the matter with my request.

I precise one more time that my xml and dao files have been generated using Abator.

So I want to launch a request with a where clause on "MOBILE" property.
When I look on the XML file, I just can't see that :

<sql id="abatorgenerated_Example_Where_Clause">
    <!--
      WARNING - This element is automatically generated by Abator for iBATIS, do not modify.
    -->
    <dynamic prepend="where">
    <isPropertyAvailable prepend="and" property="AND_CLIENT_UUID_EQUALS">
        CLIENT_UUID = #CLIENT_UUID#
      </isPropertyAvailable>
  
	etc..

And in those 'isPropertyAvailable' tags, I can't find 'MOBILE' property.
Maybe that's why my requests using MOBILE where clause do not work ! ??

Sould I had the property ??

Thx


-----Message d'origine-----
De : Yusuf [mailto:Yusuf@ekalife.co.id] 
Envoyé : mercredi 12 juillet 2006 11:15
À : user-java@ibatis.apache.org
Objet : RE: RE : RE : RE : RE : request using beanExample

i had this kind of problem and solved using right padding with empty
space, eg.

Select UUID, MOBILE,ORIGINE_UUID,ETAT,LOGIN, ETAT_MODIFIE,TSTMPINSR,
TSTMPUPDT  from UTILISATEUR where MOBILE = rpad(#value#,12,' ')

Regards,
Yusuf

-----Original Message-----
From: jeremy jardin [mailto:jeremy.jardin@newtec.caisse-epargne.fr]
Sent: Wednesday, July 12, 2006 4:13 PM
To: user-java@ibatis.apache.org; lmeadors@apache.org
Subject: RE : RE : RE : RE : request using beanExample


I'm still having that pb.. even if I only insert 12CHAR long Strings !!

I insert my user with un phone Number like that "060000000000  "
(12 chars)

and in my request, I set my example witth thaht number : "060000000000
"

stil no results !! :-(



-----Message d'origine-----
De : larry.meadors@gmail.com [mailto:larry.meadors@gmail.com] De la part
de Larry Meadors
Envoyé : mercredi 12 juillet 2006 10:49
À : user-java@ibatis.apache.org
Objet : Re: RE : RE : RE : request using beanExample

Yep.

On 7/11/06, jeremy jardin <jeremy.jardin@newtec.caisse-epargne.fr>
wrote:
> You mean that is my fiel dis CHAR(12)... and the string I put in is
only 8 char long;. It could be problematic ?
>
>
>
> -----Message d'origine-----
> De: larry.meadors@gmail.com [mailto:larry.meadors@gmail.com] De la
part de Larry Meadors
> Envoyé: mercredi 12 juillet 2006 10:37
> À: user-java@ibatis.apache.org
> Objet: Re: RE : RE : request using beanExample
>
> The length is probably wrong, and in all SQL dialects I have ever
> used, "  A"  does not equal "A".
>
> Larry
>
>
> On 7/11/06, jeremy jardin <jeremy.jardin@newtec.caisse-epargne.fr>
wrote:
> > A CHAR !!
> > Why ??
> >
> >
> > -----Message d'origine-----
> > De: larry.meadors@gmail.com [mailto:larry.meadors@gmail.com] De la
part de Larry Meadors
> > Envoyé: mercredi 12 juillet 2006 09:50
> > À: user-java@ibatis.apache.org
> > Objet: Re: RE : request using beanExample
> >
> > Is MOBILE a CHAR field or VARCHAR?
> >
> > Larry
> >
> >
> > On 7/11/06, jeremy jardin <jeremy.jardin@newtec.caisse-epargne.fr>
wrote:
> > > All my classes have been generated using Abator so, I have
something like that :
> > >
> > > List list =
sqlMapClient.queryForList("UTILISATEUR.abatorgenerated_selectByExample",
parms);
> > >
> > > Parms contains my where clause, instanciated the good way...
> > >
> > > PreparedStatement: Select UUID, MOBILE,ORIGINE_UUID,ETAT,LOGIN,
ETAT_MODIFIE,TSTMPINSR, TSTMPUPDT  from UTILISATEUR where MOBILE = ?
> > > Parameters: [0613410836]
> > > Types: [java.lang.String]
> > > ResultSet
> > >
> > >
> > > What's the matter with my request ?
> > >
> > >
> > > -----Message d'origine-----
> > > De: larry.meadors@gmail.com [mailto:larry.meadors@gmail.com] De la
part de Larry Meadors
> > > Envoyé: mercredi 12 juillet 2006 09:39
> > > À: user-java@ibatis.apache.org
> > > Objet: Re: request using beanExample
> > >
> > > Do you have a resultMap or resultClass for the select?
> > >
> > > Larry
> > >
> > >
> > > On 7/11/06, jeremy jardin <jeremy.jardin@newtec.caisse-epargne.fr>
wrote:
> > > >
> > > >
> > > >
> > > >
> > > > Hello,
> > > >
> > > >
> > > >
> > > > I'm trying to launch a request using a beanExample .. I've
logged the sql
> > > > request, and I can see that this request should answers 1
result.
> > > >
> > > >
> > > >
> > > > After all. my resultList is empty, and I don't know why.
> > > >
> > > >
> > > >
> > > > Any idea ?
> > > >
> > > >
> > >
> >
>

Mime
View raw message