Java Programming with Oracle JDBC

By: Don Bales

Write A Review

Paperback | 12 December 2001

At a Glance

Paperback
498 Pages

Dimensions(cm)
22.86 x 17.15 x 3.18

Paperback

RRP $104.50

$51.75

50%OFF

or 4 interest-free payments of $12.94 with

Ships in 15 to 25 business days

JDBC is the key Java technology for relational database access. Oracle is one of the most widely used relational database platforms. In this volume, Don Bales brings these two technologies together, and shows the reader how to leverage the full power of Oracle's implemantation of JDBC. It begins with establishing database connections. Detailed information and examples showing how to make database connections from applications, applets, servlets, and even from Java programs running within the database itself are used. Next is coverage of JDBC's relational SQL features. It shows how to issue SQL statements and get results back from the database, how to read and write data from large, streaming data types such as BLOBs, CLOBs and BFILEs and how to interface with Oracle's other built-in programming language PL/SQL. It also covers how to use JPublisher and JDBC to work seamlessly with Oracle database objects from within Java programs, and how to access nested tables and arrays using JDBC. It concludes with a discussion of transaction management, locking, concurrency, and performance topics with which every professional JDBC programmer should be familiar.

Shipping

	Standard Shipping	Express Shipping
Metro postcodes:	$9.99	$14.95
Regional postcodes:	$9.99	$14.95
Rural postcodes:	$9.99	$14.95

Orders over $79.00 qualify for free shipping.

How to return your order

At Booktopia, we offer hassle-free returns in accordance with our returns policy. If you wish to return an item, please get in touch with Booktopia Customer Care.

Additional postage charges may be applicable.

Defective items

If there is a problem with any of the items received for your order then the Booktopia Customer Care team is ready to assist you.

For more info please visit our Help Centre.

You Can Find This Book In

Non-Fiction Computing & I.T.Computer Programming & Software Development Object-Oriented Programming or OOP Databases Database Software Oracle Web Programming Booktopia Publisher Services John Wiley & Sons Publishers UK Graphical & Digital Media Applications Web Graphics & Design

