Failed to update a row in oracle sql database from java jdbc, java code stuck at update
You should call objCon.isValid() before executing this statement because this issue looks like your connection has been disconnected under the covers. If the connection isn't valid, get a new one.
The above issue is because of concurrency issues in that Oracle version, that is causing the java sessions getting blocked.
The issue is resolved when updated to the latest Oracle DB version in live.