Purpose

Enables the driver to support XMLType with binary storage on servers running Oracle 12c and higher.

Valid values

true | false

Behavior

If set to true, the driver supports XMLType with binary storage by negotiating server and client capabilities during connection time. As a result of this negotiation, decoded data associated with XMLType columns is returned in an in-line fashion without locators.

If set to false, the driver does not support XMLType with binary storage and returns the error "This column type is not currently supported by this driver."

These behaviors apply only to Oracle 12c R1. For Oracle 12c R2 and higher, the driver supports XMLType with binary storage even when SupportBinaryXML=false.

Notes

  • Queries involving XMLType with binary storage and XMLType with CLOB storage are affected when SupportBinaryXML=true. When SupportBinaryXML=true, XMLType with binary storage and XMLType with CLOB storage are returned in an in-line fashion without locators. In addition, the driver cannot update directly to LOBs. Under these circumstances, executing a Select that includes XMLType columns can degrade performance because the driver must pull all in-line data to execute the query.

Data source method

setSupportBinaryXML

Default

false

Data type

Boolean