0

I want to stop a long running query in Oracle + Hibernate 3 + Java.

I have tried setting the timeout using the code snippets below, without success.

1.

query = session.createQuery("from table");
query.setTimeout(1000);
list = query.list();

2.

Transaction tx = session.getTransaction();
tx.setTimeout(1000);
tx.begin(); 
query = session.createQuery("from table");
list = query.list();

Could anyone please help me on this?

Thanks in advance.

Eric Galluzzo
  • 3,191
  • 1
  • 20
  • 20
Gowtham
  • 1
  • 2
  • How to kill or cancel long running query within some configured time in oracle 11g and Hibernate 3 using java – Gowtham Aug 16 '16 at 13:35

1 Answers1

0

You could try option listed here Hibernate: set default query timeout?

Also if you host a webservice , under which you run this Db query, and wish to timeout the webservice if response is not returned in x seconds, then you can set connection timeout for the webservice (even on server side). Note: That would not kill the oracle process running the query though. Spring ws timeout on server side

Community
  • 1
  • 1
user2254601
  • 164
  • 2
  • 8
  • its not working. How to kill or cancel long running query from oracle 11g and Hibernate 3 using java... – Gowtham Aug 16 '16 at 13:33