I

IBM San Jose Research Lab, 13–14

IBM WebSphere, 185

IDE. See Integrated Development Environment (IDE)

ImageCanvas.java, 244–246

impedance mismatch, 23

IN parameters

callable statements, 353

dynamically typed data, 180–183

setting, 146–148

subqueries, 428

indexes

catalogs, checking use, 420

columns, accessing by, 453

creating, 18–19

data truncation, 382

length, maximum, 405

ResultSet, 347

table, describing, 402–403

information, holding from session to session, 189–191

Informix

sample driver, 59

sample URL, 58

inheritance, support, 5

input, SQL stream (SQLInput), Java Database Connectivity (JDBC) interface, 491–495

INSERT, money transfers, 253

inserting

auto-generated keys, 158–159

BLOBs into table, 217–220

detecting, 543

dynamically typed data, 180–183

rows, 471

int or INTEGER

callable statements, 362–363

column value, getting, 478

parameters, setting, 533

prepared statements, 445

reading, 493

type conversions, 180–181

writing, 498

Integrated Development Environment (IDE), 11

integration tier, JDBC 3.0 Extension (J2EE), 40

Interactive SQL client, Web browser, 209–217

Interactive Structured Query Language (ISQL)

client application, 203–217

Java database explorer, 278–280

interface

application, multitier, 330–331

Array or ARRAY, 345–348

binary large object, 350–353

call-level (CLI), 131

callable statements, 353–367

car factories application, 330–331

columns, 174

Connection, 370–381

database management system (DBMS), 53–55

distributed transactions, 550

driver, 431–432

Enterprise JavaBeans (EJB), 36

graphical user, 111

Java Database Connectivity (JDBC), 46–47

Java Naming and Directory Interface (JNDI), 551

Java Native Interface (JNI), 5

multitier application example, 330–331

Open Database Connectivity (ODBC), 20

output, Structured Query Language (SQL) stream (SQLOutput), Java Database Connectivity (JDBC) interface, 495–500

prepared statements, 34

ResultSet, 35

RowSet, 36

interface, application programming (API)

availability, 54–55

Java Database Connectivity (JDBC), 45

listed, 4–5

usefulness, 3

interface, Java Database Connectivity (JDBC)

Array, 345–348

Blob, 350–353

callable statements, 353–367

Clob, 367–370

Connection, 370–381

database information, returning. See DatabaseMetaData

driver, 431–432

input, Structured Query Language (SQL) stream (SQLInput), 491–495

intermediate points in transactions, marking (Savepoint), 488

map Structured Query Language (SQL) structured types (Struct), 511–512

output, Structured Query Language (SQL) stream (SQLOutput), 495–500

PreparedStatement and CallableStatement objects, information about (ParameterMetaData), 437–440

ResultSet objects, 483–487

Structured Query Language (SQL) REF value (Ref), 449–450

Structured Query Language (SQL) statements, 502–511

type mapping (SQLData), 488–489

interface, JDBC 3.0 Extension (J2EE)

connection events, notifications (ConnectionEventListener), 520–521

Connection objects, creating (DataSource objects), 522–524

connection pool, managing (ConnectionPoolDataSource), 521–522

connection pool (PooledConnection), 524–525

distributed transactions (XAConnection), 550

naming service (XADataSource), 551–552

ResultSetMetaData, additional initialization parameters (RowSetMetaData), 544–549

rows, 549–550

RowSet JavaBeans properties, 525–541

rowset state and parameters, obtaining information (RowSetInternal), 542–543

interface, metadata

connection, getting, 462

DatabaseMetaData, 278

dynamic data access, 178–183

Java database explorer example, 275

ParameterMetaData, 177–178

ResultSetMetaData, 174–177

usefulness, 161–162

intermediate steps, marking

deleting, 378

setting, 380

supported, 426

transaction management, 129–130

Internet

e-commerce, shopping cart example, 189–191

Java, suitability for, 3

rich-client applications, 50

Internet Web browser

BLOB data type, specifying, 221

flight string x-y coordinates (MapInfo.java), 249–250

flights between airports (FlightsVector.java), 243–244

history, 9

images (ImageCanvas.java), 244–246

label (MultilineLabel.java), 250–252

map, displaying appropriate (MapCanvas.java), 246–249

proxies, 31

Structured Query Language (SQL) client using, 209–217

Internet Web browser, remote access example

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

described, 225

flight information (Flight.java), 239–240

HyperText Markup Language (HTML) file, 226

intranets, 50

iPlanet Application Server, 192

isolation levels, transaction management, 125–126