Edit

SQLXML interface

  • Article

Download JDBC driver

The JDBC driver provides support for the JDBC 4.0 API, which introduces the java.sql.SQLXML interface. The SQLXML interface defines methods to interact and manipulate XML data. The SQLXML data type maps to the SQL Serverxml data type.

The SQLXML interface provides methods for accessing the XML value as a String, a Reader or Writer, or as a Stream. The XML value may also be accessed through a Source or set as a Result, which are used with XML Parser APIs such as Document Object Model (DOM), Simple API for XML (SAX), and Streaming API for XML (StAX), as well as with XSLT transforms and XPath.

Remarks

The following table describes the methods defined in the SQLXML interface:

Method Syntax Method Description
void free() This method frees the SQLXML object and releases the resources that it holds.
InputStream getBinaryStream() Returns an input stream to read data from the SQLXML.
Reader getCharacterStream() Returns the XML data as a java.io.Reader object or as a stream of characters.
T extends Source T getSource(Class<T> sourceClass) Returns a Source for reading the XML value specified by this SQLXML object.

Note: The getSource method supports the following sources: javax.xml.transform.dom.DOMSource, javax.xml.transform.sax.SAXSource, javax.xml.transform.stax.StAXSource, and java.io.InputStream.
String getString() Returns a string representation of the XML value designated by this SQLXML object.
OutputStream setBinaryStream() Retrieves a stream that can be used to write the XML value that this SQLXML object represents.
Writer setCharacterStream() Returns a stream to be used to write the XML value that this SQLXML object represents.
T extends Result T setResult(Class<T> resultClass) Returns a Result for setting the XML value specified by this SQLXML object.

Note: The setResult method supports the following sources: javax.xml.transform.dom.DOMResult, javax.xml.transform.sax.SAXResult, javax.xml.transform.stax.StaxResult, and java.io.OutputStream.
void setString(String value) Sets the XML value designated by this SQLXML object to the specified String representation.

The applications can read and write XML values to or from an SQLXML object only once.

When the free() method is called, a SQLXML object becomes invalid and is neither readable nor writeable. If the application tries to invoke a method on that SQLXML object other than the free() method, an exception is thrown.

The SQLXML object becomes neither readable nor writable when the application calls any of the following getter methods: getSource, getCharacterStream, getBinaryStream, and getString.

The SQLXML object becomes neither writeable nor readable when the application calls any of the following setter methods: setResult, setCharacterStream, setBinaryStream, and setString.

See also

Supporting XML data