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

Python All-in-One For Dummies

3rd Edition

Layered Design for Ruby on Rails Applications - Second Edition

Discover practical design patterns and modern abstractions for maintainable Rails applications

Web Engineering

Theory and Practice

The Pragmatic Programmer 2nd edition

your journey to mastery, 20th Anniversary Edition

Beginner's Step-by-Step Coding Course

Learn Computer Programming the Easy Way

Head First Design Patterns

Building Extensible and Maintainable Object-Oriented Software 2nd Edition

Coding For Dummies, All New Edition

For Dummies (Computer/Tech)

Learning Go

An Idiomatic Approach to Real-World Go Programming

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

For Dummies

Introduction to Machine Learning with Python

A Guide for Data Scientists

Fluent Python

Clear, Concise, and Effective Programming 2nd Edition

The Art of SEO

Mastering Search Engine Optimization

Apache Iceberg: The Definitive Guide

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

Laravel: Up & Running

3rd Edition - A Framework for Building Modern PHP Apps

Python Cookbook

Recipes for Mastering Python : 3rd Edition

Architecture Patterns with Python

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

Cloud Computing

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

Java

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

Developing Graphics Frameworks with Java and OpenGL

Data Management at Scale

Modern Data Architecture with Data Mesh and Data Fabric

Mastering Shiny

Build Interactive Apps, Reports, and Dashboards Powered by R

Flask Web Development, 2nd Edition

Developing Web Applications with Python

Python for Finance 2e

Mastering Data-Driven Finance

Learning Spark

Lightning-Fast Data Analytics

This product is categorised by