Java Programming with Oracle JDBC Oracle and Java Programming

Name: Java Programming with Oracle JDBC Oracle and Java Programming
Price: 6.44 USD
Availability: InStock
ISBN: 9780596000882

ISBN-10: 059600088X

ISBN-13: 9780596000882

Edition: 2002

Authors: Donald Bales

List price: $54.99

This item qualifies for FREE shipping.

30 day, 100% satisfaction guarantee!

Buy new: $37.66

Marketplace

2 new & used from $6.44

what's this?

Rush Rewards U
Members Receive:

You have reached 400 XP and carrot coins. That is the daily max!

JDBC is the key Java technology for relational database access. Oracle is arguably the most widely used relational database platform in the world. In this book, Donald Bales brings these two technologies together, and shows you how to leverage the full power of Oracle's implementation of JDBC. You begin by learning the all-important mysteries of establishing database connections. This can be one of the most frustrating areas for programmers new to JDBC, and Donald covers it well with detailed information and examples showing how to make database connections from applications, applets, Servlets, and even from Java programs running within the database itself. Next comes thorough coverage…

Book details

List price: $54.99
Copyright year: 2002
Publisher: O'Reilly Media, Incorporated
Publication date: 12/18/2001
Binding: Paperback
Pages: 496
Size: 7.01" wide x 9.21" long x 1.22" tall
Weight: 1.870
Language: English

Donald Bales is a Computer Applications Consultant specializing in the analysis, design, and programming of distributed systems; systems integration; and data warehousing. Don has over sixteen years experience with Oracle as both a developer and a database administrator, and six years experiance with Java. He is currently working on the migration of medical and industrial hygiene systems to a web environment for a major Oil company. When he is not developing applications, Donald can often be found working with horses, playing the piano, or playing the bagpipes. Donald has had several careers, and has at various times been a mechanic, a general contractor, Mr. Mom, a developer, and currently…



Preface



Overview



Introduction to JDBC


The JDBC API


Clients


Using SQL



Connections



Application Database Connections


JDBC Drivers


Installation


Connecting to a Database


Handling Exceptions



Applet Database Connections


Oracle Drivers and JDK Versions


It's an Applet's Life


Packaging Your Applet


Getting Around the Sandbox


Establishing a Connection Through a Firewall


Guidelines for Choosing a Workaround



Servlet Database Connections


Oracle Driver Selection


Servlet Connection Strategies


Guidelines for Choosing a Connection Strategy



Internal Database Connections


Server-Side Driver Types


Using the Server-Side Internal Driver


Using the Server-Side Thin Driver


JServer Program Support



Oracle Advanced Security


Authentication


Data Encryption


Data Integrity


A Data Encryption and Integrity Example


Secure Sockets Layer



JNDI and Connection Pooling


DataSources


Oracle's Connection Cache



Relational SQL



A Relational SQL Example


Relational Database Analysis


Refining the Analysis


Relational Database Design



Statements


Creating a Statement Object


The execute() Method


The executeUpdate() Method


The executeQuery() Method


OracleStatement Implements Statement



Result Sets


Basic Cursor Positioning


Data Types


Accessor Methods


Scrollable, Updateable Result Sets


ResultSet Is an OracleResultSet



Prepared Statements


A Prepared Statement Versus a Statement


Formulating SQL Statements


Batching


PreparedStatement Is an OraclePreparedStatement



Streaming Data Types


BLOBs


CLOBs


BFILEs


LONG RAWs


LONGs



Callable Statements


Understanding Stored Procedures


Calling Stored Procedures


CallableStatement Is an OracleCallableStatement



Object-Relational SQL



An Object-Relational SQL Example


From Relational Tables to Object Views


Object Tables



Weakly Typed Object SQL


Accessing Objects as Relational Tables


Structs


Arrays


Refs


Calling Object Methods


Putting It All Together


Oracle's Implementations



Strongly Typed Object SQL


JPublisher


The SQLData Interface


Oracle's CustomDatum Interface



Essentials



Transactions


Manual Transactions


Transaction Scope


Implicit Locking and Visibility


Isolation Levels


Distributed Transactions



Detection and Locking


Oracle's Locking Mechanisms


Detection


Data Integrity Solutions



Performance


A Testing Framework


Auto-Commit


SQL92 Token Parsing


Statement Versus PreparedStatement


Batching


Predefined SELECT Statements


CallableStatements


OCI Versus Thin Drivers



Troubleshooting


The "Gotchas"


Unsupported Features


Debugging


Net8 Tracing


Wait for the Cure


Index