Installation

Backpedal is implemented as a P6Spy module. As such, the majority of the installtion instructions are in the P6Spy installtion guide. Follow the instructions in the guide, and then come back to this page and follow the few remaining, Backpedal specific installation instructions below. Here is the

.

Backpedal installation

• Place the backpedal.nconf file in the directory spy.properties is in.
• Place in your classpath all the jars mentioned here except junit, veggie-test and easymock
• Update spy.properties to install the Backpedal module, as follows

    module.log=com.p6spy.engine.logging.P6LogFactory
    #module.outage=com.p6spy.engine.outage.P6OutageFactory
    module.backpedal=net.sourceforge.backpedal.p6spy.BackpedalP6SpyFactory

Server port

The server port is configured in backpedal.nconf. It defaults to 8899. The relevant section is:

    <component
        type="net.sourceforge.backpedal.api.server.BackpedalServer"
        class="net.sourceforge.backpedal.impl.server.BackpedalServerImpl">
        <port>8899</port>
    </component>

Real JDBC driver (yes, again!)

Backpedal needs to make "real" connections to the database when it needs to find the current values for a row before issuing a SQL statement from your application. This is required because it needs to cache the values of the row so it can backpedal to those values.

Now, you have already entered the name of the real JDBC driver in spy.properties. Unfortunately Backpedal requires this information (and some more) once again in its own configuration file. Backpedal needs the driver name, the connection url and any properties the JDBC driver requires to connect. Here is a sample for MySQL:

    <component
        type="net.sourceforge.backpedal.api.db.ConnectionFactory"
        class="net.sourceforge.backpedal.impl.db.ConnectionFactoryImpl">
        <driverName>com.mysql.jdbc.Driver</driverName>
        <connectUrl>jdbc:mysql://localhost/test</connectUrl>
    </component>

An Oracle thin driver configuration would look like this:

    <component
        type="net.sourceforge.backpedal.api.db.ConnectionFactory"
        class="net.sourceforge.backpedal.impl.db.ConnectionFactoryImpl">
        <driverName>oracle.jdbc.driver.OracleDriver</driverName>
        <connectUrl>jdbc:oracle:thin:@ipaddress:port:sid</connectUrl>
        <properties>
            <property>username=[your username]</property>
            <property>password=[your password]</property>
        </properties>
    </component>