com.ibm.commerce.base.helpers
Class BaseJDBCHelper

java.lang.Object
  |
  +--com.ibm.commerce.base.helpers.BaseJDBCHelper

public abstract class BaseJDBCHelper
extends java.lang.Object


Field Summary
static boolean autoFlush
           
static java.lang.String COPYRIGHT
           
static java.lang.String DB_DB2
           
static java.lang.String DB_DB2_390
           
static java.lang.String DB_ORACLE
           
protected  javax.ejb.SessionContext mySessionCtx
           
 
Constructor Summary
BaseJDBCHelper()
          BaseHelper constructor comment.
 
Method Summary
protected  void closeConnection()
           
protected static java.util.Hashtable convertFirstRowToHashtable(java.sql.ResultSet aResultSet)
           
static java.util.Vector convertResultSetToTable(java.sql.ResultSet rs)
           
protected static java.lang.String convertRowFromHashtable(java.util.Hashtable aHashtable)
           
protected  void debugInitConnection(java.lang.String dataSourceName, java.lang.String userId, java.lang.String pswd)
           
protected  java.sql.ResultSet executeQuery(java.sql.PreparedStatement stmt, boolean flush)
           
protected  int executeUpdate(java.sql.PreparedStatement stmt, boolean flush)
           
 void flush()
           
protected  java.sql.CallableStatement getCallableStatement(java.lang.String sqlStatement)
           
static java.lang.String getCharacterStreamFromResultSet(java.sql.ResultSet rs, int nColumn)
           
protected  java.sql.Connection getConnection()
           
static javax.sql.DataSource getDataSource()
           
protected  java.sql.PreparedStatement getPreparedStatement(java.lang.String sqlStatement)
           
protected  java.sql.PreparedStatement getPreparedStatement(java.lang.String sqlStatement, int resultSetType, int resultSetConcurrency)
           
abstract  javax.ejb.SessionContext getSessionContext()
           
static void init(com.ibm.commerce.base.helpers.ConfigProperties parameters)
           
static void init(java.lang.String ds, java.lang.String dt, java.lang.String uid, java.lang.String pw)
           
protected  void makeConnection()
           
static boolean useDB2_390()
          This method will be used by DB2/390 Creation date: (04/10/01 3:45:28 PM)
static boolean useDB2()
           
static boolean useOracle()
           
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

autoFlush

public static final boolean autoFlush

COPYRIGHT

public static final java.lang.String COPYRIGHT

DB_DB2

public static final java.lang.String DB_DB2

DB_DB2_390

public static final java.lang.String DB_DB2_390

DB_ORACLE

public static final java.lang.String DB_ORACLE

mySessionCtx

protected transient javax.ejb.SessionContext mySessionCtx
Constructor Detail

BaseJDBCHelper

public BaseJDBCHelper()
BaseHelper constructor comment.
Method Detail

closeConnection

protected void closeConnection()
                        throws java.sql.SQLException

convertFirstRowToHashtable

protected static java.util.Hashtable convertFirstRowToHashtable(java.sql.ResultSet aResultSet)
                                                         throws java.sql.SQLException

convertResultSetToTable

public static java.util.Vector convertResultSetToTable(java.sql.ResultSet rs)
                                                throws java.sql.SQLException

convertRowFromHashtable

protected static java.lang.String convertRowFromHashtable(java.util.Hashtable aHashtable)
                                                   throws java.sql.SQLException

debugInitConnection

protected void debugInitConnection(java.lang.String dataSourceName,
                                   java.lang.String userId,
                                   java.lang.String pswd)
                            throws javax.naming.NamingException,
                                   java.sql.SQLException

executeQuery

protected java.sql.ResultSet executeQuery(java.sql.PreparedStatement stmt,
                                          boolean flush)
                                   throws java.sql.SQLException,
                                          java.rmi.RemoteException

executeUpdate

protected int executeUpdate(java.sql.PreparedStatement stmt,
                            boolean flush)
                     throws java.sql.SQLException

flush

public void flush()
           throws java.rmi.RemoteException

getCallableStatement

protected java.sql.CallableStatement getCallableStatement(java.lang.String sqlStatement)
                                                   throws java.sql.SQLException

getCharacterStreamFromResultSet

public static java.lang.String getCharacterStreamFromResultSet(java.sql.ResultSet rs,
                                                               int nColumn)
                                                        throws java.sql.SQLException

getConnection

protected java.sql.Connection getConnection()
                                     throws javax.naming.NamingException,
                                            java.sql.SQLException

getDataSource

public static javax.sql.DataSource getDataSource()
                                          throws javax.naming.NamingException

getPreparedStatement

protected java.sql.PreparedStatement getPreparedStatement(java.lang.String sqlStatement)
                                                   throws java.sql.SQLException

getPreparedStatement

protected java.sql.PreparedStatement getPreparedStatement(java.lang.String sqlStatement,
                                                          int resultSetType,
                                                          int resultSetConcurrency)
                                                   throws java.sql.SQLException

getSessionContext

public abstract javax.ejb.SessionContext getSessionContext()

init

public static void init(com.ibm.commerce.base.helpers.ConfigProperties parameters)
                 throws javax.naming.NamingException

init

public static void init(java.lang.String ds,
                        java.lang.String dt,
                        java.lang.String uid,
                        java.lang.String pw)
                 throws javax.naming.NamingException

makeConnection

protected void makeConnection()
                       throws javax.naming.NamingException,
                              java.sql.SQLException

useDB2_390

public static boolean useDB2_390()
This method will be used by DB2/390 Creation date: (04/10/01 3:45:28 PM)
Returns:
boolean

useDB2

public static boolean useDB2()

useOracle

public static boolean useOracle()