Package com.nt.udc.db

Class DBConnectionFactory

java.lang.Object

com.nt.udc.db.DBConnectionFactory

All Implemented Interfaces:

JDBCConnectionFactoryIfc

Direct Known Subclasses:

OracleConnectionFactory

public class DBConnectionFactory
extends Object
implements JDBCConnectionFactoryIfc

Field Summary

Fields

Modifier and Type	Field	Description
protected boolean	autoCommit
protected String	connectionURL
protected String	dbDriver
protected String	dbHost
protected String	dbPassword
protected String	dbPort
protected String	dbServiceName
protected String	dbSID
protected String	dbUser
protected String	errMesg
protected static final String	HOST_TEMPLATE
protected static final String	PORT_TEMPLATE
protected static final String	SERVICENAME_TEMPLATE
protected static final String	SID_TEMPLATE
protected String	urlTemplate

Constructor Summary

Constructors

Constructor	Description
DBConnectionFactory(String connURL, String user, String pword, String dbdriver)	Construct the connection factory with the information necessary for creating a java.sql.Connection object for communicating with an Oracle database.
DBConnectionFactory(String connURL, String user, String pword, String dbdriver, boolean commit)	Construct the connection factory with the information necessary for creating a java.sql.Connection object for communicating with an Oracle database.
DBConnectionFactory(String host, String port, String sid, String serviceName, String user, String pword, String dbdriver, String urltemplate)	Construct the connection factory with the information necessary for creating a java.sql.Connection object for communicating with an Oracle database.
DBConnectionFactory(String host, String port, String sid, String serviceName, String user, String pword, String dbdriver, String urltemplate, boolean commit)	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
protected String	formJDBCURL()
Connection	getConnection()	Returns a java.sql.Connection object to be used for reading/writing data from/to a JDBC-compliant database.
String	getDBUser()
protected void	registerDriver()

Methods inherited from class java.lang.Object

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

Field Details

errMesg

protected String errMesg

dbHost

protected String dbHost

dbPort

protected String dbPort

dbSID

protected String dbSID

dbServiceName

protected String dbServiceName

dbUser

protected String dbUser

dbPassword

protected String dbPassword

connectionURL

protected String connectionURL

dbDriver

protected String dbDriver

urlTemplate

protected String urlTemplate

autoCommit

protected boolean autoCommit

HOST_TEMPLATE

protected static final String HOST_TEMPLATE

See Also:

• Constant Field Values

PORT_TEMPLATE

protected static final String PORT_TEMPLATE

See Also:

• Constant Field Values

SID_TEMPLATE

protected static final String SID_TEMPLATE

See Also:

• Constant Field Values

SERVICENAME_TEMPLATE

protected static final String SERVICENAME_TEMPLATE

See Also:

• Constant Field Values

Constructor Details

DBConnectionFactory

public DBConnectionFactory(String connURL,
 String user,
 String pword,
 String dbdriver)
                    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.

dbdriver - The class name of the JDBC driver.

Throws:

SQLException

DBConnectionFactory

public DBConnectionFactory(String connURL,
 String user,
 String pword,
 String dbdriver,
 boolean commit)
                    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.

dbdriver - The class name of the JDBC driver.

commit - true, if each statement will be automatically commited.

Throws:

SQLException

DBConnectionFactory

public DBConnectionFactory(String host,
 String port,
 String sid,
 String serviceName,
 String user,
 String pword,
 String dbdriver,
 String urltemplate)
                    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.

dbdriver - The class name of the JDBC driver.

urltemplate - The template of the JDBC URL.

Throws:

SQLException

DBConnectionFactory

public DBConnectionFactory(String host,
 String port,
 String sid,
 String serviceName,
 String user,
 String pword,
 String dbdriver,
 String urltemplate,
 boolean commit)
                    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.

dbdriver - The class name of the JDBC driver.

urltemplate - The template of the JDBC URL.

commit - true, if each statement will be automatically commited.

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

Returns:

A java.sql.Connection object

Throws:

SQLException

registerDriver

protected void registerDriver()
                       throws SQLException

Throws:

SQLException

formJDBCURL

protected String formJDBCURL()
                      throws SQLException

Throws:

SQLException

getDBUser

public String getDBUser()

Specified by:

getDBUser in interface JDBCConnectionFactoryIfc