From: Quint Van Deman (quint.vandemangmail.com)
Date: Tue Mar 01 2005 - 13:42:14 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Has anyone been able to configure this properly?
I've been using the JBoss/MaxDB combo for sometime now quite
successfully, but external factors within our project are forcing us to
migrate from jboss to websphere. When I attempt to use the built in
"Test connection" facility within Websphere I get the following:

"Test connection failed for data source myDB on server server1 at node
linuxboxNode01 with the following exception: java.lang.Exception:
DSRA8101E: DataSource class cannot be used as one-phase:
ClassCastException: com.sap.dbtech.jdbc.DriverSapDB, error code:
NOT_A_1_PHASE_DS. View JVM logs for further details."

Any help would be greatly appreciated.

My current (non working) configuration is as follows:

Resources->JDBC Providers
    - Added new provider = MaxDB JDBC Provider
        - Classpath = full path of sapdbc.jar
        - Native library path = blank
        - Implementation class name = com.sap.dbtech.jdbc.DriverSapDB

Resources->JDBC Providers->MaxDB JDBC Provider->Data sources
    - Added new data source = myDB
        - Name = myDB
        - JNDI name = myDB
        - Use this Data Source in CMP = unchecked
        - Data store helper class name = Generic data store helper
        - Component-managed authentication alias = none
        - Authentication alias for XA recovery = Use component-managed
authentication alias
        - Container-managed authentication alias = none
        - Mapping-configuration alias = none

Resources->JDBC Providers->MaxDB JDBC Provider->Data sources->Custom
properties
    - Added 3 new custom properties
        - url = jdbc:sapdb://localhost:7210/myDB
        - username = <username>
        - password = <password>
        - all Type = java.lang.String

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]