Com. Microsoft. sqlserver. JDBC. sqlserverexception: the object name 'xx' is invalid.

Myeclipse error message:

Error: COM. Microsoft. sqlserver. JDBC. sqlserverexception: the object name 'xx' is invalid.

Warning SQL error: 208, sqlstate: s0002

 

Error Description: The hql statement can be run in sqlserver, but an error is returned when it is run in hibernate.

Solution: the settings in the. HBM. xml file mapped to the data table are incorrect. You must not only add the database name catalog = "eportal", but also add the schema name schema = "DBO ".

This is a new feature in sqlserver2005, which can be omitted in MySQL.