How to create a MySQL log using Java

Question

I am currently using MySQL Workbench which already contains a logging mechanism. The problem is, is that the log only logs queries executed within the Workbench.
Any connections made by JDBC isn't actually logged. How do I create a log that incorporates the Java queries into SQL?

I am using Workbench 6.3, SQL version 5.6.31

Where do you want the log to be stored? – Andreas Jul 07 '16 at 15:33 — Andreas, Jul 07 '16 at 15:33
Pushed to a table possibly within the db? @Andreas – JStef Jul 07 '16 at 15:35 — JStef, Jul 07 '16 at 15:35
log4j - Logging in Database / Files might help you. – MeisterAjit Jul 07 '16 at 15:41 — MeisterAjit, Jul 07 '16 at 15:41

score 1 · Accepted Answer · edited May 23 '17 at 10:28

1

I believe you need the server side logging. If that's correct, see How to enable MySQL Query Log?.

This, of course, logs all the SQL queries received by the MySQL server (all connections), which means you should use it judiciously.

edited May 23 '17 at 10:28

Community

1
1

answered Jul 07 '16 at 15:38

Kedar Mhaswade

4,535
2
25
34

That is for SQL version 5.2.9 and earlier. – JStef Jul 07 '16 at 15:42

How to create a MySQL log using Java

1 Answers1