Chapter 8. SQL Data Access and Manipulation

In the previous chapter, we covered the essentials of JDBC programming, including connect string URL, data sources, connections, and statements. In this chapter, we’ll look at the JDBC API for accessing and manipulating SQL data, including the key metadata, the built-in SQL data types, LOBs, user-defined collections, Oracle object data types, XML type, Result Sets (scrollable, updatable), and rowsets (JdbcRowSet, CachedRowSet, WebRowSet, JoinRowSet and FilteredRowSet).

Key Metadata in JDBC

JDBC metadata is an umbrella name for a set of metadata objects that provide information about the database entities, including the database itself (DatabaseMetaData); the parameters of a PreparedStatement (ParamaterMetaData ...

Get Oracle Database Programming using Java and Web Services now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.