I am trying to migrate from Jboss AS version 5.1 to 6.1 and I am having this strange issue. I´ll aprecciate if someone help me.
I have this class:
And I have the table TESTE_JBOSS in my database SQL SERVER 2008 R2 with collation Latin1_General_BIN. Note that both the table names are in uppercase.
When I put the server (JbossAS 6.1.0) up everything seems ok, but when I tried to use the application I got the error:
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'teste_jboss'.
When I change the table name in database to lowercase things work, but I can´t change all the table and column names to lowercase.
I tried to change the persistence.xml, the version of hibernate to 3.6.7, the datasource, the jdbc driver. But anything worked.
I run this exactly same application in JbossAS 6.0 Final and it worked fine. I don´t know if there is some configuration or if is a bug of JbossAS 6.1.0.