oracle.apps.fnd.applxdf.comp
Class DBUtil

java.lang.Object
  oracle.apps.fnd.applxdf.comp.DBUtil

public class DBUtil
extends java.lang.Object

DB related utility class

Author:

Guoqiang Su <Guoqiang.Su@oracle.com>

Constructor Summary

DBUtil()
Constructor.

DBUtil(XDFLogger theLogger, Parameters theParam)
Constructor.

Method Summary

void	dropConst(java.lang.String szConst, java.lang.String szTableName)
void	executeConsDDLSt(java.lang.String ddlSt, java.lang.String szObject) Execute constraint DDL.
static boolean	executeDDLSt(Parameters theParam, java.lang.String ddlSt) Execute the DDL statement.
java.util.ArrayList	getConsColsFromDB(java.lang.String szConsName, java.lang.String szTableName) Retrieve all columns of a given constraint.
java.util.ArrayList	getConsFromDB(java.lang.String szQuery, java.lang.String szTableName) Retrieve Constraint name(s) from target database.
static java.lang.String	getConstraintName(java.lang.String constraintDDL) Get the constraint name.
long	getDbmsSpaceBlockSize(java.lang.String p_tableName, java.lang.String p_owner, java.lang.String type)
long	getDBTableBlockSize(java.lang.String szTableName, java.lang.String szOwner)
static java.math.BigInteger	getMod(java.lang.String actualNum, java.lang.String modWith) Get the mod value.
static java.lang.String	getTableNameFromSqlString(java.lang.String sqlStmt) Returns the table name after "From" in a sql string.
static java.lang.String	getTime() Get the current time.
boolean	isConsNameInDB(java.lang.String szConst, java.lang.String szTable)
void	renameCons(java.lang.String szNameNew, java.lang.String szNameOld, java.lang.String szTableName) Rname the constraint name in the target DB.
static boolean	returnsRecord(Parameters theParam, java.lang.String queryStr, java.util.ArrayList arguments) Check wehther the query string returns record or not.
static void	setLoggerAndParameter(XDFLogger theLogger, Parameters theParam) Set the logger to the class.

Methods inherited from class java.lang.Object

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

Constructor Detail

DBUtil

public DBUtil()

Constructor.

DBUtil

public DBUtil(XDFLogger theLogger,
              Parameters theParam)

Constructor.

Method Detail

setLoggerAndParameter

public static void setLoggerAndParameter(XDFLogger theLogger,
                                         Parameters theParam)

Set the logger to the class.

Parameters:

theLogger - Logger instance

theParam - Parameters instance

executeDDLSt

public static boolean executeDDLSt(Parameters theParam,
                                   java.lang.String ddlSt)

Execute the DDL statement.

Parameters:

theParam - Parameters instance

ddlSt - DDL statement

Returns:

true if success

Throws:

java.lang.Exception - when closing the statement

returnsRecord

public static boolean returnsRecord(Parameters theParam,
                                    java.lang.String queryStr,
                                    java.util.ArrayList arguments)
                             throws java.lang.Exception

Check wehther the query string returns record or not.

Parameters:

theParam - Parameters nstance

queryStr - query string

arguments - arguments assocaited with the query string

Returns:

true if it returns record

Throws:

java.lang.Exception - when the statement is closed.

getMod

public static java.math.BigInteger getMod(java.lang.String actualNum,
                                          java.lang.String modWith)

Get the mod value.

Parameters:

actualNum - nubmer to do the mod

modWith - the number to be mod with

Returns:

mod value

getTableNameFromSqlString

public static java.lang.String getTableNameFromSqlString(java.lang.String sqlStmt)

Returns the table name after "From" in a sql string.

Parameters:

sqlStmt - sql statement

Returns:

table name after "From".

getTime

public static java.lang.String getTime()

Get the current time.

Returns:

current time string

getConsFromDB

public java.util.ArrayList getConsFromDB(java.lang.String szQuery,
                                         java.lang.String szTableName)

Retrieve Constraint name(s) from target database.

Parameters:

szQuery -

szTableName -

Returns:

ArrayList

renameCons

public void renameCons(java.lang.String szNameNew,
                       java.lang.String szNameOld,
                       java.lang.String szTableName)

Rname the constraint name in the target DB.

Parameters:

szNameNew -

szNameOld -

szTableName -

dropConst

public void dropConst(java.lang.String szConst,
                      java.lang.String szTableName)

getDBTableBlockSize

public long getDBTableBlockSize(java.lang.String szTableName,
                                java.lang.String szOwner)

getDbmsSpaceBlockSize

public long getDbmsSpaceBlockSize(java.lang.String p_tableName,
                                  java.lang.String p_owner,
                                  java.lang.String type)

getConsColsFromDB

public java.util.ArrayList getConsColsFromDB(java.lang.String szConsName,
                                             java.lang.String szTableName)

Retrieve all columns of a given constraint.

Parameters:

szConsName - - name of constraint

Returns:

array of columns

executeConsDDLSt

public void executeConsDDLSt(java.lang.String ddlSt,
                             java.lang.String szObject)

Execute constraint DDL. (we could use the one in the DBUtil, since we need to catch the error for renaming.

Parameters:

ddlSt -

Throws:

java.lang.Exception

isConsNameInDB

public boolean isConsNameInDB(java.lang.String szConst,
                              java.lang.String szTable)

getConstraintName

public static java.lang.String getConstraintName(java.lang.String constraintDDL)

Get the constraint name.

Parameters:

constraintDDL - constraint ddl

Returns:

the constraint name