E

EJB. See Enterprise JavaBeans (EJB)

embedded Structured Query Language (SQL), 16

embedding, application logic on database

callable statements, 353–367

client-server architecture, 15

creating, 19

creating object, 375

descriptions, 427–428

Structured Query Language (SQL) escape syntax, 120

unchained transactions, 125

employees

adding photographs to table, 218–220

retrieving photographs from table, 221–224

encapsulation, 5

Enterprise JavaBeans (EJB)

advantages, 5

business data components, 41–42

business logic components, 41

container-managed persistence, 10

entity beans, 192–200

interface, 36

RowSet properties, 525–541

session beans, 186–191

types, 185

usefulness, 40–41

enterprise platform, Java’s acceptance as, 3–6

entity beans

banking application, 41–42

bean-managed persistence, 194–199

container-managed persistence, 192–194

container-managed versus bean-managed persistence, 199–200

defined, 185

tier location, 39

errors

DataTruncation, 106–107

driver or database, 35

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

SQLException, 101–103

escape processing, 526

escape string, wildcard characters, 423

examples. See sample

exception

batch updates, 348–350

connections, 523

described, 489–491

driver or database error, 35

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

queries, 509

unsupported conversions, 89

execute() statement, 70–71

executing, prepared statements, 151–153

explorer, database explorer

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

exported keys, 398