I use payara 5.2022.1 + REST application deployed as war. I use oracle db with latest JDBC driver (ojdbc11.jar )
When my db is down, all requests hang out to infinity.
I setup in jdbc properties:
oracle.net.READ_TIMEOUT = 2000ms
but it doesn’t work. I expected that server returns 500 after 2s. Also http thread timeout is ignored (30s). I see some warning/error logs - Socket read timed out or Cannot allocate more connections, but server doesn’t return response.
Do you have some knowledge how to setup payara jdbc pool to achieve fail fast when db is down?