JdbcTemplate and Statement

Hi devers,

My purpose is that I am trying to control a time out of a query statement during on its executed IF that query is used to retrieve a large amount of data.

I try testing with JdbcTemplate (org.springframework.jdbc.core) and Statement (java.sql) by using their method is setQueryTimeOut( seconds ). But there is nothing is working properly.

jdbcTemplate.setQueryTimeOut( seconds ) : It will occur a problem is setQueryTimeOut() is not implemented yet.

statement.setQueryTimeOut( seconds ) : An NullPointerException will be occurred in server.

Is there anyone give a solution/way in this issue? Or is there the other solution without touch in time out by somehow? Expecting all idea.



God Helse !