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 Oracle9i JDeveloper 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. This code has been developed and tested with Oracle9i JDeveloper release 9.0.3, production (build 1035).

Installing the Files

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

 [top]

Sample Data

You may install these sample database objects in an Oracle8i or Oracle9i database using one of these methods:

• Follow the instructions in the JDeveloper help system topic “Creating and Populating the Sample Schema Tables,” which is available under the Tutorials node in the Contents tab.  

OR

• Use a sample schema already installed in an Oracle9i database. The HR schema may already be installed in an available Oracle9i database to which you have access.
  
  OR

• Run selected scripts in the JDeveloper tutorial directories. The JDEV_HOME\jdev\  tutorials\ sample_schema_scripts directory contains the SQL*Plus scripts you need. Run the scripts in this order: 

  • hr8_cre.sql

  • hr8_popul.sql

  • hr8_idx.sql

  • hr8_code.sql

  • hr8_comnt.sql

OR

• Run the following script after creating the HR user and granting it CONNECT and RESOURCE privileges.

hr_install.sql

 [top]

Websites

Authors

Quovera  - Peter's company web site.

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

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

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

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]

About the Sample Files

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

• Code Snippets and other Samples - This contains small pieces of code contained in the chapter that you would otherwise have to key in. It also contains 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. 

Which Printing do You Have?

Using the Files From This Web Page

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.

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 

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):

1. Use the file with an "_start" suffix for the starting files needed for the practice. Use the file with an "_end" suffix for the completed files for the practice. Note the name of the workspace directory that will be created (in the table in the "Sample Files and Errata" section).
    
2. Copy the Zip file into the JDEV_HOME\jdev\mywork directory. 
    
3. If a workspace file of the same name is open in JDeveloper, close it. Rename the directory in the file system for that workspace.
    
4. Unzip the file. In the unzip dialog, specify that you want to extract all files into the current directory and want to "Use folder names." This will create a directory with the name shown in the table in the "Sample Files and Errata" section.
    
5. 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.
    
6. Select the workspace file inside that directory (with a .jws extension).
    
7. The workspace should open and there should be one or more project nodes under it. If files opened in the Miscellaneous Files node, close the workspace and all files in the Miscellaneous Files node and repeat steps 5 and 6.
    
8. Click each project (.jpr file) node and click the Rebuild toolbar button.
    
9. If there is a BC4J project in the workspace, select the .jpx file under that project (for example, HRBC4J.jpx). Select "Edit..." 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 your connection will be used.

[top]

1

2

p. 143, 164, Box.java
p. 145, 163, Rectangle.java
p. 147, 165, TestBox.java
p. 150, ShowQuarter.java
p. 150, ShowQuarter2.java
p. 151, TestLoops.java
p. 151, TestException.java
p. 152, TestScope.java
p. 152, ShowSalary.java
p. 153, TestShowSalary.java
p. 155, PetNames.java
p. 158, StringAppend.java
p. 158, TestCast.java

6

Ch06_end.zip
(SortWS2)

Ch06_Corrections.txt

7

Ch07_end.zip
(DeployWS2)   (Note 1)

8

Ch08_2_start.zip   (Note 5)
(LocDept2WS)

Ch08_2_end.zip
(LocDept2WS2)

9

10

11

12

Ch12_2_end.zip
(HRWS12b)

13

Ch13_2_end.zip
(HRWS13b)

Ch14_2_end.zip
(HRWS14b)

Ch17_end.zip
(LocDept3WS2)

Ch18_2_end.zip - Customize
(CustomBeansWS)

Ch19_Snippets.txt

Ch19_end.zip
(MenuToolbarWS2)

Ch20_end.zip
(LayoutWS2)

none

Ch23_end.zip  (Note 7)
(Locations2WS)

Ch24_end.zip  (Note 8)
(Locations3WS2)

none

none

App B

none

none

App C

none

none

App D

p. 876, Bold test  
    (source code)

p. 879, HTML page  
    (source code)

p. 881, JavaScript page
   (source code) 
   (javascript file)

p. 881, JavaScript in the page
   (source code)

p. 883, 885, Page using CSS
   (source code) 
   (cascading style sheet)

none