Logging SQL statements in application

Question

I am adding SLF4J and Logback to my application and I am unsure if I should log the SQL statements that I generate in the repository layer (using Spring JDBC). The level of these statements would of course be set to DEBUG since it could generate a lot of log statements.

Is it common to log SQL statements generated by the application?

Yeah there is nothing wrong in logging the SQL statements as it might me helpful in case of debugging. But it is advisable to keep it at DEBUG level — prasanth
– prasanth, Commented Mar 31, 2013 at 14:41

HMM · Accepted Answer · 2013-03-31 15:00:15Z

1

Yes, It is common.

All ORMs, including openjpa and hibernate do it. All mappers like MyBatis have some logging mechanism to hook into any of several logging implementations.

Even in immemorial times. The drivers used to do it when a java.sql.DriverManager#setLogStream was invoked

;)

answered Mar 31, 2013 at 15:00

HMM

3,0131 gold badge21 silver badges31 bronze badges

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

Comments

duffymo · Accepted Answer · 2013-03-31 14:46:55Z

0

I'd write this kind of information to database, keeping statistics so I can query and summarize them.

It's certainly possible to do it with the log, but it's not as easy to summarize as it is from the database. No SQL for log files without extraordinary efforts.

answered Mar 31, 2013 at 14:46

duffymo

310k46 gold badges376 silver badges571 bronze badges

2 Comments

LuckyLuke Over a year ago

Does it mean that you would not log the SQL if you don't log it to a database?

duffymo Over a year ago

Logging is done in either case; it's just a choice as to where I put the information. I think a database makes more sense here.

mkazma · Accepted Answer · 2013-03-31 15:22:05Z

0

Actually if you have a huge application that is considered a financial asset in your point of view, than of course you should log your application since the logging will be considered a security major you can refer to when ever you want. Plus the logging is useful for debugging. But you have to consider which level of logging you want to choose since it will have a huge load on your database if you want log all your SQL statements.

answered Mar 31, 2013 at 15:22

mkazma

5804 gold badges11 silver badges29 bronze badges

Collectives™ on Stack Overflow

Logging SQL statements in application

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related