Oracle JDeveloper 3 Handbook

by Dr. Paul Dorsey & Peter Koletzke

Sample Files and Errata

Disclaimer

Installation

Sample Data

Web Sites

Sample Files and Errata

Disclaimer

The files in this set have no warranty of usefulness or accuracy. They have been tested to the best of the authors' abilities but are intended to merely to supplement the hands-on practices in the Oracle JDeveloper 3 Handbook. The authors and any other entities that make these files available are not responsible for any effects that may result from the use of these files. The files below are offered as freeware in the public domain. There is no technical support available from the authors or the publisher for users of these files.

 

Installation

 

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

 

 [top]

Sample Data

 

The practices in this book use database objects owned by a sample user, Scott, in the Oracle database. The demo tables are installed into the Scott user when the Oracle database is created. A DBA may have created the Scott schema after installation by running SCOTT.SQL in the ORACLE_HOME\RDBMS\Admin directory of the machine where the database is installed. There is also a file called DEMOBLD.SQL in ORACLE_HOME\sqlplus\demo directory that creates the database objects (not the schema). You may already have these tables in some format. However, some versions of the Scott schema contain different tables and some do not create the primary and foreign key constraints.

Therefore, to ensure compatibility with the examples in the book, use the following script to create the database objects (after the Scott user has been created). If you need to refresh the tables at any point, rerun this script.

deptemp.sql

 

 [top]

Web Sites

 

Author

Quovera (formerly Millennia Vision) - Peter's company web site.

Peter's Home Page - Sample Oracle development files.

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

Other

International Oracle Users Group - Americas

Oracle Development Tools User Group

Oracle Technology Network

Netscape - Developer - JavaScript

Sun - Javasoft - Reference for all Java technology also here

Go!Zilla; GetRight - Download managers

Three D Graphics - Graphics components included in JDeveloper

Tucows - Software downloads

Unicode - Standards

WWW Consortium - HTML, XML

 

[top]

Sample Files and Errata

 

This section contains links to all files available in this set. The files are divided into the following categories:

  • Code Snippets - small pieces of code that you would otherwise have to key in
  • 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, Notes, and Other Samples - last minute corrections and clarifications that are not in the book. Read these before attempting the hands-on practices. There are several files that demonstrate techniques not explained in the practices.

Which printing do you have? The errata are different for the first and second printing. You can tell which printing you have by looking on the copyright/credits page (on the back of the second title page). It has the copyright line on it. Under the Oracle trademark paragraph is a series of numbers. If that line starts with "1234567890," you have a first printing. If it starts with "234567890," you have a second printing, etc. The errata files note which printing has the problem by indicating the printing number in parentheses, for example "(1 pr)" for first printing.

 

If the file link causes the file to be displayed when you do not want it to be displayed, right click the link, select Save Link As (in Netscape) or Save Target As (in Internet Explorer), and supply the directory and file name.

 

Practice Files Installation

 

 

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

 

 

The practices require a connection called "ScottConnection." Instructions for creating that connection may be found in Phase II of the Chapter 2 practice (pp.64-65). Once you have set up the connection, use the following steps to install the practice file.

  1. Copy the Zip file into the JDEV_HOME directory and unzip it from there. The file will create (or overwrite) the "myprojects" and/or the "myhtml" directories and files within those directories that are needed for the practice. Most files are the files that result from completing the practice. If there are application files required for a practice, they are contained in a file with a "start" suffix.
  2. Open the workspace file noted in parentheses (all are unzipped within the JDEV_HOME\myprojects directory).
  3. Click each project node and click the Rebuild toolbar button.

 

 

What to do if You Have Problems

There are several troubleshooting techniques mentioned in the introduction of the book.

 

[top]

Chapter

Code Snippets

Hands-On Practice Files (workspace file)

Errata, Notes, and Other Samples

1

none

Ch01_Practice.zip

(myempapp\EmployeeWS.jws)

none

2

Ch02_Snippets.txt

Ch02_Practice.zip

(deptideapp\DeptIdeWS.jws)

none

6

Ch06_Snippets.txt

Ch06_Practice.zip

(buscomppkg\BusCompWS.jws

Ch06_Corrections.txt

7

Ch07_Snippets.txt

Ch07_Practice.zip (Note 2)

(deploypractice\DeployWS.jws)

none

8

Ch08_Snippets.txt

Ch08_Practice.zip (Note 4)

(empappjsp\EmpJSPWS.jws)

Ch08_Corrections.txt

Sample HTML

Sample JavaScript   (source code)

Sample Using a Cascading Style Sheet   (source code)

Mandatory Column Highlighting

9

Ch09_Snippets.txt

Ch09_Practice.zip (Note 1)

(empapp\EmpAppWS.jws)

Ch09_Corrections.txt

Ch09 Samples.zip (Note5)

Customized Grid Control

10

Ch10_Snippets.txt

Ch10_Practice_start.zip

Ch10_Practice_end.zip

(menutoolbar\MenuToolWS.jws)

Ch10_Corrections.txt

11

Ch11_Snippets.txt

Ch11_Practice_start.zip

Ch11_Practice_end.zip

(layoutapp\LayoutAppWS.jws)

Ch11_Corrections.txt

Ch11 Samples.zip (Note6)

12

Ch12_Snippets.txt

Ch12_Practice.zip (Note 3)

(myfileout\MyFileOutWS.jws)

Ch12_Corrections.txt

13

Ch13_Snippets.txt

Ch13_Practice_start.zip

(sortapp\SortAppWS.jws)

 None

App B

AppB_Snippets.txt

none

None

[top]

Notes

  1. You may receive an Oracle error in the LOV lookup field demonstration. A workaround is included in the corrections file for Chapter 9.

  2. The files in this set are starting files. No ending files are supplied because this is just a deployment profile practice where you use files that have already been created. The JSP application has been greatly simplified for the purposes of demonstrating the deployment profile. It uses a simple DataPage Wizard file that shows all department records.

  3. This file contains the starting file created in Phases I and II of the first practice. The remainder of the steps in this and the following practice are completed outside of JDeveloper so no additional sample files are supplied here. See the Chapter 12 Code Snippets file for the scripts used in these practices

  4. Be sure that the webapp directory in the JDEV_HOME\myhtml directory is available. Also, if you want to call the web beans in this file, you may have to register the beans using the Web Object Manager (demonstrated on p.298 "Use the Web Object Manager").

  5. This Zip file contains applications that demonstrate selected Swing and AWT components. Use the same instructions as you would for installing the practice Zip files. The workspace file is components\ComponentDemoWS.jws under JDEV_HOME. Click the project file and click Rebuild.

    There are demonstrations of ComboBox, List, ProgressBar, ProgressMonitor, Scroll Pane, SimpleTable, SplitPane, TabbedPane, Text components, and ToggleButton. The files that are named with a Demo prefix are executable applications. They call other support files in this project that are not executable. The DemoSampleComponents application just shows non-workiing versions of many of the components. Other demos contain some functionality. Many of the applications are adapted from the Java Tutorial that is available at the Sun Java site.

  6. This Zip file contains applications that demonstrate layout managers other than those used in the practices: BoxLayout2, CardLayout, GridLayout. OverlayLayout2, PaneLayout, VerticalFlowLayout, and XYLayout. Use the same instructions as you would for installing the practice Zip files. The workspace file is layoutsLayoutWS.jws under JDEV_HOME. Click the project file and click Rebuild.

Last Updated 12-May-2001