Here is a Servlet for Testing Servlet-JDBC Connections & JDBC Drivers

Hi folks -

Here is my thank you for everyone's help getting PostgreSQL/mySQL and
various JDBC drivers running on Linux/ NT/ & MacOSX.
---------------------------------------------------------------------------

Servlet Container / JDBC / HTTPD Validation Application

http://www.worker-bee.com/projects/servlet_validate/index.html

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.

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/Servlet_JDBC_Validate/ (if
no HTTPD server) or http://localhost/Servlet_JDBC_Validate/ (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.

'deep

----------------------------------
Amandeep Jawa
Worker Bee Software
----------------------------------
deep(at)worker-bee(dot)com
225A Dolores St.
San Francisco, CA 94103-2202

Home: 415 255 6257 (ALL MALP)

professional: http://www.worker-bee.com
personal: http://www.deeptrouble.com
political: http://www.sflcv.org