java.sql.SQLException: ORA-01453: SET TRANSACTION must be first statement of transact
posted 8 years ago
I am getting the Oracle Exception java.sql.SQLException: ORA-01453: SET TRANSACTION must be first statement of transact after we upgraded the Oracle version from Oracle 184.108.40.206 to Oracle 220.127.116.11.
Initially we had a Oracle Version 18.104.22.168 and the Application was working fine with it. Now the DBA has upgraded the version Oracle to 22.214.171.124 by applying a patch ("p4163445_92070_SOLARIS64"). After this upgrade, about 15 minutes after starting the service, i am getting this exception regularly.
I was thinking this could be a oracle parameter issue or a issue in Oracle 126.96.36.199. I will not be able to change the code since, the number of points i have to change is huge.
If you can figure out where this issue is you can either call commit before the transaction level is changed or remove the change in transaction level all together. My guess would to look for a case of shared code where someone is asking for a database connection without realizing that it has been used (without a commit). Usually, these are in nested calls.