JDBC driver for XML?

[Michael Hildner]

I was looking at database drivers recently, noticed that there are ODBC to XML drivers, also ODBC to text drivers. Wondering if there is a JDBC to XML driver. Might be useful for a small database.

[Ajith Kallambella]

Many database vendors are jumping into the XML bandwagon supporting seamless SQL/XML integration . Oracle has a repertoire of XML-enabled interfaces. So does Sybase, SQL Server etc. The point to note however, is that these tools and frameworks are native and cannot be used as generic( cross-vendor ) solutions.
Having said that, I should point out that it is fairly easy to write your own lightweight class library to format a DB resultset to XML and vice-versa. The book "XML Databases" by Wrox Press ( Author Kevin Williams ) is written specifically to address XML-DB integration and using an XML file itself to represent a small hierarchical database. If you haven't read it, I suggest you check it out!
Good luck,

------------------
Ajith Kallambella M.
Sun Certified Programmer for the Java�2 Platform.
IBM Certified Developer - XML and Related Technologies, V1.

[Sanjay Anand]

Excellent reference. It helped me tremendously as did Ajith's timely advice to hard code customized xml based on my particular data. I think that remains the best way at this point in the technology.
Sanjay