My Oracle Support Banner

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 AUGUST 23, 2023

Applies to:

Oracle WebLogic Server - Version 10.3.5 to 12.1.1.0
Information in this document applies to any platform.

Symptoms

Customer is using ojdbc6.jar and the JDBC driver for 11.1.0.7.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.

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.