August 2000
Intermediate to advanced
348 pages
8h 51m
English
Content preview from Database Programming with JDBC & Java, Second EditionBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Chapter 5. The JDBC Optional Package
Narrow souls I cannot abide;there’s almost no good or evil inside.
—Friedrich Nietzsche, The Gay Science
The JDBC API you have covered in this book is called the JDBC 2.0 Core API. The JDBC 2.0 Core API is a narrowly focused specification that supports the functionality required by applications to successfully access databases. With the JDBC 2.0 release, however, Sun added an API called the JDBC 2.0 Optional Package (formerly called the JDBC 2.0 Standard Extension) to support extended database access functionality. The JDBC 2.0 version of the Optional Package encompasses the following elements:
Data source-oriented database access via the new JNDI API
JDBC driver-based connection pooling
Rowsets
Distributed transactions
As I write this chapter, the JDBC 2.0 Optional Package has just been finalized. Very few drivers support any of this functionality. I will therefore cover as much of the JDBC 2.0 Optional Package in this chapter as possible, but I will not be able to do full justice to some topics due to the scarcity of available information at the time of writing.
Data Sources
In Chapter 3, we covered how to register a JDBC driver and make a connection using a JDBC URL. Perhaps you, like me and many others, found this to be a bit of an annoyance, especially if you are trying to write database-independent code. I am now about to tell you that all of that is completely unnecessary. You don’t have to register drivers. You don’t have to know anything ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.