|Oracle8i Application Developer's Guide - XML
Release 3 (8.1.7)
Part Number A86030-01
Using XSQL Servlet, 6 of 24
The XSQLServlet, XSQLRequest, and XSQLCommandLine, as well as the core XSQLPageProcessor are all Java programs and as such are very portable and very simple to setup.
The only setup requirements are to make sure the appropriate JAR files are in the CLASSPATH of the JavaVM that will be running processing the XSQL Pages. The JAR files include:
In addition, the directory where XSQL Page Processor's configuration file (XSQLConfig.xml) resides must also be listed as a directory in the CLASSPATH. This usually resides in the ./xsql/lib directory.
So, putting all this together, if you have installed the XSQL distribution in C:\xsql, then your CLASSPATH would appear as follows:
To use the XSQL Servlet, one additional setup step is required: associating the .xsql file extension with the XSQL Servlet's java class oracle.xml.xsql.XSQLServlet. How you set the CLASSPATH of the web server's Servlet environment and how you associate a Servlet with a file extension are done differently for each web server. The XSQL Servlet's Release Notes contain detailed setup information for specific web servers you might want to use with XSQL Pages.
For the purposes of this lesson, we'll be using the Oracle Web-to-Go single-user web server that is small, easy to use, and that supports Java Servlets.