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 !