Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:
3.1.1

Mapping documents:

Code between sessionFactory.openSession() and session.close():
hibernateUtil.getSessionFactory().getCurrentSession();

Full stack trace of any exception that occurs:
could not execute query [select this_.analystID as anlystID1_1_, this_.userFirstName as userFirs2_1_1, this_.pwdCreationDate as pwdCreat6_1_1_, this_.roleID as roldID1_1_, this.loginAttempts as loginAtt8_1_1_, rolse2_.roleID as roldID32_0_,roles2_.description as descript2_32_0_, roles2_.userRole as userRole32_0_ from analyst this_left outer join roles roles2_ on this_.roleID=roles2_.roleID where this_.sid=?]
java.sql.SQLException:[DataDirect][Sybase JDBC Driver]Invalid column name: roleID32_0_
at com.ddtek.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.ddtek.jdbc.base.BaseExceptions.getException(Unknown Source)
at org.hibernate.type.LongType.get(LongType.java:28)
at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:113)
etc.

Name and version of the database you are using:
Sybase ASE 12.5.2

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:
error



The db has not changed just our hibernate implementation and driver. We moved to the data direct driver for full container support for Jboss. Why is it having an issue translating the hql (it seems)? Any input here?

Out of curiousity, does the same exception occur when using the ClassQueryTranslatorFactory?

I don't know as I have not used that class. Can you explain where that would be implemented and I will try it?

In your hibernate configuration file, specify the property below: