In the previous chapter, we covered the essential features of JDBC, most of which were introduced in the JDBC 1.0 specification, the version of JDBC included in JDK 1.1. In this chapter, we will learn additional JDBC 1.0 options, but we will also cover new features introduced in JDBC 2.0 and 3.0.
First, we will consider the different ways we can connect to a database. We will cover:
Different types of JDBC drivers
Different ways of supplying the connection information, such as the database URL, username, and password
The DataSource class, new in JDBC 3.0, that Sun recommends we use
Next, we will consider some additional ResultSet options that were introduced in JDBC 2.0:
Scrollability— the ability to navigate ...