OracleEX -连接数据库

JDBC Thin Driver

Oracle support for the JDBC API is provided through the oracle.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 the CLASSPATH 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 that there 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 the ocijdbc10.dll dynamic link library.

在Eclispe的SQLExplorer中建立连接

 

URL:

jdbc:oracle:thin:@localhost:1521:XE

 

XE -- 数据库名