|Oracle8i Application Developer's Guide - XML
Release 3 (8.1.7)
Part Number A86030-01
XML-SQL Utility (XSU) Specifications and Cheat Sheets, 3 of 5
There are two versions of the utility - XSU111.zip and XSU12.zip, one compatible for JDK 1.1.x and the other with JDK1.2 respectively.
This is the JDK 1.1.x compatible version. It needs Java JDK 1.1.x version and the JDBC 1.x compliant drivers. Oracle ships classes111.zip as the JDBC 1.x compliant driver. The utility is also dependent on the Oracle XML Parser V2 for parsing documents and for creating DOM nodes. To load this into the database, the database must be running Oracle8i JVM (JServer) version 8.1.5 or above.
This version of the utility is JDK1.2.x/JDK 2.x compliant. It needs Java JDK 1.2.x (or JDK2.x) to be available. The JDBC drivers need to be JDK1.2 compliant as well. Oracle ships classes12.zip as the JDBC2.0 compliant driver. The XSU utility is also dependent on the Oracle XML parser V2. The database version must be 8.1.6 or above, with Oracle8i JVM (JServer) enabled, for the utility to be uploaded in to the server and run inside the database.
Before installing the utility make sure that you choose the right version of the utility depending on your particular needs. For example, if you can only use the JDK1.1.x version, then download the XSU111.zip file. Ensure that you have the JDK and the JDBC drivers correctly downloaded and installed, if not already available.
After downloading the zip file, simply extract the contents to a directory of your choice, say C:\xml. The files will get expanded in to a subdirectory called XSU111 or XSU12 depending on the version of the utility.
Depending on the way you plan to use the utility, on the client or server side, perform different set up tasks.
If you are running XSU from the client side, you need to correct CLASSPATH settings. If these variables are already set correctly in your environment, then you need to only ensure that oraclexmlsql.jar is included in this CLASSPATH. You can do this by either editing your global settings or changing the settings for your current shell.
The latter operation only affects the current shell you are running in and consequently you have to source or execute these batch files for every different shell.
Ensure that Your database is up and running.
After this, you are ready to use the utility from the client side.
To use XSU's PL/SQL API, or write Java stored procedures on top of XSU Java APIs, perform the following steps:
Now, you are ready to use the Java and PL/SQL APIs inside the Oracle server.