SAG-X/Open CLI, Structured Query Language (SQL), 19–20
sample
database transactions, 253–269
interactive Structured Query Language (SQL) client application, 203–217
Java database explorer. See Java database explorer
multimedia content, handling, 217–224
multitier applications, remote method invocation and Java Database Connectivity (JDBC), 323–341
phonebook service example, 186–189
shopping cart example, 189–191
sample airline 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
sample database explorer application
catalogs, browsing, 275–278
database engine specifications and limitations, 275
described, 271–272
interactive Structured Query Language (SQL) tool, 278–280
logging in, 272–274
navigation graphical control, 274
source code, 280–323
sample multitier application
client class (CarSales.java), 334–340
client programs, 326–327
data structure, 324–325
described, 323–324
implementation, 328–334
interfaces, 330–331
remote method invocation (RMI) server, 340–341
sample remote access application
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
savepoint
deleting, 378
setting, 380
supported, 426
transaction management, 129–130
scalar functions
date and time, 122–123
numeric, 121–122
string, 122
Structured Query Language (SQL) escape syntax, 121–123
system, 121
scanning query results
creating cursors, 98
ResultSets, 77–78
schema, 548
scrolling, rows, 451
searchability
setting, 548–549
verifying, 487
security, drivers, choosing, 31
SELECT queries, 135
sending
BLOBs, 217–220
prepared statements, 154–155
Structured Query Language (SQL) statements, 68–71
serial communications, 4
server, remote method invocation (RMI)
defined, 5
HTTP tunneling, 50
multitier applications, 340–341
servers
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
servers, application
components, distributed. See EJB)
connection pool, maintaining, 10
database-mapping code for entity beans, 192
servlets, 50
session beans
banking application, 41
defined, 185
stateful, 189–191
stateless, 186–189
tier location, 39
setXXX() methods, 146–148
shopping cart example, 189–191
short
callable statements, 365
column, updating, 481
column value, getting, 464–465
mapping, 113
prepared statements, 447
reading, 494
writing, 499
Simple Network Management Protocol (SNMP), 4
simultaneous connections, checking for maximum, 166–167
single-tier drivers, 22
size, row maximum, 166–167
SMALLINT, 180–181
smartcards, 6
SNMP. See Simple Network Management Protocol (SNMP)
software partitioning, defined, 323
software reuse, 5
software tier, 15
sound files. See Blob or BLOB
source code
Account.java banking application, 257–262
airline example, 227–252
BLOBs, 221–224
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
help box for Java database explorer, 302–304
implementation for car factory example, 328–330
interfaces for car factory example, 330–331
login for Java database explorer, 305–306
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
Structured Query Language (SQL) commands for Java database explorer, 320–323
TimeT.java banking application, 267
space padding, 113
special characters
availability, checking, 400
Structured Query Language (SQL) escape syntax, 123
speech synthesis and recognition, 4
SQL-92, 16
SQLData, 488–489
SQLException
connections, 520–523
described, 489–491
interactive SQL tool, 278–280
queries, 509
SQLInput, 491–495
SQLOutput, 495–500
SQLPermission, 500
SQLWarning
clearing, 371
connection, checking, 374
constructors, 501–502
during query or update, 103–106
value, getting, 509
stateful session beans, 189–191
stateless session beans, 186–189
Statement
batch updates, 139–141
database and driver resources, creating, 502–511
delayed execution. See time-outs
getting, 465
length, maximum, 405
sending, 46
stored procedures
callable statements, 353–367
client-server architecture, 15
creating, 375
descriptions, 427–428
Structured Query Language (SQL) escape syntax, 120
unchained transactions, 125
streams, retrieving, 94–95
String
auto-generated keys, 158–159
callable statement, 365
CLOB pointer, 369–370
DATE, converting from, 89
date, converting to, 430
getting, 465
mapping, 182
parameters, accessing, 180
prepared statements, 447
reading, 494
Structured Query Language (SQL) escape syntax, 122
supported, 410
updating, 481
writing, 499
Structured Query Language (SQL)
constants and values, defined (Types), Java Database Connectivity (JDBC), 515–518
cursors, creating, 98
defined, 14
dynamic, creating. See Prepared Statements
grammar support, checking, 419–420
impedance mismatch with object-oriented programming language, 23
inheritance, 119
keywords, information, getting, 163–165
mapping. See type mapping
relational databases, 16–20
SAG-X/Open CLI, 19–20
syntax, 17–19
uses, 16–17
Structured Query Language (SQL) data type conversions
accessing data using type map, 119
defining, 117–119
mapping data types to Java, 112–115
object-orientation and, 6
SQL inheritance, 119
type mapping tables, 115–117
Structured Query Language (SQL) escape syntax
callable statements, 353
outer joins, 124
scalar functions, 121–123
special characters, 123
stored procedures, 120
time and date, 120
Structured Query Language (SQL) statements
BLOBs and CLOBs, storing, 71–72
building, 67–68
closing, 71
creating database and driver resources (Statement), 502–511
defined, 66
grouping to treat as whole. See transaction management
precompiling (PreparedStatement), 440–449
properties, adjusting, 72–73
sending, 68–71
sending to specific data source. See driver
time-outs, setting, 73–74
structured types (Struct or STRUCT)
data type conversion, 511–512
Structured Query Language (SQL) name, getting, 449
writing, 499
Sun Microsystems, Inc., 3
suppliers, database
drivers, 31–33
Java adoption, 9
stored procedures, 15
SWING, 274
Sybase
catalog information, 170–172
employees with messages, listing, 124
keywords, getting, 164–165
sample drivers, 226
sample URL, 58
stored procedures, 150
Sybase Jaguar, 185
synchronizing
client-server networks, 14–15
entity bean with data in database table. See persistence