Stack Overflow
Stack Overflow

Questions tagged [p6spy]

P6Spy is a framework that enables database activity to be seamlessly intercepted and logged with no code changes to the application.

P6Spy is a framework that enables database activity to be seamlessly intercepted and logged with no code changes to the application.

Resources:

65 questions
3
votes
2 answers

How to Configure P6Spy with OracleConnectionPoolDataSource in specific

We are using Oracle connection Pooling mechanism in our project as our application uses some oracle specific features. The configuration of our datasource in jetty.xml is as follows:
Kriss
  • 31
  • 1
  • 3
2
votes
1 answer

P6spy doesn't spy on hsql jdbc driver

When trying to spy on the jdbc connection to a hsqldb database it doesn't work. It looks like the org.hsqldb.jdbcDriver is not deregistered.
raisercostin
  • 8,777
  • 5
  • 67
  • 76
2
votes
2 answers

P6SpyDriver cannot be cast to javax.sql.XADataSource exception while trying to configure P6Spy 2.0 with xa-datasource using Jboss AS 7 and potgres

P6spy v2 has a support for xa datasources - P6spy on github In my jboss AS 7 standalone-full-ha.xml, i have the following datasource configurations.
ishan
  • 1,202
  • 5
  • 24
  • 44
2
votes
2 answers

P6Spy not logging SQL

I have a program that updates tables in a database using prepared statements, and I'm trying to see the output of all the SQL statements that are implemented. My research suggested P6Spy which looked great, I downloaded it, added the P6Spy.jar as a…
user22
  • 117
  • 4
  • 11
2
votes
2 answers

Filtering with P6SPY

Is there a way to set the filter in p6spy, such that it only logs "insert/delete/update" and NOT "select" SQL statements? Documentation of p6spy mentions: "P6Spy allows you to monitor specific tables or specific statement types" An example they gave…
RJWebDev
2
votes
4 answers

How to setup p6spy driver in Arquillian tests on jBoss 7.x?

Apart from setting up the module in JBOSS_HOME/modules/com/p6spy/main adding p6spy.jar and module.xml saying: …
Boris Pavlović
  • 63,078
  • 28
  • 122
  • 148
2
votes
2 answers

Grails 2.0.4 and sql profiling using p6spy plug-in configuration

I am using grails 2.0.4. Even though the sql profiler client is connecting; p6spy is not logging anything. I suspect that the problem lies in the property file, or that there is a conflict with my Config.groovy log4j settings. •…
Sami
  • 51
  • 2
2
votes
1 answer

p6spy log vs. Hibernate log

p6spy is very useful for debuging hibernate query, but, there is any way to format query with the same logic of Hibernate ? : p6spy log example : p6spy - 1339663561390|15|0|statement|select…
Up_Router
  • 73
  • 9
1
vote
0 answers

Why doesn't p6spy show the correct spatial query for Oracle?

I set p6spy to show all SQL statements. But it doesn't show correct SQLstatements for spatial a query. Here is one example: select * from ( select this_.myactivity_id as y0_ from mytable this_ where this_.start_time_local…
Sean Nguyen
  • 12,528
  • 22
  • 74
  • 113
1
vote
0 answers

spring-boot-data-source-decorator with p6spy are not logging insert statements

I am using p6spy to log the sql statements.we are using springboot/hibernate for Java ORM mapping.I see only select statements are getting loggged in spy.log.when insert statemnets are executing in the code I see only commmit is coming in the log…
user739115
  • 1,117
  • 5
  • 20
  • 41
1
vote
0 answers

Is it possible to solve the problem that the p6spy log goes out twice?

Is it possible to solve the problem that the p6spy log goes out twice? If you look at the p6spy log, two logs are output, consisting of a 'question mark log' and a 'value log corresponding to a question mark'. At this point, I want to get rid of the…
user18045244
  • 65
  • 4
1
vote
1 answer

How to use p6spy for standalone application that limits its JDBC drivers?

I have a standalone 3rd party application working with Oracle database and I need to troubleshoot its DB queries. And I don't have access to its source code (nor desire to decompile it :-) ). Its DB connection configuration has several separate…
Vladislav
  • 11
  • 2
1
vote
1 answer

Modify sql statements generated by JDBC

What is the simplest way to intercept and modify sql statements generated by jdbc driver? There is something like P6Spy. According to information from google, an open source framework to support applications that intercept and optionally modify…
mike
  • 11
  • 1
1
vote
1 answer

Specify user's home directory in a .properties file

I am trying to integrate p6spy (3.x.x) in my project, and in spy.properties file, I wanted to specify logfile=${user.home}/logs/spy-%d{yyyyMMdd}.log or at least logfile=${user.home}/logs/spy.log So far, I couldn't manage to do either, and the…
Turzo
  • 490
  • 1
  • 5
  • 14
1
vote
1 answer

How to configure p6spy for mssql server with hibernate?

In our web application we are using spring, hibernate & sql server 2016 as db. We are using jndi to connect to the database. To record all the queries executed by hibernate I am trying to implement the p6spy. Here are the changes I have…
Rajeshkumar
  • 815
  • 12
  • 35
1
2
3 4 5