Appendix

Installing the Drivers

Following is generic information on the driver set-up. One should consult the driver manual or accompanying documentation for specific instructions related to OS or other components.

1. Sun JDBC ODBC Bridge:

As we discussed, if you have already installed the latest JDK version from SUN , you probably have the JDBC - ODBC bridge related classes. All you need now is:

• Set your CLASSPATH to point to the required classes.
• Install an ODBC driver.

Check out this FAQ if you are not sure about CLASSPATH.

To install ODBC driver on Windows:

1. Double click "ODBC data source" in control panel
2. Click Tab : System DSN
3. Click Add , and choose an appropriate driver (such as "Microsoft ODBC for ORACLE" or " SQL Server")
4. Fill up the required fields according to your system set up.
5. Name the driver as "myDriver"

2. Oracle JDBC driver

If you have (or downloaded) oracle JDBC driver for your version of Oracle RDBMS:

• The required class file (such as clasess11.jar depending on your driver version) should be in your CLASSPATH
• In your code to load driver, instead of:

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());

• Similarly, to make a connection use the following code:

DriverManager.getConnection ("jdbc:oracle:thin:dbUser/dbPassword@hostName:1521:ORCL");

1. String dbUser contains the Oracle user id.
2. String dbPassword contains the Oracle password.
3. String hostName contains the host name or IP address of the m/c running Oracle.
4. ORCL is the oracle SID.

Some versions of drivers may need the following type of call to getConnection:

Connection conn = DriverManager.getConnection ("jdbc:oracle:thin:@" + tnsName,dbUser,dbPassword);

Connection Pooling and Introduction to Application Servers
Building Web Applications Using Servlets and JSP Part II