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 Rashmi Dave <ra...@persistent.co.in> on 2006/02/06 06:37:51 UTC

[Abator] selectByExample not working?

Hi Jeff,

I am using Abator generated DAO classes to fire queries against the tables.

I would like to select those rows in a table where the ACTIVE column is "Y".
For this my code reads

RolesExample roleExl = new RolesExample();
roleExl.setIsActive("Y");
        
List roleGrps = roleDAO.selectByExample(roleExl);

I would like this to generate a WHERE ACTIVE = 'Y' in the select query.

However, I find that the list being returned has all the rows in the table.
Not sure if I am using this right. Can you please help?

Thanks in advance

Cheers!
Rashmi

Re: [Abator] selectByExample not working?

Posted by Jeff Butler <je...@gmail.com>.
iBATIS and Abator support sequences directly - there's no need to alter the
generated inserts if you configure the abator_config file properly.  To use,
specify something like this in your Abator configuration:

<table schema="someschema" tableName="someTable">
  <generatedKey column="some_column" sqlStatement="select
sequence.nextvalfrom someSequence"
                         identity="false"/>
</table>

You'll need to replace all the values in the above example to the actual
values in your database.

When you run the DAO insert method, it will return the newly generated key -
so you can use the value in other queries.

Jeff Butler



On 2/6/06, Rashmi Dave <ra...@persistent.co.in> wrote:
>
>  Hi Jeff,
>
>
>
> Thanks for this. It has worked.
>
>
>
> I have one more question. In my table, the primary key is to be generated
> using a sequence (I am using Oracle). Now, I have altered the Insert in the
> sql map file so that it does not take the ID from the parameter Class. I
> need the value of the sequence that gets generated for the newly inserted
> record so that I can use it to populate other related tables. Can you
> suggest a good method of doing this using iBATIS?
>
>
>
> Thanks so much
>
>
>
> Regards
>
> ~Rashmi
>
>
>  ------------------------------
>
> *From:* Jeff Butler [mailto:jeffgbutler@gmail.com]
> *Sent:* Monday, February 06, 2006 7:44 PM
> *To:* user-java@ibatis.apache.org
> *Subject:* Re: [Abator] selectByExample not working?
>
>
>
> Add this line of code before calling the DAO method:
>
>
>
> roleExl.setIsActive_Indicator(RolesExample.EXAMPLE_EQUALS);
>
>
>
> HTH -
>
> Jeff Butler
>
>
>
> On 2/5/06, *Rashmi Dave* <ra...@persistent.co.in> wrote:
>
> Hi Jeff,
>
> I am using Abator generated DAO classes to fire queries against the
> tables.
>
> I would like to select those rows in a table where the ACTIVE column is
> "Y".
> For this my code reads
>
> RolesExample roleExl = new RolesExample();
> roleExl.setIsActive("Y");
>
> List roleGrps = roleDAO.selectByExample(roleExl);
>
> I would like this to generate a WHERE ACTIVE = 'Y' in the select query.
>
> However, I find that the list being returned has all the rows in the
> table.
> Not sure if I am using this right. Can you please help?
>
> Thanks in advance
>
> Cheers!
> Rashmi
>
>
>

RE: [Abator] selectByExample not working?

Posted by Rashmi Dave <ra...@persistent.co.in>.
Hi Jeff,

 

Thanks for this. It has worked.

 

I have one more question. In my table, the primary key is to be generated
using a sequence (I am using Oracle). Now, I have altered the Insert in the
sql map file so that it does not take the ID from the parameter Class. I
need the value of the sequence that gets generated for the newly inserted
record so that I can use it to populate other related tables. Can you
suggest a good method of doing this using iBATIS?

 

Thanks so much

 

Regards

~Rashmi 

 

  _____  

From: Jeff Butler [mailto:jeffgbutler@gmail.com] 
Sent: Monday, February 06, 2006 7:44 PM
To: user-java@ibatis.apache.org
Subject: Re: [Abator] selectByExample not working?

 

Add this line of code before calling the DAO method:

 

roleExl.setIsActive_Indicator(RolesExample.EXAMPLE_EQUALS);

 

HTH -

Jeff Butler

 

On 2/5/06, Rashmi Dave <ra...@persistent.co.in> wrote: 

Hi Jeff,

I am using Abator generated DAO classes to fire queries against the tables.

I would like to select those rows in a table where the ACTIVE column is "Y".

For this my code reads

RolesExample roleExl = new RolesExample();
roleExl.setIsActive("Y");

List roleGrps = roleDAO.selectByExample(roleExl);

I would like this to generate a WHERE ACTIVE = 'Y' in the select query. 

However, I find that the list being returned has all the rows in the table.
Not sure if I am using this right. Can you please help?

Thanks in advance

Cheers!
Rashmi

Re: [Abator] selectByExample not working?

Posted by Jeff Butler <je...@gmail.com>.
Add this line of code before calling the DAO method:

roleExl.setIsActive_Indicator(RolesExample.EXAMPLE_EQUALS);

HTH -
Jeff Butler


On 2/5/06, Rashmi Dave <ra...@persistent.co.in> wrote:
>
> Hi Jeff,
>
> I am using Abator generated DAO classes to fire queries against the
> tables.
>
> I would like to select those rows in a table where the ACTIVE column is
> "Y".
> For this my code reads
>
> RolesExample roleExl = new RolesExample();
> roleExl.setIsActive("Y");
>
> List roleGrps = roleDAO.selectByExample(roleExl);
>
> I would like this to generate a WHERE ACTIVE = 'Y' in the select query.
>
> However, I find that the list being returned has all the rows in the
> table.
> Not sure if I am using this right. Can you please help?
>
> Thanks in advance
>
> Cheers!
> Rashmi
>
>