How to get query string from connection in Java?

Question

I'm writing a method that tries to log db calls, form connecting to it, to after the query, there are many places that calls the method connect() to start and the cleanUp() method to end, I can't and don't want to modify every place. So the sequence is like this :

  Connection con = ...
  connect();
  s = con.createStatement();
  ResultSet rs = s.executeQuery(" select * from xyz ");
  rs.next();
  cleanUp();

There are many methods that uses this sequence, so how do I, somehow in cleanUp(), get the sql query string [ in this case : select * from xyz ] from all the methods that run their queries, is there a way to get that info from the "con", does the con object know what query it has just ran ?

This article gives some examples how to monitor statements through a data source proxy. If you happen to be using Oracle, the driver also has some built-in diagnostic capabilities. — Mick Mnemonic
– Mick Mnemonic, Commented Oct 5, 2016 at 21:10
I like this answer the best, how to pick it as my choice ^_^ ?! — Frank
– Frank, Commented Oct 7, 2016 at 14:30

sirandy · Accepted Answer · 2016-10-05 21:09:39Z

1

I suggest to you to use an aspect, AspectJ would be perfect for this case. With an aspect, you could trigger a behavior once your monitored method has been executed. Here are a couple examples you could check: http://www.yegor256.com/2014/06/01/aop-aspectj-java-method-logging.html and https://mathewjhall.wordpress.com/2011/03/31/tracing-java-method-execution-with-aspectj/

answered Oct 5, 2016 at 21:09

sirandy

1,8445 gold badges27 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

user207421 · Accepted Answer · 2016-10-05 22:57:51Z

1

You can get it in MySQL from Statement.toString().

answered Oct 5, 2016 at 22:57

user207421

312k45 gold badges324 silver badges493 bronze badges

Collectives™ on Stack Overflow

How to get query string from connection in Java?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related