vertx-sql-client icon indicating copy to clipboard operation
vertx-sql-client copied to clipboard

Published 20 hours ago • verified publisher icon eclipse-vertx

print SQL statement and result，or support P6SPY

Open nnzbz opened this issue 2 years ago • 7 comments

I'm wondering how to print out the final SQL statement and result in vertx? It would be great help to debug. or support p6spy? I tried for oracle but it doesn't work

nnzbz avatar Apr 29 '22 10:04 nnzbz

Supporting p6spy is not possible because we don't use JDBC drivers. Well, except the Oracle reactive client but we need the Oracle specific APIs so generic JDBC is not possible.

We'll think about it. Logging database interactions is useful for developers and we may be able to find a solution that works across all the reactive drivers we have.

tsegismont avatar May 09 '22 10:05 tsegismont

I think the tracing SPI can achieve the same result

vietj avatar May 10 '22 05:05 vietj

I think also we could simply log report those in the logger like we do for TCP networking activity debugging

vietj avatar May 24 '22 05:05 vietj

Is there any updates on the issue? I'd like to be able to debug SQL queries.

newzubakhin avatar Jul 21 '22 19:07 newzubakhin

can you try using the tracing SPI @newzubakhin to achieve this ?

vietj avatar Jul 22 '22 12:07 vietj