Setting the CLASSPATH Correctly

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:

• classes111.zip for the Oracle JDBC Driver

• xmlparserv2.jar for the Oracle XML Parser for Java V2

• oraclexmlsql.jar for the Oracle XML-SQL Utility for Java

• oraclexsql.jar for the Oracle XSQL Servlet and Page Processor

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:

• On Windows NT:

  C:\xsql\lib\classes111.zip;C:\xsql\lib\xmlparserv2.jar;
  C:\xsql\lib\oraclexmlsql.jar;C:\xsql\lib\oraclexsql.jar;C:\xsql\lib
  

• On UNIX, if you installed in your /web directory, the CLASSPATH would appear as follows:

  /web/xsql/lib/classes111.zip:/web/xsql/lib/xmlparserv2.jar:
  /web/xsql/lib/oraclexmlsql.jar:/web/xsql/lib/oraclexsql.jar:/web/xsql/lib
  
  

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.