Re: [jira] Updated: (DERBY-334) Add initial SQL support for XML datatype/functions in Derby, based on SQL/XML specs.

[Satheesh Bandaram]

I have committed this patch. I have some review comments, which I think we can take up as a possible patch on this, if needed. One change I did make to this patch.. is fix Copyright notices. They all need to refer to 2005, I think. I fixed what ever I found. Satheesh Sending        java\engine\org\apache\derby\catalog\types\BaseTypeIdImpl.java Sending        java\engine\org\apache\derby\catalog\types\TypesImplInstanceGetter.java Sending        java\engine\org\apache\derby\iapi\build.xml Sending        java\engine\org\apache\derby\iapi\reference\ClassName.java Sending        java\engine\org\apache\derby\iapi\reference\SQLState.java Sending        java\engine\org\apache\derby\iapi\services\io\RegisteredFormatIds.java Sending        java\engine\org\apache\derby\iapi\services\io\StoredFormatIds.java Sending        java\engine\org\apache\derby\iapi\sql\compile\C_NodeTypes.java Sending        java\engine\org\apache\derby\iapi\types\DTSClassInfo.java Sending        java\engine\org\apache\derby\iapi\types\DataTypeUtilities.java Sending        java\engine\org\apache\derby\iapi\types\DataValueFactory.java Sending        java\engine\org\apache\derby\iapi\types\DataValueFactoryImpl.java Sending        java\engine\org\apache\derby\iapi\types\SQLChar.java Sending        java\engine\org\apache\derby\iapi\types\StringDataValue.java Sending        java\engine\org\apache\derby\iapi\types\TypeId.java Adding         java\engine\org\apache\derby\iapi\types\XML.java Adding         java\engine\org\apache\derby\iapi\types\XMLDataValue.java Sending        java\engine\org\apache\derby\iapi\types\build.xml Sending        java\engine\org\apache\derby\impl\jdbc\Util.java Sending        java\engine\org\apache\derby\impl\sql\compile\BinaryOperatorNode.java Sending        java\engine\org\apache\derby\impl\sql\compile\C_NodeNames.java Sending        java\engine\org\apache\derby\impl\sql\compile\CharTypeCompiler.java Sending        java\engine\org\apache\derby\impl\sql\compile\DB2LengthOperatorNode.java Sending        java\engine\org\apache\derby\impl\sql\compile\NodeFactoryImpl.java Sending        java\engine\org\apache\derby\impl\sql\compile\ParameterNode.java Sending        java\engine\org\apache\derby\impl\sql\compile\QueryTreeNode.java Sending        java\engine\org\apache\derby\impl\sql\compile\ReadCursorNode.java Sending        java\engine\org\apache\derby\impl\sql\compile\ResultColumnList.java Sending        java\engine\org\apache\derby\impl\sql\compile\ResultSetNode.java Sending        java\engine\org\apache\derby\impl\sql\compile\RowResultSetNode.java Sending        java\engine\org\apache\derby\impl\sql\compile\SelectNode.java Sending        java\engine\org\apache\derby\impl\sql\compile\TypeCompilerFactoryImpl.java Sending        java\engine\org\apache\derby\impl\sql\compile\UnaryOperatorNode.java Adding         java\engine\org\apache\derby\impl\sql\compile\XMLConstantNode.java Adding         java\engine\org\apache\derby\impl\sql\compile\XMLTypeCompiler.java Sending        java\engine\org\apache\derby\impl\sql\compile\sqlgrammar.jj Sending        java\engine\org\apache\derby\loc\messages_en.properties Adding         java\testing\org\apache\derbyTesting\functionTests\master\DerbyNet\xmlBinding.out Adding         java\testing\org\apache\derbyTesting\functionTests\master\DerbyNet\xml_general.out Adding         java\testing\org\apache\derbyTesting\functionTests\master\DerbyNetClient\xml_general.out Adding         java\testing\org\apache\derbyTesting\functionTests\master\xmlBinding.out Adding         java\testing\org\apache\derbyTesting\functionTests\master\xml_general.out Adding         java\testing\org\apache\derbyTesting\functionTests\tests\lang\xmlBinding.java Adding         java\testing\org\apache\derbyTesting\functionTests\tests\lang\xmlBinding_app.properties Adding         java\testing\org\apache\derbyTesting\functionTests\tests\lang\xmlTestFiles Adding         java\testing\org\apache\derbyTesting\functionTests\tests\lang\xmlTestFiles\deep40k.xml Adding         java\testing\org\apache\derbyTesting\functionTests\tests\lang\xmlTestFiles\dtdDoc.xml Adding         java\testing\org\apache\derbyTesting\functionTests\tests\lang\xmlTestFiles\dtdDoc_invalid.xml Adding         java\testing\org\apache\derbyTesting\functionTests\tests\lang\xmlTestFiles\personal.dtd Adding         java\testing\org\apache\derbyTesting\functionTests\tests\lang\xmlTestFiles\personal.xsd Adding         java\testing\org\apache\derbyTesting\functionTests\tests\lang\xmlTestFiles\wide40k.xml Adding         java\testing\org\apache\derbyTesting\functionTests\tests\lang\xmlTestFiles\xsdDoc.xml Adding         java\testing\org\apache\derbyTesting\functionTests\tests\lang\xmlTestFiles\xsdDoc_invalid.xml Adding         java\testing\org\apache\derbyTesting\functionTests\tests\lang\xml_general.sql Sending        tools\jar\DBMSnodes.properties Transmitting file data ...................................................... Committed revision 189721. [bandaram:satheesh] A B (JIRA) wrote: [ http://issues.apache.org/jira/browse/DERBY-334?page=all ] A B updated DERBY-334: ---------------------- Attachment: derby-xml_v4.stat derby-xml_v4.patch Latest patch (_v4) resolves conflicts with recent checkins. This patch also removes the two new XML tests from the derbyall suite, since we don't want to require that people running derbyall have Xerces in their classpaths. The two tests can still be run manually using RunTest. At some point we'll probably want to create a new XML suite that contains all of the XML tests, but I think that can be submitted as a seperate patch. Add initial SQL support for XML datatype/functions in Derby, based on SQL/XML specs. ------------------------------------------------------------------------------------- Key: DERBY-334 URL: http://issues.apache.org/jira/browse/DERBY-334 Project: Derby Type: New Feature Components: SQL Versions: 10.1.0.0 Reporter: A B Assignee: A B Fix For: 10.1.0.0 Attachments: derby-xml_v4.patch, derby-xml_v4.stat Adding some "starter" XML functionality to Derby, which can then serve as the basis for future XML development. Initial features include the following: 1 - A built-in XML datatype. 2 - An XMLPARSE() operator for creating XML values. 3 - An XMLSERIALIZE() operator for serializing XML values to strings (for data retrieval). 4 - An XMLEXISTSTS() operator for running simple existence queries against XML using XPath. These features are implemented at the SQL level only (no JDBC support). See the email here for a more detailed description: http://thread.gmane.org/gmane.comp.apache.db.derby.devel/4468