Spring JDBC - logging prevention - INFO: added default SqlReturnUpdateCount parameter: # update-count-1

Question

My standalone application uses Spring JDBC.

In System.out

I see many of the following statements:

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

How to prevent these logs?

Answer 1

I circumvented this by skipping unannounced results that I still don't need

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

Answer 2

You can write a function call in the following format:

 Select function_name(args) from dual; 

Using the above query, you can use any mapping function in JdbcTemplate

Hope this helps you solve the problem.