T

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



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