SAS Safety Scalable Performance Data Server 4.5 Manual Do Utilizador

3. JDBC handles the request, formats the information, and returns the result to the Web

page.

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>

•

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.

•

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.

•

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.

•

spdsuser value=user ID is the user ID that queries the SPD Server table.

•

sharePassword value=the password is the password of the user ID that will make the
query.

•

shareRelease value=V9 is the version of the driver you are using. This must not be
altered.

•

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.