EJB CMP 2.1 - update question

[forrozeiro]

Hi there,

I have a table with, say, these columns

table mytable
col1 (PK)
col2
col3
col4

I am using a container managed persistence bean do map the table. Versions:

EJB 2.1
JBoss 3.2.7

The question is, which is the best way to do an update like this:

update my table set....
where col3 = xxx

That is, update by a column that is not the pk?

Thank you in advance!

 

[prosper]

Assume you store the record in entity bean.
I would get a collection of entities throguh EJB QL like this (select object(c) from table where col3=?).
After you got the collection of entities, you can read the record one by one and update the values of col3.

Please tell us if you use entity bean to store record and do you use EJB QL?

It is better not to write very complicated EJB QL.