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

[Suhas Walanjoo]

Thanks!!!

On Fri, Jan 30, 2009 at 3:32 PM, Ravi Mutyala <rmutyala at gmail.com> wrote:

> 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
> >
> >
> _______________________________________________
> Jug mailing list
> Jug at lists.okcjug.org
> http://lists.okcjug.org/listinfo.cgi/jug-okcjug.org
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okcjug.org/pipermail/jug-okcjug.org/attachments/20090130/f8e10f9a/attachment.htm>