In this section, we will discuss the preliminary setup required to create an XSQL application, which is not much, as the XSQLServlet is specified in web.xml and the XSQL libraries are added to the project when an XSQL page is created. Oracle database 11g JDBC drivers may be used with any Oracle database version 9i and later. We will use Oracle database 10g. We need to install Oracle database 10g including sample schemas. We need to create and start an instance of the Oracle Database. Connect to the database with the Order Entry (OE) sample schema (username).

CONNECT OE/<password>

Run the following SQL script to create a database table that consists of an example catalog:

CREATE TABLE Catalog(Journal VARCHAR(25), Publisher
Varchar(25),Edition VARCHAR(25), Title Varchar(45), Author
Varchar(25));
INSERT INTO Catalog VALUES('Oracle Magazine', 'Oracle
Publishing','July-August 2005', 'Tuning Undo Tablespace', 'Kimberly
Floss');
INSERT INTO Catalog VALUES('Oracle Magazine...