A colleague of mine is having an issue with a Hibernate-generated query running on Informix. He's running Hibernate 3.2.1 GA.
Here's the generated query as logged by Hibernate:
Code:
2009-08-28 11:44:17,312 DEBUG [org.hibernate.SQL] select first 76 idrec1_.fullname as col_0_0_, idrec1_.city as col_1_0_, profilerec0_.birthDate as col_2_0_, profilerec0_.id as col_3_0_, idrec1_.add_date as col_4_0_ from profile_rec profilerec0_, id_rec idrec1_ where profilerec0_.id=idrec1_.id order by idrec1_.fullname, profilerec0_.id
And here's the error:
Code:
2009-08-28 11:44:17,406 DEBUG [org.hibernate.util.JDBCExceptionReporter] could not execute query [select idrec1_.fullname as col_0_0_, idrec1_.city as col_1_0_, profilerec0_.birthDate as col_2_0_, profilerec0_.id as col_3_0_, idrec1_.add_date as col_4_0_ from profile_rec profilerec0_, id_rec idrec1_ where profilerec0_.id=idrec1_.id order by idrec1_.fullname, profilerec0_.id]
java.sql.SQLException: Column (profilerec0_) not found in any table in the query (or SLV is undefined).
It would seem that somehow the Hibernate query is causing Informix to think that profilerec0_ is a column, not a table. However, there is nothing wrong that I can see with the SQL.
Any thoughts?
Best,
Laird
Login
FAQ
Search
