Is there any option to terminate the execution of query after 15 seconds?

Question

rs = pstmt.executeQuery();

I want to set timer exactly before the execute query for 15 seconds for that it should be terminated.

score 2 · Answer 1 · answered Dec 31 '18 at 10:58

2

You can use this,

pstmt.setQueryTimeout(15);
rs = pstmt.executeQuery();

answered Dec 31 '18 at 10:58

Sandeepa

after that 15 seconds done I need to close this connection open other connection – Sai Kumar Adulla Dec 31 '18 at 12:08

1 Answers1