We are running JBoss 3.0.2 with Tomcat 4.0.4 against SQL Server 2000 Enterprise Edition.
We are seeing the following error:
java.sql.SQLException: [Microsoft][SQLServer 2 000 Driver for JDBC][SQLServer]Invalid object name 'vendor'.
This error can occur when hitting any table, not just vendor.
The error first appears after we made changes to the database schema using a DTS package. We often get this error after an application restart. Sometimes the application will run for several days without the error appearing, then it suddenly appears again.
Any ideas or suggestions would be greatly appreciated.