RE: MySQL 5.0 XML support

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

> -----Original Message-----
> From: Deepak Vohra [mailto:dvohra09@yahoo.com]
> Sent: Thursday, September 06, 2007 2:59 PM
> To: java@lists.mysql.com
> 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)

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related lists.mysql.com Links announce benchmarks bugs certification cluster commits dotnet gui-tools internals java maxdb myodbc mysql mysqldoc packagers perl plusplus replication win32 Request more information about Pantek

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/java?unsub=lists@pantek.com