Index

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

A

absolute positioning in result sets, 4.1.3.1

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

B

BEA WebLogic, 2.1.5

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

CLASSPATH, specifying, 2.2.2

CLI, 1

closing objects

application, 7.2

closeAll method, 7.1, 7.1, 7.2

Connection, 7.1

DataHandler, 7.1

DataHandler.java, 7.2

employees.jsp, 7.2

ResultSet, 7.1

Statement, 7.1

Component Palette, 1.2.1

concurrency types in result sets, 4.1.3.4

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 XE

DataSource object, 3.3.1

getDBConnection, 3.3.1

overview of, 3.3.1

using Java, 3.3, 3.3.1

using JDeveloper, 1.2

Connection Navigator, 3.1.2, 6.2.1

browsing data, 3.1.3

database objects, editing, 3.1.3

table data, viewing, 3.1.3

table definition, viewing, 3.1.3

Connection object

DataSource, 3.3.1

DriverManager, 3.3.1

CSS, 4.3.4

list of components, 4.3.4

cursor variables

REF CURSOR, 6.3

using, 6.3

D

database URLs, 3.3.2

database_specifier, 3.3.2

driver_type, 3.3.2

non-XE client, 3.3.2

Oracle Database XE Client, 3.3.2.1

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

DBConnection1, 3.1.2

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, 6.1

using, 6.1

E

edit_emp.jsp, 1.3

Employees.java, 1.3

employees.jsp, 1.3, 4.3.3

environment variables

Oracle JDBC OCI Driver, 2.2.2

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

forward-only result sets, 4.1.3.2

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.2, 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

Java class, 5.3, 5.4

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 Code Insight, 1.2.1

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 virtual machine, 2.2.2

Java Visual Editor, 1.2.1

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 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 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 Install, 2.3.1

BEA WebLogic, support for, 2.1.5

browsing data, 3.1.3

Component Palette, 1.2.1

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.2

downloading, 2.3.2

Full Install, 2.3.1

GUI, 1.2.2

IBM WebSphere, support for, 2.1.5

installation guide, 2.3

installation requirements, 2.3.2

Java Code Editor, 1.2.1

Java Visual Editor, 1.2.1

JavaBean, 5.1.1

JBoss, support for, 2.1.5

JDeveloper Connection Navigator, 3.1.1

look and feel, 4.3.4

navigators, 1.2.2

online documentation, 2.3

Oracle Application Server, support for, 2.1.5

Oracle Java Virtual Machine, 2.3.1

platform support, 2.3

project, creating, 3.2.2

projects, 3.2

Property Inspector, 1.2.1

ResultSet object, creating, 4.4.2

scriptlet representation, 4.4.2

server support, 2.1.5

starting, 2.3.3

tools, 1.2.1

user interface, 1.2.2

windows, 1.2.2, 1.2.2

JDeveloper Connection Navigator, 3.1.1

browsing connections, 3.1.1

viewing database objects, 3.1.1

JSP, 2.1.5

jsp

forward tag, 5.6.1

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

JVM, 2.2.2

32-bit, 2.2.2

L

LD_LIBRARY_PATH variable, specifying, 2.2.2

libocijdbc10.so, 2.2.2

libraries

adding, 3.3.5

Project Properties dialog box, 3.3.5

login_action.jsp, 1.3

N

next method, 4.1.3

O

OC4J, 3.3.4.2

OCI, 1.1, 1.1.2

driver, 2.2.2

LD_LIBRARY_PATH variable, 2.2.2

library path environment variable, 2.2.2

OCI driver

Microsoft Windows, 2.2.2

Sun Solaris, 2.2.2

ocijdbc10.dll, 2.2.2

ODP.NET, 2.1.2

ojdbc14.jar, 2.2.2

OJVM, 2.3.1

Oracle Application Server, 2.1.5

Oracle Application Server Containers for J2EE server

OC4J, 2.1.5

Oracle Call Interface, 1.1

Oracle Data Provider for .NET, 2.1.2

Oracle Database Express Edition, 1

Oracle Database XE, 1

classes12*.* support, 2.1.3

client-side application development, 1.1

closing objects, 7

connecting to, 1.1

deprecated features, 2.1.3

development home page, 1.4

discussion forum, 1.4

documentation, 1.4

installation guides, 2.1.1

JDK 1.2 support, 2.1.3

JDK 1.3, 2.1.3

ojdbc14.jar file, using, 2.1.3

OracleConnectionCacheImpl, 2.1.3

oracle.jdbc.driver.* support, 2.1.3

registration, 1.4

release notes, 2.1.1

resources, 1.4

stored procedures, 6.1.2

unconnecting, 7

Oracle Database XE Client, 2.1.2, 3.3.2.1

Database URL syntax, 3.3.2.1

default service, 3.3.2.1

development tools, 2.1.2

installation, 2.1.1, 2.1.2, 2.2

Oracle Data Provider for .NET, 2.1.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 XE client

verifying, 2.2

Oracle Database XE 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 XE 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

environment variables, 2.2.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

pure Java, 1.1.1

SQL*Net, 1.1.1

TCP/IP, 1.1.1

TTC, 1.1.1

Type IV, 1.1.1

Oracle JDeveloper, 1.2

installing, 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 Technology Network, 1.4

ORACLE_HOME directory, 2.2.1

OracleCallableStatement, 4.1.1, 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

oracle.sql.Datum, 1.1.3

OracleStatement interface

OracleCallableStatement, 4.1.1

OraclePreparedStatement, 4.1.1

OracleTypes.CURSOR variable, 6.3.2

orai18n.jar, 2.2.2

P

PATH variable, specifying, 2.2.2

positioning in result sets, 4.1.3.1

PreparedStatement, 4.1.1

Project Properties dialog box, 3.3.5

Property Inspector, 1.2.1

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

read-only result set concurrency type, 4.1.3.4

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

concurrency types, 4.1.3.4

positioning, 4.1.3.1

scrollability, 4.1.3.1

sensitivity to database changes, 4.1.3.1

updatability, 4.1.3.3

ResultSet object, 4.1.3

closing, 7.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_emp.jsp, 1.3

Employees.java, 1.3

employees.jsp, 1.3

error messages, 4.6.3

failed logins, 4.6.3

functionality, 1.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

scrollable result sets

scroll-insensitive result sets, 4.1.3.2

scroll-sensitive result sets, 4.1.3.2

sensitivity in result sets to database changes, 4.1.3.1

Sequenced Packet Exchange

Oracle JDBC OCI Driver, 1.1.2

shared object library, 2.2.2

SPX, 1.1.2

SQL92, 6.2

SQL92 Entry Level, 1

SQLException, 5.5

Statement interface, 4.1.1

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

Connection Navigator, 6.2.1

creating, 6.2.1

Java, 6.1.2, 6.2

JDeveloper, 6.2.1

OracleCallableStatement, 6.1.2

PL/SQL, 6.1.2

style sheets, using, 4.3.1, 4.3.4

T

testing

connection method, 4.2.2

filtered data, 4.5.2

HR account, 2.1.1.1

JavaClient.java, 4.5.2

query results, 4.2.2

TNS listener, 1.1.1

U

UCS2 character set

oracle.sql, 1.1.3

updatability in result sets, 4.1.3.3

updatable result set concurrency type, 4.1.3.4

update_action.jsp, 1.3

updating data, 5.2.5

edit_emp, 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

W

Web server, 2.1.5

Apache Tomcat, 2.1.5

JDeveloper OC4J server, 2.1.5

OC4J server, 2.1.5

servelet container, 2.1.5

web.xml, 5.6

X

X/Open SQL Call Level Interface, 1