C | JDBC 3: Java Database Connectivity

C++, 6

call-level interface (CLI), 131

callable statements

accessing parameters, 180

batch updates, 139–141

creating, 375–376

example, 149–150

information about, 437–440

Java Database Connectivity (JDBC) interface, 353–367

setting parameters, 183

stored procedures, handling, 145–150

canceling

transactions, 253

unwanted results (cancel() method), 87–88

car factories application

client class (CarSales.java), 334–340

client programs, 326–327

data structure, 324–325

described, 323–324

implementation, 328–334

interface (CarFactory.java), 330–331

interface (Car.java), 327–328

remote method invocation (RMI) server, 340–341

catalogs

browsing with Java database explorer, 275–278

defined, 63

differences among databases, 169

identifiers, checking, 403

methods supported, checking, 420

name, 544–545

tables available, 411–412

chained transaction mode, 125

changes. See also batch updates

auto-increments, 544

canceling, 452

car factory example, 214

clock (TimeT.java), 267

columns, 472–482

columns, automatic, 414–415

concurrency levels, setting, 451

with cursors, 138–139

detecting, 543

dirty reads, 125

dynamically typed data, 180–183

interactive Structured Query Language (SQL) tool in Web browser, 278–280

noncritical events during (SQLWarning), 103–106

performing, 70–71

ResultSets with cursors, 135–139

ResultSets without cursors, 134–135

tables, 26–27

char or CHAR, 181

character large objects. See clob or CLOB

character stream

callable statements, 366

CLOB pointer, 367

converting, 468

parameter, setting, 531

prepared statements, 448–449

character strings, mapping, 112–113

CLI. See call-level interface (CLI)

client/server architecture

car factory example, illustrated, 324

embedded Structured Query Language (SQL), limitations of, 16

interactive Structured Query Language (SQL), 203–217

JDBC 3.0 Extension (J2EE) client tier, 38

relational databases, 14–15

remote method invocation, 334–340

clob or CLOB

callable statements, 361

column, updating, 476–477

data type conversion, 179

Java Database Connectivity (JDBC) interface, 367–370

parameter, setting, 531

prepared statements, 444

reading, 492–493

Structured Query Language (SQL) statements, 71–72

values, getting, 458

writing, 497

clock, updating (TimeT.java), banking application, 267

close() method, 371

closing

connection, checking, 374

database connections, 524

memory, 62

result set, 88

rows, 452–453

Structured Query Language (SQL) statements, 71

Cloudscape

sample driver, 59

sample URL, 58

Codd, E.F., 13

code

Account.java banking application, 257–262

airline example, 227–252

compiling, 55

connection for Java database explorer, 280–299

database connectivity for car factory example, 331–334

error box for Java database explorer, 299–301

generated by entity bean container, 199–200

generated by programmer, 194–200

help box for Java database explorer, 302–304

implementation for car factory example, 328–330

interfaces for car factory example, 330–331

main frame for Java database explorer, 306–312

navigator for Java database explorer, 313–320

NetBank.java banking application, 262–266

reference look-up for car factory example, 334–340

registry binding for car factory example, 340–341

retrieving BLOBs, 221–224

sending BLOBs, 218–220

Structured Query Language (SQL) commands for Java database explorer, 320–323

TimeT.java banking application, 267

codes, airport, 235–236

collaboration, 4

ColumnLayout.java, 237–239

columns

adding to tables, 419

aliasing, 421

arranging in single, 237–239

attributes, relationship to (deployment descriptors), 192

browsing, 277–278

counting, 545

field size, maximum, 534

finding, 453

foreign keys, 395–396

name, 545

number and label, getting, 78–79

properties, 483–484

ResultSetMetaData interface, 174

rows, identifying, 391–392

updates, 472–482

columns, accessing

by column indexes, 80–82

by name, 82–83

as objects, 179–180

reading, 79–80

commands, batch

retrieving, 221

sending, 217–220

commands, general behavior of, 63–64

committing transactions

autocommit mode, 126

checking database requirements, 371–373

closing after, 133

defined, 125

intermediate, allowing, 35

Common Object Request Broker Architecture (CORBA) Internet Inter-Orb Protocol (IIOP), 4

communication protocol, 29–30

completing transactions, 125

computers, distributing Java objects across

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

concurrency levels

availability, checking, 459

levels, checking, 509

setting, 531–532

updates, 133

Connect Software, Inc., 225

Connect SW

sample driver, 59

sample URL, 58

Connection

defined, 46

driver, finding, 433–434

establishing (Airplet.java), remote database access through browser, 226–231

events notification, 520–521

factory, 36

Java Database Connectivity (JDBC) interface, 370–381

maximum allowable, 404

needs, 8

objects, 522–524

statements, 506–507

connection pool

advantages, 9–10

described, 524–525

Enterprise JavaBeans, 185

managing (ConnectionPoolDataSource), 521–522

tier location, 40

ConnectionEvent, 519–520

ConnectionEventListener, 520–521

ConnectionPoolDataSource, 521–522

consistency, data, 124–125

constants, Structured Query Language (SQL) types, 515–518

constructors

BatchUpdateException class, 349–350

ConnectionEvent class, 519–520

DataTruncation, 381

Date, 430

DriverPropertyInfo, 437

RowSetEvent, 541

SQLException, 489–490

SQLPermission, 500

SQLWarning, 501–502

Time, 512–513

Timestamp, 513–514

container-managed persistence

bean-managed persistence versus, 199–200

defined, 10

entity beans, 192–194

converting

availability, checking, 421

changing, 381

connection, checking, 528

data, implicit, 103

Java Database Connectivity (JDBC) interface (SQLData), 488–489

parameters, setting, 540–541

result types, 89–94

Structured Query Language (SQL) data type conversions, 449–450

tables, 115–117

CORBA. See Common Object Request Broker Architecture (CORBA) Internet Inter-Orb Protocol (IIOP)

counters, automatic. See auto-generated keys

currency, 547

cursors

checking, 469–470

closing at commit, 451–452

creating, 98

database, 15

monitoring, 543

moving, 542

name, 510

scanning ResultSets, 132–134

Structured Query Language (SQL), creating, 98

updating ResultSets, 135–139