Test connection button in WebSphere Application Server V5 fails when trying to connect to Microsoft SQL Server datasource (XA)
 Technote (troubleshooting)
 
Problem(Abstract)
The test connection button fails to establish a connection to Microsoft® SQL Server with a "Could not find stored procedure 'master..xp_jdbc_open' " error when connecting from WebSphere® Application Server V5.
 
Cause
The following exception occurs due to missing components from the Microsoft SQL Server database:

SQLState(HY000) vendor code(2812)
java.sql.SQLException: [IBM][SQLServer JDBC Driver][SQLServer]Could not
find stored procedure 'master..xp_jdbc_open'.
at com.ibm.websphere.jdbc.base.BaseExceptions.createException(Unknown
Source)
at com.ibm.websphere.jdbc.base.BaseExceptions.getException(Unknown
Source)
at
com.ibm.websphere.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
 
Resolving the problem

To resolve this issue, install Stored Procedures for JTA which you can download from this site:

ftp://ftp.software.ibm.com/software/websphere/info/tools/DataDirect/datadirect.htm#JTA

The instructions to install the Stored Procedures for JTA are available from DataDirect here:

http://www.datadirect.com
 
 
Cross Reference information
Segment Product Component Platform Version Edition
Application Servers Runtimes for Java Technology Java SDK
 
 


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server > DB Connections/Connection Pooling
Operating system(s): Windows
Software version: 5.0
Software edition:
Reference #: 1168355
IBM Group: Software Group
Modified date: Sep 11, 2004