R

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



JDBC 3. 0. JAVA Database Connectivity
JDBC 3: Java Database Connectivity
ISBN: 0764548751
EAN: 2147483647
Year: 2002
Pages: 148

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net