Chapter 9. Database Connectivity

Topics in this Chapter:

  • Relational vs. Object-Oriented Databases

  • Structured Query Language

  • Optimizing JDBC Database Connections

  • Connection Pooling

One of the most powerful features of JSP pages, as well as a great advantage over other scripting languages, is its ability to utilize the full Java API. Specifically, the Java 2 Enterprise Edition (J2EE) comes with many supporting APIs that allow access to external data sources. One example of this was seen in Chapter 8; the JNDI API allows access to external directory services such as Lightweight Directory Access Protocol (LDAP) and Novell Directory Services (NDS). This chapter will focus on one specific API from the J2EE called Java DataBase Connectivity (JDBC).

What ...

Get Core JSP 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.