Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Installing RAD SQL Profiler in WebSphere Commerce Developer 7

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
    
@faisalkhalique

This comment has been minimized.

Copy link

commented Dec 15, 2018

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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.