com.clra.util
Class DBConfiguration

java.lang.Object
  |
  +--com.clra.util.DBConfiguration

public class DBConfiguration

extends Object

A collection of configurable properties used by this package.

Version:

$Id: DBConfiguration.java,v 1.2 2002/01/30 15:13:40 rphall Exp $

Author:

Rick Hall

Field Summary

static String	DBDRIVER
static String	DBPASSWORD
static String	DBTYPE
static String	DBURL
static String	DBUSER
static String	PN_DBTYPE
static String	PN_PREFIX_DBDRIVER
static String	PN_PREFIX_DBPASSWORD
static String	PN_PREFIX_DBURL
static String	PN_PREFIX_DBUSER

Method Summary

static void	closeSQLConnection(java.sql.Connection conn) Closes SQL connection
static void	closeSQLResultSet(java.sql.ResultSet rs) Closes SQL result set
static void	closeSQLStatement(java.sql.Statement stmt) Closes SQL statement
static Integer	convertIntToIntegerOrNull(int i) Converts an int value to an Integer object.
static java.sql.Connection	getConnection() Gets a SQL connection
static boolean	isOracle()

Methods inherited from class java.lang.Object

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

Field Detail

PN_DBTYPE

public static final String PN_DBTYPE

PN_PREFIX_DBDRIVER

public static final String PN_PREFIX_DBDRIVER

PN_PREFIX_DBURL

public static final String PN_PREFIX_DBURL

PN_PREFIX_DBUSER

public static final String PN_PREFIX_DBUSER

PN_PREFIX_DBPASSWORD

public static final String PN_PREFIX_DBPASSWORD

DBTYPE

public static String DBTYPE

DBDRIVER

public static String DBDRIVER

DBURL

public static String DBURL

DBUSER

public static String DBUSER

DBPASSWORD

public static String DBPASSWORD

Method Detail

isOracle

public static boolean isOracle()

getConnection

public static java.sql.Connection getConnection()
                                         throws java.sql.SQLException

Gets a SQL connection

closeSQLResultSet

public static void closeSQLResultSet(java.sql.ResultSet rs)

Closes SQL result set

closeSQLStatement

public static void closeSQLStatement(java.sql.Statement stmt)

Closes SQL statement

closeSQLConnection

public static void closeSQLConnection(java.sql.Connection conn)

Closes SQL connection

convertIntToIntegerOrNull

public static Integer convertIntToIntegerOrNull(int i)

Converts an int value to an Integer object. Per JDBC, a zero-valued int is converted to null.