You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by jeremy jardin <je...@newtec.caisse-epargne.fr> on 2006/07/12 09:54:12 UTC

RE : RE : request using beanExample

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 <je...@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 <je...@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 ?
> >
> >
>

Re: RE : RE : request using beanExample

Posted by Larry Meadors <lm...@apache.org>.
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 <je...@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 <je...@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 <je...@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 ?
> > >
> > >
> >
>