• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Paul Clapham
  • Bear Bibeault
  • Jeanne Boyarsky
Sheriffs:
  • Ron McLeod
  • Tim Cooke
  • Devaka Cooray
Saloon Keepers:
  • Tim Moores
  • Tim Holloway
  • Jj Roberts
  • Stephan van Hulst
  • Carey Brown
Bartenders:
  • salvin francis
  • Scott Selikoff
  • fred rosenberger

Websphere 6.0 DataSource and Microsoft's JDBC driver

 
Ranch Hand
Posts: 427
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 427
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I forgot to mention: I am using a V4 DataSource in Websphere 6.0
 
author
Posts: 4226
33
jQuery Eclipse IDE Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Sean Sullivan
Ranch Hand
Posts: 427
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
 
If we don't do the shopping, we won't have anything for dinner. And I've invited this tiny ad:
the value of filler advertising in 2020
https://coderanch.com/t/730886/filler-advertising
reply
    Bookmark Topic Watch Topic
  • New Topic