Author: rareddy Date: 2009-04-20 20:10:07 -0400 (Mon, 20 Apr 2009) New Revision: 810 Added: trunk/client-jdbc30/ trunk/client-jdbc30/pom.xml trunk/client-jdbc30/src/ trunk/client-jdbc30/src/main/ trunk/client-jdbc30/src/main/java/ trunk/client-jdbc30/src/main/java/com/ trunk/client-jdbc30/src/main/java/com/metamatrix/ trunk/client-jdbc30/src/main/java/com/metamatrix/core/ trunk/client-jdbc30/src/main/java/com/metamatrix/core/jdbc/ trunk/client-jdbc30/src/main/java/com/metamatrix/core/jdbc/SQLXML.java Removed: trunk/client-jdbc30/pom.xml trunk/client-jdbc30/src/ trunk/client-jdbc30/src/main/ trunk/client-jdbc30/src/main/java/ trunk/client-jdbc30/src/main/java/com/ trunk/client-jdbc30/src/main/java/com/metamatrix/ trunk/client-jdbc30/src/main/java/com/metamatrix/core/ trunk/client-jdbc30/src/main/java/com/metamatrix/core/jdbc/ trunk/client-jdbc30/src/main/java/com/metamatrix/core/jdbc/SQLXML.java Log: TEIID-177: maven project that can create a client jar file which woks with JDK1.5 and supports JDBC 3.0 Copied: trunk/client-jdbc30 (from rev 806, branches/jdbc30-jdk15/client-jdbc30) Property changes on: trunk/client-jdbc30 ___________________________________________________________________ Name: svn:ignore + .classpath .project .settings Deleted: trunk/client-jdbc30/pom.xml =================================================================== --- branches/jdbc30-jdk15/client-jdbc30/pom.xml 2009-04-20 19:01:03 UTC (rev 806) +++ trunk/client-jdbc30/pom.xml 2009-04-21 00:10:07 UTC (rev 810) @@ -1,191 +0,0 @@ -<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd"> - <parent> - <artifactId>teiid</artifactId> - <groupId>org.jboss.teiid</groupId> - <version>6.0.0-SNAPSHOT</version> - </parent> - <modelVersion>4.0.0</modelVersion> - <groupId>org.jboss.teiid</groupId> - <artifactId>teiid-client-jdbc30</artifactId> - <name>JDBC 3.0 Client</name> - <version>6.0.0-SNAPSHOT</version> - <description>JDBC 3.0 Compatible Client for JDK1.5</description> - - <build> - <plugins> - <plugin> - <groupId>org.apache.maven.plugins</groupId> - <artifactId>maven-compiler-plugin</artifactId> - <configuration> - <source>1.5</source> - <target>1.5</target> - <showDeprecation>false</showDeprecation> - <showWarnings>false</showWarnings> - </configuration> - </plugin> - <plugin> - <artifactId>maven-surefire-plugin</artifactId> - <configuration> - <includes> - <include>**/*TestCase.java</include> - <include>**/*Test.java</include> - <include>**/Test*.java</include> - </includes> - <excludes> - <exclude>**/Abstract*TestCase.java</exclude> - <!-- hack to prevent anonymous inner classes in Tests from being run as tests --> - <include>**/Test*$*.java</include> - </excludes> - </configuration> - </plugin> - - <plugin> - <groupId>org.apache.maven.plugins</groupId> - <artifactId>maven-antrun-plugin</artifactId> - <dependencies> - <dependency> - <groupId>org.apache.ant</groupId> - <artifactId>ant</artifactId> - <version>1.7.0</version> - </dependency> - </dependencies> - <executions> - <execution> - <id>generate-1.5</id> - <phase>generate-sources</phase> - <configuration> - <tasks> - <copy todir="${project.build.directory}/generated-sources/main/java" overwrite="true"> - <fileset dir="${basedir}/../client-jdbc/src/main/java"> - <include name="**/*.java"/> - </fileset> - <fileset dir="${basedir}/../common-core/src/main/java"> - <include name="**/*.java"/> - </fileset> - <fileset dir="${basedir}/../client/src/main/java"> - <include name="**/*.java"/> - </fileset> - - <filterset begintoken="/*## " endtoken=" ##"> - <filter token="JDBC3.0-JDK1.5-begin" value=""/> - <filter token="JDBC3.0-JDK1.5-end" value=""/> - </filterset> - - <filterset begintoken="## " endtoken=" ##*/"> - <filter token="JDBC3.0-JDK1.5-begin" value=""/> - <filter token="JDBC3.0-JDK1.5-end" value=""/> - </filterset> - - <filterset begintoken="//## " endtoken=" ##"> - <filter token="JDBC4.0-begin" value="/*"/> - <filter token="JDBC4.0-end" value="*/"/> - </filterset> - </copy> - <copy todir="${project.build.directory}/generated-sources/main/resources" overwrite="true"> - <fileset dir="${basedir}/../client-jdbc/src/main/resources"> - <include name="**/*"/> - </fileset> - <fileset dir="${basedir}/../common-core/src/main/resources"> - <include name="**/*"/> - </fileset> - <fileset dir="${basedir}/../client/src/main/resources"> - <include name="**/*"/> - </fileset> - </copy> - </tasks> - <sourceRoot>${project.build.directory}/generated-sources/main/java</sourceRoot> - </configuration> - <goals> - <goal>run</goal> - </goals> - </execution> - <!-- - <execution> - <id>generate-1.5-test</id> - <phase>generate-sources</phase> - <configuration> - <tasks> - <copy todir="${project.build.directory}/generated-sources/test/java" overwrite="true"> - <fileset dir="${basedir}/../client-jdbc/src/test/java"> - <include name="**/*.java"/> - </fileset> - <fileset dir="${basedir}/../common-core/src/test/java"> - <include name="**/*.java"/> - </fileset> - <fileset dir="${basedir}/../client/src/test/java"> - <include name="**/*.java"/> - </fileset> - - <filterset begintoken="/*## " endtoken=" ##"> - <filter token="JDBC3.0-JDK1.5-begin" value=""/> - <filter token="JDBC3.0-JDK1.5-end" value=""/> - </filterset> - - <filterset begintoken="## " endtoken=" ##*/"> - <filter token="JDBC3.0-JDK1.5-begin" value=""/> - <filter token="JDBC3.0-JDK1.5-end" value=""/> - </filterset> - - <filterset begintoken="//## " endtoken=" ##"> - <filter token="JDBC4.0-begin" value="/*"/> - <filter token="JDBC4.0-end" value="*/"/> - </filterset> - </copy> - <copy todir="${project.build.directory}/generated-sources/test/resources" overwrite="true"> - <fileset dir="${basedir}/../client-jdbc/src/test/resources"> - <include name="**/*"/> - </fileset> - <fileset dir="${basedir}/../common-core/src/test/resources"> - <include name="**/*"/> - </fileset> - <fileset dir="${basedir}/../client/src/test/resources"> - <include name="**/*"/> - </fileset> - </copy> - </tasks> - <testSourceRoot>${project.build.directory}/generated-sources/test/java</testSourceRoot> - </configuration> - <goals> - <goal>run</goal> - </goals> - </execution> - --> - </executions> - </plugin> - </plugins> - - <resources> - <resource> - <directory>${project.build.directory}/generated-sources/main/resources</directory> - <filtering>false</filtering> - <includes> - <include>**/*</include> - </includes> - </resource> - <!-- - <resource> - <directory>${project.build.directory}/generated-sources/test/resources</directory> - <filtering>false</filtering> - <includes> - <include>**/*</include> - </includes> - </resource> - --> - </resources> - - </build> - <dependencies> - <dependency> - <groupId>junit</groupId> - <artifactId>junit</artifactId> - <version>4.4</version> - <scope>test</scope> - </dependency> - <dependency> - <groupId>org.mockito</groupId> - <artifactId>mockito-all</artifactId> - <version>1.3</version> - <scope>test</scope> - </dependency> - </dependencies> -</project> \ No newline at end of file Copied: trunk/client-jdbc30/pom.xml (from rev 806, branches/jdbc30-jdk15/client-jdbc30/pom.xml) =================================================================== --- trunk/client-jdbc30/pom.xml (rev 0) +++ trunk/client-jdbc30/pom.xml 2009-04-21 00:10:07 UTC (rev 810) @@ -0,0 +1,191 @@ +<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd"> + <parent> + <artifactId>teiid</artifactId> + <groupId>org.jboss.teiid</groupId> + <version>6.0.0-SNAPSHOT</version> + </parent> + <modelVersion>4.0.0</modelVersion> + <groupId>org.jboss.teiid</groupId> + <artifactId>teiid-client-jdbc30</artifactId> + <name>JDBC 3.0 Client</name> + <version>6.0.0-SNAPSHOT</version> + <description>JDBC 3.0 Compatible Client for JDK1.5</description> + + <build> + <plugins> + <plugin> + <groupId>org.apache.maven.plugins</groupId> + <artifactId>maven-compiler-plugin</artifactId> + <configuration> + <source>1.5</source> + <target>1.5</target> + <showDeprecation>false</showDeprecation> + <showWarnings>false</showWarnings> + </configuration> + </plugin> + <plugin> + <artifactId>maven-surefire-plugin</artifactId> + <configuration> + <includes> + <include>**/*TestCase.java</include> + <include>**/*Test.java</include> + <include>**/Test*.java</include> + </includes> + <excludes> + <exclude>**/Abstract*TestCase.java</exclude> + <!-- hack to prevent anonymous inner classes in Tests from being run as tests --> + <include>**/Test*$*.java</include> + </excludes> + </configuration> + </plugin> + + <plugin> + <groupId>org.apache.maven.plugins</groupId> + <artifactId>maven-antrun-plugin</artifactId> + <dependencies> + <dependency> + <groupId>org.apache.ant</groupId> + <artifactId>ant</artifactId> + <version>1.7.0</version> + </dependency> + </dependencies> + <executions> + <execution> + <id>generate-1.5</id> + <phase>generate-sources</phase> + <configuration> + <tasks> + <copy todir="${project.build.directory}/generated-sources/main/java" overwrite="true"> + <fileset dir="${basedir}/../client-jdbc/src/main/java"> + <include name="**/*.java"/> + </fileset> + <fileset dir="${basedir}/../common-core/src/main/java"> + <include name="**/*.java"/> + </fileset> + <fileset dir="${basedir}/../client/src/main/java"> + <include name="**/*.java"/> + </fileset> + + <filterset begintoken="/*## " endtoken=" ##"> + <filter token="JDBC3.0-JDK1.5-begin" value=""/> + <filter token="JDBC3.0-JDK1.5-end" value=""/> + </filterset> + + <filterset begintoken="## " endtoken=" ##*/"> + <filter token="JDBC3.0-JDK1.5-begin" value=""/> + <filter token="JDBC3.0-JDK1.5-end" value=""/> + </filterset> + + <filterset begintoken="//## " endtoken=" ##"> + <filter token="JDBC4.0-begin" value="/*"/> + <filter token="JDBC4.0-end" value="*/"/> + </filterset> + </copy> + <copy todir="${project.build.directory}/generated-sources/main/resources" overwrite="true"> + <fileset dir="${basedir}/../client-jdbc/src/main/resources"> + <include name="**/*"/> + </fileset> + <fileset dir="${basedir}/../common-core/src/main/resources"> + <include name="**/*"/> + </fileset> + <fileset dir="${basedir}/../client/src/main/resources"> + <include name="**/*"/> + </fileset> + </copy> + </tasks> + <sourceRoot>${project.build.directory}/generated-sources/main/java</sourceRoot> + </configuration> + <goals> + <goal>run</goal> + </goals> + </execution> + <!-- + <execution> + <id>generate-1.5-test</id> + <phase>generate-sources</phase> + <configuration> + <tasks> + <copy todir="${project.build.directory}/generated-sources/test/java" overwrite="true"> + <fileset dir="${basedir}/../client-jdbc/src/test/java"> + <include name="**/*.java"/> + </fileset> + <fileset dir="${basedir}/../common-core/src/test/java"> + <include name="**/*.java"/> + </fileset> + <fileset dir="${basedir}/../client/src/test/java"> + <include name="**/*.java"/> + </fileset> + + <filterset begintoken="/*## " endtoken=" ##"> + <filter token="JDBC3.0-JDK1.5-begin" value=""/> + <filter token="JDBC3.0-JDK1.5-end" value=""/> + </filterset> + + <filterset begintoken="## " endtoken=" ##*/"> + <filter token="JDBC3.0-JDK1.5-begin" value=""/> + <filter token="JDBC3.0-JDK1.5-end" value=""/> + </filterset> + + <filterset begintoken="//## " endtoken=" ##"> + <filter token="JDBC4.0-begin" value="/*"/> + <filter token="JDBC4.0-end" value="*/"/> + </filterset> + </copy> + <copy todir="${project.build.directory}/generated-sources/test/resources" overwrite="true"> + <fileset dir="${basedir}/../client-jdbc/src/test/resources"> + <include name="**/*"/> + </fileset> + <fileset dir="${basedir}/../common-core/src/test/resources"> + <include name="**/*"/> + </fileset> + <fileset dir="${basedir}/../client/src/test/resources"> + <include name="**/*"/> + </fileset> + </copy> + </tasks> + <testSourceRoot>${project.build.directory}/generated-sources/test/java</testSourceRoot> + </configuration> + <goals> + <goal>run</goal> + </goals> + </execution> + --> + </executions> + </plugin> + </plugins> + + <resources> + <resource> + <directory>${project.build.directory}/generated-sources/main/resources</directory> + <filtering>false</filtering> + <includes> + <include>**/*</include> + </includes> + </resource> + <!-- + <resource> + <directory>${project.build.directory}/generated-sources/test/resources</directory> + <filtering>false</filtering> + <includes> + <include>**/*</include> + </includes> + </resource> + --> + </resources> + + </build> + <dependencies> + <dependency> + <groupId>junit</groupId> + <artifactId>junit</artifactId> + <version>4.4</version> + <scope>test</scope> + </dependency> + <dependency> + <groupId>org.mockito</groupId> + <artifactId>mockito-all</artifactId> + <version>1.3</version> + <scope>test</scope> + </dependency> + </dependencies> +</project> \ No newline at end of file Copied: trunk/client-jdbc30/src (from rev 806, branches/jdbc30-jdk15/client-jdbc30/src) Copied: trunk/client-jdbc30/src/main (from rev 806, branches/jdbc30-jdk15/client-jdbc30/src/main) Copied: trunk/client-jdbc30/src/main/java (from rev 806, branches/jdbc30-jdk15/client-jdbc30/src/main/java) Copied: trunk/client-jdbc30/src/main/java/com (from rev 806, branches/jdbc30-jdk15/client-jdbc30/src/main/java/com) Copied: trunk/client-jdbc30/src/main/java/com/metamatrix (from rev 806, branches/jdbc30-jdk15/client-jdbc30/src/main/java/com/metamatrix) Copied: trunk/client-jdbc30/src/main/java/com/metamatrix/core (from rev 806, branches/jdbc30-jdk15/client-jdbc30/src/main/java/com/metamatrix/core) Copied: trunk/client-jdbc30/src/main/java/com/metamatrix/core/jdbc (from rev 806, branches/jdbc30-jdk15/client-jdbc30/src/main/java/com/metamatrix/core/jdbc) Deleted: trunk/client-jdbc30/src/main/java/com/metamatrix/core/jdbc/SQLXML.java =================================================================== --- branches/jdbc30-jdk15/client-jdbc30/src/main/java/com/metamatrix/core/jdbc/SQLXML.java 2009-04-20 19:01:03 UTC (rev 806) +++ trunk/client-jdbc30/src/main/java/com/metamatrix/core/jdbc/SQLXML.java 2009-04-21 00:10:07 UTC (rev 810) @@ -1,407 +0,0 @@ -/* - * %W% %E% - * - * Copyright 2006 Sun Microsystems, Inc. All rights reserved. - * SUN PROPRIETARY/CONFIDENTIAL. Use is subject to license terms. - */ -package com.metamatrix.core.jdbc; - -import java.io.InputStream; -import java.io.OutputStream; -import java.io.Reader; -import java.io.Writer; -import java.sql.SQLException; - -import javax.xml.transform.Result; -import javax.xml.transform.Source; - -/** - * The mapping in the JavaTM programming language for the SQL XML type. - * XML is a built-in type that stores an XML value - * as a column value in a row of a database table. - * By default drivers implement an SQLXML object as - * a logical pointer to the XML data - * rather than the data itself. - * An SQLXML object is valid for the duration of the transaction in which it was created. - * <p> - * 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 DOM, SAX, and StAX, as - * well as with XSLT transforms and XPath evaluations. - * <p> - * Methods in the interfaces ResultSet, CallableStatement, and PreparedStatement, - * such as getSQLXML allow a programmer to access an XML value. - * In addition, this interface has methods for updating an XML value. - * <p> - * The XML value of the SQLXML instance may be obtained as a BinaryStream using - * <pre> - * SQLXML sqlxml = resultSet.getSQLXML(column); - * InputStream binaryStream = sqlxml.getBinaryStream(); - * </pre> - * For example, to parse an XML value with a DOM parser: - * <pre> - * DocumentBuilder parser = DocumentBuilderFactory.newInstance().newDocumentBuilder(); - * Document result = parser.parse(binaryStream); - * </pre> - * or to parse an XML value with a SAX parser to your handler: - * <pre> - * SAXParser parser = SAXParserFactory.newInstance().newSAXParser(); - * parser.parse(binaryStream, myHandler); - * </pre> - * or to parse an XML value with a StAX parser: - * <pre> - * XMLInputFactory factory = XMLInputFactory.newInstance(); - * XMLStreamReader streamReader = factory.createXMLStreamReader(binaryStream); - * </pre> - * <p> - * Because databases may use an optimized representation for the XML, - * accessing the value through getSource() and - * setResult() can lead to improved processing performance - * without serializing to a stream representation and parsing the XML. - * <p> - * For example, to obtain a DOM Document Node: - * <pre> - * DOMSource domSource = sqlxml.getSource(DOMSource.class); - * Document document = (Document) domSource.getNode(); - * </pre> - * or to set the value to a DOM Document Node to myNode: - * <pre> - * DOMResult domResult = sqlxml.setResult(DOMResult.class); - * domResult.setNode(myNode); - * </pre> - * or, to send SAX events to your handler: - * <pre> - * SAXSource saxSource = sqlxml.getSource(SAXSource.class); - * XMLReader xmlReader = saxSource.getXMLReader(); - * xmlReader.setContentHandler(myHandler); - * xmlReader.parse(saxSource.getInputSource()); - * </pre> - * or, to set the result value from SAX events: - * <pre> - * SAXResult saxResult = sqlxml.setResult(SAXResult.class); - * ContentHandler contentHandler = saxResult.getXMLReader().getContentHandler(); - * contentHandler.startDocument(); - * // set the XML elements and attributes into the result - * contentHandler.endDocument(); - * </pre> - * or, to obtain StAX events: - * <pre> - * StAXSource staxSource = sqlxml.getSource(StAXSource.class); - * XMLStreamReader streamReader = staxSource.getXMLStreamReader(); - * </pre> - * or, to set the result value from StAX events: - * <pre> - * StAXResult staxResult = sqlxml.setResult(StAXResult.class); - * XMLStreamWriter streamWriter = staxResult.getXMLStreamWriter(); - * </pre> - * or, to perform XSLT transformations on the XML value using the XSLT in xsltFile - * output to file resultFile: - * <pre> - * File xsltFile = new File("a.xslt"); - * File myFile = new File("result.xml"); - * Transformer xslt = TransformerFactory.newInstance().newTransformer(new StreamSource(xsltFile)); - * Source source = sqlxml.getSource(null); - * Result result = new StreamResult(myFile); - * xslt.transform(source, result); - * </pre> - * or, to evaluate an XPath expression on the XML value: - * <pre> - * XPath xpath = XPathFactory.newInstance().newXPath(); - * DOMSource domSource = sqlxml.getSource(DOMSource.class); - * Document document = (Document) domSource.getNode(); - * String expression = "/foo/@bar"; - * String barValue = xpath.evaluate(expression, document); - * </pre> - * To set the XML value to be the result of an XSLT transform: - * <pre> - * File sourceFile = new File("source.xml"); - * Transformer xslt = TransformerFactory.newInstance().newTransformer(new StreamSource(xsltFile)); - * Source streamSource = new StreamSource(sourceFile); - * Result result = sqlxml.setResult(null); - * xslt.transform(streamSource, result); - * </pre> - * Any Source can be transformed to a Result using the identity transform - * specified by calling newTransformer(): - * <pre> - * Transformer identity = TransformerFactory.newInstance().newTransformer(); - * Source source = sqlxml.getSource(null); - * File myFile = new File("result.xml"); - * Result result = new StreamResult(myFile); - * identity.transform(source, result); - * </pre> - * To write the contents of a Source to standard output: - * <pre> - * Transformer identity = TransformerFactory.newInstance().newTransformer(); - * Source source = sqlxml.getSource(null); - * Result result = new StreamResult(System.out); - * identity.transform(source, result); - * </pre> - * To create a DOMSource from a DOMResult: - * <pre> - * DOMSource domSource = new DOMSource(domResult.getNode()); - * </pre> - * <p> - * Incomplete or invalid XML values may cause an SQLException when - * set or the exception may occur when execute() occurs. All streams - * must be closed before execute() occurs or an SQLException will be thrown. - * <p> - * Reading and writing XML values to or from an SQLXML object can happen at most once. - * The conceptual states of readable and not readable determine if one - * of the reading APIs will return a value or throw an exception. - * The conceptual states of writable and not writable determine if one - * of the writing APIs will set a value or throw an exception. - * <p> - * The state moves from readable to not readable once free() or any of the - * reading APIs are called: getBinaryStream(), getCharacterStream(), getSource(), and getString(). - * Implementations may also change the state to not writable when this occurs. - * <p> - * The state moves from writable to not writeable once free() or any of the - * writing APIs are called: setBinaryStream(), setCharacterStream(), setResult(), and setString(). - * Implementations may also change the state to not readable when this occurs. - * <p> - * <p> - * All methods on the <code>SQLXML</code> interface must be fully implemented if the - * JDBC driver supports the data type. - * - * @see javax.xml.parsers - * @see javax.xml.stream - * @see javax.xml.transform - * @see javax.xml.xpath - * @since 1.6 - */ -public interface SQLXML -{ - /** - * This method closes this object and releases the resources that it held. - * The SQL XML object becomes invalid and neither readable or writeable - * when this method is called. - * - * After <code>free</code> has been called, any attempt to invoke a - * method other than <code>free</code> will result in a <code>SQLException</code> - * being thrown. If <code>free</code> is called multiple times, the subsequent - * calls to <code>free</code> are treated as a no-op. - * @throws SQLException if there is an error freeing the XML value. - * @exception SQLFeatureNotSupportedException if the JDBC driver does not support - * this method - * @since 1.6 - */ - void free() throws SQLException; - - /** - * Retrieves the XML value designated by this SQLXML instance as a stream. - * The bytes of the input stream are interpreted according to appendix F of the XML 1.0 specification. - * The behavior of this method is the same as ResultSet.getBinaryStream() - * when the designated column of the ResultSet has a type java.sql.Types of SQLXML. - * <p> - * The SQL XML object becomes not readable when this method is called and - * may also become not writable depending on implementation. - * - * @return a stream containing the XML data. - * @throws SQLException if there is an error processing the XML value. - * An exception is thrown if the state is not readable. - * @exception SQLFeatureNotSupportedException if the JDBC driver does not support - * this method - * @since 1.6 - */ - InputStream getBinaryStream() throws SQLException; - - /** - * Retrieves a stream that can be used to write the XML value that this SQLXML instance represents. - * The stream begins at position 0. - * The bytes of the stream are interpreted according to appendix F of the XML 1.0 specification - * The behavior of this method is the same as ResultSet.updateBinaryStream() - * when the designated column of the ResultSet has a type java.sql.Types of SQLXML. - * <p> - * The SQL XML object becomes not writeable when this method is called and - * may also become not readable depending on implementation. - * - * @return a stream to which data can be written. - * @throws SQLException if there is an error processing the XML value. - * An exception is thrown if the state is not writable. - * @exception SQLFeatureNotSupportedException if the JDBC driver does not support - * this method - * @since 1.6 - */ - OutputStream setBinaryStream() throws SQLException; - - /** - * Retrieves the XML value designated by this SQLXML instance as a java.io.Reader object. - * The format of this stream is defined by org.xml.sax.InputSource, - * where the characters in the stream represent the unicode code points for - * XML according to section 2 and appendix B of the XML 1.0 specification. - * Although an encoding declaration other than unicode may be present, - * the encoding of the stream is unicode. - * The behavior of this method is the same as ResultSet.getCharacterStream() - * when the designated column of the ResultSet has a type java.sql.Types of SQLXML. - * <p> - * The SQL XML object becomes not readable when this method is called and - * may also become not writable depending on implementation. - * - * @return a stream containing the XML data. - * @throws SQLException if there is an error processing the XML value. - * The getCause() method of the exception may provide a more detailed exception, for example, - * if the stream does not contain valid characters. - * An exception is thrown if the state is not readable. - * @exception SQLFeatureNotSupportedException if the JDBC driver does not support - * this method - * @since 1.6 - */ - Reader getCharacterStream() throws SQLException; - - /** - * Retrieves a stream to be used to write the XML value that this SQLXML instance represents. - * The format of this stream is defined by org.xml.sax.InputSource, - * where the characters in the stream represent the unicode code points for - * XML according to section 2 and appendix B of the XML 1.0 specification. - * Although an encoding declaration other than unicode may be present, - * the encoding of the stream is unicode. - * The behavior of this method is the same as ResultSet.updateCharacterStream() - * when the designated column of the ResultSet has a type java.sql.Types of SQLXML. - * <p> - * The SQL XML object becomes not writeable when this method is called and - * may also become not readable depending on implementation. - * - * @return a stream to which data can be written. - * @throws SQLException if there is an error processing the XML value. - * The getCause() method of the exception may provide a more detailed exception, for example, - * if the stream does not contain valid characters. - * An exception is thrown if the state is not writable. - * @exception SQLFeatureNotSupportedException if the JDBC driver does not support - * this method - * @since 1.6 - */ - Writer setCharacterStream() throws SQLException; - - /** - * Returns a string representation of the XML value designated by this SQLXML instance. - * The format of this String is defined by org.xml.sax.InputSource, - * where the characters in the stream represent the unicode code points for - * XML according to section 2 and appendix B of the XML 1.0 specification. - * Although an encoding declaration other than unicode may be present, - * the encoding of the String is unicode. - * The behavior of this method is the same as ResultSet.getString() - * when the designated column of the ResultSet has a type java.sql.Types of SQLXML. - * <p> - * The SQL XML object becomes not readable when this method is called and - * may also become not writable depending on implementation. - * - * @return a string representation of the XML value designated by this SQLXML instance. - * @throws SQLException if there is an error processing the XML value. - * The getCause() method of the exception may provide a more detailed exception, for example, - * if the stream does not contain valid characters. - * An exception is thrown if the state is not readable. - * @exception SQLFeatureNotSupportedException if the JDBC driver does not support - * this method - * @since 1.6 - */ - String getString() throws SQLException; - - /** - * Sets the XML value designated by this SQLXML instance to the given String representation. - * The format of this String is defined by org.xml.sax.InputSource, - * where the characters in the stream represent the unicode code points for - * XML according to section 2 and appendix B of the XML 1.0 specification. - * Although an encoding declaration other than unicode may be present, - * the encoding of the String is unicode. - * The behavior of this method is the same as ResultSet.updateString() - * when the designated column of the ResultSet has a type java.sql.Types of SQLXML. - * <p> - * The SQL XML object becomes not writeable when this method is called and - * may also become not readable depending on implementation. - * - * @param value the XML value - * @throws SQLException if there is an error processing the XML value. - * The getCause() method of the exception may provide a more detailed exception, for example, - * if the stream does not contain valid characters. - * An exception is thrown if the state is not writable. - * @exception SQLFeatureNotSupportedException if the JDBC driver does not support - * this method - * @since 1.6 - */ - void setString(String value) throws SQLException; - - /** - * Returns a Source for reading the XML value designated by this SQLXML instance. - * Sources are used as inputs to XML parsers and XSLT transformers. - * <p> - * Sources for XML parsers will have namespace processing on by default. - * The systemID of the Source is implementation dependent. - * <p> - * The SQL XML object becomes not readable when this method is called and - * may also become not writable depending on implementation. - * <p> - * Note that SAX is a callback architecture, so a returned - * SAXSource should then be set with a content handler that will - * receive the SAX events from parsing. The content handler - * will receive callbacks based on the contents of the XML. - * <pre> - * SAXSource saxSource = sqlxml.getSource(SAXSource.class); - * XMLReader xmlReader = saxSource.getXMLReader(); - * xmlReader.setContentHandler(myHandler); - * xmlReader.parse(saxSource.getInputSource()); - * </pre> - * - * @param sourceClass The class of the source, or null. - * If the class is null, a vendor specifc Source implementation will be returned. - * The following classes are supported at a minimum: - * <pre> - * javax.xml.transform.dom.DOMSource - returns a DOMSource - * javax.xml.transform.sax.SAXSource - returns a SAXSource - * javax.xml.transform.stax.StAXSource - returns a StAXSource - * javax.xml.transform.stream.StreamSource - returns a StreamSource - * </pre> - * @return a Source for reading the XML value. - * @throws SQLException if there is an error processing the XML value - * or if this feature is not supported. - * The getCause() method of the exception may provide a more detailed exception, for example, - * if an XML parser exception occurs. - * An exception is thrown if the state is not readable. - * @exception SQLFeatureNotSupportedException if the JDBC driver does not support - * this method - * @since 1.6 - */ - <T extends Source> T getSource(Class<T> sourceClass) throws SQLException; - - /** - * Returns a Result for setting the XML value designated by this SQLXML instance. - * <p> - * The systemID of the Result is implementation dependent. - * <p> - * The SQL XML object becomes not writeable when this method is called and - * may also become not readable depending on implementation. - * <p> - * Note that SAX is a callback architecture and the returned - * SAXResult has a content handler assigned that will receive the - * SAX events based on the contents of the XML. Call the content - * handler with the contents of the XML document to assign the values. - * <pre> - * SAXResult saxResult = sqlxml.setResult(SAXResult.class); - * ContentHandler contentHandler = saxResult.getXMLReader().getContentHandler(); - * contentHandler.startDocument(); - * // set the XML elements and attributes into the result - * contentHandler.endDocument(); - * </pre> - * - * @param resultClass The class of the result, or null. - * If resultClass is null, a vendor specific Result implementation will be returned. - * The following classes are supported at a minimum: - * <pre> - * javax.xml.transform.dom.DOMResult - returns a DOMResult - * javax.xml.transform.sax.SAXResult - returns a SAXResult - * javax.xml.transform.stax.StAXResult - returns a StAXResult - * javax.xml.transform.stream.StreamResult - returns a StreamResult - * </pre> - * @return Returns a Result for setting the XML value. - * @throws SQLException if there is an error processing the XML value - * or if this feature is not supported. - * The getCause() method of the exception may provide a more detailed exception, for example, - * if an XML parser exception occurs. - * An exception is thrown if the state is not writable. - * @exception SQLFeatureNotSupportedException if the JDBC driver does not support - * this method - * @since 1.6 - */ - <T extends Result> T setResult(Class<T> resultClass) throws SQLException; - -} Copied: trunk/client-jdbc30/src/main/java/com/metamatrix/core/jdbc/SQLXML.java (from rev 806, branches/jdbc30-jdk15/client-jdbc30/src/main/java/com/metamatrix/core/jdbc/SQLXML.java) =================================================================== --- trunk/client-jdbc30/src/main/java/com/metamatrix/core/jdbc/SQLXML.java (rev 0) +++ trunk/client-jdbc30/src/main/java/com/metamatrix/core/jdbc/SQLXML.java 2009-04-21 00:10:07 UTC (rev 810) @@ -0,0 +1,407 @@ +/* + * %W% %E% + * + * Copyright 2006 Sun Microsystems, Inc. All rights reserved. + * SUN PROPRIETARY/CONFIDENTIAL. Use is subject to license terms. + */ +package com.metamatrix.core.jdbc; + +import java.io.InputStream; +import java.io.OutputStream; +import java.io.Reader; +import java.io.Writer; +import java.sql.SQLException; + +import javax.xml.transform.Result; +import javax.xml.transform.Source; + +/** + * The mapping in the JavaTM programming language for the SQL XML type. + * XML is a built-in type that stores an XML value + * as a column value in a row of a database table. + * By default drivers implement an SQLXML object as + * a logical pointer to the XML data + * rather than the data itself. + * An SQLXML object is valid for the duration of the transaction in which it was created. + * <p> + * 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 DOM, SAX, and StAX, as + * well as with XSLT transforms and XPath evaluations. + * <p> + * Methods in the interfaces ResultSet, CallableStatement, and PreparedStatement, + * such as getSQLXML allow a programmer to access an XML value. + * In addition, this interface has methods for updating an XML value. + * <p> + * The XML value of the SQLXML instance may be obtained as a BinaryStream using + * <pre> + * SQLXML sqlxml = resultSet.getSQLXML(column); + * InputStream binaryStream = sqlxml.getBinaryStream(); + * </pre> + * For example, to parse an XML value with a DOM parser: + * <pre> + * DocumentBuilder parser = DocumentBuilderFactory.newInstance().newDocumentBuilder(); + * Document result = parser.parse(binaryStream); + * </pre> + * or to parse an XML value with a SAX parser to your handler: + * <pre> + * SAXParser parser = SAXParserFactory.newInstance().newSAXParser(); + * parser.parse(binaryStream, myHandler); + * </pre> + * or to parse an XML value with a StAX parser: + * <pre> + * XMLInputFactory factory = XMLInputFactory.newInstance(); + * XMLStreamReader streamReader = factory.createXMLStreamReader(binaryStream); + * </pre> + * <p> + * Because databases may use an optimized representation for the XML, + * accessing the value through getSource() and + * setResult() can lead to improved processing performance + * without serializing to a stream representation and parsing the XML. + * <p> + * For example, to obtain a DOM Document Node: + * <pre> + * DOMSource domSource = sqlxml.getSource(DOMSource.class); + * Document document = (Document) domSource.getNode(); + * </pre> + * or to set the value to a DOM Document Node to myNode: + * <pre> + * DOMResult domResult = sqlxml.setResult(DOMResult.class); + * domResult.setNode(myNode); + * </pre> + * or, to send SAX events to your handler: + * <pre> + * SAXSource saxSource = sqlxml.getSource(SAXSource.class); + * XMLReader xmlReader = saxSource.getXMLReader(); + * xmlReader.setContentHandler(myHandler); + * xmlReader.parse(saxSource.getInputSource()); + * </pre> + * or, to set the result value from SAX events: + * <pre> + * SAXResult saxResult = sqlxml.setResult(SAXResult.class); + * ContentHandler contentHandler = saxResult.getXMLReader().getContentHandler(); + * contentHandler.startDocument(); + * // set the XML elements and attributes into the result + * contentHandler.endDocument(); + * </pre> + * or, to obtain StAX events: + * <pre> + * StAXSource staxSource = sqlxml.getSource(StAXSource.class); + * XMLStreamReader streamReader = staxSource.getXMLStreamReader(); + * </pre> + * or, to set the result value from StAX events: + * <pre> + * StAXResult staxResult = sqlxml.setResult(StAXResult.class); + * XMLStreamWriter streamWriter = staxResult.getXMLStreamWriter(); + * </pre> + * or, to perform XSLT transformations on the XML value using the XSLT in xsltFile + * output to file resultFile: + * <pre> + * File xsltFile = new File("a.xslt"); + * File myFile = new File("result.xml"); + * Transformer xslt = TransformerFactory.newInstance().newTransformer(new StreamSource(xsltFile)); + * Source source = sqlxml.getSource(null); + * Result result = new StreamResult(myFile); + * xslt.transform(source, result); + * </pre> + * or, to evaluate an XPath expression on the XML value: + * <pre> + * XPath xpath = XPathFactory.newInstance().newXPath(); + * DOMSource domSource = sqlxml.getSource(DOMSource.class); + * Document document = (Document) domSource.getNode(); + * String expression = "/foo/@bar"; + * String barValue = xpath.evaluate(expression, document); + * </pre> + * To set the XML value to be the result of an XSLT transform: + * <pre> + * File sourceFile = new File("source.xml"); + * Transformer xslt = TransformerFactory.newInstance().newTransformer(new StreamSource(xsltFile)); + * Source streamSource = new StreamSource(sourceFile); + * Result result = sqlxml.setResult(null); + * xslt.transform(streamSource, result); + * </pre> + * Any Source can be transformed to a Result using the identity transform + * specified by calling newTransformer(): + * <pre> + * Transformer identity = TransformerFactory.newInstance().newTransformer(); + * Source source = sqlxml.getSource(null); + * File myFile = new File("result.xml"); + * Result result = new StreamResult(myFile); + * identity.transform(source, result); + * </pre> + * To write the contents of a Source to standard output: + * <pre> + * Transformer identity = TransformerFactory.newInstance().newTransformer(); + * Source source = sqlxml.getSource(null); + * Result result = new StreamResult(System.out); + * identity.transform(source, result); + * </pre> + * To create a DOMSource from a DOMResult: + * <pre> + * DOMSource domSource = new DOMSource(domResult.getNode()); + * </pre> + * <p> + * Incomplete or invalid XML values may cause an SQLException when + * set or the exception may occur when execute() occurs. All streams + * must be closed before execute() occurs or an SQLException will be thrown. + * <p> + * Reading and writing XML values to or from an SQLXML object can happen at most once. + * The conceptual states of readable and not readable determine if one + * of the reading APIs will return a value or throw an exception. + * The conceptual states of writable and not writable determine if one + * of the writing APIs will set a value or throw an exception. + * <p> + * The state moves from readable to not readable once free() or any of the + * reading APIs are called: getBinaryStream(), getCharacterStream(), getSource(), and getString(). + * Implementations may also change the state to not writable when this occurs. + * <p> + * The state moves from writable to not writeable once free() or any of the + * writing APIs are called: setBinaryStream(), setCharacterStream(), setResult(), and setString(). + * Implementations may also change the state to not readable when this occurs. + * <p> + * <p> + * All methods on the <code>SQLXML</code> interface must be fully implemented if the + * JDBC driver supports the data type. + * + * @see javax.xml.parsers + * @see javax.xml.stream + * @see javax.xml.transform + * @see javax.xml.xpath + * @since 1.6 + */ +public interface SQLXML +{ + /** + * This method closes this object and releases the resources that it held. + * The SQL XML object becomes invalid and neither readable or writeable + * when this method is called. + * + * After <code>free</code> has been called, any attempt to invoke a + * method other than <code>free</code> will result in a <code>SQLException</code> + * being thrown. If <code>free</code> is called multiple times, the subsequent + * calls to <code>free</code> are treated as a no-op. + * @throws SQLException if there is an error freeing the XML value. + * @exception SQLFeatureNotSupportedException if the JDBC driver does not support + * this method + * @since 1.6 + */ + void free() throws SQLException; + + /** + * Retrieves the XML value designated by this SQLXML instance as a stream. + * The bytes of the input stream are interpreted according to appendix F of the XML 1.0 specification. + * The behavior of this method is the same as ResultSet.getBinaryStream() + * when the designated column of the ResultSet has a type java.sql.Types of SQLXML. + * <p> + * The SQL XML object becomes not readable when this method is called and + * may also become not writable depending on implementation. + * + * @return a stream containing the XML data. + * @throws SQLException if there is an error processing the XML value. + * An exception is thrown if the state is not readable. + * @exception SQLFeatureNotSupportedException if the JDBC driver does not support + * this method + * @since 1.6 + */ + InputStream getBinaryStream() throws SQLException; + + /** + * Retrieves a stream that can be used to write the XML value that this SQLXML instance represents. + * The stream begins at position 0. + * The bytes of the stream are interpreted according to appendix F of the XML 1.0 specification + * The behavior of this method is the same as ResultSet.updateBinaryStream() + * when the designated column of the ResultSet has a type java.sql.Types of SQLXML. + * <p> + * The SQL XML object becomes not writeable when this method is called and + * may also become not readable depending on implementation. + * + * @return a stream to which data can be written. + * @throws SQLException if there is an error processing the XML value. + * An exception is thrown if the state is not writable. + * @exception SQLFeatureNotSupportedException if the JDBC driver does not support + * this method + * @since 1.6 + */ + OutputStream setBinaryStream() throws SQLException; + + /** + * Retrieves the XML value designated by this SQLXML instance as a java.io.Reader object. + * The format of this stream is defined by org.xml.sax.InputSource, + * where the characters in the stream represent the unicode code points for + * XML according to section 2 and appendix B of the XML 1.0 specification. + * Although an encoding declaration other than unicode may be present, + * the encoding of the stream is unicode. + * The behavior of this method is the same as ResultSet.getCharacterStream() + * when the designated column of the ResultSet has a type java.sql.Types of SQLXML. + * <p> + * The SQL XML object becomes not readable when this method is called and + * may also become not writable depending on implementation. + * + * @return a stream containing the XML data. + * @throws SQLException if there is an error processing the XML value. + * The getCause() method of the exception may provide a more detailed exception, for example, + * if the stream does not contain valid characters. + * An exception is thrown if the state is not readable. + * @exception SQLFeatureNotSupportedException if the JDBC driver does not support + * this method + * @since 1.6 + */ + Reader getCharacterStream() throws SQLException; + + /** + * Retrieves a stream to be used to write the XML value that this SQLXML instance represents. + * The format of this stream is defined by org.xml.sax.InputSource, + * where the characters in the stream represent the unicode code points for + * XML according to section 2 and appendix B of the XML 1.0 specification. + * Although an encoding declaration other than unicode may be present, + * the encoding of the stream is unicode. + * The behavior of this method is the same as ResultSet.updateCharacterStream() + * when the designated column of the ResultSet has a type java.sql.Types of SQLXML. + * <p> + * The SQL XML object becomes not writeable when this method is called and + * may also become not readable depending on implementation. + * + * @return a stream to which data can be written. + * @throws SQLException if there is an error processing the XML value. + * The getCause() method of the exception may provide a more detailed exception, for example, + * if the stream does not contain valid characters. + * An exception is thrown if the state is not writable. + * @exception SQLFeatureNotSupportedException if the JDBC driver does not support + * this method + * @since 1.6 + */ + Writer setCharacterStream() throws SQLException; + + /** + * Returns a string representation of the XML value designated by this SQLXML instance. + * The format of this String is defined by org.xml.sax.InputSource, + * where the characters in the stream represent the unicode code points for + * XML according to section 2 and appendix B of the XML 1.0 specification. + * Although an encoding declaration other than unicode may be present, + * the encoding of the String is unicode. + * The behavior of this method is the same as ResultSet.getString() + * when the designated column of the ResultSet has a type java.sql.Types of SQLXML. + * <p> + * The SQL XML object becomes not readable when this method is called and + * may also become not writable depending on implementation. + * + * @return a string representation of the XML value designated by this SQLXML instance. + * @throws SQLException if there is an error processing the XML value. + * The getCause() method of the exception may provide a more detailed exception, for example, + * if the stream does not contain valid characters. + * An exception is thrown if the state is not readable. + * @exception SQLFeatureNotSupportedException if the JDBC driver does not support + * this method + * @since 1.6 + */ + String getString() throws SQLException; + + /** + * Sets the XML value designated by this SQLXML instance to the given String representation. + * The format of this String is defined by org.xml.sax.InputSource, + * where the characters in the stream represent the unicode code points for + * XML according to section 2 and appendix B of the XML 1.0 specification. + * Although an encoding declaration other than unicode may be present, + * the encoding of the String is unicode. + * The behavior of this method is the same as ResultSet.updateString() + * when the designated column of the ResultSet has a type java.sql.Types of SQLXML. + * <p> + * The SQL XML object becomes not writeable when this method is called and + * may also become not readable depending on implementation. + * + * @param value the XML value + * @throws SQLException if there is an error processing the XML value. + * The getCause() method of the exception may provide a more detailed exception, for example, + * if the stream does not contain valid characters. + * An exception is thrown if the state is not writable. + * @exception SQLFeatureNotSupportedException if the JDBC driver does not support + * this method + * @since 1.6 + */ + void setString(String value) throws SQLException; + + /** + * Returns a Source for reading the XML value designated by this SQLXML instance. + * Sources are used as inputs to XML parsers and XSLT transformers. + * <p> + * Sources for XML parsers will have namespace processing on by default. + * The systemID of the Source is implementation dependent. + * <p> + * The SQL XML object becomes not readable when this method is called and + * may also become not writable depending on implementation. + * <p> + * Note that SAX is a callback architecture, so a returned + * SAXSource should then be set with a content handler that will + * receive the SAX events from parsing. The content handler + * will receive callbacks based on the contents of the XML. + * <pre> + * SAXSource saxSource = sqlxml.getSource(SAXSource.class); + * XMLReader xmlReader = saxSource.getXMLReader(); + * xmlReader.setContentHandler(myHandler); + * xmlReader.parse(saxSource.getInputSource()); + * </pre> + * + * @param sourceClass The class of the source, or null. + * If the class is null, a vendor specifc Source implementation will be returned. + * The following classes are supported at a minimum: + * <pre> + * javax.xml.transform.dom.DOMSource - returns a DOMSource + * javax.xml.transform.sax.SAXSource - returns a SAXSource + * javax.xml.transform.stax.StAXSource - returns a StAXSource + * javax.xml.transform.stream.StreamSource - returns a StreamSource + * </pre> + * @return a Source for reading the XML value. + * @throws SQLException if there is an error processing the XML value + * or if this feature is not supported. + * The getCause() method of the exception may provide a more detailed exception, for example, + * if an XML parser exception occurs. + * An exception is thrown if the state is not readable. + * @exception SQLFeatureNotSupportedException if the JDBC driver does not support + * this method + * @since 1.6 + */ + <T extends Source> T getSource(Class<T> sourceClass) throws SQLException; + + /** + * Returns a Result for setting the XML value designated by this SQLXML instance. + * <p> + * The systemID of the Result is implementation dependent. + * <p> + * The SQL XML object becomes not writeable when this method is called and + * may also become not readable depending on implementation. + * <p> + * Note that SAX is a callback architecture and the returned + * SAXResult has a content handler assigned that will receive the + * SAX events based on the contents of the XML. Call the content + * handler with the contents of the XML document to assign the values. + * <pre> + * SAXResult saxResult = sqlxml.setResult(SAXResult.class); + * ContentHandler contentHandler = saxResult.getXMLReader().getContentHandler(); + * contentHandler.startDocument(); + * // set the XML elements and attributes into the result + * contentHandler.endDocument(); + * </pre> + * + * @param resultClass The class of the result, or null. + * If resultClass is null, a vendor specific Result implementation will be returned. + * The following classes are supported at a minimum: + * <pre> + * javax.xml.transform.dom.DOMResult - returns a DOMResult + * javax.xml.transform.sax.SAXResult - returns a SAXResult + * javax.xml.transform.stax.StAXResult - returns a StAXResult + * javax.xml.transform.stream.StreamResult - returns a StreamResult + * </pre> + * @return Returns a Result for setting the XML value. + * @throws SQLException if there is an error processing the XML value + * or if this feature is not supported. + * The getCause() method of the exception may provide a more detailed exception, for example, + * if an XML parser exception occurs. + * An exception is thrown if the state is not writable. + * @exception SQLFeatureNotSupportedException if the JDBC driver does not support + * this method + * @since 1.6 + */ + <T extends Result> T setResult(Class<T> resultClass) throws SQLException; + +}