Set query timeout in postico code#
The code works with Oracle 12 and Oracle 18 is the change in the driver's jar what brings up the problem.
Set query timeout in postico drivers#
This works using Oracle jdbc drivers version 12c, but when we have migrated to Oracle 18c, and we changed the driver to the version 18c, the query execution stops after 15 minutes with this exception. To avoid a timeout exception, we use this sentence at StatementLevel: tQueryTimeout(0)
We have a J2EE application on a payara 5.2020 server that executes a long running query (PL/SQL that executes for a couple of hours).
0 kommentar(er)
