Table 4.8 lists the SQL data types supported by JDBC and their equivalents in the Java programming language.
ARRAY is a sequence of values. For example, in a
Student table, you can have a
Scores column that is an
ARRAY OF INTEGER. The
getArray method returns an object of the interface type
java.sql.Array. That interface has methods to fetch the array values.
When you get a LOB or an array from a database, the actual contents are fetched from the database only when you request individual values. This is a useful performance enhancement, as the data can ...