The code works with Oracle 12 and Oracle 18 is the change in the driver's jar what brings up the problem. 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |