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. |