P6Spy and Spring.

I had some problems integrating P6Spy in our application following the docs. The docs, which btw make it look pretty easy but they don’t say much about datasources…

Thankfully I stumbled upon this post: Integrate P6Spy with Spring. Mucho easier, yes yes. I tweaked it a bit though, like using P6ConnectionPoolDataSource and the normal (provided with the distribution) spy.properties instead of the described sp6spy.log file.

So using P6Spy with Spring is actually a lot easier then the easy way it’s supposed to be (wow, does that sentence makes sense? ;)) You actually don’t need to know anything about specific P6Spy configuration details.

Now let’s take a look at the output…

[update as requested]

Here’s the relevant snipped from my Spring config

As you can see, piece of cake. ;)

[update 12/09/2006] moved the snipped to pastie