tables
browsing, 276–278
checking whether selectable, 389
correlation names, 422
Data Definition Language (DDL), 268–269
foreign keys, 395–396
hierarchies, 410
inserting BLOBs, 217–220
list available, 411–412
maximum columns allowed, 404
names, 549
privileges, 411
retrieving BLOBs, 220–224
rows, handling by entity beans. See entity beans
structure, 226
Structured Query Language (SQL), 17
updating, 26–27
TCP/IP. See Transmission Control Protocol/Internet Protocol (TCP/IP) port
telephone interface, 4
television, 4
text, very large. See clob or CLOB
text-based interface, retrieving results in. See Interactive SQL (ISQL)
text editor, 11
thin-client application, 50
tiers
N-tiered computing, 7–8
Open Database Connectivity (ODBC) drivers, 22
three, 143
two. See client-server architecture
time
clock, updating (TimeT.java), 267
data, mapping to Java, 113–114
functions, listing, 412
handling (Time), 512–513
parameters, setting, 538–539
Structured Query Language (SQL) escape syntax, 120
values (Timestamp), 513–515
time or TIME
callable statements, 365
column, updating, 482
prepared statements, 447–448
reading, 494
type conversions, 182
value, getting, 465–466
writing, 499
time-outs
login, 522
queries, 537
Structured Query Language (SQL) statements, setting, 73–74
timestamp or TIMESTAMP
callable statements, 366
column, updating, 482
parameters, setting, 539
prepared statements, 448
reading, 494
type conversions, 182
value, getting, 466–467
writing, 499
TINYINT, 180–181
Transact Structured Query Language (SQL), 268–269
transaction coordinator, 40
transaction management
defined, 124–125
distributed transactions, 130–131
Enterprise JavaBeans, 185
isolation levels, 125–126
managing, 126–128
modes, 125
savepoints, 129–130
transaction rollback, 253
transactions
account balance and other controls, 255–256
Account.java class, 257–262
ATM panel, 256–257
clock, updating (TimeT.java), 267
HyperText Markup Language (HTML) file, 257
interface, 35
isolation mode, 539–540
multiple, 424
NetBank.java class, 262–266
preserving ResultSets across, 133
processing monitors, 12
support, checking, 428
tables, creating (Data Definition Language (DDL)), 268–269
usefulness, 253
welcome screen, 254
transactions, distributed
advantages, 10
JDBC 3.0 Extension (J2EE) interface (XAConnection), 550
transaction management, 130–131
Transmission Control Protocol/Internet Protocol (TCP/IP) port, 57
truncation
defined, 34
indexes, 382
unexpected (DataTruncation exception), 381–382
write, 72–73
two-phase commit, 130–131
Type 1 driver, 32–33
Type 2 driver, 32–33
Type 3 driver, 30–33
Type 4 driver, 32–33
type mapping
to another database connectivity API. See Type 1 driver
ARRAY, 345–348
BIGINT, 181–182
BINARY, 182
BIT, 181
Blob or BLOB, 221
Boolean, 182
byte, 182
changing, 381
char or CHAR, 181
clob or CLOB, 179
connection, checking, 528
DATALINK, 500
date or DATE, 430
DECIMAL, 181
DISTINCT, 179
double or DOUBLE, 181
entity beans, 200
FLOAT or float, 180–181
int or INTEGER, 180–181
Java Database Connectivity (JDBC) interface (SQLData), 488–489
JAVA_OBJECT, 93
LONGVARBINARY, 182
LONGVARCHAR, 458
NUMERIC, 181
parameters, setting, 540–541
REAL, 179–181
Ref or REF, 179
short, 113
SMALLINT, 180–181
String, 182
Struct or STRUCT, 511–512
Structured Query Language (SQL) data type conversions, 449–450
tables, 115–117
time or TIME, 182
timestamp or TIMESTAMP, 182
TINYINT, 180–181
Unicode character stream, 468
VARBINARY, 182
VARCHAR, 181
Types, 515–518