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
accessor methods, 5.1.2
Apache Tomcat, 2.1.4
application navigation, 5.6
HTML submit buttons, 5.6
jsp
forward tags, 5.6
Application Navigator, 3.2.1
using, 3.2.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, 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.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 12c Release 1
DataSource object, 3.3.1
default service, 3.3.2.1
getDBConnection, 3.3.1
using Java, 3.3, 3.3.1
using JDeveloper, 1.2
connecting to Oracle Database12c Release 1
overview of, 3.3.1
Connection object
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
properties, 3.3.1
url property, 3.3.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
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.4
IDE, 1.2.1, 2.1.3
Oracle JDeveloper, 2.1.3
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 database, 2.2
integrated development environment, 2.1.3

J

J2SE, 2.1.2
installing, 2.1.2
Java Runtime Environment, 2.1.2
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 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 Pages, 2.1.4
java.sql, 1.1.2
JBoss, 2.1.4
JDBC, 1, 1.1
JDBC drivers
driver version, determining, 2.2.3
JDBC escape syntax, 6.2
JDeveloper, 1.2, 1.2
Apache Tomcat, support for, 2.1.4
API support, 3.3.4
application templates, 3.2
application, creating, 3.2.2
applications, 3.2
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
IBM WebSphere, support for, 2.1.4
installation guide, 2.3
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.4
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.4
Oracle WebLogic Server, support for, 2.1.4
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.4
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
jsp
useBean tag, 4.4.1
JSP, 2.1.4
JSP pages
creating, 4.3, 4.3.2
custom tag libraries, 4.3
deploying, 2.1.4
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

L

libraries
adding, 3.3.5
Project Properties dialog box, 3.3.5
login_action.jsp, 1.3
login.jsp, 1.3

N

next method, 4.1.3

O

ojdbc5.jar, 2.2.2, 2.2.2
Oracle Application Server, 2.1.4
Oracle Database 12c Release 1, 2.1.1, 3.3.2.1
closing objects, 7
connecting to, 1.1
installation, 2.2
installation guides, 2.1.1
release notes, 2.1.1
unconnecting, 7
verifying, 2.2
verifying installation, 2.2
Oracle Database 12c Release 1 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 JDBC library
oracle.jdbc, 3.3.4.1
oracle.jdbc.pool, 3.3.4.1
oracle.sql, 3.3.4.1
Oracle JDBC packages
oracle.jdbc, 1.1.2
oracle.sql, 1.1.2
Oracle JDBC Packages, 1.1.2
Oracle JDBC support, 1.1
Oracle JDBC Thin Driver, 1.1.1
Type IV, 1.1.1
Oracle JDeveloper, 1.2
installing, 2.3
Oracle JDeveloper Studio Edition, 2.3
Oracle REF CURSOR Type, 6.3.1
Oracle Weblogic Server, 3.3.4.2
Oracle WebLogic Server, 2.1.4
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.2, 1.1.2, 3.3.4.1
java.sql, 1.1.2
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.2
data types, 1.1.2
Oracle JDBC library, 3.3.4.1
UCS-2 character set, 1.1.2
oracle.sql.Datum, 1.1.2
OracleTypes.CURSOR variable, 6.3.2
orai18n.jar, 2.2.2, 2.2.2

P

positioning in result sets, 4.1.3.1
Project Properties dialog box, 3.3.5
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, 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.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 functionality, 4.6
login interface, 4.6.4
login page, 4.6.2
login_action.jsp, 1.3
login.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
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
login feature, 4.7
query results, 4.2.2

U

UCP, 8
ucp.jar, 8.1
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

W

Web server, 2.1.4
Apache Tomcat, 2.1.4
servlet container, 2.1.4
web.xml, 5.6

X

X/Open SQL Call Level Interface, 1