RDBMS. See relational databases
read-only mode, connections
checking, 374
detecting, 415–416
isolation mode, 528
parameters, setting, 549–550
setting, 63
verifying, 451
reads
columns, 79–80
data isolation levels, 125–126
data management, 370–371
data truncation on, 382
REAL, 179–181
receiving, BLOBs, 94–95
Ref or REF
callable statements, 364
column, updating, 480–481
column value, getting, 464
data type conversions, 93
Java Database Connectivity (JDBC) interface, 449–450
parameters, setting, 538
prepared statements, 447
reading, 494
writing, 498
registration
drivers, 435
OUT parameters, 358–359
rowset listener, 528
XAConnection, 550
Registry, 325–326
relational databases
client/server architecture, 14–15
defined, 13–14
mapping to Java classes, 25
object-orientation and, 6
Open Database Connectivity (ODBC) standard, 20–22
Structured Query Language (SQL) standard, 16–20
remote database access
airport codes (AirportChoice.java), 235–236
airport information (Airport.java), 231–235
airport map with routes (FlightsPanel.java), 240–243
client-server architecture, 14–15
columns, arranging in single (ColumnLayout.java), 237–239
connection, establishing (Airplet.java), 226–231
described, 225
flight information (Flight.java), 239–240
flight string x-y coordinates (MapInfo.java), 249–250
flights between airports (FlightsVector.java), 243–244
HyperText Markup Language (HTML) file, 226
images (ImageCanvas.java), 244–246
label (MultilineLabel.java), 250–252
map, displaying appropriate (MapCanvas.java), 246–249
remote method invocation (RMI)
car factory implementation (CarFactoryImpl.java), 331–334
car factory interface (CarFactory.java), 330–331
car implementation (CarImpl.java), 328–330
car interface (Car.java), 327–328
client class (CarSales.java), 334–340
client programs, 326–327
data structure, 324–325
described, 323–324
remote method invocation (RMI) server
defined, 5
HTTP tunneling, 50
multitier applications, 340–341
Remote Procedure Calls (RPCs)
callable statements, 353–367
client-server architecture, 15
creating, 19
creating object, 375
descriptions, 427–428
Structured Query Language (SQL) escape syntax, 120
unchained transactions, 125
reservations database
airport codes (AirportChoice.java), 235–236
airport information (Airport.java), 231–235
airport map with routes (FlightsPanel.java), 240–243
columns, arranging in single (ColumnLayout.java), 237–239
connection, establishing (Airplet.java), 226–231
flight information (Flight.java), 239–240
flight string x-y coordinates (MapInfo.java), 249–250
flights between airports (FlightsVector.java), 243–244
HyperText Markup Language (HTML) file, 226
images (ImageCanvas.java), 244–246
label (MultilineLabel.java), 250–252
map, displaying appropriate (MapCanvas.java), 246–249
resource tier
defined, 8
JDBC 3.0 Extension (J2EE), 40
results
BLOBs, receiving, 94–95
columns, 78–83
fetchable types, 75–76
multiple types, managing, 83–87
prepared statements, retrieving, 154
properties, adjusting, 95–98
result set, closing, 88
returning. See driver
rows, retrieving, 76–78
set, getting, 76
Structured Query Language (SQL) cursors, creating, 98
types, converting, 89–94
unwanted, canceling, 87–88
ResultSet
characteristics, 483–487
closing, 88
column values, accessing as objects, 179–180
cursors, creating, 98
defined, 131
executing, 505
holdability, 507
interface, 35
method for examining results, 97–98
multiple, 424
navigating, 132–134
objects, 450–482
rows, retrieving, 76–78
scanning, 470–471
Structured Query Language (SQL) ARRAY, returning results, 347
updating with cursors, 135–139
updating without cursors, 134–135
ResultSetMetaData
additional initialization parameters (RowSetMetaData), 544–549
column properties, 174–177
columns, 174
retrieving
BLOBs, 220–224
BLOBs from table, 220–224
data, 18
dynamically typed data, 178–180
reviewing query results
creating cursors, 98
ResultSets, 77–78
rich-client applications, Java Database Connectivity (JDBC), 50
RMI. See remote method invocation (RMI)
rollbacks
complete, 126
cursors, holding open, 425
defined, 125
intermediate savepoints, 379
routes, airport map, 240–243
rows
BLOBs, inserting, 217
checking for maximum size, 527
deleting, 18
dirty reads, 127–128
entity beans. See entity beans
identifying, 464
inserting, 471
interface, 35
loading (RowSetReader), 549–550
maximum number, 534
navigating, 132–134
property information, 175
results, retrieving, 76–78
retrieving, 76–78
saving (RowSetWriter), 550
updating, 508
RowSet
defined, 155
designing and using, 157
interface, 36
JavaBeans properties, 550
methods, 156
RowSet state
notifying of changes (RowSetListener), 543
obtaining (RowSetInternal), 542–543
significant changes in (RowSetEvent), 541
RPCs. See Remote Procedure Calls (RPCs)
runtime
discovering database objects, 168–174
Structured Query Language (SQL) queries, building, 174