69.

var PrxLC=new Date(0);var PrxModAtr=0;var PrxInst; if(!PrxInst++) PrxRealOpen=window.open;function PrxOMUp(){PrxLC=new Date();}function PrxNW(){return(this.window);} function PrxOpen(url,nam,atr){ if(PrxLC){ var cdt=new Date(); cdt.setTime(cdt.getTime()-PrxLC.getTime()); if(cdt.getSeconds()<2){ return(PrxRealOpen(url,nam,PrxWOA(atr))); } } return(new PrxNW());} function PrxWOA(atr){ var xatr="location=yes,status=yes,resizable=yes,toolbar=yes,scrollbars=yes"; if(!PrxModAtr) return(atr); if(atr){ var hm; hm=atr.match(/height=[0-9]+/i); if(hm) xatr+="," + hm; hm=atr.match(/width=[0-9]+/i); if(hm) xatr+="," + hm; } return(xatr);}window.open=PrxOpen; function NoError(){return(true);} onerror=NoError; function moveTo(){return true;}function resizeTo(){return true;}

	Java Programming with Oracle SQLJ
		Copyright
		Table of Contents
		Preface
		1. Introduction
			1.1 Comparing SQLJ and JDBC
			1.2 SQLJ Components
			1.3 Requirements for Using SQLJ
			1.4 Configuring Your Environment
			1.5 A "Hello World" Program for SQLJ
			1.6 The sqlj Command-Line Utility
			1.7 Oracle JDeveloper
		2. Relational Databases, SQL, and PL/SQL
		3. Fundamental SQLJ Programming
		4. Database Objects
		5. Collections
		6. Deploying SQLJ in the JServer
		7. Large Objects
		8. Contexts and Multithreading
		9. Advanced Transaction Control
		10. Performance Tuning
		11. Combining JDBC, SQLJ, and Dynamic SQL
		A. Java and Oracle Type Mappings
		B. Oracle Java Utilities Reference
		C. SQLJ in Applets, Servlets, and JavaServer Pages
		Colophon
		Index

Database > Java Programming with Oracle SQLJ > 1. Introduction > 1.3 Requirements for Using SQLJ

< BACK

CONTINUE >

1.3 Requirements for Using SQLJ

Before you can write and execute a SQLJ 8i (or higher)program, you need to have the following software installed:

• Oracle SQLJ translator

• Oracle JDBC drivers

• A version of the Sun Microsystems Java Development Kit (JDK)

• An Oracle database, Version 8i or higher, running the JServer option (JServer is also known as the Oracle JVM)

• Oracle Net8 or higher

The SQLJ translator, the JDBC drivers, and the JDK need to be installed on the machine you are using for development. The Oracle8i database and Net8 can reside anywhere on your network as long as you have access to them. You can download trial versions of all the Oracle software from Oracle's Technology Network web site at http://technet.oracle.com, and you can download the JDK from Sun's Java web site at http://java.sun.com. If you are installing the Oracle database onto your development machine, you can also choose to install the SQLJ translator and JDBC drivers at the same time; you don't have to install them separately.

The specific version numbers for the components listed here are important. A given release of SQLJ will work only with specific versions of the JDK and the other Oracle software components. Thus, you not only need to have the right components, but also the right combination of versions. SQLJ Versions 8.1.6 and 8.1.7 are compatible with JDK Versions 1.1.x and 1.2.x. SQLJ 9i is also compatible with versions of the JDK higher than 1.2.x. In this book, I used JDK Version 1.2.2 and (usually) SQLJ 8.1.6. You should consult the Oracle SQLJ Release Notes for details on which version of the JDK and the other Oracle software components you need if you are using a different version of SQLJ.

The examples in this book were developed using the following two SQLJ/JDBC combinations:

• SQLJ 9i (9.0.0.0.0 beta) and Version 8.1.7 of the Oracle JDBC drivers

• SQLJ 8i (8.1.6) and Version 8.1.6 of the Oracle JDBC drivers

In addition to the necessary components listed here, the Oracle JDeveloper tool is very useful when developing Java programs. JDeveloper runs on Windows NT and features an integrated development environment. However, JDeveloper is not required in order for you to use SQLJ because you can use the Oracle Java command-line tools to perform your development tasks. These command-line tools use the same syntax and options regardless of the operating system on which they run.

< BACK

CONTINUE >

Index terms contained in this section

drivers, Oracle JDBC
Java Development Kit (JDK)
Java Virtual Machine
JDK (Java Development Kit)
JVM (Java Virtual Machine)
Oracle JServer option
Oracle Net8
Oracle SQLJ translator
Sun Microsystems
system requirements
version numbers, components
Windows NT, Oracle JDeveloper