how to support auto primary key in JES 8.1

Hi,

thank you for reply.

Suppose I have a column named ID in the database table. According the guideline, I have to remove the ID from CMP field / database column.

Here I got two more questions:

1. Is there possible to specify the database column name manually?

2. If I want to use the ID to do filtering in EJBQL, I need to refer to the field by using beanNmae.id, In this case, I will get a deployment error because the corresponding cmp field is not existing.

Is there any solution / comments for above question. Thank you.

CornerStone at 2007-7-7 0:07:20 >

Hi,

Thank you for the reply.

thank you for clarifying the question 1.

For 2nd question,

2. If I want to use the ID to do filtering in EJBQL, I need to refer to the field by using beanNmae.id, In this case, I will get a deployment error because the corresponding cmp field is not existing.

What I want to do is to write a EJBQL like:

<ejb-ql><![CDATA[SELECT OBJECT(schedule) FROM BookingScheduleEntityBean as schedule WHERE schedule.id = ?1 and (schedule.endDate is null or schedule.endDate > ?2.... ]]></ejb-ql>

the schedule.id is the primary key previously. I want to use the auto primary key feature of JES so that I have to remove id CMP filed according to JES's developer guide. But the problem here is that I will got a deployment error if I remove the id CMP field. Because the id is no more a CMP field.

what you claim the "meaningless" is correct for most of case, but in some cases, I got the schedule id and want to use the schedule id to retrieve some other information. Inevitably , I have to write a query like the one mentioned above.

Is there any solution for this problem?

xifeng

CornerStone at 2007-7-7 0:07:20 >