Assuming that you have already been working
through this tutorial, you will already be set to run a JDBC
application. However, before we get into the nitty gritty,
let's do a recap.
Installing a Database
The first thing you will need, of course
is an actual running database with a table that you can
query and modify. In the SQL and CGI sections, we explained how
to setup an MSAccess database
and create a test table. We will continue to use that table and
database here. In particular, we will use the CUSTOMERS table
from the Test_db.mdb database that we gave a datasource name
of "Access" in our 32-bit ODBC control panel.
Installing the JDK
You will also need to install the JDK.
I recommend installing JDK 1.17,
but that you code your application to the JDK 1.02 standard.
That way your application will be accessible to a wider
audience of web browsers, many of who may not have
browsers that support JDK 1.1 APIs.
As we said before, most of the JDBC
drivers you will need are installed by default so you
already have them when you install the JDK. Drivers that
are not installed by default can be downloaded by going to
You will install them in the "lib" directory in the Java files
tree. I put mine in "c:\java\sun\jdk1.1.7\lib\sun\jdbc\".
Installing a Local Web Server
Finally, you will need a web server to serve your
Java application. In the CGI section, we discussed how you could
setup the Sambar Web Server on
your local workstation. Using a local web server means that you can do
all your development and testing locally and then transfer the final
application to the web server on the internet. This section
assumes you have already installed Sambar and the rest.
Table of Contents