Lists Home |
Date Index |
I think Merant used to have a driver that did this, but I'm not sure if
it's available any more.
Note that there are a number of strategies for doing this. (Both SQL
Server and Oracle support this with SQL functions/operators.)
1) Document is table. The document must have the form:
This is simple, but the disadvantage is that it only works with
documents that match the above format.
2) Designate row elements. The user specifies a "row" element with an
XPath expression. The attributes and/or simple child elements of the
"row" element are treated as columns. This allows users to extract a
fixed part of any XML document.
3) Designate row and column elements. Same as (2), except that further
XPath expressions that use the row element as context designate the
Jihan Lee wrote:
> We are developping an application that access various databases using
> the correspondng JDBC drivers. We actually would like to actually
> extend this fonctionality to XML files. In fact we would like to view
> our XML files as tables and perform all kind of SQL statments on them.
> We do not wish to make specific programming for that but use standard
> JDBC interfacing. Does anyone know of any JDBC driver for accessing
> XML files preferably a type 4 driver ?