OpenSQL DataSource not allowed if select-for-update is used Error?

[Former Member]

Hi,

I have created an enterprise application, EJB (Session + entity) + WAR, and corresponding ear file deployes with the following warning message, I have done similar apps in the past without erros.

Warning: DataSource TMP_EMPLOYEES_DATA is OpenSQL. It is used by an abstract schema that uses select-for-update locking. It is now allwed to use OpenSQL DataSource if select-for-updaet is used.

Any idea?

Thanks

[former_member585757]

Hi Ezatullah, all,

while I do not propose an alternative solution, I'd like to add some explanation to the error message itself: Open SQL for Java strives to provide portable semantics across the set of supported databases and does not offer features which can not be provided by all the databases.

Now, a SELECT .. FOR UPDATE in the semantics as used here is not generally available, in particular not regarding the locking semantics.

Thus, the feature is rejected in combination with a Open SQL/JDBC data source.

Best Regards, Dietmar