Preface	p. ix
Overview
Introduction to JDBC	p. 3
The JDBC API	p. 3
Clients	p. 5
Using SQL	p. 8
Connections
Application Database Connections	p. 11
JDBC Drivers	p. 11
Installation	p. 16
Connecting to a Database	p. 19
Handling Exceptions	p. 29
Applet Database Connections	p. 34
Oracle Drivers and JDK Versions	p. 34
It's an Applet's Life	p. 35
Packaging Your Applet	p. 38
Getting Around the Sandbox	p. 44
Establishing a Connection Through a Firewall	p. 56
Guidelines for Choosing a Workaround	p. 58
Servlet Database Connections	p. 59
Oracle Driver Selection	p. 59
Servlet Connection Strategies	p. 60
Guidelines for Choosing a Connection Strategy	p. 87
Internal Database Connections	p. 88
Server-Side Driver Types	p. 88
Using the Server-Side Internal Driver	p. 89
Using the Server-Side Thin Driver	p. 95
JServer Program Support	p. 99
Oracle Advanced Security	p. 102
Authentication	p. 103
Data Encryption	p. 103
Data Integrity	p. 107
A Data Encryption and Integrity Example	p. 109
Secure Sockets Layer	p. 111
JNDI and Connection Pooling	p. 113
DataSources	p. 113
Oracle's Connection Cache	p. 121
Relational SQL
A Relational SQL Example	p. 135
Relational Database Analysis	p. 135
Refining the Analysis	p. 140
Relational Database Design	p. 142
Statements	p. 149
Creating a Statement Object	p. 149
The execute() Method	p. 150
The executeUpdate() Method	p. 155
The executeQuery() Method	p. 167
OracleStatement Implements Statement	p. 174
Result Sets	p. 176
Basic Cursor Positioning	p. 176
Data Types	p. 177
Accessor Methods	p. 181
Scrollable, Updateable Result Sets	p. 198
ResultSet Is an OracleResultSet	p. 214
Prepared Statements	p. 216
A Prepared Statement Versus a Statement	p. 216
Formulating SQL Statements	p. 217
Batching	p. 230
PreparedStatement Is an OraclePreparedStatement	p. 243
Streaming Data Types	p. 245
BLOBs	p. 246
CLOBs	p. 273
BFILEs	p. 286
LONG RAWs	p. 294
LONGs	p. 300
Callable Statements	p. 302
Understanding Stored Procedures	p. 303
Calling Stored Procedures	p. 309
CallableStatement Is an OracleCallableStatement	p. 321
Object-Relational SQL
An Object-Relational SQL Example	p. 325
From Relational Tables to Object Views	p. 325
Object Tables	p. 333
Weakly Typed Object SQL	p. 337
Accessing Objects as Relational Tables	p. 338
Structs	p. 339
Arrays	p. 345
Refs	p. 348
Calling Object Methods	p. 350
Putting It All Together	p. 352
Oracle's Implementations	p. 362
Strongly Typed Object SQL	p. 365
JPublisher	p. 366
The SQLData Interface	p. 371
Oracle's CustomDatum Interface	p. 398
Essentials
Transactions	p. 411
Manual Transactions	p. 412
Transaction Scope	p. 412
Implicit Locking and Visibility	p. 413
Isolation Levels	p. 415
Distributed Transactions	p. 415
Detection and Locking	p. 427
Oracle's Locking Mechanisms	p. 427
Detection	p. 431
Data Integrity Solutions	p. 434
Performance	p. 437
A Testing Framework	p. 438
Auto-Commit	p. 439
SQL92 Token Parsing	p. 439
Statement Versus PreparedStatement	p. 440
Batching	p. 442
Predefined SELECT Statements	p. 444
CallableStatements	p. 445
OCI Versus Thin Drivers	p. 446
Troubleshooting	p. 448
The "Gotchas"	p. 448
Unsupported Features	p. 452
Debugging	p. 454
Net8 Tracing	p. 458
Wait for the Cure	p. 461
Index	p. 465
Table of Contents provided by Syndetics. All Rights Reserved.

Java Programming with Oracle JDBC

At a Glance

Paperback

Shipping

How to return your order

Defective items

You Can Find This Book In

More in Web Graphics & Design

Web Engineering

Theory and Practice

Wordpress: The Missing Manual

The Book That Should Have Been in the Box 3rd Edition

Responsive Web Design with HTML 5 & CSS

9th edition

CHART

Designing Creative Data Visualizations from Charts to Art

Learning Web Design

A Beginner's Guide to HTML, CSS, JavaScript, and Web Graphics : 5th Edition

Escaping the Build Trap

How Effective Product Management Creates Real Value

Information Architecture

For the Web and Beyond : 4th Edition

Don't Make Me Think, Revisited

A Common Sense Approach to Web Usability

UX Strategy

How to Devise Innovative Digital Products that People Want 2nd Edition

Getting Started with 3D Printing

2nd Edition

Design and Disability

10 Tales of Accessible Design

This Is Service Design Methods

A Companion to This Is Service Design Doing

Learning React

Modern Patterns for Developing React Apps

Unleashing User Innovation

Multidisciplinary Perspectives on End-User Development and Generative AI

The Anticipatory Design Playbook

A UX Guide to Design AI-Driven Experiences

The Anticipatory Design Playbook

A UX Guide to Design AI-Driven Experiences

Ajax For Dummies

For Dummies

Confident Web Design

How to Design and Create Websites and Futureproof Your Career

Confident Coding

How to Write Code and Futureproof Your Career

Web Design with HTML, CSS, JavaScript and jQuery Set

R Graphics Cookbook

Practical Recipes for Visualizing Data

Designing Web APIs

Building APIs That Developers Love

Org Design for Design Orgs

Microinteractions

Full Color Edition

This product is categorised by