[jboss-jira] [JBoss JIRA] Created: (HIBERNATE-65) Error with 'id' property with 3.2.3
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