• 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
  • Tim Cooke
  • paul wheaton
  • Jeanne Boyarsky
  • Ron McLeod
Sheriffs:
  • Paul Clapham
  • Liutauras Vilda
  • Devaka Cooray
Saloon Keepers:
  • Tim Holloway
  • Roland Mueller
Bartenders:

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: 4354
45
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 ]
 
Sometimes you feel like a nut. Sometimes you feel like a tiny ad.
Smokeless wood heat with a rocket mass heater
https://woodheat.net
reply
    Bookmark Topic Watch Topic
  • New Topic