Index

A B C D E F G H I J L M N O P Q R S T U V W X

A

absolute positioning in result sets, 4.1.3.1

accessor methods, 5.1.2

ADF Data Controls, 7.2.3

Apache Tomcat, 2.1.5

application navigation, 5.6

HTML submit buttons, 5.6

jsp

forward tags, 5.6

Application Navigator, 3.2.1

using, 3.2.1

application UI, 7.4

application, creating, 7.3.1

B

bind variables, 6.1.1

IN, OUT, and IN OUTparameters, 6.1.3

OracleCallableStatement, 6.1.3

OraclePreparedStatement, 6.1.3

using, 6.1.3

C

CLASSPATH, 2.2.2

CLI, 1

closing objects

application, 8.2

closeAll method, 8.1, 8.1, 8.2

Connection, 8.1

DataHandler, 8.1

DataHandler.java, 8.2

employees.jsp, 8.2

ResultSet, 8.1

Statement, 8.1

Component Palette, 1.2.2

connecting from JDeveloper

driver, specifying, 3.1.2

host name, specifying, 3.1.2

JDBC port, specifying, 3.1.2

service name, specifying, 3.1.2

connecting to Oracle Database

DataSource object, 3.3.1

default service, 3.3.2.1

getDBConnection, 3.3.1

overview of, 3.3.1

using Java, 3.3, 3.3.1

using JDeveloper, 1.2

Connection object, 7.3.1

DataSource, 3.3.1

DriverManager, 3.3.1

CSS

list of components, 4.3.4

cursor variables

REF CURSOR, 6.3

using, 6.3

D

Database Navigator, 3.1.2

browsing data, 3.1.3

database objects, editing, 3.1.3

table data, viewing, 3.1.3

table definition, viewing, 3.1.3

database URLs, 3.3.2

database_specifier, 3.3.2

driver_type, 3.3.2

syntax, 3.3.2

thin-style service names, 3.3.2

DataHandler.java, 1.3, 4.2.1

DataSource object, 3.3.1

databaseName, 3.3.1

dataSourceName, 3.3.1

description, 3.3.1

driverType, 3.3.1

networkProtocol, 3.3.1

password, 3.3.1

portNumber, 3.3.1

properties, 3.3.1

serverName, 3.3.1

url, 3.3.1

user, 3.3.1

Datasource object

properties, 3.3.1

url property, 3.3.1

deafault service

URLs, examples, 3.3.2.1

default service

syntax, 3.3.2.1

using, 3.3.2.1

delete_action.jsp, 1.3

deleting data, 5.4

creating a method, 5.4.1

DataHandler.java, 5.4.1

delete_action.jsp, 5.4.2, 5.4.3

handling a delete action, 5.4.3

link to delete, 5.4.2

deployment descriptor file, 5.6

dynamic SQL

OracleCallableStatement, 6.1

OraclePreparedStatement, 4.1.1, 6.1

using, 6.1

E

edit.jsp, 1.3

Employees.java, 1.3

employees.jsp, 1.3, 4.3.3

Entry Level of the SQL-92, 1

environment variables

specifying, 2.2.2

environment variables, checking, 2.2.2

exception handling, 5.5

catch block, 5.5, 5.5.1

DataHandler.java, 5.5.2

deleteEmployee, 5.5.1

getAllEmployees, 5.5

handling any SQLException, 5.5.2

SQLException, 5.5

try block, 5.5, 5.5.1

execute, 4.1.2

executeBatch, 4.1.2

executeQuery, 4.1.2

executeUpdate, 4.1.2

F

filtering data, 4.5

DataHandler.java, 4.5.1

G

getAllEmployees, 4.4.2

getCursor method, 6.3.2

getDBConnection method, 4.2.1

globalization classes file, 2.2.2

H

HR account

testing, 2.1.1.1

HR user account

sample application, 2.1.1.1

unlocking, 2.1.1.1

HTML forms, 4.3.1.4

HTML tags, 4.3.1.3

I

IBM WebSphere, 2.1.5

