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 10:41:55 UTC
RE : RE : RE : request using beanExample
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 <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 ?
> > >
> > >
> >
>
Re: RE : RE : RE : request using beanExample
Posted by Larry Meadors <lm...@apache.org>.
Yep.
On 7/11/06, jeremy jardin <je...@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 <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 ?
> > > >
> > > >
> > >
> >
>