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
15
votes
4 answers

Anything better than P6Spy?

I am planning to use P6Spy to intercept database statements within our architecture. However, I noticed on the P6Spy website that the last release of the software was back in 2003. Is there anything out there that is better or should I just stick…
rmcc
  • 3,507
  • 7
  • 29
  • 25
6
votes
3 answers

hibernate p6spy problem

I'm trying to get to grips with what hibernate is doing under the hood, and I'm using p6spy as a proxy for the mysql jdbc driver so I can see what's really going to the database. I'm a little confused by the output from p6spy however - grateful for…
Jeremy
  • 1,635
  • 2
  • 18
  • 21
6
votes
5 answers

Only show effective SQL string P6Spy

I'm using p6spy to log the sql statements generated by my program. The format for the outputted spy.log file looks like this: current time|execution time|category|statement SQL String|effective SQL string I'm just wondering if anyone knows if…
user22
  • 117
  • 4
  • 11
5
votes
1 answer

How does P6SPY work?

Pretty much everything in the question. I just discovered p6spy in association with hibernate which is really cool to see the actual sql queries, though I'm quite baffled on how it works. So how does it work?
Sephy
  • 50,022
  • 30
  • 123
  • 131
5
votes
1 answer

capture final SQL query generated by hibernate JPA in JBoss AS 7

I have been trying really hard to capture the exact SQL of a really complicated JPA query in my project for the purpose of optimization but so far i am unable to do so. I have tried the following ways: 1) Tried enabling hibernate logs via logback by…
ishan
  • 1,202
  • 5
  • 24
  • 44
4
votes
3 answers

Intercept the JDBC statements to the database using P6Spy in a hibernate application

I am developing a hibernate console application and refer to this article http://www.mkyong.com/hibernate/how-to-display-hibernate-sql-parameter-values-solution/ to setup the P6Spy in order to see what is the actual value of the "(?)" of the SQL…
Ken Chan
  • 84,777
  • 26
  • 143
  • 172
4
votes
2 answers

Usage of P6Spy with datasource in Spring applicationContext.xml

I am using Hibernate 4, Spring 3, JSF 2.0 and Weblogic 10.3.6 as server. I have created datasource on Weblogic server and in applicationContext.xml I have defined datasource as
Jacob
  • 14,463
  • 65
  • 207
  • 320
3
votes
1 answer

spring boot with p6spy sleuth traces interpretation

We have been using spring cloud sleuth in our micoservices for tracing. We have also added enabled jdbc level spans from spring data Repository connection, fetch and query. I am seeing some weird jps traces of name jdbc:/datasource/connection which…
v78
  • 2,803
  • 21
  • 44
3
votes
0 answers

Use p6spy to log Spark JDBC datasource

I would like to log the JDBC statements that my Spark job executes with the help of p6spy. Using p6spy is usually straightforward: one inserts the string :p6spy: into the jdbc url and includes the p6spy driver classes into the classpath of the…
werner
  • 13,518
  • 6
  • 30
  • 45
3
votes
2 answers

p6spy outputs sql messages twice with spring boot

I want to show sql parameters via p6spy in spring boot, because hibernate is showing sql parameters quite bulky. But for some reason p6spy logger output sql message twice although actually queries to the db execute once. Usual spring application…
Дима Годиков
  • 317
  • 3
  • 10
3
votes
2 answers

P6Spy does not log hibernate update with HSQLDB

I'm trying to set up a simple project using HSQLDB to explain Hibernate basics. For a better understanding of Hibernate internal's I would like to install P6Spy to show corresponding SQL statements. I can't get SQL Update statements in my…
yunandtidus
  • 3,847
  • 3
  • 29
  • 42
3
votes
1 answer

exclude include in p6spy not working

I was trying p6spy filter option. I am using p6spy version 2+ I need to exclude logs with select statements. My properties file is shown below. filter=true include= exclude=select [a-z,_, , =, ']* But with this configuration i am not getting the…
Ronald James
  • 647
  • 1
  • 5
  • 13
3
votes
2 answers

How to configure p6spy to redirect its output into a file

I was able to successfully configure P6Spy to intercept the JDBC calls and output them to Eclipse's console. However, I'd like to have those logs with the binding parameters captured in the file. Could someone please give me a hand on how to to…
Simeon Leyzerzon
  • 18,658
  • 9
  • 54
  • 82
3
votes
2 answers

How can I configure sql logging with the Flyway gradle plugin?

I'm using the standard Flyway Gradle plugin from Flyway 3.2.1 Flyway doesn't seem to output any SQL logging, at least not at debug level. I've configured p6spy and I can now see the SQL that Flyway is issuing, but only by enabling Gradle debug…
Shorn
  • 19,077
  • 15
  • 90
  • 168
3
votes
1 answer

Generate a SQL script from Hibernate

I'm using Hibernate 4.3.5-Final for my Java Swing application and I do many UDPATE, INSERT and DELETE with it (in HQL or with Criteria). Now, what I'm trying to do is to export a SQL script of all modifications done on my database but I don't know…
Florentin Le Moal
  • 177
  • 8
1
2 3 4 5