JDBC-Connection with JDBC-Oracle Thin Driver 7.34

In JDK 1.0 it is not possible for applets to build up a connection to one host other than where this applet is loaded from.
In JDK 1.1 you can sign your code and give specific rights ("UniversalConnect") so that this rule can be broken. After loading the applet the user/browser could trust the signer of the applet and give him the specific right to connect to all hosts everywhere.

This applet can only be used with Netscape with JDK 1.1.

I generated a test certificate ("object signing certificate") with Signtool 1.1 and signed the Jar-library with it:

The user/browser has to load this test certificate into his Netscape browser: On success the browser shows some dialog windows for inserting the certificate. Under the "Security button" under "Signers" in Netscape you should see a new entry. Prerequesite is that the browser also has an entry in his preferences applications for cacert (normally this is already done in Netscape)

Now you can load my signed JDBC-test-applet (not so fast: 405 KB):

After you push the "Execute"-button, you will see a Netscape-Window where you will be asked for granting the "UniversalConnect". You push the "Grant"-button to trust my applet and after that you will see in the edit window (below the Execute-button) that you establish a connection to an Oracle-Server with JDBC-Oracle 7.34 Thin Driver. If this Oracle-Server is not down you will see there a table of some employers (the "scott/tiger emp" table). This consumes 5 seconds at the first time but then it is faster ...


If you want to start the applet without security checks (attention!) you can configure your Netscape to do so:

Now you can load my unsigned JDBC-test-applet:

On success you will see the same as with the signed applet ...

10. November 1999, Josef Willenborg