How to interrupt the database query using time out in Hibernate?

Question

I am developing an application that queries a gigantic database, so I would like to maintain the integrity of this allowing Hibernate to query up to 30 seconds. Faced with this problem, what would be the best way to solve it?

Answer 1

Complementing Jean’s answer, in Hibernate you have the method .setTimeout() where you can set the maximum time a particular query will be able to execute.

Example:

Query suaQuery;
// Tempo do timeout e sua unidade
suaQuery.setTimeout(10,TimeUnit.MILLISECONDS);

If the query takes longer than the set time will launch an exception of the type Querytimeoutexception, that you can capture and make the necessary treatments.

try {
    suaQuery.list();
}
catch (QueryTimeoutException e) {
    // faz qualquer tratamento que seja necessário
}

Answer 2

It’s been a while since I did this with nhibernate. Look for references to connection properties on Hibernate. In the same file/code where you set the connection you can set the timeout. below some examples taken from ONLY

<property name="hibernate.c3p0.timeout">300</property>

here using Spring

<prop key="hibernate.c3p0.idle_test_period">300</prop>