← Back to team overview

dhis2-devs team mailing list archive

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.

Thanks

-- 
God Helse !