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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.