Error loading entity new on JB AS 7.1

[lancetx]

I've got an application that I've been working on under JBoss 5, then I moved it to 6.  Now I'm running under AS 7.1.  One of my tests to load an object entity is failing under 7.1 although it worked fine under the other versions.

I've traced it down to an attribute that is using @Formula to load the value.  It seems to be generating the sql with the table prefix on the formula, rather than just using the formula itself. 

I've not been about to exactly confirm that is the issue - although I did pinpoint it down to that @Forumla statement.  The log is printing all sql up to, but no including the one that is failing.  I'm guessing the error is superseeding the print of the sql. 

Any suggestions would be appreciated - even how to get it to print out the generated SQL prior to the error being thrown so I could verify exactly what it's doing.

I tried upgrading the hibernate jars from 4.0.1 to 4.1.2 - that didn't seem to make any difference.

[smarlow]

Try adding <property name="hibernate.show_sql" value="true" /> to your persistence.xml (or Hibernate configuration file) to see the generated sql. 

You might try looking in the Hibernate jira system for others reporting the issue.  Link is here.  Forums are here.

[lancetx]

I have that in my persistence.xml already - it shows the sql for all queries except the one causing the error.

[lancetx]

Finally figured it out - I was able to set the JDBC driver to output the SQL.  Hibernate was prefixing a database reserved key word with the table alias.  So I guess I will have to send that to the Hibernate group.