Installing RAD SQL Profiler in WebSphere Commerce Developer 7

sql_profiler_wcde7.md

Original Instructions

http://www.ibm.com/developerworks/websphere/library/techarticles/0905_roberts/0905_roberts.html

Changes

1. 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
   

2. 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">

3. 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">

4. Place the JAR file at this location instead:

   ${RAD_HOME}\SDP\runtimes\extraJars
   

5. 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:-

1. Install the plugin 'Eclipse 2.0 Style Plugin Support" from the Eclipse update site at http://download.eclipse.org/eclipse/updates/4.4 (other higher versions didn't work for me)
2. In the eclipse.ini file, remove the vm argument "Dosgi.framework.extensions=org.eclipse.wst.jsdt.nashorn.extension" if available. When having this argument, the SQL profiler plugin installation kept on failing
3. Copy the jdbcProfiler.jar to <WAS_INSTALL_DIR>/lib/ext (for example my local path was D:\ibm\websphere\appserver\lib\ext