1

I looking for a software to trace all the statements on my oracle database. I have a Delphi application (without the source code) and there are many stored procedures called. To trace all the query executed I'm using this tool: Statement Tracer for Oracle

It works great. Now, I have a web application (Java + GWT using JDBC to connect to the DB) and I need to do the same thing. I don't want only the calls from my app to the db but every statement executed inside stored procedure. Does anybody know a tool in able to do that ?

ajduke
  • 4,991
  • 7
  • 36
  • 56
CC.
  • 2,736
  • 11
  • 53
  • 70

1 Answers1

0

There's a jdbc tracer project https://github.com/tokuhirom/jdbc-tracer where you can import the project through maven and implement some listeners, receiving the SQL statements and other info from the JDBC Statements. I'm sure that if you create a visual project through its maven library you can create a sorta visual interface showing all SQL Queries done through a JDBC driver.

lucasdeassis
  • 63
  • 4