was version: 6.0 Implementation class name of "Oracle JDBC Driver" : oracle.jdbc.xa.client.OracleXADataSource
When running the italic lines, there are below exceptions: DSRA9350E: Operation Connection.commit is not allowed during a global transaction. DSRA9350E: Operation Connection.rollback is not allowed during a global transaction.
How to modify? As someone mentioned, just comment the italic lines, but how to commit or rollback db transaction?
When you are using a XADatasource in a managed environment, the app server takes care of committing and rolling back the transactions in which this XADatasource participates. In your case the XA datasource is being used in a EJB transaction. Your application is not supposed to commit/rollback the database transaction.
Thanks, but the same version of source codes in weblogic has no such problem, any reason? (At least, when creating connection pool in weblogic, "Implementation class name" of "Oracle JDBC Driver" can not be set anywhere.)
Joined: Jul 24, 2006
In weblogic, there is only such set: "Driver Classname racle.jdbc.driver.OracleDriver".
"oracle.jdbc.driver.OracleDriver" and "oracle.jdbc.OracleDriver" (which mentioned in the weblogic link provided by you) can not be set in websphere because there is below exception when "Test connection": Test connection failed for data source xxxx on server xxxxsvr at node xxxxnode with the following exception: java.lang.Exception: DSRA8101E: DataSource class cannot be used as one-phase: ClassCastException: oracle.jdbc.driver.OracleDriver, error code: NOT_A_1_PHASE_DS. View JVM logs for further details.
Otherwise, is there any differece between "Data sources" and "Data sources (Version 4)", I'm using "Data sources" (EJB 2.0), is it ok?