FairCom JDBC Developer's Guide

Setting Up the JDBC Driver: Web Server

In a Web server environment, the FairCom DB SQL JDBC driver and Java applets that use it reside on a host system. No additional driver software is required on the client machine. Client applications must support a Java virtual machine compatible with the Java JDK Version 1.6 or later.

Client applications invoke a JDBC applet through a Web page on the server. The browser downloads both the applet and the JDBC Driver from the server (usually in compressed format) and runs the applet. The Java applet opens a database connection (see "Connecting to a Database") and accesses the database using the JDBC API.

A general JDBC security restriction is that applets can only open a database connection from the server from which they are downloaded. That means the host system must be running both the HTTP Web server and the FairCom DB SQL Server process.

To set up the JDBC Driver for an applet on a Web server, complete these steps:

• Copy compiled class files for the FairCom DB SQL JDBC Driver and the applet to a directory accessible to the Web page that will invoke the applet.
• Compress all the class files into a single Java Archive (JAR) file.
• Create the Web page that will invoke the applet.

The following sections describe these steps.

In This Section Copying JDBC Driver and Applet Class Files Creating a Web Page That Invokes the Applet