Package com.nt.udc.db

Class OracleConnectionFactory

java.lang.Object

com.nt.udc.db.DBConnectionFactory

com.nt.udc.db.OracleConnectionFactory

All Implemented Interfaces:

JDBCConnectionFactoryIfc

public class OracleConnectionFactory
extends DBConnectionFactory

This class, once constructed with the necessary information, will produce a java.sql.Connection object for connecting to an Oracle database.

Field Summary

Fields inherited from class com.nt.udc.db.DBConnectionFactory

dbDriver, HOST_TEMPLATE, PORT_TEMPLATE, SERVICENAME_TEMPLATE, SID_TEMPLATE, urlTemplate

Constructor Summary

Constructors

Constructor	Description
OracleConnectionFactory(String connURL, String user, String pword)	Construct the connection factory with the information necessary for creating a java.sql.Connection object for communicating with an Oracle database.
OracleConnectionFactory(String host, String port, String sid, String serviceName, String user, String pword)	Construct the connection factory with the information necessary for creating a java.sql.Connection object for communicating with an Oracle database.

Method Summary

Modifier and Type	Method	Description
Connection	getConnection()	Returns a java.sql.Connection object to be used for reading/writing data from/to a JDBC-compliant database.
protected void	registerDriver()

Methods inherited from class com.nt.udc.db.DBConnectionFactory

formJDBCURL, getDBUser

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

OracleConnectionFactory

public OracleConnectionFactory(String connURL,
 String user,
 String pword)
                        throws SQLException

Construct the connection factory with the information necessary for creating a java.sql.Connection object for communicating with an Oracle database.

Parameters:

connURL - The URL used by the JDBC driver to make the connection to the database.

user - The user ID to be used for the database login.

pword - The password to be used for the database login.

Throws:

SQLException

OracleConnectionFactory

public OracleConnectionFactory(String host,
 String port,
 String sid,
 String serviceName,
 String user,
 String pword)
                        throws SQLException

Construct the connection factory with the information necessary for creating a java.sql.Connection object for communicating with an Oracle database.

Parameters:

host - The host name where the Oracle database is running.

port - The port on which the Oracle communication software is running.

sid - The identifier used to indicate the Oracle database instance to which to connect.

serviceName - The identifier used to indicate the Oracle database service name to which to connect.

user - The user ID to be used for the database login.

pword - The password to be used for the database login.

Throws:

SQLException

Method Details

getConnection

public Connection getConnection()
                         throws SQLException

Returns a java.sql.Connection object to be used for reading/writing data from/to a JDBC-compliant database.

Specified by:

getConnection in interface JDBCConnectionFactoryIfc

Overrides:

getConnection in class DBConnectionFactory

Returns:

A java.sql.Connection object

Throws:

SQLException

registerDriver

protected void registerDriver()
                       throws SQLException

Overrides:

registerDriver in class DBConnectionFactory

Throws:

SQLException