[Hibernate-issues] [Hibernate-JIRA] Created: (HHH-1965) Alias Error when SELECT object.id FOR UPDATE OF object.ID

[vision m. (JIRA) <no...@at...>]

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