Connecting to a database
Before a query can be executed, the JdbcSource applet must connect to an external database. To do this, the following information must be supplied: All of this information can be relayed via the applet PARAM tags. The following sample HTML code shows the PARAM tags needed to connect automatically to a database that requires a user ID and a password. In this case, the JDBC driver is also automatically loaded.



<APPLET NAME="dataBase1" CODEBASE="..\..\.." CODE="lotus.jdbc.JdbcSource" WIDTH=1 HEIGHT=1>
  <PARAM NAME="driver" VALUE="JDBC driver  classname">
  <PARAM NAME="autoload" VALUE="true">	
  <PARAM NAME="database" VALUE="databaseURL">	
  <PARAM NAME="user" VALUE="databaseID">
  <PARAM NAME="password" VALUE="databasePassword">
  <PARAM NAME="autoconnect" VALUE="true">	
</APPLET>



The following JdbcSource PARAM tags specify the options for connecting to the database:

The tag option is specified by the NAME attribute and the option value is specified by the VALUE attribute of the tag.

Within the APPLET tag, the various attributes do the following: