Alias Error when SELECT object.id FOR UPDATE OF object.ID
---------------------------------------------------------
Key: HHH-1965
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1965
Project: Hibernate3
Type: Bug
Components: core
Versions: 3.1.3
Environment: Hibernate-Version: 3.1.3
ORACLE10g
Reporter: vision matford
On Oracle you can do this:
SELECT object.ID FROM TABLE object FOR UPDATE OF object.ID
giving you back the id and locking lines.
But with Hibernate it's not working.
Query q = session.createQuery("SELECT object.ID FROM TABLE object");
q.setLockMode("object",LockMode.UPGRADE);
q.list();
This code generate the following error:
Exception in thread "Thread-0" java.lang.IllegalArgumentException: alias not found: obj
at org.hibernate.loader.hql.QueryLoader.applyLocks(QueryLoader.java:299)
at org.hibernate.loader.Loader.preprocessSQL(Loader.java:189)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1552)
at org.hibernate.loader.Loader.doQuery(Loader.java:661)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2145)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
at org.hibernate.loader.Loader.list(Loader.java:2024)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:308)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:153)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1106)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
What's working actually :
Query q = session.createQuery("SELECT object FROM TABLE object");
q.setLockMode("object",LockMode.UPGRADE);
q.list();
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
|
