Set Query Timeout from NamedParameterJdbcTemplate

Question

I'm using the Spring Framework. How can I set the query timeout when using a NamedParameterJdbcTemplate? I notice that JdbcTemplate has a setQueryTimeout(int queryTimeout) method, but I have not been able to find a way to do this with a NamedParameterJdbcTemplate. It has a getJdbcOperations() method, but it appears that setQueryTimeout() is not exposed.

Answer 1

You should be able to do that by creating a JdbcTemplate, set the query timeout, and then wrap the JdbcTemplate into a NamedParameterJdbcTemplate:

JdbcTemplate template = new JdbcTemplate(...);
template.setQueryTimeout(...);
NamedParameterJdbcTemplate named = new NamedParameterJdbcTemplate(template);