How can I log SQL statements executed by Flyway?

Question

Does anyone know how I can log the sql output from Flyway?
It logs sql errors only, but I need to log information such as "table created", "table dropped" etc...

score 7 · Accepted Answer · edited Sep 10 '20 at 14:05

7

If you use the API you can see the statements being executed by setting the log level of com.googlecode.flyway.core.dbsupport.SqlScript to debug.

edited Sep 10 '20 at 14:05

Youcef LAIDANI

55,661
15
90
140

answered Jul 03 '13 at 19:10

Axel Fontaine

34,542
16
106
137

4

by adding -X on command line or am i missing something here? I can see on the SQLScript the debug mode but i am not sure how to switch it on when running it. – tosi Jul 04 '13 at 15:30
1

Correct. -X will also output this info (and a lot more) – Axel Fontaine Jul 04 '13 at 17:21
2

The -X command line switch works when using the maven plugin, too. – Carl G Oct 16 '14 at 21:42

How can I log SQL statements executed by Flyway?

1 Answers1