November 3, 2010 at 1:39 pm
About 6 months back, we migrated the database from SQL Server 2000 to SQL Server 2008.
In this 6 month period since the migration we intermittently keep getting the following error:
SQL|Dynamic|Query|SELECT * FROM MASTER..SPT_DATATYPE_INFO: java.sql.SQLException: Invalid object name 'master..spt_datatype_info'. Severity 16, State 1, Procedure 'Server_Name null', Line 1
The application is written in Java and uses the SQL Server 2008 as the database. The JDBC driver is: weblogic.jdbc.mssqlserver4.Driver
When we start getting the above error the Stall count increases to 50 and eventually the entire weblogic cluster has to be recycled. After this, for a few weeks everything is quiet, no errors but then again this error shows-up.
Tried to find out the trend but did not see anything specific related to the error.
I discussed this error with our SQL Server DBA and Weblogic Admin and they do not see anything out of ordinary other than the increase in the number of stalled transactions finally leading to recycling of the entire cluster.
I googled this: 'master..spt_datatype_info' (Returns information about the data types supported by the current environment) and found out this is no longer supported in version 2005 (and 2008), instead a stored procedure is available:
USE master;
GO
EXEC sp_datatype_info -9;
GO
Note that our application never calls this SQL directly: SELECT * FROM MASTER..SPT_DATATYPE_INFO, looks like (not 100% sure) it is executed internally by SQL Server.
Please let me know if anyone has encountered this issue and if yes, what solution worked out...
Thanks
November 3, 2010 at 2:04 pm
You probably need to get new drivers from the vendor. Sometimes, drivers need to get information from the DBMS catalog about the result sets that are returned. Your current driver expects to get that information from a catalog schema that doesn't exist in the newer version of the server. This probably isn't something you can fix without weblogic's help.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply