Adding JDBC Drivers

Before you can use the Database object you need to install a JDBC Driver and tell Active Web about the driver. The drivers are available from the database suppliers and consist of a set of Java Classes or a Java Archive (JAR) file.

For Active Web you should add the JDBC driver to either the lib directory of your web application in the case of a JDBC driver being distributed as a JAR file; or the classes directory in the case of a class hierarchy. These directories can be found directly under the WEB-INF directory.

Configuration of the driver into Active Web is made by amending the jdbc_drivers parameter of the Active Web servlet (see General Configuration).

<init-param>
<param-name>jdbc_drivers</param-name>
<param-value>sun.jdbc.odbc.JdbcOdbcDriver,com.northgateis.reality.realsql.RealSQLDriver</param-value>
</init-param>

By default Active Web is configured with two JDBC drivers, one for the Sun JDBC / ODBC bridge and the other for Reality at Northgate Information Solutions MultiValue Database.

Once you have added your new JDBC driver to your Web Application the simply append your driver class (refer to the driver documentation for its name) to the list of drivers separating it from the previous one with a single comma.

Comment on this topic

Topic ID: 150031