Question

Extend timeout in java.sql.SQLTimeoutException

  • 13 April 2023
  • 2 replies
  • 61 views

Userlevel 4
Badge +8

In IFS Cloud, how is it possible to extend the java.sql.SQLTimeoutException setting?

We are experiencing this timeout when receiving an application message through IFS Connect, and it kicks off a plsql method, that is taking a while to run, so the application message times out before it is done.


2 replies

Userlevel 3
Badge +8

Hi

did you fixed this issue?

We are facing same problem, timeout error SQLTimeoutException  is thrown after 1 minute.

Neno

Userlevel 4
Badge +8

In the ifscloud-value.yaml file below settings can be added to increase the timeout.

At the moment we have issues though with the value resetting to 30 (default) when a pod is restarted. Trying to solve that.

 

ifsappconnect:

  replicas: 3

  connectQueryTimeout: 60

  queryTimeout: 60

 

Reply