I made the following changes to my application:
In spring-datasource.properties, I changed the driver class name as following
Used given spy.properties from p6spy distribution and changed as following:
# oracle driver
# the mysql open source 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
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"