com.nt.udc.db

Class JDBCUtils

java.lang.Object

com.nt.udc.db.JDBCUtils

public final class JDBCUtils
extends java.lang.Object

This class provides static methods that can be used to obtain DB-specific objects and information. Rather than having generic methods that return specific objects based upon a given type of DB, DB-specific methods are used since different parameters may be needed from one DB to the next.

Constructor Summary

Constructors

Constructor and Description
JDBCUtils()

Method Summary

Methods

Modifier and Type	Method and Description
static JDBCConnectionFactoryIfc	getOracleConnectionFactory(java.lang.String connect, java.lang.String user, java.lang.String pword) Returns a JDBCConnectionFactoryIfc object to be used for obtaining a java.sql.Connection object to an Oracle DB.
static long	getOracleTimeAsLong(java.sql.Connection dbConn) Returns a long value representing the current time for the Oracle DB.
static java.sql.Timestamp	getOracleTimeAsTimestamp(java.sql.Connection dbConn) Returns a Timestamp object representing the current time for the Oracle DB.

Methods inherited from class java.lang.Object

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

Constructor Detail

JDBCUtils

public JDBCUtils()

Method Detail

getOracleConnectionFactory

public static JDBCConnectionFactoryIfc getOracleConnectionFactory(java.lang.String connect,
                                                  java.lang.String user,
                                                  java.lang.String pword)
                                                           throws java.sql.SQLException

Returns a JDBCConnectionFactoryIfc object to be used for obtaining a java.sql.Connection object to an Oracle DB.

Parameters:

connect - Connection URL for Oracle JDBC driver. Format is: jdbc:oracle:thin:@::

user - User name used for logging in to the DB.

pword - Password used for logging in to the DB.

Returns:

A JDBCConnectionFactoryIfc object

Throws:

java.sql.SQLException

getOracleTimeAsTimestamp

public static java.sql.Timestamp getOracleTimeAsTimestamp(java.sql.Connection dbConn)
                                                   throws java.sql.SQLException

Returns a Timestamp object representing the current time for the Oracle DB.

Parameters:

dbConn - A Connection object for the Oracle DB

Returns:

Timestamp object, representing current database time.

Throws:

java.sql.SQLException

getOracleTimeAsLong

public static long getOracleTimeAsLong(java.sql.Connection dbConn)
                                throws java.sql.SQLException

Returns a long value representing the current time for the Oracle DB.

Parameters:

dbConn - A Connection object for the Oracle DB

Returns:

long value, representing current database time, in milliseconds

Throws:

java.sql.SQLException