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
