Installing and Using a JDBC Driver

The installation of a JDBC driver varies according to the type of driver that is being used. Oracle8i Lite provides a Type II driver. It uses an ODBC datasource setup to locate and communicate with the database. Although this TYPE II driver uses an ODBC configuration, it is different from the JDBC-ODBC Bridge of the type I.

After all the pieces are installed, it's a good idea to test the database connection outside of your Java applications to be sure everything is correct. Oracle8i Lite provides a utility called SQL*Plus that can get a connection to an Oracle8i Lite database and issue SQL commands. The utility will prompt you for three input fields; username, password, and host string. For username, you can ...

Get Special Edition Using Java 2 Standard Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.