Movatterモバイル変換

Skip navigation links

oracle.jdbc
Class OracleDriver

java.lang.Object
  oracle.jdbc.driver.OracleDriver
      oracle.jdbc.OracleDriver

All Implemented Interfaces:

java.sql.Driver

public classOracleDriver

extends oracle.jdbc.driver.OracleDriver

The Oracle JDBC driver class that implements thejava.sql.Driver interface.

Register the JDBC drivers

To access a database from a Java application, you must first provide the code to register your installed driver with your program. You do this with the staticregisterDriver() method of thejava.sql.DriverManager class. This class provides a basic service for managing a set of JDBC drivers. TheregisterDriver() method takes as input a "driver" class, that is, a class that implements thejava.sql.Driver interface, as is the case withOracleDriver.

Note: Alternatively, you can use theforName() method of thejava.lang.Class class to load the JDBC drivers directly. For example:Class.forName ("oracle.jdbc.OracleDriver");. However, this method is valid only for JDK-compliant Java virtual machines. It is not valid for Microsoft Java virtual machines.

You register the driver only once in your Java application.

DriverManager.registerDriver (new oracle.jdbc.OracleDriver());

Open a Connection to a database

Once you have registered the driver, you can open a connection to the database with the staticgetConnection() method of thejava.sql.DriverManager class. The type of the object returned isjava.sql.Connection.

Understanding the Forms of getConnection()

Specifying a Databse URL, User Name, and Password

The following signature takes the URL, user name, and password as separate parameters:

getConnection(String URL, String user, String password);

Where the URL is of the form:
  jdbc:oracle:<drivertype>:@<database>

The following example connects userscott with passwordtiger to a database with SIDorcl through port 1521 of hostmyhost, using the Thin driver.

Connection conn = DriverManager.getConnection
  ("jdbc:oracle:thin:@myhost:1521:orcl", "scott", "tiger");

Specifying a Databse URL That Includes User Name and Password

The following signature takes the URL, user name, and password all as part of a URL parameter:

getConnection(String URL);

Where the URL is of the form:
  jdbc:oracle:<drivertype>:<user>/<password>@<database>

The following example connects userscott with passwordtiger to a database on hostmyhost using the OCI driver. In this case, however, the URL includes the userid and password, and is the only input parameter.

