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
0
votes
1 answer

How would I instrument an R2DBC for Spring Cloud Sleuth Zipkin?

For a normal data source I would do the following using P6Spy @Configuration @Order(LOWEST_PRECEDENCE) @Slf4j public class DataSourceBeanPostProcessor implements BeanPostProcessor { @Override public Object postProcessAfterInitialization(Object…
Archimedes Trajano
  • 35,625
  • 19
  • 175
  • 265
0
votes
1 answer

Injecting P6Spy in JBoss results in "Wrong driver class [class com.mysql.jdbc.Driver] for this connection URL"

I'm currently debugging an application deployed over JBoss EAP 6.4.0.GA and I want to use P6Spy to check what the database returns. I downloaded the files from Maven and followed the instructions, which were: Create a module in…
lartkma
  • 589
  • 1
  • 5
  • 15
0
votes
0 answers

Something strange happend after spring-boot auto restart

I use a static threadlocal variable store per request sql query count. As the code public class App { public static ThreadLocal count = ThreadLocal.withInitial(() -> 0);; } And i count it when some sql execute public class…
Cao Vison
  • 47
  • 5
0
votes
1 answer

p6spy, create a new log file (with timestamp) at each start

title say it everything. I want to log my sql queries but the problem is, at each program restart it append query in same file because I'm specifying the same in my spy.properties file: driverlist=com.mysql.cj.jdbc.Driver dateformat=yyyy-MM-dd…
kmanish75
  • 19
  • 2
  • 7
0
votes
2 answers

Example to use P6Spy as Proxy Datasource with Quarkus Application

I am new to Microservices. In our project, we are creating DB Connections at every service per container. I was trying to migrate this to a data source but have this problem. Let's say I have Service A and a data source of 10 initial connections is…
Raul Kiran Gaddam
  • 307
  • 3
  • 7
0
votes
1 answer

Configure P6Spy on Quarkus

I'd like to use P6Spy with Quarkus but am unable to configure it by following generic instructions. Has anyone managed to get these two working together?
geca
  • 2,711
  • 2
  • 17
  • 26
0
votes
1 answer

P6Spy Spring Boot starter decorator produces empty output

I configured a Spring Boot starter P6Spy decorator as per the instructions on their site: ## p6spy ### # Register P6LogFactory to log JDBC…
Simeon Leyzerzon
  • 18,658
  • 9
  • 54
  • 82
0
votes
1 answer

Does ps6spy support currentSchema in postgresql url parameter?

I use p6spy-3.8.6 and postgresql-42.2.9.jre7 modules in WildFly 10 to define datasource. In standalone.xml if I use it's I ok - jdbc:postgresql://localhost:5432/migrazione?currentSchema=pidea II ko -…
sunrelax
  • 65
  • 9
0
votes
2 answers

P6Spy. How detect outage statement?

I'm trying to use p6spy for logging outage sql-statement. Based on official doc (http://p6spy.readthedocs.io/en/latest/index.html) I can do it by set specific properties in spy.properties file such as outagedetection and outagedetectioninterval. I…
Kseniya
  • 1
0
votes
1 answer

Gradle test dependencies not loaded in Spring Boot test

I am trying to work with p6spy in Spring Boot tests. I have a test class annotated with @RunWith(SpringRunner.class) @SpringBootTest My gradle.build looks like this dependencies { compile('org.springframework.boot:spring-boot-starter-data-jpa') …
sorencito
  • 2,517
  • 20
  • 21
0
votes
1 answer

p6spy 3.x configuration (avoid No visible constructors in class com.p6spy.engine.wrapper.ConnectionWrapper)

I am upgrading P6SPY on our Java applications based on Spring framework. Current p6spy version is 2.1.4 and we want at least version 3.0.0 (or 3.2.0). After I changed version in pom.xml and deployed application, some AOP errors appeared. No visible…
Worsik
  • 57
  • 3
  • 11
0
votes
1 answer

Having trouble logging HQL return values using log tools

I am trying to log the return values from HQL and I followed the following instructions: https://www.mkyong.com/hibernate/how-to-display-hibernate-sql-parameter-values-solution/ I was able to use 1.1 to see the return values on my eclipse. However,…
user4347600
0
votes
1 answer

how to analyse P6spy log live and from log files?

With old version 1.3 of p6spy.jar you could plug the irontrack UI live and also read spy.log afterwards to analyse SQL activity. What tool could do the same with p6spy version 2.x.x format ?
Gauthier Peel
  • 1,438
  • 2
  • 17
  • 35
0
votes
1 answer

p6spy makes Tomcat8 will no longer redeploy when in use

Cannot redeploy tomcat when I am using p6spy on top of my Postgres database driver. It works great until redeploy. When I do a redeploy, I get this error: javax.management.InstanceAlreadyExistsException:…
Nicholas DiPiazza
  • 10,029
  • 11
  • 83
  • 152
0
votes
1 answer

Capturing sql queries along with bind parameters into log files

I used p6spy/log4jdbc to capture the sql queries along with the bind parameters, connecting to Oracle database (hibernate 4.3.5 and oracle 10g is used) and push it to log files which are configured using logback. The datasource is created by…
Sreedhar
  • 1
1 2 3
4
5