Appendix
June 12, 2000
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:
- Double click "ODBC data source" in control panel
- Click Tab : System DSN
- Click Add , and choose an appropriate driver (such as "Microsoft
ODBC for ORACLE" or " SQL Server")
- Fill up the required fields according to your system set up.
- 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");
Use :
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");
where:
- String dbUser contains the Oracle user id.
- String dbPassword contains the Oracle password.
- String hostName contains the host name or IP address of the m/c
running Oracle.
- 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);
where tnsName is the TNS name entry in tnsnames.ora (net easy config -
database name).
Connection Pooling and Introduction to Application Servers
Building Web Applications Using Servlets and JSP Part II
|