IDE, 1.2.1, 2.1.4

Oracle JDeveloper, 2.1.4

importing packages

import dialog box, 4.4.2

IN parameters, 6.1.2

index.jsp, 1.3

index.jsp, creating, 5.6.1

insert_action.jsp, 1.3

inserting data, 5.3

employees.jsp, 5.3.4

handle an insert action, 5.3.4

insert_action.jsp, 5.3.3, 5.3.4

insert.jsp, 5.3.3

JSP, 5.3.3

link to insert page, 5.3.2

method, creating, 5.3.1

new data, entering, 5.3.3

insert.jsp, 1.3

installation

directories and files, 2.2.1

verifying on the client, 2.2

integrated development environment, 2.1.4

InternetworkPacket Exchange

Oracle JDBC OCI Driver, 1.1.2

IPX, 1.1.2

J

J2SE, 2.1.3

installing, 2.1.3

Java Runtime Environment, 2.1.3

JDBC API, 2.1.3

Java class, 3.3.3

creating, 3.3.3

DataHandler, 3.3.3

Java Database Connectivity, 1

Java libraries

adding in JDeveloper, 3.3.4

JSP runtime library, 3.3.4.2

Oracle JDBC library, 3.3.4.1

Java Persistence API, 7.2.1

Java Visual Editor, 1.2.2

JavaBean, 5.1

Create Bean dialog box, 5.1.1

creating, 5.1

creating in JDeveloper, 5.1.1

defining, 5.1.2

Employee.java, 5.1.1

Employees table, 5.1.2

properties and methods, creating, 5.1.2

sample application, 5.1

JavaClient.java, 1.3

JavaServer Faces, 7.2.2

JavaServer Pages, 2.1.5

java.sql, 1, 1.1.3

JBoss, 2.1.5

JDBC, 1, 1.1

JDBC drivers

driver version, determining, 2.2.3

JDBC escape syntax, 6.2

JDBC Thin, 1.1

JDeveloper, 1.2, 1.2

Apache Tomcat, support for, 2.1.5

API support, 3.3.4

application templates, 3.2

application, creating, 3.2.2

applications, 3.2

base installation, 2.3.1

browsing data, 3.1.3

Component Palette, 1.2.2

Create Bean dialog box, 5.1.1

creating a Java Class, 3.3.3

database, connecting, 3.1, 3.1.2

database, disconnecting, 3.1.2

database, reconnecting, 3.1.2

default layout, 1.2.1

downloading, 2.3.2

full installation, 2.3.1

IBM WebSphere, support for, 2.1.5

installation guide, 2.3

installation requirements, 2.3.2

Java Code Insight, 1.2.2

Java Source Editor, 1.2.2

Java Visual Editor, 1.2.2

JavaBean, 5.1.1

JBoss, support for, 2.1.5

JDeveloper Database Navigator, 3.1.1

look and feel, 4.3.4

navigators, 1.2.1

online documentation, 2.3

Oracle Application Server, support for, 2.1.5

Oracle Java Virtual Machine, 2.3.1

Oracle WebLogic Server, support for, 2.1.5

platform support, 2.3

project, creating, 3.2.2

projects, 3.2

Property Inspector, 1.2.2

ResultSet object, creating, 4.4.2

scriptlet representation, 4.4.2

server support, 2.1.5

starting, 2.3.3

tools, 1.2.2

user interface, 1.2.1, 1.2.1

windows, 1.2.1, 1.2.1

JDeveloper Database Navigator, 3.1.1

browsing connections, 3.1.1

viewing database objects, 3.1.1

JDK 1.4, support, 2.1.3

JSP, 2.1.5

jsp

useBean tag, 4.4.1

JSP pages

creating, 4.3, 4.3.2

custom tag libraries, 4.3

deploying, 2.1.5

elements used, 4.3.1

handling login action, 4.6.5

HTML forms, 4.3.1.4

HTML tags, 4.3, 4.3.1.3

Java-based scriptlets, 4.3

JSP tags, 4.3

presentation, 4.3.1

scriptlets, 4.3.1.2

