RE : RE : RE : RE : RE : RE : request using beanExample

[jeremy jardin <je...@newtec.caisse-epargne.fr>]

Yes, it works !
 
I've had needed tag in my xml file using rpad like this: 
 
      <isPropertyAvailable prepend="and" property="AND_MOBILE_EQUALS">
        MOBILE = rpad(#MOBILE#,12,' ')
      </isPropertyAvailable>
Now, it's ok.
 
Thx a lot.
 
 
-----Message d'origine-----
De : Jeff Butler [mailto:jeffgbutler@gmail.com] 
Envoyé : jeudi 13 juillet 2006 15:45
À : user-java@ibatis.apache.org; Graeme J Sweeney
Objet : Re: RE : RE : RE : RE : RE : request using beanExample
 
Yes - this is the correct way to do it.  Set the value for the MOBILE field, as well as the indicator for the field.
 
Jeremy - it looks, from your previous posts, that the SQL statement is being generated correctly.  Can you run the generated SQL statement (from the logs) in an SQL client to verify?
 
As for looking at the generated XML, the generated XML for the where clause is very wordy and too complex (because of a bug in the current version of iBATIS).  To see how it works, you'll have to look at the code in the generated DAO. 
 
All I can offer is that the bug in iBATIS is fixed and when iBATIS 2.2.0 is released, there will be a better version of Abator available.  The generated XML and DAO classes are MUCH (orders of magnitude) smaller.
 
Jeff Butler


 
On 7/13/06, Graeme J Sweeney <ib...@gjsweeney.com> wrote: 
On Thu, 13 Jul 2006, jeremy jardin wrote:

> 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 :

<snip/>

> Sould I had the property ??

Pour votre Anglais: add not had

>From your abator generated classes you should have a 
UTILISATEURExample (or UtilsateurExample) source file. It should have a
method

setMobile_Indicator()

such that

UTILISATEURExample.setMobile("060000000000  ");
UTILISATEURExample.setMobile_Indicator (UTILISATEURExample.EXAMPLE_EQUALS);

should produce the SQL you expect:

select * from UTILISATEUR where MOBILE = "060000000000  ";

--
Graeme -