This chapter has covered a large amount of information on the use of the JDBC API within Apache Derby.
The first section of this chapter covered the basics of a JDBC application, including what imports to use, what driver is required, and how to connect to a database. Then the basic mechanics of allocating statements and executing simple DDL commands were reviewed, along with how to trap SQL errors and warnings in the application.
The second section examined the mechanics of creating, retrieving, and determining the contents of result sets. In particular, the ability to dynamically determine the data type, name, width, and other control information for columns in an answer set was explored in detail.
The third section examined prepared ...