Chapter 18: JDBC and Database Connection Pooling

Source Code in This Chapter

Note: right-click or shift-click on the links to download the associated file. All code is freely available for unrestricted use.

Order now

• FruitTest.java A simple JDBC example that connects to either an Oracle or a Sybase database and prints out the values of predetermined columns in the fruits table.
• DriverUtilities.java Some simple utilities for loading drivers and opening connections.
• FruitCreation.java Creates a table named fruits in either an Oracle or a Sybase database.
• DatabaseUtilities.java Some utilities that simplify retrieving results for some of the most common types of JDBC queries.
• DBResults.java Class to store completed results of a JDBC Query. Differs from a ResultSet in several ways:
  • ResultSet doesn’t necessarily have all the data; reconnection to database occurs as you ask for later rows.
  • This class stores results as strings, in arrays.
  • This class includes DatabaseMetaData (database product name and version) and ResultSetMetaData (the column names).
  • This class has a toHTMLTable method that turns the results into a long string corresponding to an HTML table.
• EmployeeTest.java Class that uses DatabaseUtilities to connect to Oracle or Sybase and print employees table as plain text.
• EmployeeTest2.java Class that uses DatabaseUtilities to connect to Oracle or Sybase and print employees table as an HTML table.
• EmployeeCreation.java Class that creates the sample employees table.
• QueryViewer.java An interactive database query viewer. Connects to the specified Oracle or Sybase database, executes a query, and presents the results in a JTable. Uses the following helper classes:
  • DatabaseUtilities.java, DBResults.java, and DriverUtilities.java. JDBC utilities discussed above.
  • DBResultsTableModel.java Class that tells a JTable how to extract relevant data from a DBResults object (which is used to store the results from a database query).
  • WindowUtilities.java A few utilities that simplify using windows in Swing.
  • ExitListener.java A listener that you attach to the top-level Frame or JFrame of your application, so quitting the frame exits the application.
• PreparedStatements.java An example to test the timing differences resulting from repeated raw queries vs. repeated calls to prepared statements. These results may vary dramatically among database servers and drivers.
• ConnectionPool.java A class for preallocating, recycling, and managing JDBC connections.
• ConnectionPoolServlet.java A servlet that reads information from a database and presents it in an HTML table. It uses connection pooling to optimize the database retrieval. A good timing test case is ConnectionPool.html, which loads many copies of this servlet into different frame cells.
• ConnectionPoolServlet2.java A variation of ConnectionPoolServlet that uses only a single connection, queueing up all requests to it. Used to compare timing results. A good timing test case is ConnectionPool2.html, which loads many copies of this servlet into different frame cells.
• ConnectionPoolServlet3.java A variation of ConnectionPoolServlet that does not use connection pooling. Used to compare timing benefits of connection pooling. A good timing test case is ConnectionPool3.html, which loads many copies of this servlet into different frame cells.

URLs in This Chapter

• JDBC home page
• On-line API for java.sql
• On-line JDBC tutorial
• MySQL home page
• Available JDBC drivers

General

On-site servlet and JSP short courses. Taught at your location. Public (open enrollment) servlet and JSP short courses. For those without enough people to justify an on-site course. Order from amazon.com. Free examination copies for instructors. For courses that are considering the use of the book. Course materials License materials for use in your own courses.

Reader reviews. Table of contents. Also available in PDF. Index. Adobe acrobat (PDF) format. API for all code. Javadoc format.