Spring JDBC - prevent logging - INFO: Added default SqlReturnUpdateCount parameter named #update-count-1

Question

My standalone application uses Spring JDBC.

I see a lot of the following statements in System.out

Mar 28, 2013 6:42:12 PM org.springframework.jdbc.core.JdbcTemplate extractReturnedResults
INFO: Added default SqlReturnUpdateCount parameter named #update-count-1

How do I prevent these logs?

Remove `org.springframework.jdbc.core.JdbcTemplate` (possibly less) from your loggers. — Sotirios Delimanolis, Mar 28 '13 at 15:27
Then it's probably using commons-logging by default, search around on how to disable that, I'm not exactly sure. Or add log4j/logback and put your own logging configuration. — Sotirios Delimanolis, Mar 28 '13 at 15:33
Check out [this](http://stackoverflow.com/questions/23252743/change-spring-framework-log-level-in-simple-example-project) and see if it works :) — Lu Fangjian, Jul 25 '14 at 08:53

score 3 · Answer 1 · answered Mar 28 '13 at 16:52

3

I got around this by skipping the undeclared results, which I don't need anyway

JdbcTemplate jt = new JdbcTemplate(dataSource);
jt.setSkipUndeclaredResults(true);

answered Mar 28 '13 at 16:52

arahant

2,203
7
38
62

score 0 · Answer 2 · edited Jul 23 '19 at 10:01

0

You can write the function call in the following format:

Select function_name(args) from dual;

With the above query, you can use any matching function in JdbcTemplate

Hope this helps you solve the issue.

edited Jul 23 '19 at 10:01

Romil Patel

12,879
7
47
76

answered Jul 23 '19 at 09:19

kupendra pola

97
4

Spring JDBC - prevent logging - INFO: Added default SqlReturnUpdateCount parameter named #update-count-1

2 Answers2

Linked