Error with 'id' property with 3.2.3 ----------------------------------- Key: HIBERNATE-65 URL: http://jira.jboss.com/jira/browse/HIBERNATE-65 Project: Hibernate Issue Type: Bug Reporter: Chris Laprun Assigned To: Steve Ebersole I have a property defined as: <property name="id" not-null="true" unique="true" type="java.lang.String"/> The query: Iterator producerInfos = session.createQuery("from ProducerInfo pi order by pi.id").iterate(); works fine on 3.2.2 but fails in 3.2.3 with: 14:49:21,513 INFO [LongType] could not read column value from result set: col_0_0_; Wrong data type: type: VARCHAR (12) expected: BIGINT value: NetUnity 14:49:21,518 WARN [JDBCExceptionReporter] SQL Error: -16, SQLState: 37000 14:49:21,518 ERROR [JDBCExceptionReporter] Wrong data type: type: VARCHAR (12) expected: BIGINT value: NetUnity [...] Caused by: java.sql.SQLException: Wrong data type: type: VARCHAR (12) expected: BIGINT value: NetUnity at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.jdbcResultSet.getColumnInType(Unknown Source) at org.hsqldb.jdbc.jdbcResultSet.getLong(Unknown Source) at org.hsqldb.jdbc.jdbcResultSet.getLong(Unknown Source) at org.jboss.resource.adapter.jdbc.WrappedResultSet.getLong(WrappedResultSet.java:718) at org.hibernate.type.LongType.get(LongType.java:28) at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:163) at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:154) at org.hibernate.type.ManyToOneType.hydrate(ManyToOneType.java:103) at org.hibernate.type.EntityType.nullSafeGet(EntityType.java:204) at org.hibernate.impl.IteratorImpl.postNext(IteratorImpl.java:93) at org.hibernate.impl.IteratorImpl.<init>(IteratorImpl.java:58) at org.hibernate.loader.hql.QueryLoader.iterate(QueryLoader.java:405) -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira