How to stop database query using time out in hibernate?

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, it will throw an exception of type QueryTimeoutException , which you can capture and make the necessary treatments.

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

It's been a while since I've done this with nHibernate. Look for references to connection properties in hibernate. In the same file / code where you define the connection you can set the timeout. here are some examples taken from SO

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

here using Spring

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