SQL/XML support

[ivan vasyliev]

I wonder if there any plans to add SQL/XML support to H2?
http://en.wikipedia.org/wiki/SQL/XML

I can't find any embeddable db for java with this feature (at least
XMLTABLE function)...

Thanks

[Thomas Mueller]

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 - 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

Regards,
Thomas

[Noel Grandin]

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, xavie...@gmail.com 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

--
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 h2-database...@googlegroups.com.
To post to this group, send email to h2-da...@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.