Oracle8i SQLJ Developer's Guide and Reference Release 2 (8.1.6) A81360-01 |
|
This preface introduces you to the Oracle8i SQLJ Developer's Guide and Reference, discussing the intended audience, structure, and conventions of this document. A list of related Oracle documents is also provided.
This manual is intended for anyone with an interest in SQLJ programming but assumes at least some prior knowledge of the following:
Although general knowledge of SQL and JDBC is sufficient, any knowledge of Oracle-specific SQL and JDBC features would be helpful as well.
See "Related Documents" below for the names of Oracle documents that discuss SQL and JDBC.
The two major aspects of using SQLJ are:
Chapters 3 through 7 provide information about programming features, with chapters 3 and 4 covering the most important aspects.
Chapter 8 provides information about translator options and features.
In all, this document consists of twelve chapters and two appendixes, as follows:
This document uses UNIX syntax for file paths (for example: /myroot/myfile.html
). If you are using some other kind of operating system, then substitute the appropriate syntax.
This document uses [Oracle Home]
to indicate your Oracle home directory.
In addition, this document uses the following conventions:
In this document, it was not feasible to use more standard conventions, such as square brackets [] to enclose optional items to be provided, because of the particulars of SQLJ coding syntax.
For example, in the following statement the square brackets and curly brackets are part of SQLJ coding syntax, but the angle brackets indicate that connctxt_exp
, execctxt_exp
, and results_exp
are optional entries. You must provide a SQL operation, however.
#sql <[<connctxt_exp><,><execctxt_exp>]> <results_exp> = { SQL operation };
And in the following SQLJ command line option (-user
), the angle brackets indicate that conn_context_class
and the password (with preceding slash) are optional entries. You must provide a username, however.
-user<@conn_context_class>=username</password>
This section lists other documentation of interest.
See the following additional documents available from the Oracle Java Platform group:
This book introduces the basic concepts of Java in Oracle8i and provides general information about server-side configuration and functionality. Information that pertains to the Oracle Java platform as a whole, rather than to a particular product (such as JDBC, SQLJ, or EJBs) is in this book.
This book describes how to use the JPublisher utility to translate object types and other user-defined types to Java classes. If you are developing SQLJ or JDBC applications that use object types, VARRAY types, nested table types, or object reference types, then JPublisher can generate custom Java classes to map to them.
This book covers programming syntax and features of Oracle's implementation of the JDBC standard (for Java Database Connectivity). This includes an overview of the Oracle JDBC drivers, details of Oracle's implementation of JDBC 1.22 and 2.0 features, and discussion of Oracle JDBC type extensions and performance extensions.
This book discusses Java stored procedures--programs that run directly in the Oracle8i server. With stored procedures (functions, procedures, database triggers, and SQL methods), Java developers can implement business logic at the server level, thereby improving application performance, scalability, and security.
This book describes the Oracle extensions to the Enterprise JavaBeans and CORBA specifications.
You can also refer to the following documents from the Oracle Server Technologies group.
This book contains information about the Oracle8 Connection Manager and Net8 network administration in general.
This book contains information about NLS environment variables, character sets, and territory and locale settings. In addition, it contains an overview of common NLS issues, typical scenarios, and NLS considerations for OCI and SQL programmers.
This book describes features of the Oracle Advanced Security Option (formerly known as ANO or ASO).
This book introduces basic design concepts and programming features in using an Oracle8i database and creating database access applications.
This book describes general functionality and features of database large objects (LOBs) in Oracle8i.
This book contains general information about structured objects and other object-relational database features in Oracle8i.
This book documents PL/SQL packages available as part of the Oracle8i server, some of which may be useful to call from JDBC applications.
PL/This book explains the concepts and features of PL/SQL, Oracle's procedural language extension to SQL.
This book contains a complete description of the content and syntax of the SQL commands and features used to manage information in an Oracle database.
This book contains general reference information about the Oracle8i server.
This book contains information about error messages that can be passed by the Oracle8i server.
Documentation from the following Oracle groups may also be of interest.
This documentation contains information about how the Oracle8i Application Server supports JDBC.
This documentation contains information about how the Oracle8i JDeveloper Suite supports JDBC.
For documentation of SQLJ standard features and syntax, refer to ANSI specification X3.135.10-1998:
You can obtain this from ANSI at the following Web site:
http://www.ansi.org/