This is correct.
The SQL-to->XML side of the utility works against
any JDBC driver. API-wise, this is the OracleXMLQuery
However, presently the XML->to->TABLES(insert)
direction has some dependencies on the Oracle driver.
API-wise, as you discovered, this is the OracleXMLSave
class. This will be corrected in a later release.
Steve Muench, Lead XML Evangelist / Consulting Product Mgr
Oracle Corp, Business Components for Java Development Team
----- Original Message -----
From: "Omar López Ruiz" <[log in to unmask]>
To: <[log in to unmask]>
Sent: Saturday, February 19, 2000 9:38 AM
Subject: Re: Transforming SQL queries via JDBC in an XML document
| Has anyone tried the Oracle XML SQL Utility with any other JDBC driver apart from the Oracle
one? Does anyone knows if it calls to Oracle JDBC methods, for instance in the OracleXMLSave class?
I've tried the samp10 with the Informix Driver, (I also change the URL), and I have the followind
| Exception in thread "main" java.lang.NoClassDefFoundError: oracle/jdbc/driver/Or
| at samp10.main(samp10.java:26)
| Any ideas, it seems that the OracleXMLSave class calls the
| Omar López.
| Steve Muench wrote:
| Oracle XML SQL Utility does what you need.
| It works with any JDBC driver.
| Against Oracle8i using the *Oracle* JDBC driver
| it knows how to work with Oracle8i's more advanced
| Object/Relational features for streaming
| logical, richly-structured XML Object Views, but
| against other JDBC-based datasources it handles
| the "flat" relational tables supported by these
| databases just fine.
| To make using it totally declarative, you can
| try out the free Oracle XSQL Pages technology
| that runs in any Servlet Engine with any JDBC
| driver and makes assembling dynamic XML content
| from SQL and other sources and combining it
| with XSLT transformations in the server or client
| Pick a utility and click on "Software" icon to download.
| Steve Muench, Lead XML Evangelist / Consulting Product Mgr
| Oracle Corp, Business Components for Java Development Team
| ----- Original Message -----
| From: "Omar Lspez Ruiz" <[log in to unmask]>
| To: <[log in to unmask]>
| Sent: Wednesday, February 16, 2000 9:13 AM
| Subject: Transforming SQL queries via JDBC in an XML document
| | Hi all,
| | Imagine I have some Java Servlets that can access a relational database via JDBC, now, I
| to transform/convert this relational data, with maybe some data manipulation, in an XML
| How can I do that?, How it's the best way?, I've heard something about Oracle XML SQL Utility
| Java. Has anybody used this Java package? It's propietary to Oracle or can be used against other
| commercial databases, think that some basic SQL sentences are diferent form Informix, Sybase or
| | Any input is welcome.
| | Omar