Error when setting transaction isolation to TRANSACTION_SERIALIZABLE: java.sql.SQLException: Due to vendor limitations, setting transaction isolation for "Oracle XA" JDBC XA driver is not supported
(Doc ID 1509302.1)
Last updated on MAY 25, 2021
Applies to:Oracle WebLogic Server - Version 10.3.5 to 220.127.116.11
Information in this document applies to any platform.
Customer is using ojdbc6.jar and the JDBC driver for 18.104.22.168.0-Production along with WLS 10.3.5. They have set their transaction isolation to TRANSACTION_SERIALIZABLE with a setTransactionIsolation(TRANSACTION_SERIALIZABLE); call. They are seeing an error:
Since TRANSACTION_SERIALIZABLE is a valid setting for the Oracle DB, this call shouldn't be rejected.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document