Troubleshooting
Problem
Oracle SQL DELETE and SQL INSERT Statements do not auto commit (patch issue)
Symptom
Automatic commit on database transactions is disabled for custom pools with a type=remote and transaction=true, causing latency in commit of database transactions (waits on commit) in business processes. Issue introduced in patch 4316 and patch 4217.
Possible symptoms:
(1) Lightweight JDBC adapter LWJDBC when using an Oracle custom pool and pool.type is set to remote may have noticeably longer commit times for insert and delete after applying patch.
(2) Unable to purge a table on Oracle 10GR2 SGBD, when using custom pool and pool.type is set to remote.
When we execute
the request on Oracle directly, no problem. When the request is done on GIS,
the result is OK, but nothing is removed on Oracle (the data are not purged,
but the DB is locked).
After investigation, the request is executed, but
not committed.
No error messages given until the connection between GIS and Oracle is broken where you will then see the rollback begin in Oracle.
To view more of this document
Historical Number
NFX5565
Was this topic helpful?
Document Information
Modified date:
25 February 2019
UID
swg21559525