[OKC JUG] P6Spy & jahia.net's JDBC SQL Profile for SQL

[Ravi Mutyala]

deregisterdrivers=true may solve the problem, if your JDBC driver is
loaded by classloader before it loads P6Spy.  Default option in
spy.properties is false.

Ravi.

On Fri, Jan 30, 2009 at 2:09 PM, Suhas Walanjoo
<suhas.walanjoo at gmail.com> wrote:
> Ravi,
>
> Thanks for your message. This is what I did. (Also P6Spy stopped new
> development a few years ago, so how did youy get specific instructions for
> JBoss (which is relatively recent development)
>
> I made the following changes to my application:
>
> In spring-datasource.properties, I changed the driver class name as
> following
> #datasource.driverClassName=oracle.jdbc.driver.OracleDriver
> datasource.driverClassName=com.p6spy.engine.spy.P6SpyDriver
>
> Used given spy.properties from p6spy distribution and changed as following:
>
> Added
> # oracle driver
> realdriver=oracle.jdbc.driver.OracleDriver
> Commented
> # the mysql open source driver
> #realdriver2=org.gjt.mm.mysql.Driver
>
> Put it in a diectory so that it would be picked up by maven during the build
> and it would be puts in WEB-INF/classes directory
>
> next I changed pom.xml of my application to add
>
> <dependency>
> <groupId>p6spy</groupId>
> <artifactId>p6spy</artifactId>
> <version>1.3</version>
> </dependency>
> I used "jar -tvf mywebapp.war" command to check both the above files exist
> in the respective directories of WEB-INF.
>
> I started Jahia SQL profiler with this command
> java -Xmx256m -jar sqlprofiler.jar
>
> and then only deployed the application war on weblogic. The modified
> application seems to work as usual.
>
> However, Jahia SQL Profiler does give an error message "Not Connected to
> P6Spy"
>
> Please help.
>
> Regards,
>
> Suhaas
>
> On Fri, Jan 30, 2009 at 3:01 PM, Ravi Mutyala <rmutyala at gmail.com> wrote:
>>
>> Suhaas,
>>
>> I used the P6Spy with hibernate and JBOSS. Check the sample
>> spy.properties that comes with the release and you should get most of
>> your configuration. deregisterdrivers=true is the only change I had to
>> make in the sample property file.
>>
>> Regards,
>> Ravi.
>>
>> On Fri, Jan 30, 2009 at 1:49 PM, Suhas Walanjoo
>> <suhas.walanjoo at gmail.com> wrote:
>> > Hi,
>> >
>> > I tried to set up Jahia.net's JDBC SQL Profile (this in turn uses P6Spy)
>> > with Weblogic
>> > and Oracle, by following the documentation.
>> >
>> > Has anyone worked with either Jahia.net's JDBC SQL Profile  or P6Spy ?
>> >
>> > Regards,
>> >
>> > Suhaas
>> >
>> > _______________________________________________
>> > Jug mailing list
>> > Jug at lists.okcjug.org
>> > http://lists.okcjug.org/listinfo.cgi/jug-okcjug.org
>> >
>> >
>> _______________________________________________
>> Jug mailing list
>> Jug at lists.okcjug.org
>> http://lists.okcjug.org/listinfo.cgi/jug-okcjug.org
>
>