Connection conn = DriverManager.getConnection
   ("jdbc:oracle:oci8:scott/tiger@myhost);

If you want to connect with the Thin driver, you must specify the port number and SID. For example, if you want to connect to the database on hostmyhost that has a TCP/IP listener up on port 1521, and theSID (system identifier) isorcl:

Connection conn = DriverManager.getConnection
   ("jdbc:oracle:thin:scott/tiger@myhost:1521:orcl);

Specifying a Database URL and Properties Object

The following signature takes a URL, together with a properties object that specifies user name and password (perhaps among other things):

getConnection(String URL, Properties info);

Where theURL is of the form:
  jdbc:oracle:<drivertype>:@<database>

In addition to the URL, use an object of the standard JavaProperties class as input. For example:

java.util.Properties info = new java.util.Properties();
  info.put ("user", "scott");
  info.put ("password","tiger");
  info.put ("defaultRowPrefetch","15");
  getConnection ("jdbc:oracle:oci8:@",info);

The table below lists the connection properties that Oracle JDBC drivers support.

Connection Properties Recognized by Oracle JDBC Drivers

Select your driver type : thin, oci, kprb...

Oralce provides four types of JDBC driver.

• Thin Driver, a 100% Java driver for client-side use without an Oracle installation, particularly with applets. The Thin driver type isthin. To connect userscott with passwordtiger to a database withSID (system identifier)orcl through port 1521 of hostmyhost, using the Thin driver, you would write :

  Connection conn = DriverManager.getConnection  ("jdbc:oracle:thin:@myhost:1521:orcl", "scott", "tiger");

• OCI Driver for client-side use with an Oracle client installation. The OCI driver type isoci. To connect userscott with passwordtiger to a database withSID (system identifier)orcl through port 1521 of hostmyhost, using the OCI driver, you would write :

  Connection conn = DriverManager.getConnection  ("jdbc:oracle:oci:@myhost:1521:orcl", "scott", "tiger");

  Note that you can also specify the database by aTNSNAMES entry. You can find the availableTNSNAMES entries listed in the filetnsnames.ora on the client computer from which you are connecting. For example, if you want to connect to the database on hostmyhost as userscott with passwordtiger that has aTNSNAMES entry ofMyHostString, enter:

  Connection conn = DriverManager.getConnection  ("jdbc:oracle:oci8:@MyHostString","scott","tiger");

  If your JDBC client and Oracle server are running on the same machine, the OCI driver can use IPC (InterProcess Communication) to connect to the database instead of a network connection. An IPC connection is much faster than a network connection.

  Connection conn = DriverManager.getConnection  ("jdbc:oracle:oci8:@","scott","tiger");

• Server-Side Thin Driver, which is functionally the same as the client-side Thin driver, but is for code that runs inside an Oracle server and needs to access a remote server, including middle-tier scenarios. The Server-Side Thin driver type isthin and there is no difference in your code between using the Thin driver from a client application or from inside a server.
  
• Server-Side Internal Driver for code that runs inside the target server, that is, inside the Oracle server that it must access. The Server-Side Internal driver type iskprb and it actually runs within a default session. You are already "connected". Thereforethe connection should never be closed.
  To access the default connection, write:

  DriverManager.getConnection("jdbc:oracle:kprb:");  or:DriverManager.getConnection("jdbc:default:connection:");

  You can also use the Oracle-specific defaultConnection() method of the OracleDriver class which is generally recommended:

  OracleDriver ora = new OracleDriver();  Connection conn = ora.defaultConnection();

  Note: You are no longer required to register theOracleDriver class for connecting with the Server-Side Internal driver, although there is no harm in doing so. This is true whether you are usinggetConnection() ordefaultConnection() to make the connection.
  Any user name or password you include in the URL string is ignored in connecting to the server default connection. TheDriverManager.getConnection() method returns a new JavaConnection object every time you call it. Note that although the method is not creating a new physical connection (only a single implicit connection is used), it is returning a new object.
  Again, when JDBC code is running inside the target server, the connection is an implicit data channel, not an explicit connection instance as from a client. It should never be closed.

TRACE

public static final booleanTRACE

See Also:

Constant Field Values

OracleDriver

publicOracleDriver()

isDMS

public static final booleanisDMS()

Returns true if this jar includes DMS instrumentaion.

Returns:

true if DMS jar

isInServer

public static final booleanisInServer()

Returns true if this jar was built to run in the Oracle Java VM.

Returns:

true if server jar

isJDK14

public static final booleanisJDK14()

Deprecated. 

Returns true if this is a JDK 1.4 or later compliant jar. Since JDK 1.3 is desupported, always returns true.

Returns:

true

isDebug

public static final booleanisDebug()

Returns true if this jar includes debug code.

Returns:

true if debug jar

isPrivateDebug

public static final booleanisPrivateDebug()

Returns true if this jar includes Oracle internal debug code.

Returns:

true if private debug jar

getJDBCVersion

public static final java.lang.StringgetJDBCVersion()

Returns a String that specifies the version of the JDBC spec supporte by the driver.

Returns:

JDBC spec version

getDriverVersion

public static final java.lang.StringgetDriverVersion()

Returns a String that specifies the Oracle version number of the driver.

Returns:

version number

getBuildDate

public static final java.lang.StringgetBuildDate()

Returns a String that specifies exactly when the jar file was built.

Returns:

build date

main

public static voidmain(java.lang.String[] args)                 throws java.lang.Exception

Prints a description of the Oracle JDBC driver .jar file to System.out.

Parameters:

args - Ignored

Throws:

java.lang.Exception

Skip navigation links