Standard JSP tags, 4.3

static content, adding, 4.3.3

style sheet, adding, 4.3.4

updating data, 5.2.4

JSP tags, 4.3, 4.3.1.1, 4.3.1.1

JSR 127 specification, 7.2.2

L

libraries

adding, 3.3.5

Project Properties dialog box, 3.3.5

login_action.jsp, 1.3

M

master-detail application

files, 7.1

overview, 7.1

projects, 7.1

running, 7.8

model project, 7.3.2

Model-View-Controller design pattern, 7.1

MVC design pattern, 7.1

N

next method, 4.1.3

O

OCI, 1.1, 1.1.2

ODP.NET, 2.1.2

ojdbc5.jar, 2.2.2

OJVM, 2.3.1

Oracle ADF, 7, 7.2

service-oriented applications, creating, 7.2

Oracle ADF Business Components

features, 7.2.1

Oracle ADF Faces, 7.2.2

Oracle Application Developer Framework, 7

Oracle Application Development Framework, 7.2

Oracle Application Server, 2.1.5

Oracle Call Interface, 1.1

Oracle Data Provider for .NET, 2.1.2

Oracle Database

classes12*.* support, 2.1.3

client-side application development, 1.1

closing objects, 8

connecting to, 1.1

JDK 1.2 support, 2.1.3

JDK 1.3, 2.1.3

ojdbc5.jar file, using, 2.1.3

ojdbc6.jar file, using, 2.1.3

OracleConnectionCacheImpl, 2.1.3

oracle.jdbc.driver.* support, 2.1.3

unconnecting, 8

Oracle Database Client, 2.1.2, 3.3.2.1

development tools, 2.1.2

installation, 2.1.1, 2.1.2, 2.2

Oracle JDBC drivers, 2.1.2

Oracle ODBC Driver, 2.1.2

Oracle Provider for OLE DB, 2.1.2

Oracle Services for Microsoft Transaction Server, 2.1.2

verifying installation, 2.2

Oracle Database client

verifying, 2.2

Oracle Database Client installation

environment variables, 2.2.1

installed directories and files, 2.2.1

ORACLE_HOME /jlib, 2.2.1

ORACLE_HOME/jdbc, 2.2.1

platform-specific, 2.2

Oracle Database Server, 2.1.1

installation, 2.1.1

platform-specific, 2.1.1

Oracle Java Virtual Machine, 2.3.1

Oracle JDBC drivers, 2.1.2

Oracle JDBC library

oracle.jdbc, 3.3.4.1

oracle.jdbc.pool, 3.3.4.1

oracle.sql, 3.3.4.1

Oracle JDBC OCI Driver, 1.1.2

client installation, 1.1.2

Oracle JDBC Packages, 1.1.3

Oracle JDBC packages

oracle.jdbc, 1.1.3

oracle.sql, 1.1.3

Oracle JDBC support, 1.1

Oracle JDBC Thin Driver, 1.1.1

network protocols, 1.1.1

SQL*Net, 1.1.1

TCP/IP, 1.1.1

TTC protocol, 1.1.1

Type IV, 1.1.1

Oracle JDeveloper, 1.2

installing, 2.3

Oracle JDeveloper Studio Edition, 2.3

Oracle ODBC Driver, 2.1.2

Oracle Provider for OLE DB, 2.1.2

Oracle REF CURSOR Type, 6.3.1

Oracle Services for Microsoft Transaction Server, 2.1.2

Oracle WebLogic Server, 2.1.5

Oracle Weblogic Server, 3.3.4.2

ORACLE_HOME directory, 2.2.1

OracleCallableStatement, 6.1, 6.1.2

creating, 6.1.2

IN, OUT, IN OUT parameters, 6.1.2

using, 6.1.2

OracleDatabaseMetaData, 2.2.3

oracle.jdbc, 1.1, 1.1.3, 1.1.3, 3.3.4.1

java.sql, 1.1.3

Oracle JDBC library, 3.3.4.1, 3.3.4.1

oracle.jdbc.pool, 3.3.4.1

