• 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 Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Websphere 6.0 DataSource and Microsoft's JDBC driver

 
Ranch Hand
Posts: 427
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I forgot to mention: I am using a V4 DataSource in Websphere 6.0
 
author
Posts: 4335
39
jQuery Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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 ]
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic