Microsoft SQL Server 2005 is not compatible with versions of WebSphere Application Server prior to version 6.1
 Technote (troubleshooting)
 
Problem(Abstract)
Due to some changes in SQL syntax between Microsoft SQL Server 2000 and Microsoft SQL Server 2005, IBM® WebSphere® Application Server versions prior to V6.1 are not compatible with the 2005 product. The table lock hints, generated CMP code, and certain internal queries, no longer work in Microsoft SQL Server 2005.
 
Resolving the problem
Due to some changes in SQL syntax between Microsoft SQL Server 2000 and Microsoft SQL Server 2005, Application Server versions prior to V6.1 are not compatible with Microsoft SQL Server. This is due to the fact that table lock hints, generated CMP code, and certain internal queries, no longer work in Microsoft SQL Server 2005.
In fact, the level of the JDBC driver for use with Microsoft SQL Server, which is delivered with Application Server versions prior to V6.1, does not claim support for Microsoft SQL Server 2005. If a customer uses any JDBC driver capable of connectivity to the Microsoft SQL Server 2005 database, and uses it with a version of Application Server prior to V6.1, it may work to some degree but will not be completely compatible. IBM knows that the incompatibilities between the 2000 and 2005 products do affect other scenarios and can cause failures. For all of these reasons, IBM cannot claim support for the Microsoft SQL Server 2005 with versions of Application Server prior to V6.1.

For customers who do not plan to use any of the Microsoft SQL Server 2005 specific functions in their applications, or who have moved to a next release of their database, the compatibility mode [in combination with acquiring a third party JDBC driver that supports the Microsoft SQL Server 2005 database] might be a good solution. However, for customers who have purchased Microsoft SQL Server 2005 specifically for the new features it provides, this will not be compatible unless the customer also moves to Application Server V6.1 or later.

For additional reference, please refer to the IBM support statement and supported hardware and software information found at:
http://www.ibm.com/support/docview.wss?uid=swg27004311

Here is a common problem that a customer will encounter if they do try to use SQL Server 2005 with WebSphere Application Server Version 5.1 or Version 6.0:
[2/15/08 14:40:55:425 EST] 33c430be WSRdbXaResour E DSRA0304E: XAException occurred. XAException contents and details are: The cause is : null.
[2/15/08 14:40:55:425 EST] 33c430be WSRdbXaResour E DSRA0302E: XAException occurred.
Error code is: XAER_NOTA. Exception is: [IBM][SQLServer JDBC Driver][SQLServer]xa_commit (40000000) returns -4
[2/15/08 14:40:55:441 EST] 33c430be XATransaction E J2CA0027E: An exception occurred while
invoking commit on an XA Resource Adapter from dataSource Wfm3DataSource, within transaction ID {XID: formatId(57415344), gtrid_length(39), bqual_length(28), data(000000000000000100000001b764428f08576713c3916b991ddb81e1e2a78606736
57276657231b764428f08576713c3916b991ddb81e1e2a786060000000100000000)}:
javax.transaction.xa.XAException: [IBM][SQLServer JDBC Driver][SQLServer]xa_commit (40000000) returns -4
at
com.ibm.websphere.jdbcx.sqlserver.SQLServerImplXAResource.executeXaRpc(Unknown Source)
at
com.ibm.websphere.jdbcx.sqlserver.SQLServerImplXAResource.commit(Unknown Source)
at
com.ibm.websphere.jdbcx.base.BaseXAResource.commit(Unknown Source)
at
com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl.commit(WSRdbXaResourceImpl.java:206)
at
com.ibm.ejs.j2c.XATransactionWrapper.commit(XATransactionWrapper.java:439)
The fix in APAR PK59038 upgrades the Data Direct Connect driver that WebSphere provides. Applying a CF that applies this APAR fix may resolve this problem.
----------------------------------------------------------
Disclaimer: The information in this IBM Technote is believed to be accurate at the time of publishing based on currently available information. Information in this document may change at any time at IBM’s sole discretion based on market opportunities or other factors, and are not intended to be a commitment to future products, feature availability, or support in any way. IBM is not responsible for the misuse of the information provided in this Technote and use of the information constitutes acceptance for use on an AS IS basis and at the user's risk. There are no warranties with regard to this information. Neither the author nor the publisher accepts any liability for any direct, indirect, or consequential loss or damage arising from use of, or reliance on, this information.
 
 
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 > General
Operating system(s): z/OS
Software version: 6.0
Software edition:
Reference #: 1254636
IBM Group: Software Group
Modified date: Jan 31, 2007