Resolution:
Following are a couple of possible reasons why it may not be working:

1. If the applet is trying to connect to Oracle via ODBC, it won't work. Applets don't have permission to access ODBC.

2. If the applet is using JDBC, you will need to include classes12.zip as one of the "jar" files referenced in the html page (like gmsjrtview.jar, etc). You would also need to include the gmsjsqlds.jar.

3. If (2) still doesn't work, can you send us your applet html page and the RTView version so that we can review it.

Even if you get the applet to connect directly to the database, you may still encounter problems, especially if other clients are expected to invoke the applet on their machines. They'll get socketPermission errors because the applet is not allowed to access a remote database.

This is why we recommend using the Data Server to act as the proxy between the database and applet.

The applet makes the requests to the Data Server for all the sql data. The Data Server makes the sql call, and returns the data to the applet via socket as XML stream.  There won't be any socket permission errors and the applet won't need the classes12.zip or gmsjsqlds.jar.

Data Server set up is well documented in our standard documentation.