[jboss-jira] [JBoss JIRA] Created: (HIBERNATE-65) Error with 'id' property with 3.2.3

[Chris Laprun (JIRA)]

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