-
I noticed a bug concerning the "exclude" option.
In the file spy.properties it is said that "exclude" takes a "comma separated list of tables to exclude when filtering". After looking in the current source of the svn trunk I found out that
P6LogQuery.foundTable()
contains the statement
found = Pattern.matches(tables[i], sql);
The JDK-API for Pattern states that
public static...
2009-10-10 19:10:17 UTC by segfault79
-
Hi.
I am trying to use p6spy for Tomcat 6 for logging **sql**, also.
1. I am copy **p6spy.jar to Tomcat/lib**,
2. and copy **spy.properties to WEB-INF/classes**,
3. then modify xml-config file of application to use P6SpyDriver
4. and Modify the realdriver line in the **spy.properties**
I am don't edited TOMCATOPTS environment variable follows:
*SET...
2009-10-08 15:16:32 UTC by bunakovm
-
patmoore committed revision 21 to the p6spy SVN repository, changing 2 files.
2009-09-10 19:43:05 UTC by patmoore
-
I had configured P6Spy on JBoss-4.2.1.GA pointing to Oracle or Enterprise DB, please click on the following for more information:
http://yingliang.researchblog.org/2009/08/28/configure-p6spy-with-jboss-421ga/
Thanks.
2009-08-28 20:50:05 UTC by yldu
-
I've built from the CVS (not SVN) head and run the unit tests. P6TestOptions fails with the message "expected a driver 3 of 'Borax' but found 'Driver 8'".
Have you seen this?.
2009-08-25 05:11:34 UTC by whitemarlin
-
the documentation says that the log line format is "current time|execution time|category|statement SQL String|effective SQL string".
I have output that looks like this:
* p6spy - 10:32:57|0|1|statement|select this_.id as id0_0_, this_.version as version0_0_, this_.create_time as create3_0_0_, this_.name as name0_0_ from member_group this_ where this_.name=?|select this_.id as...
2009-08-24 21:39:56 UTC by supune
-
Is there any way to use p6spy with an XA JDBC driver? I am currently trying to use the oracle.jdbc.xa.client.OracleXADataSource Thin/XA driver under WebLogic 9.2. However, when I configure this I get the following stack trace during startup (presumably because the XA driver does not implement the appropriate interface):
<Feb 7, 2003 12:08:05 PM GMT-05:00> <Error>...
2009-08-19 12:41:24 UTC by varaprasad8
-
Hi
I use Jonas 4.8 and I followed the notes in p6spy documentation, but I don't obtain sql staements in spy.log. I obtain these messages:
Many thanks for your help
1247757646881|-1||debug||com.p6spy.engine.common.P6SpyOptions reloading properties
1247757646901|-1||info||Using properties file: /usr/share/jonas/conf/spy.properties
1247757646913|-1||info||No value in environment for...
2009-07-16 15:39:18 UTC by bilell
