I am trying to configure a DataSource using Websphere 6.0 and Microsoft's JDBC Driver for SQL Server 2000.
After configuring the JDBC Provider and the DataSource, the Test Connection operation generates this message:
DSRA8101E: DataSource class cannot be used as one-phase: ClassCastException: com/microsoft/jdbc/sqlserver/SQLServerDriver incompatible with javax/sql/ConnectionPoolDataSource, error code: NOT_A_1_PHASE_DS
How can I fix this? Is anybody using Microsoft�s JDBC driver and Websphere 6.0?
posted 14 years ago
I forgot to mention: I am using a V4 DataSource in Websphere 6.0
Which database and which database driver are you using? Have you tried using the XA database driver instead of the non-XA (or visa versa)? I'm familiar with 2-phase errors (more common), but I haven't seen 1-phase errors before.