OraclePreparedStatement, 4.1.1, 6.1

bind variables, 6.1.1

creating, 6.1.1

precompiled, 6.1.1

using, 6.1.1

oracle.sql, 1.1, 1.1.3

data types, 1.1.3

Oracle JDBC library, 3.3.4.1

UCS-2 character set, 1.1.3

oracle.sql.Datum, 1.1.3

OracleTypes.CURSOR variable, 6.3.2

orai18n.jar, 2.2.2

P

positioning in result sets, 4.1.3.1

Project Properties dialog box, 3.3.5

projects, creating, 7.3.1

Property Inspector, 1.2.2

Q

querying data, 4.1, 4.1

DataHandler.java, 4.2.1

Java application, 4.2

JDBC concepts, 4.1

Log window output, 4.2.2

output, 4.2.2

query methods, 4.1.2

results, testing, 4.2.1

trace message, 4.2.2

R

REF CURSOR, 6.3, 6.3.2

accessing data, 6.3.2

CallableStatement, 6.3.2

declaring, 6.3.1

Oracle REF CURSOR Type, 6.3.1

REF CURSORs, 6.3.1

materialized as result set objects, 6.3.2

relative positioning in result sets, 4.1.3.1

result set enhancements

positioning, 4.1.3.1

scrollability, 4.1.3.1

sensitivity to database changes, 4.1.3.1

updatability, 4.1.3.1

result sets

declaring, 4.1.3.2

features, 4.1.3.1

ResultSet object, 4.1.3

closing, 8.1

getBoolean, 4.1.3

getInt, 4.1.3

getLong, 4.1.3

JDeveloper, creating in, 4.4.2

next method, 4.1.3

S

sample application

classes, 1.3

connecting, 3.3.1

DataHandler.java, 1.3

delete_action.jsp, 1.3

edit.jsp, 1.3

Employees.java, 1.3

employees.jsp, 1.3

error messages, 4.6.3

failed logins, 4.6.3

HR user account, 2.1.1.1

index.jsp, 1.3

insert_action.jsp, 1.3

insert.jsp, 1.3

JavaClient.java, 1.3

JSPs, 1.3

login_action.jsp, 1.3

overview, 1.3

security features, 4.6

testing, 1.3

update_action.jsp, 1.3

user authentication, 4.6

scriplets, 4.3.1.2

scriptlet

representation in JDeveloper, 4.4.2

scriptlets, 4.3.1.2, 4.3.1.2

scrollability in result sets, 4.1.3.1

sensitivity in result sets to database changes, 4.1.3.1

Sequenced Packet Exchange

Oracle JDBC OCI Driver, 1.1.2

SPX, 1.1.2

SQLException, 5.5

Statement object, 4.1.1

execute method, 4.1.2

executeBatch method, 4.1.2

executeQuery method, 4.1.2

executeUpdate method, 4.1.2

OraclePreparedStatement, 6.1.1

query methods, 4.1.2

stored function

calling, 6.2

stored function, creating, 6.2

stored procedures

calling, 6.2

creating, 6.2.1

Database Navigator, 6.2.1

JDeveloper, 6.2.1

OracleCallableStatement, 6.1.2

style sheets, using, 4.3.1, 4.3.4

T

testing

connection method, 4.2.2

filtered data, 4.5.2

JavaClient.java, 4.5.2

query results, 4.2.2

TNS listener, 1.1.1

Transparent Network Substrate listener, 1.1.1

TTC protocol, 1.1.1

Two-Task Common protocol, 1.1.1

U

updatability in result sets, 4.1.3.1

update_action.jsp, 1.3

updating data, 5.2.5

edit.jsp, 5.2.5

Java class, 5.2

JSP pages, 5.2.4

update action, handling, 5.2.5

update_action.jsp, 5.2.5

user authentication, 4.6.1

V

view project, 7.4

W

Web server, 2.1.5

Apache Tomcat, 2.1.5

servlet container, 2.1.5

web.xml, 5.6

X

X/Open SQL Call Level Interface, 1