November 2001
Intermediate to advanced
496 pages
13h 51m
English
Content preview from Java Programming with Oracle JDBCBecome 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 16. Strongly Typed Object SQL
Strongly typed
object SQL refers to the use of client-side
custom Java classes to manipulate database-side SQL objects. The
classes themselves are referred to as
custom
because a Java class is created to
mirror its database counterpart. To mirror database objects you can
use one of two approaches: the JDBC API’s standard
SQLData interface or Oracle’s
CustomDatum interface. With the
SQLData interface, a database object is
represented as a custom Java class that implements the
SQLData interface; however, a collection is still
represented by an Array object, and a reference is
still represented by a Ref object. With the Oracle
CustomDatum interface, a database object is
represented as an Oracle custom class file that implements the
CustomDatum and
CustomDatumFactory interfaces. Unlike the
SQLData interface, The
CustomDatum interface supports all database object
types, including references and collections.
For example, in Chapter 15 we used a
Struct object to manipulate a database object, an
Array object for collections, and a
Ref object to hold a database reference. With
strongly typed object SQL, you’ll use a custom Java class to
manipulate a database object, an Array object or
another custom Java class for a collection, and a
Ref object or yet another custom Java class to
hold a database reference.
If you’re concerned with portability, then you should use the
SQLData interface. Otherwise, since the
SQLData interface currently doesn’t provide ...
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.