Hello, group,
Has anyone successfully configured P6Spy in Websphere Test Environment (5.0) with
DataSource?
I have a DataSource myDS defined and then changed name to myDSReal. Then I configured
P6Spy DataSource with name myDS. Then I modified spy.properties as follows,
realdriver=com.ibm.as400.access.AS400JDBCDriver
realdatasource=myDSReal
realdatasourceclass=com.ibm.websphere.rsadapter.DB2AS400DataStoreHelper
realdatasourceproperties=port;3306,serverName;myserver
I do see a spy.log file is created, but see following error from console,
[1/27/04 16:53:20:851 PST] de42baf FreePool E J2CA0046E: Method
createManagedConnctionWithMCWrapper caught an exception during creation of the
ManagedConnection for resource jdbc/ms4pib, throwing ResourceAllocationException.
Original exception: com.ibm.ws.exception.WsException: DSRA8101E: DataSource class
cannot be used as one-phase: ClassCastException:
com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource
at
com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException.<init>(DataStoreAdapterException.java:222)
at com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException.
If you have successfully configured P6Spy in WebSphere Test Env 5.0 with DataSource,
please help!
Thank you!
