SupportBinaryXML
- Last Updated: May 15, 2020
- 1 minute read
- DataDirect Connectors
- JDBC
- IBM Db2 5.1
- MySQL 5.1
- Progress OpenEdge 5.1
- SAP Sybase 5.1
- Documentation
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."
Notes
- Queries involving XMLType with binary storage and XMLType with CLOB storage are affected
when
SupportBinaryXML=true. WhenSupportBinaryXML=true, XMLType with binary storage and XMLType with CLOB storage are returned in an in-line fashion without locators. In addition, DatabaseMetaData.locatorsUpdateCopy() is reported astrue, and 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.
Default
false
Data Type
Boolean