Skip to content

Advanced Configuration

eostermueller edited this page Nov 21, 2014 · 3 revisions

Tracing a Program Launched by Eclipse

If you're tracing a program while it is running under Eclipse, installation Steps 1 and 2 won't work. Instead of using -javaagent parameter, launch your program using the Eclipse InTrace Plugin. Then continue with step 3 and launch the wuqiSpank web app.

JDBC Driver

Want to visualize SQL but not using java? use [Text-File-Import](Text File Import). Read on for Java people. New in 0.07, wuqiSpank supports the 5 JDBC drivers detailed below without any additional configuration. The following doc is no longer necessary to trace your JDBC driver, but is kept around for troubleshooting purposes.

The following specifies which JDBC driver wuqiSpank will trace:

<context-param>
     <param-name>org.headlessintrace.jdbc.IJdbcProvider</param-name>
     <param-value>[choose a JdbcProviderClass from table below]</param-value>
</context-param>
JdbcProviderClass Tested With Notes
org.headlessintrace.jdbc.OracleProvider 11g Default configuration
org.headlessintrace.jdbc.MySqlProvider 5.1.31
org.headlessintrace.jdbc.HsqldbProvider 1.8.0.10
org.headlessintrace.jdbc.PostgresProvider 9.2
org.headlessintrace.jdbc.Db2Provider 10.5 Thanks to Craig Boyd for all the inTrace traces of activity from the DB2 JDBC driver.

Roll Your Own

If your JDBC driver is not listed above, you can also add 'roll your own' support, as follows. The tricky part is discovering which classes in the JDBC driver .jar file work best with wuqiSpank.

  <context-param>
        <param-name>org.headlessintrace.jdbc.IJdbcProvider</param-name>
        <param-value>org.wuqispank.web.WebXmlConfigImpl</param-value>
    </context-param>
    <context-param>
        <param-name>java.sql.Statement.implementors</param-name>
        <!-- Use commas in the following to trace multiple class names that implement java.sql.Statement -->
        <param-value>oracle.jdbc.OracleStatement</param-value>
    </context-param>
    <context-param>
        <param-name>java.sql.Connection.implementors</param-name>
        <!-- Use commas in the following to trace multiple class names that implement java.sql.Connection -->
        <param-value>oracle.jdbc.driver.PhysicalConnection</param-value>
    </context-param>

Clone this wiki locally