Declared Transactions still contain multiple commits

[pokeefb]

You should try to debug stuff on jdbc level to see what's going on really.

This might sound a little stupid, but how do I set up Craftsman Spy to work for me (the website doesn't provide much info)? I've tried this:

1. Make sure spy.jar is in the class path
2. Update the log4j file to include the "craftsman.spy" category
3. Run the application using the -Dspy.driver=oracle.jdbc.driver.OracleDriver option

and nothing much happens.

[dejanp]

1. is ok.
2. is not needed.
3. is not needed.
4. is change the driver in your datasource to "craftsman.spy.SpyDriver"
5. is change the jdbc url to "jdbc:spy:originaldriverhere:restoftheoriginal url"

[pokeefb]

I'm still not getting this right. My original data source configuration is:

<bean id="dataSource" class="oracle.jdbc.pool.OracleConnectionCacheImpl" destroy-method="close">
    <property name="URL" value="jdbc:oracle:thin@(... url ...)>
    <property name="user" value="${database.user}"/>
    <property name="password" value="${database.password}"/>
    <property name="maxLimit" value="${database.maxActive}"/>
</bean>

To get Craftsman Spy to work, changed it to the following:

<bean id="dataSource" class="oracle.jdbc.pool.OracleConnectionCacheImpl" destroy-method="close">
    <property name="URL" value="jdbc:spy:oracle:thin@(... url ...)" >
    <property name="user" value="${database.user}"/>
    <property name="password" value="${database.password}"/>
    <property name="maxLimit" value="${database.maxActive}"/>
    <property name="driverType" value="craftsman.spy.SpyDriver" />
</bean>

When I run the application, I get an error stating "Invalid Oracle URL specified".

Any idea what I'm doing wrong?

Thanks again,
Ben

[dejanp]

<property name="URL" value="jdbc:spy:theoriginaldriverhere:oracle:thin@ (... url ...)" >

[pokeefb]

Hmmm... How do I find the original driver?

As far as I can tell, the application only ever specifieds jdbc:oracle:thin, which is the name of the thin client driver, yes?