Setup Instructions for Chapter 6
Database Setup
Before running the examples in Chapter 6, do the following:
- Set your current directory to ./orxmlapp/Examples/ch06
- Run the following SQL scripts as the indicated user...
- As user XMLBOOK, run the latest_quotes.sql script.
This creates the tables for the Yahoo Quotes examples
- As user XMLBOOK, run the insert_quote.sql script.
This creates a stored procedure for the Yahoo Quotes examples
- As user XMLBOOK, run the create_course_assignments.sql script.
This creates the tables for the course enrollment info examples
- As user XMLBOOK, run the createAccessLog.sql script.
This creates the tables for the Web tracking access log example
To run a script use the SQL*Plus command-line tool that
comes with your Oracle database using the command:
$ sqlplus username/password @scriptname.sqlSetup for External Java Libraries
Before running the examples in Chapter 6, do the following:
- Obtain the JTidy library from http://www3.sympatico.ca/ac.quick/jtidy.html, create a JDeveloper library for the
JTidyHome/lib/Tidy.jar archive, and add this library to the Chapter-06 project's library list.
- Obtain the Oracle8i Advanced Queueing library that is shipped with Oracle8i, create a JDeveloper library for the
ORACLE_HOME/rdbms/jlib/aqapi.jar archive, and add this library to the Chapter-06 project's library list.
For detailed instructions on creating a JDeveloper library to
represent a Java archive, see the Using JDeveloper with Oracle
XDK Components section of Chapter 4.