O

Object Database Management Group (ODMG), 11

Object Query Language (OQL), 11

objects. See also entity beans

bridges, 11

callable statements, 363–364

column, updating, 479–480

connection. See Connection

data, representing, 185

default mapping from Structured Query Language (SQL), 178–179

impedance mismatch with Structured Query Language (SQL), 23

information, getting, 462–464

Java orientation, 5–6

parameters, setting, 535–537

persistence, 10

prepared statements, 446–447

reading, 493–494

reference types, handling. See Ref or REF

registered to receive events from pooled connections, 36

schema, 169

sharing, 4

storing in database, 148

writing, 498

ODBC. See Open Database Connectivity (ODBC)

ODMG. See Object Database Management Group (ODMG)

Online Transaction Processing (OLTP), 12

open call-level interface (CLI), Structured Query Language (SQL), 19–20

Open Database Connectivity (ODBC)

application component, 20–21

bridge driver, 29–30

Core Structured Query Language (SQL) grammar support, checking, 423

data source, 22

driver, 21–22

driver manager, 21

interface, 20

Java Database Connectivity (JDBC) versus, 22

versus specific drivers as a subprotocol, 51

standard, 20–22

Open Database Connectivity (ODBC) bridge

sample driver, 59

sample URL, 58

operating systems. See portability

Oracle

sample driver, 60

sample URL, 58

stored procedures, 150

Oracle Application Server, 185

Oracle Lite

sample driver, 60

sample URL, 58

OUT parameters

callable statements, 358

registering, 148–149

retrieving dynamically typed data, 178–180

outer joins

Structured Query Language (SQL) escape syntax, 124

support, checking, 425

output, Structured Query Language (SQL) stream (SQLOutput), Java Database Connectivity (JDBC) interface, 495–500