RE: MySQL 5.0 XML support

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

> -----Original Message-----
> From: Deepak Vohra [mailto:[email protected]] 
> Sent: Thursday, September 06, 2007 2:59 PM
> To: [email protected]
> Subject: MySQL 5.0 XML support
> 
> Mark,
> 
> MySQL Connector/J 5.1.2 beta supports JDBC4.0 SQLXML.
> MySQL 5.0/5.1 has to support SQL:2003 standard 'XML'
> data type for SQLXML support in the JDBC driver. But, MySQL 
> 5.0/5.1 does not support the SQL:2003 standard XML data type. 
> 
> thanks,
> Deepak

Deepak,

There's no "hard" requirement that a database has to implement SQL:2003 "XML" data types for JDBC-4.0's SQLXML to work at all. 

(In fact, if you look at the JDBC-4.0 specification, you won't see any examples of using SQL to manipulate XML, because it's not a prerequesite for java.sql.SQLXML).

The _only_ thing our SQLXML implementation is missing is the ability to call getObject() on an column and use type-inference to return you a SQLXML instance, since MySQL doesn't have an XML type.

If you check the examples at http://svn.mysql.com/svnpublic/connector-j/trunk/jdbc-4-0-examples/src/examples/cex2007/XMLSamples.java you'll see that SQLXML is easily used to consume and process XML with MySQL in a way that is "familiar" to Java developers.

	-Mark
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (MingW32)

iD8DBQFG4GOBtvXNTca6JD8RApCeAJ9ia2NQEEvxFCmnivz/EnwKcn62xwCeNG9p
mxTPwJR1gZAP6xYLb6qMozI=
=qQc8
-----END PGP SIGNATURE-----


-- 
MySQL Java Mailing List
For list archives: http://lists.mysql.com/java
To unsubscribe:    http://lists.mysql.com/[email protected]