Java Programming with Oracle JDBC

By: Don Bales

Write A Review

Paperback | 12 December 2001

At a Glance

Paperback
498 Pages

Dimensions(cm)
29.0 x 179.0 x 234.0

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 Programming

Beginner's Step-by-Step Coding Course

Learn Computer Programming the Easy Way

Python Workout, Second Edition

200 ten-minute exercises

The Pragmatic Programmer 2nd edition

your journey to mastery, 20th Anniversary Edition

Python All-in-One For Dummies

3rd Edition

Web Engineering

Theory and Practice

Head First Design Patterns

Building Extensible and Maintainable Object-Oriented Software 2nd Edition

Python for Excel

A Modern Environment for Automation and Data Analysis

Coding For Dummies, All New Edition

For Dummies (Computer/Tech)

Building Microservices

Designing Fine-Grained Systems 2nd Edition

Starting Out with Python

5th Global Edition

The Art of SEO

Mastering Search Engine Optimization

Apache Iceberg: The Definitive Guide

Data Lakehouse Functionality, Performance, and Scalability on the Data Lake

Developing Graphics Frameworks with Java and OpenGL

Java

An Introduction to Problem Solving and Programming, 8th Global Edition

Python Cookbook

Recipes for Mastering Python : 3rd Edition

JavaScript - The Definitive Guide

Architecture Patterns with Python

Enabling Test-Driven Development, Domain-Driven Design, and Event-Driven Microservices

Cloud Computing

2nd Edition - Concepts, Technology, Security, and Architecture

PHP, MySQL, & JavaScript All-In-One For Dummies

For Dummies

Learning Go

An Idiomatic Approach to Real-World Go Programming

Web Scraping with Python

3rd Edition - Data Extraction from the Modern Web

Spring Boot: Up and Running

Building Cloud Native Java and Kotlin Applications

Beginner's Step-by-Step Coding Course

Learn Computer Programming the Easy Way

Vibe Coding with Cursor, Windsurf, and Lovable

Build Apps Fast with AI-Assisted Software Development and Testing

This product is categorised by