File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Websphere and the fly likes Websphere 6.0 DataSource and Microsoft's JDBC driver Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Products » Websphere
Bookmark "Websphere 6.0 DataSource and Microsoft Watch "Websphere 6.0 DataSource and Microsoft New topic
Author

Websphere 6.0 DataSource and Microsoft's JDBC driver

Sean Sullivan
Ranch Hand

Joined: Sep 09, 2001
Posts: 427
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?

Sean
Sean Sullivan
Ranch Hand

Joined: Sep 09, 2001
Posts: 427
I forgot to mention: I am using a V4 DataSource in Websphere 6.0
Scott Selikoff
author
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3710
    
    5

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.


My Blog: Down Home Country Coding with Scott Selikoff
Sean Sullivan
Ranch Hand

Joined: Sep 09, 2001
Posts: 427
I was unable to get Microsoft's JDBC driver to work in Websphere 6.0

I learned that IBM bundles a SQL Server driver with Websphere 6. I decided to use the IBM supplied driver and everything is now working.
Philip Wu
Greenhorn

Joined: Jan 12, 2006
Posts: 1
Try the following configurtaion for Microsoft SQL 2000 jdbc driver.
Implementation Classname:
com.microsoft.jdbcx.sqlserver.SQLServerDataSource
Data source helper class:
com.ibm.websphere.rsadapter.ConnectJDBCDataStoreHelper
DataSource custom properties:
serverName=...
portNumber=1433
databaseName=...
enable2Phase=false
[ January 12, 2006: Message edited by: Pei-Xun Wu ]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Websphere 6.0 DataSource and Microsoft's JDBC driver