Skip Headers
Oracle® Database 2 Day + Java Developer's Guide
11g Release 1

B28765-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
PDF · Mobi · ePub

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, 7.5.4
ADF Faces
PanelPage component, 7.5.3
PanelPage with text, 7.5.3
ADF Faces Core, 7.7.1
ADF Faces Core Component Palette, 7.5.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.5.1, 7.5.1
application, creating, 7.3

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
business components, creating, 7.4

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

Data Control Palette, 7.5.4
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
DBConnection1, 3.1.2
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
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
footer facet, 7.8, 7.8

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 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 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
BEA WebLogic, support for, 2.1.5
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 Connection 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
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 Connection Navigator, 3.1.1
browsing connections, 3.1.1
viewing database objects, 3.1.1
JDK 1.4, support, 2.1.3
JSF JSP libraries, 7.5.2
JSF navigation diagrams, 7.6, 7.6.2
creating a page from, 7.6.1
navigation cases, 7.6.2
navigation rules, 7.6.2
navigation, defining, 7.6.3
JSP, 2.1.5
jsp
useBean tag, 4.4.1
JSP page layout, 7.5.3
JSP Pages
form fields, 7.5.4
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
login.jsp, 1.3

M

master-detail application
business components, creating, 7.4
COMMIT functionality, 7.8
detail data, displaying, 7.5.5
displaying data, 7.5
edit form, creating, 7.7.1
editing data, 7.7
edit.jsp page, creating, 7.7.1
employees.jsp page, creating, 7.5.2
files, 7.1
JSP page, 7.5.5
JSP page for detail data, creating, 7.5.2
JSP page for master data, creating, 7.5.4
master data, displaying, 7.5.4
navigating to the edit page, 7.7.2
navigation, 7.6
navigation between pages, defining, 7.6.1
navigation diagrams, 7.6
navigation rules, 7.6.2
overview, 7.1
projects, 7.1
ROLLBACK functionality, 7.8
running, 7.9
testing, 7.5.6
viewing data in a browser, 7.5.6
model project, 7.4
Model-View-Controller design pattern, 7.1
MVC design pattern, 7.1

N

next method, 4.1.3

O

OC4J, 3.3.4.2
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, 7.2.1
features, 7.2.1
Oracle ADF Faces, 7.2.2
facets, 7.2.2.1
Oracle Application Developer Framework, 7
Oracle Application Development Framework, 7.2
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
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_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

PanelPage component, 7.7.1
positioning in result sets, 4.1.3.1
Project Properties dialog box, 3.3.5
projects, creating, 7.3
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 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
selecting schema objects, 7.4
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
SQL92, 6.2
SQL92 Entry Level, 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
Connection Navigator, 6.2.1
creating, 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
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.5.1, 7.5.1

W

Web server, 2.1.5
Apache Tomcat, 2.1.5
JDeveloper OC4J server, 2.1.5
OC4J server, 2.1.5
servlet container, 2.1.5
web.xml, 5.6

X

X/Open SQL Call Level Interface, 1