How can I prevent sql update statement on cmp-beans ?

[claude.glauser]

Hi,

i looked at the issued sql statements for a jboss-ql query.
There are only two statements to retreieve all beans :), but
also an update statement for every bean when the function
returns:

Executing SQL: UPDATE documententity SET Creation_Date=?, Modification_Date=? WHERE Id=?

I am not aware that my code changes creation_date nor modification_date.

What are the conditions that an update statement will be performed ?
Is there a way to prevent it ?

Thanks a lot for your answers.

[stephanenicoll]

Yes you can preven this. Actually it has been fixed in 3.2.4RCX (1 I think but I am not sure).

To prevent this there is one flag to set to false in your jbosscmp-jdbc.sql : 'check-dirty-after-get'

So on your CreationDate and ModificationDate cmp fields, you should aad :

<check-dirty-after-get>false</check-dirty-after-get>

in the cmp-field section.

If you are using xdoclet, it's not supported for the moment even I submitted a patch about this last week.

Hope it helps,

Stephane

[claude.glauser]

Thanks a lot for your help !