Java(TM) Boutique - Building Web Applications Using Servlets and JSP

Tutorials : Building Web Applications Using Servlets and JSP :

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).

Applet Index
(sorted alphabetically)
A B C D E F G H I J K
L M N O P Q R S T U
V W X Y Z #s

The Java Source
(applets w/source code)
A B C D E F G H I J K
L M N O P Q R S T U
V W X Y Z

How to Add Java Applets to Your Site

New on the Java Boutique:

New Review:

Time Management Made Easy with the Quartz Enterprise Job Scheduler
Why not just use the Java timer API? This open source scheduling API boasts simplicity, ease-of-integration, a well-rounded feature set, and it's free!

New Applet:

Reverse Complement
Reverse Complement is a simple applet that converts DNA or RNA sequences into three useful formats.