http://www.ibm.com/developerworks/websphere/library/techarticles/0905_roberts/0905_roberts.html
-
Modify the deployment XML file to change data source implementation class:
${WCDE_HOME}\workspace\WC\META-INF\ibmconfig\cells\defaultCell\applications\defaultApp\deployments\defaultApp\resources.xml
-
Change the implementation class name:
<resources.jdbc:JDBCProvider description="Oracle JDBC Driver" implementationClassName="oracle.jdbc.pool.OracleConnectionPoolDataSource" name="Oracle JDBC Driver" xmi:id="JDBCProvider_1123801737693">
-
With the wrapper class name:
<resources.jdbc:JDBCProvider description="Oracle JDBC Driver" implementationClassName="com.ibm.issw.jdbc.wrappers.WrappedOracleDataSource" name="Oracle JDBC Driver" xmi:id="JDBCProvider_1123801737693">
-
Place the JAR file at this location instead:
${RAD_HOME}\SDP\runtimes\extraJars
-
Make sure the JDBC profiler server is up and running
$ grep -i "jdbc profiler" ${WCDE_HOME}\wasprofile\logs\server1\trace.log [9/18/12 11:37:04:291 PDT] 00000014 JdbcProfilerD I Jdbc Profiler listening to socket 26000
For RAD 9.5, I had to do the following steps:-