Setting Up the JDBC Driver: Web Server

In a Web server environment, the c-treeACE 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 JavaSoft’s JDK Version 1.4 or later. (Internet browsers such as Netscape or Internet Explorer meet this requirement.)

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 c-treeACE 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 c-treeACE 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.