Oracle XSQL Pages: Setup and Examples

Once you have built a set of XSQL Pages, you can use your pages by doing the following:

• Requesting them over the Web after installing the Oracle XSQL Servlet on your favorite Web Server,

• Calling the Oracle XSQL Command Line Utility in batch programs,

• Invoking the XSQLRequest.process() method from within any Java program

• Using <jsp:include page="foo.xsql"> or <jsp:forward page="bar.xsql"> in a JSP

Figure 19-5 shows how XSQL Servlet is one of three "clients" to the core XSQL Page Processor Engine. This is also illustrated in Figure 19-6 and Figure 19-8.

XSQL Page Processor interprets, caches, and processes the contents of your XSQL Pages. As its name implies, XSQLServlet is a Java Servlet that allows XSQL Pages to be accessed through a web server over HTTP.

The other two clients are:

• XSQLCommandLine utility that allows XSQL Pages to be processed from the command line

• XSQLRequest class that offers a simple API to process XSQL Pages programmatically from within a custom Java program

Figure 19-5 Installing XSQL Servlet -- Explaining XSQL Servlet Architecture