[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - ORDER BY and FOR UPDAE
lafr
do-not-reply at jboss.com
Mon Jun 25 17:42:13 EDT 2007
Since my JBoss App shares the database with a C++-App I'd like to enable <row-locking> for the Entity Beans.
But this is incompatible with accessing data in a defined order.
The SQL-statement for a finder "SELECT ... ORDER BY a, b FOR UPDATE" is, at least for Informix DB, illegal.
You can only use either "ORDER BY" or "FOR UPDATE".
But I can't do without one of them.
Any similar experience?
Any hints how to solve this dilemma?
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4057510#4057510
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4057510
More information about the jboss-user
mailing list