There are several parts to SQLXML support.
There is the JDBC layer
http://docs.oracle.com/javase/tutorial/jdbc/basics/sqlxml.html
http://docs.oracle.com/javase/6/docs/api/java/sql/SQLXML.html
And the actual syntax layer
http://en.wikipedia.org/wiki/SQL/XML
For now, I would stick with leaving columns as CLOB, and focus on
implementing the bits that provide most value to you, which is probably
a subset of the SQL/XML syntax and functions.
On 2013-05-07 10:55, [email protected] wrote:
Hi,
H2 being my favorite database for testing/prototyping, I would like to
see SQLXML support too.
Do you think it would be difficult to implement it on basis of CLOB
support and add the missing parts? What would be the name of this
column type in DDL?
Regards,
Xavier
On Saturday, March 19, 2011 10:30:56 AM UTC+1, Thomas Mueller wrote:
Hi,
There are currently no plans to implement the standard SQL/XML, I will
add it to the roadmap. If you need this feature you would have to
implement it yourself however (patches are always welcome!).
A few (non-standard) XML functions are available:
http://h2database.com/html/functions.html#xmlattr
<http://h2database.com/html/functions.html#xmlattr> - those functions
are used to generate the Atom and RSS newsfeed:
http://code.google.com/p/h2database/source/browse/trunk/h2/src/test/org/h2/samples/newsfeed.sql
<http://code.google.com/p/h2database/source/browse/trunk/h2/src/test/org/h2/samples/newsfeed.sql>
Regards,
Thomas
--
You received this message because you are subscribed to the Google
Groups "H2 Database" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
