Setup Instructions for Chapter 17
Database Setup
Before running the examples in Chapter 17, do the following:
- Set your current directory to ./orxmlapp/Examples/ch17
- Run the following SQL scripts as the indicated user...
- As user XMLBOOK, run the store.sql script.
Creates all the tables/data for the Web Store example
- As user XMLBOOK, run the create_portal_tables.sql script.
Creates all the tables/data for the Web Store example
- If you have not already run it as part of the setup for Chapter 6, then as user XMLBOOK, run the latest_quotes.sql script.
This creates the tables for the Yahoo Quotes examples
- If you have not already run it as part of the setup for Chapter 6, then 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_forum_tables.sql script.
Creates all the tables/data for the Discussion Forum 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 17, do the following:
- If you have not already created this library as part of the setup for Chapter 6, then 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-17 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.