[Hibernate-issues] [Hibernate-JIRA] Commented: (HHH-1848) A session.lock generates a query with a v

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-1848?page=comments#action_23706 ] 

Christopher G. Stach II commented on HHH-1848:
----------------------------------------------

We just ran into this same issue with JDK 1.5.0_07, Hibernate 3.2.0.cr2, Hibernate Annotations 3.2.0.cr1, and MySQL 5.0.18.  The generated query is incorrect.  It's trying to look for the PK and version columns in the subclass' table.

Hibernate:
    /* READ lock xxx.Subclass */ select
        id
    from
        subclass_table
    where
        id =?
        and optlock_ver =?

org.hibernate.util.JDBCExceptionReporter.logExceptions SQL Error: 1054, SQLState: 42S22
org.hibernate.util.JDBCExceptionReporter.logExceptions Unknown column 'id' in 'field list'
$RCSfile: ExceptionHandler.java,v $.execute Exception
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'id' in 'field list'
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2822)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1536)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1626)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:3031)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:943)
        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1049)
        at com.mysql.jdbc.jdbc2.optional.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:811)
        at com.caucho.sql.UserPreparedStatement.executeQuery(UserPreparedStatement.java:108)
        at com.caucho.sql.UserPreparedStatement.executeQuery(UserPreparedStatement.java:108)
        at org.hibernate.dialect.lock.SelectLockingStrategy.lock(SelectLockingStrategy.java:71)
        at org.hibernate.persister.entity.AbstractEntityPersister.lock(AbstractEntityPersister.java:1282)
        at org.hibernate.event.def.AbstractLockUpgradeEventListener.upgradeLock(AbstractLockUpgradeEventListener.java:88)
        at org.hibernate.event.def.DefaultLockEventListener.onLock(DefaultLockEventListener.java:64)
        at org.hibernate.impl.SessionImpl.fireLock(SessionImpl.java:586)
        at org.hibernate.impl.SessionImpl.lock(SessionImpl.java:578)
        at org.springframework.orm.hibernate3.HibernateTemplate$10.doInHibernate(HibernateTemplate.java:596)
        at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:366)
        at org.springframework.orm.hibernate3.HibernateTemplate.lock(HibernateTemplate.java:594) 

> A session.lock generates a query with a version column in a joined subclass which does not exist
> ------------------------------------------------------------------------------------------------
>
>          Key: HHH-1848
>          URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1848
>      Project: Hibernate3
>         Type: Bug

>     Versions: 3.2.0.cr2
>  Environment: Windows XP Pro SP2 (full update)
> Java 1.5.0_06
> Postgres 8.1
> postgresql-8.1-404.jdbc3.jar
> Annotations 3.2.0 cr1
> hibernatetools-3.1.0.beta5
>     Reporter: Eduard Mossinkoff
>     Priority: Minor
>  Attachments: screenshot-1.jpg, screenshot-1.jpg
>
>
> A joined class hierarchy using annotations has a version property named "optlock" like in the annotation reference.
> The session factory in the Eclipse Hibernate console shows the joined subclass and it contains the "id" and "version" properties inherited from its superclass. The generated schema only has the version property in the table representing the root entity. The subclass has no "optlock" column. Now when a session.lock() is called with an instance of the subclass as its parameter and lockmode "UPGRADE", a query is generated including the "optlock" column on the subclass table which doesn't exist in the schema.
> The root entity, only showing the relevant properties
> @Entity
> @Inheritance(strategy = InheritanceType.JOINED)
> @AccessType("field")
> public class ModelObject implements Serializable, AccessControl {
> 	private static final long serialVersionUID = 2354579396538279696L;
> 	transient public static final int STORAGE_COSTS = 10;
> 	@Id
> 	@GeneratedValue(generator = "system-uuid")
> 	@GenericGenerator(name = "system-uuid", strategy = "uuid")
> 	private String id;
> 	@Version
> 	@Column(name="optlock")
> 	private Integer version;
> }
> A sub class 
> @Entity
> @AccessType("field")
> public class Item extends ModelObject implements Cloneable, Serializable {
> }
> @Entity
> @AccessType("field")
> public class Domain extends Item {
>       protected String domainId = null;
> }
> @Entity
> @AccessType("field")
> public class UserDomain extends Domain {
>         private long lastLoginDate;
> }
> The Hibernate console shows:
> org.across.model.UserDomain
> +id:java.lang.String
> +version:java.lang.Integer
> The database table of ModelObject
> CREATE TABLE dev.modelobject
> (
>   id varchar(255) NOT NULL,
>   optlock int4,
>   acl_id varchar(255),
>   CONSTRAINT modelobject_pkey PRIMARY KEY (id),
>   CONSTRAINT fk78ba6fa841f3e430 FOREIGN KEY (acl_id)
>       REFERENCES dev.acl (id) MATCH SIMPLE
>       ON UPDATE NO ACTION ON DELETE NO ACTION
> ) 
> WITHOUT OIDS;
> ALTER TABLE dev.modelobject OWNER TO across;
> The UserDomain table
> CREATE TABLE dev.userdomain
> (
>   id varchar(255) NOT NULL,
>   lastlogindate int8 NOT NULL,
>   CONSTRAINT userdomain_pkey PRIMARY KEY (id),
>   CONSTRAINT fkbbd6448faf7c2769 FOREIGN KEY (id)
>       REFERENCES dev."domain" (id) MATCH SIMPLE
>       ON UPDATE NO ACTION ON DELETE NO ACTION
> ) 
> WITHOUT OIDS;
> ALTER TABLE dev.userdomain OWNER TO across;
> The query generated when calling session.lock(userDomain, LockMode.UPGRADE); where userDomain is an instance created in a different session that was closed. 
> Hibernate: select id from dev.UserDomain where id =? and optlock =? for update
> 7625 [main] WARN  org.hibernate.util.JDBCExceptionReporter  - SQL Error: 0, SQLState: 42703
> 7625 [main] ERROR org.hibernate.util.JDBCExceptionReporter  - ERROR: column "optlock" does not exist
> The "optlock" column is not present in the UserDomain table only in the ModelObject table. 
> The question is, is the generated query wrong or is the Hibernate Eclipse tool generating a wrong schema.

-- 
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

[Hibernate-issues] [Hibernate-JIRA] Commented: (HHH-1848) A session.lock generates a query with a v

An object relational-mapping (ORM) library for Java

[Hibernate-issues] [Hibernate-JIRA] Commented: (HHH-1848) A session.lock generates a query with a version column in a joined subclass which does not exist