Kill long requests after timeout

Question

We have an application that contains the Apache web server as an entry point, and the application will run on another server. Therefore, in apache we set the timeout to 40 seconds, but in the application some request takes more time to retrieve records that are more than 40 seconds, because of this apache throws a 5xx error. But the request retrieves the records from the database after we received the response from the apache web server.

How to kill this request (or transaction) after 40 seconds (e.g. apache timeout)?

Thanks in advance.

Answer 1

setDafaultTimeout Hibernate .

      HibernateTransactionManager transactionManager = new HibernateTransactionManager();
      transactionManager.setDefaultTimeout(int timeoutinSecs);

hibernate . .

Answer 2

Spring AsyncTaskExecutor.

TaskExecutor, (Runnable, long) timeout, Callable. . , , , PrivilegedAction to Callable before .

Answer 3

- Statement.cancel()

Answer 4

. JTA , , . postgres: statement_timeout

JTA , , JTA JDBC.

API JDBC - : java.sql.Statement.setQueryTimeout(int timeout), .

Answer 5

, .

() (MySql)