Chapter 18. JDBC AND DATABASE CONNECTION POOLING

Topics in This Chapter

  • The seven basic steps in connecting to databases

  • Simple database retrieval example

  • Some utilities that simplify JDBC usage

  • Formatting a database result as plain text or HTML

  • An interactive graphical query viewer

  • Precompiled queries

  • A connection pool library

  • A comparison of servlet performance with and without connection pooling

  • Sharing connection pools

JDBC provides a standard library for accessing relational databases. Using the JDBC API, you can access a wide variety of different SQL databases with exactly the same Java syntax. It is important to note that although JDBC standardizes the mechanism for connecting to databases, the syntax for sending queries and committing transactions, ...

Get Core Servlets and JavaServer Pages™ 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.

Start your free trial