Sample Files and Errata

Oracle JDeveloper 10g Handbook

by Dr. Avrom Faderman, Peter Koletzke, & Dr. Paul Dorsey

Disclaimer

Installing the Files

Sample Data

Websites

Chapters from the 9i Edition

About the
Sample Files

Sample Files
and Errata

Disclaimer

The files on this page have been tested to the best of the authors' abilities and are intended only to supplement the hands-on practices in the Oracle JDeveloper 10g Handbook. These files have no warranty of usefulness or accuracy. The authors and any other entities making these files available are not responsible for any effects that may result from their use. The files accessible from the links below are offered as freeware in the public domain. The authors and publisher offer no technical support for users of these files. This code has been developed and tested with Oracle JDeveloper 10g release 9.0.5.1 production (build 1605), and checked with patch release 9.0.5.2 (build 1618).

Installing the Files

Unzip the file into a new directory (for example, C:\JDev10Practice). Open this file, INDEX.HTML, in your browser.

[top]

Tip
Some file links on this page will ask if you want to save or open the file. If the file displays in the browser, but you want to save it instead, select "Save Link As" (in Netscape) or "Save Target As" (Internet Explorer) from the right-click menu on the file link.

Sample Data

The practices in this book use database objects in an Oracle8i, Oracle9i, or Oracle 10g database. The objects are owned by a sample user, HR. .

You may install these sample database objects using one of these methods:

Use a sample schema installed by default in an Oracle9i or Oracle 10g database. The HR schema may already be installed in an available Oracle database. You or your database administrator may need to unlock the HR account using: ALTER USER hr ACCOUNT UNLOCK in SQL*Plus. Scripts to reinstall this schema are located in the ORACLE_HOME\demo\schema\human_resources directory (for Oracle9i and Oracle 10g).
Run the following script after creating the HR user and granting it CONNECT and RESOURCE privileges.

hr_install.sql

Should you want to recreate the schema, you can remove the objects in this schema by running hr_drop.sql. You can then re-run the install procedures described above to recreate the objects.

[top]

Websites

The following list contains several of the key websites mentioned in the book. Appendix A contains a more extensive list of websites where you can find additional information about technologies discussed in the book.

Authors

Oracle Technology Network - Avrom's company. The main source of Oracle information about JDeveloper.

Avrom's Personal Home Page

Quovera - Peter's company web site.

Peter's Personal Home Page - Sample Oracle development files.

Dulcian, Inc. - Paul's company web site.

Other

International Oracle Users Group

Oracle Development Tools User Group

Netscape - Developer - JavaScript

Sun - Java - Reference for all Java technology

WWW Consortium - HTML, XML

[top]

Chapters from 9i the Edition

The following files are Adobe Acrobat versions of Chapters 6 and 19 from the Oracle9i JDeveloper Handbook by the same authors. The subjects in these chapters are not discussed in the 10g edition, but have not changed significantly from the 9i edition. They are included should you require more information about the subjects. The steps in the practices refer to the 9i version of JDeveloper.

[top]

About the Sample Files

This section contains links to files organized by chapter and divided into the following categories:

Code snippets and other samples - The files in this section contain small pieces of code from the book chapters that you would otherwise have to key in. They also contain sample files that are supplements to the material in the book.

Hands-on practice files - starting and ending files for the practices. Use the steps in the "Practice Files Installation" section below to set up the files.

Errata - last minute corrections and clarifications that are not in the book. Read these before attempting the hands-on practices.

Using the Files From This Web Page

If the file link causes the file to be displayed when you would rather save it to the file system, right click the link, select Save Link As (in Netscape) or Save Target As (in Internet Explorer or Mozilla), and supply the directory and file name.

Note: So that these files may be displayed in your browser, TXT extensions have been added to some file names. To use one of these files, you can copy the text from the browser page and paste it into Notepad. Then save the file without the TXT extension. Alternatively, you can navigate to the directory in which the file resides (see the Location or Address field in the browser) and copy the text from that file.

[top]

Using the Practice Files

Important Note
The instructions in the book are complete and you do not need to install any of the starting files to successfully complete the practices. The files in this archive are included in case you need to check your work, run practices out of order, or would like to see an example of the files that are created by the practice.

The practices require a connection called "HR." Instructions for creating that connection may be found in the Chapter 1 practice. Once you have set up the connection, use the following steps to install any of the practice files (listed in the table in the "Sample Files and Errata" section):

Use the file with the "_start" suffix for the starting files needed for the practice. Use the file with the "_end" suffix for the completed files for the practice. The ending files for a particular practice may be required for another practice as noted in the book. Note the name of the workspace directory that will be created (in the table in the "Sample Files and Errata" section).
Copy the Zip file into the JDEV_HOME\jdev\mywork directory.
If a workspace file of the same name is open in JDeveloper, close it. Close JDeveloper. Rename the directory in the file system for that workspace.
Unzip the file. In the unzip dialog, specify that you want to extract into the current directory, want to extract all files, and want to "Use folder names" as in the dialog shown here:

(Do not select all files and extract because this will not create empty directories.) This will create a directory with the name shown in the table in the "Sample Files and Errata" section.
If you want to run the files, you need to copy standard.jar to the project directory (for the practices in Chapters 1, 7, 12, 13. 14, 17, and 18 ) using the following technique:

Copying standard.jar
Copy the file JDEV_HOME\jakarta-taglibs\jstl-1.0\lib\standard.jar into the directory: <workspace dir>\ViewController\ public_html\ WEB-INF\ lib.

"workspace dir" is the directory into which you installed the workspace files (where the .jws file is located). If the lib directory does not exist, create it before copying the file.

In JDeveloper, select File | Open and double click the directory name. Do not select either of the two items that have the same name and a .zip extension.
Select the workspace file inside that directory (with a .jws extension).
Click each project (.jpr file) node and click the Rebuild toolbar button. The notes indicate which project to compile first.
If there is a Model project in the workspace, select the Model.jpx file under that project (for example, ViewController.jpx). Select "Edit Model" from the right-click menu on that file. In the Connection page of the Business Components Project Wizard, specify your connection and click OK. This ensures that the connection to your HR schema will be used.

Note
The starting and ending workspace directories for some practices contain a number (in the middle or end of the file name) if the workspace directory is used in another practice. The workspace filename usually matches the directory name but may not exactly match the name used in the book.

What to do if You Have Problems
There are several troubleshooting techniques and strategies mentioned in the introduction of the book.

If you receive a runtime error such as the following lines below, follow the instructions in the "Copying standard.jar" note above:

Error(1): "http://java.sun.com/jstl/core" is not a registered TLD namespace.
Error(1): Unable to load taghandler class: http://java.sun.com/jstl/core

Click Browse File System to view the directories and files linked from this page

[top]