3.
JDBC handles the request, formats the information, and returns the result to the Web
page.
JDBC Code Examples and Tips
The following lines must be a part of the HTML file for JDBC:
<applet code="CLASSPATH.*.class codebase="../ width=600 height=425>
<param name=url value="jdbc:sharenet://spdssnet_node:PORT">
<param name="dbms_options" value=DBQ='libname' HOST='host_node' SERV='NNNN'>
<param name="spdsuser" value="userid">
<param name="sharePassword" value="thepassword">
<param name="shareRelease" value="V9">
<param name="dbms" value="spds">
</applet>
Line 1:
• CLASSPATH points to the class path set up where the JDBC driver is installed.
•
*.class is the name of the Java class that consumes all of the <PARAM name=...> lines.
Line 2:
• spdssnet_node is the node name of the machine on which the SPD SNET server is
running.
• PORT=port number of the machine on which the SPD SNET server is running.
Line 3:
• value=DBQ='libname' is the LIBNAME domain of the SPD Server.
• HOST='host_node' is the location of the SPD SNET server.
• SERV='NNNN' is the port number of the name server.
Line 4:
• spdsuser value=user ID is the user ID that queries the SPD Server table.
Line 5:
• sharePassword value=the password is the password of the user ID that will make the
query.
Line 6:
• shareRelease value=V9 is the version of the driver you are using. This must not be
altered.
Line 7:
• Sets the foreign database property on the JDBC driver. This means that the server is
not SAS and JDBC should not create a DataBaseMetaData object. See the examples
below for how to get around this.
JDBC Code Examples and Tips 101
