Servlet Container / JDBC / HTTPD Validation Application

Version 1.0.1 • 03/05/02

This is a simple Java Servlet based Web Application I wrote to help developers confirm that their HTTPD Server / Servlet Container & JDBC compliant databases are all working properly. It is also useful for testing JDBC drivers.

It is written entirely in Java & all source code & make files are included (for MacOS X/Linux/Windows). It should run on any Java Servlet 2.0 compliant servlet container.

Click here to download the web app in WAR format.

It comes preconfigured for use with:

  • PostgreSQL
  • mySQL
  • MS SQL Server
However, adding the ability to test other databases is TRIVIAL. I preconfigured it for every major database that I had an installation of & a free driver for. If you have a free driver for another database & an installation of that database I could test against, let me know & maybe I'll have time to add it....

Installation is simple if you are familiar with the Java Servlet 2.0 specification:

  1. Download the WAR file from the link above.
  2. Copy it to your servlet container's webapps directory (i.e. $TOMCAT_HOME/webapps)
  3. Restart your servlet container.
  4. Restart your HTTPD server (if you have one)
  5. Access the web app at http://localhost:8080/ServletJDBCValidate/ (if no HTTPD server) or http://localhost/ServletJDBCValidate/ (if you are running both an HTTPD Server & a Servlet Container)

Let me know if you find this to be useful & if you need more detailed usage notes - maybe I'll write some up. Also feel free to modify & improve the source code.