JDBC Thin Driver
Oracle support for the JDBC API is provided through theoracle.jdbc and oracle.sql packages.
Directories and Files in the ORACLE_HOME Directory
Directory
Description
/jdbc/lib
The lib directory contains the ojdbc14.jar and ojdbc14_g.jar required Java classes. These contain the JDBC driver classes for use with JDK 1.4.
/jdbc/Readme.txt
This file contains late-breaking and release-specific information about the drivers, which may not have been included in other documentation on the product.
/jlib
This directory contains the orai18n.jar file. This file contains classes for globalization and multibyte character sets support.
This section describes the environment variables that must be set for the JDBC Thin Driver. You must set theCLASSPATH for your installed JDBC Thin Driver. For JDK 1.4, you must set the following values for the CLASSPATH :
ORACLE_HOME /jdbc/lib/ojdbc14.jar
ORACLE_HOME /jlib/orai18n.jar
Ensure thatthere is only one JDBC class file, such as ojdbc14.jar , and one globalization classes file, orai18n.jar , in your CLASSPATH .
Note:
The JDBC Thin Driver requires a TCP/IP listener to be running on the computer where the database is installed.
JDBC OCI Driver
OCI is an API that enables you to create applications that use the native procedures or function calls of a third-generation language to access Oracle Database and control all phases of the SQL statement processing.
The JDBC OCI driver, written in a combination of Java and C, converts JDBC calls to calls to OCI. It does this by using native methods to call C-entry points . These calls communicate with the database using SQL*Net.
On Microsoft Windows, set PATH as follows:
ORACLE_HOME
/bin
This directory contains theocijdbc10.dll dynamic link library.
在Eclispe的SQLExplorer中建立连接
URL:
jdbc:oracle:thin:@localhost:1521:XE
XE -- 数据库名