com.retek.commons.domain.core.persistence.db.oracle
Class DbUtil

java.lang.Object
  extended bycom.retek.commons.domain.core.persistence.db.oracle.DbUtil

public class DbUtil
extends java.lang.Object


Constructor Summary
DbUtil()
           
 
Method Summary
static void addInClause(java.lang.StringBuffer bufferSQL, java.util.Collection values, boolean useQuotes)
           
static void addTableJoin(java.lang.StringBuffer sql, java.lang.String tableOneJoinColumn, java.lang.String tableTwoJoinColumn)
           
static boolean addToWhereClauseForIn(java.lang.StringBuffer sql, java.lang.String colName, java.util.Set colValues, java.lang.String appender, java.util.List bindVariableList)
           
static void addToWhereClauseForSearch(java.lang.StringBuffer buffer, java.lang.String columnName, java.lang.Class expectedClass, java.util.Collection refs, boolean caseSensitive, java.util.List bindVariableList)
           
static void addToWhereClauseForSearch(java.lang.StringBuffer buffer, java.lang.String columnName, java.lang.Class expectedClass, java.util.Collection refs, java.util.List bindVariableList)
           
static void addToWhereClauseForSearch(java.lang.StringBuffer sql, java.lang.String colName, java.lang.Class expectedBusinessInterface, DistributedReference ref, boolean caseSensitive, java.util.List bindVariableList)
           
static void addToWhereClauseForSearch(java.lang.StringBuffer sql, java.lang.String colName, java.lang.Class expectedBusinessInterface, DistributedReference ref, java.util.List bindVariableList)
           
static void addToWhereClauseForSearch(java.lang.StringBuffer sql, java.lang.String colName, java.lang.Class expectedBusinessInterface, DistributedReference ref, java.lang.String appender, boolean caseSensitive, java.util.List bindVariableList)
           
static void addToWhereClauseForSearch(java.lang.StringBuffer sql, java.lang.String colName, java.lang.Class expectedBusinessInterface, DistributedReference ref, java.lang.String appender, java.util.List bindVariableList)
           
static void addToWhereClauseForSearch(java.lang.StringBuffer buffer, java.lang.String columnName, java.util.Collection values, boolean caseSensitive, java.util.List bindVariableList)
           
static void addToWhereClauseForSearch(java.lang.StringBuffer buffer, java.lang.String columnName, java.util.Collection expectedClasses, java.util.Collection refs, java.util.List bindVariableList)
           
static void addToWhereClauseForSearch(java.lang.StringBuffer buffer, java.lang.String columnName, java.util.Collection values, java.util.List bindVariableList)
           
static void addToWhereClauseForSearch(java.lang.StringBuffer sql, java.lang.String colName, Enum enum, java.lang.String appender, java.util.List bindVariableList)
           
static void addToWhereClauseForSearch(java.lang.StringBuffer sql, java.lang.String colName, java.lang.Object colVal, java.util.List bindVariablesList)
           
static void addToWhereClauseForSearch(java.lang.StringBuffer sql, java.lang.String colName, RDate startDate, RDate endDate, java.util.List bindVariableList)
           
static void addToWhereClauseForSearch(java.lang.StringBuffer sql, java.lang.String colName, RDate startDate, RDate endDate, java.lang.String appender, java.util.List bindVariableList)
           
static boolean addToWhereClauseForSearch(java.lang.StringBuffer sql, java.lang.String colName, java.lang.String colVal, boolean caseSensitive, java.util.List bindVariableList)
           
static void addToWhereClauseForSearch(java.lang.StringBuffer sql, java.lang.String colName, java.lang.String colVal, java.util.List bindVariableList)
           
static boolean addToWhereClauseForSearch(java.lang.StringBuffer sql, java.lang.String colName, java.lang.String colVal, java.lang.String appender, boolean caseSensitive, java.util.List bindVariableList)
           
static void addToWhereClauseForSearch(java.lang.StringBuffer sql, java.lang.String colName, java.lang.String colVal, java.lang.String appender, java.util.List bindVariableList)
           
static void addToWhereClauseForSearchWithNoAppender(java.lang.StringBuffer sql, java.lang.String colName, java.lang.Object colVal, java.util.List bindVariablesList)
           
static void buildUnionInClause(java.lang.StringBuffer bufferSQL, java.util.Collection values, int maxSize, boolean useQuotes)
           
static void checkForInvalidReferences(java.util.Collection searchRefs, java.util.Collection foundRefs)
           
static void checkForInvalidReferences(java.util.Set searchRefs, java.util.Set foundRefs)
           
static java.util.Set extractIdStrings(java.util.Set refs)
           
static java.lang.String formatLikeStr(java.lang.String str)
           
static void handleAppend(java.lang.StringBuffer sql)
           
static void handleAppend(java.lang.StringBuffer sql, java.lang.String appender)
           
static void handleOrAppend(java.lang.StringBuffer buffer)
           
static java.lang.String handleSqlDate(RDate sqlDate, java.util.List bindVariableList)
          Create sql date query clause.
static java.lang.String handleSqlDate(RDate sqlDate, java.util.List bindVariableList, boolean truncateTime)
          Create sql date query clause.
static void setParameters(RetekPreparedStatement stmt, java.util.List bindVariablesList)
           
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

DbUtil

public DbUtil()
Method Detail

addTableJoin

public static void addTableJoin(java.lang.StringBuffer sql,
                                java.lang.String tableOneJoinColumn,
                                java.lang.String tableTwoJoinColumn)

addToWhereClauseForIn

public static boolean addToWhereClauseForIn(java.lang.StringBuffer sql,
                                            java.lang.String colName,
                                            java.util.Set colValues,
                                            java.lang.String appender,
                                            java.util.List bindVariableList)

addToWhereClauseForSearch

public static boolean addToWhereClauseForSearch(java.lang.StringBuffer sql,
                                                java.lang.String colName,
                                                java.lang.String colVal,
                                                java.lang.String appender,
                                                boolean caseSensitive,
                                                java.util.List bindVariableList)

addToWhereClauseForSearch

public static void addToWhereClauseForSearch(java.lang.StringBuffer sql,
                                             java.lang.String colName,
                                             java.lang.String colVal,
                                             java.lang.String appender,
                                             java.util.List bindVariableList)

addToWhereClauseForSearch

public static boolean addToWhereClauseForSearch(java.lang.StringBuffer sql,
                                                java.lang.String colName,
                                                java.lang.String colVal,
                                                boolean caseSensitive,
                                                java.util.List bindVariableList)

addToWhereClauseForSearch

public static void addToWhereClauseForSearch(java.lang.StringBuffer sql,
                                             java.lang.String colName,
                                             java.lang.String colVal,
                                             java.util.List bindVariableList)

addToWhereClauseForSearch

public static void addToWhereClauseForSearch(java.lang.StringBuffer sql,
                                             java.lang.String colName,
                                             Enum enum,
                                             java.lang.String appender,
                                             java.util.List bindVariableList)

addToWhereClauseForSearch

public static void addToWhereClauseForSearch(java.lang.StringBuffer sql,
                                             java.lang.String colName,
                                             RDate startDate,
                                             RDate endDate,
                                             java.lang.String appender,
                                             java.util.List bindVariableList)

addToWhereClauseForSearch

public static void addToWhereClauseForSearch(java.lang.StringBuffer sql,
                                             java.lang.String colName,
                                             RDate startDate,
                                             RDate endDate,
                                             java.util.List bindVariableList)

addToWhereClauseForSearch

public static void addToWhereClauseForSearch(java.lang.StringBuffer sql,
                                             java.lang.String colName,
                                             java.lang.Class expectedBusinessInterface,
                                             DistributedReference ref,
                                             java.lang.String appender,
                                             boolean caseSensitive,
                                             java.util.List bindVariableList)

addToWhereClauseForSearch

public static void addToWhereClauseForSearch(java.lang.StringBuffer sql,
                                             java.lang.String colName,
                                             java.lang.Class expectedBusinessInterface,
                                             DistributedReference ref,
                                             boolean caseSensitive,
                                             java.util.List bindVariableList)

addToWhereClauseForSearch

public static void addToWhereClauseForSearch(java.lang.StringBuffer sql,
                                             java.lang.String colName,
                                             java.lang.Class expectedBusinessInterface,
                                             DistributedReference ref,
                                             java.util.List bindVariableList)

addToWhereClauseForSearch

public static void addToWhereClauseForSearch(java.lang.StringBuffer sql,
                                             java.lang.String colName,
                                             java.lang.Class expectedBusinessInterface,
                                             DistributedReference ref,
                                             java.lang.String appender,
                                             java.util.List bindVariableList)

addToWhereClauseForSearch

public static void addToWhereClauseForSearch(java.lang.StringBuffer buffer,
                                             java.lang.String columnName,
                                             java.util.Collection values,
                                             boolean caseSensitive,
                                             java.util.List bindVariableList)

addToWhereClauseForSearch

public static void addToWhereClauseForSearch(java.lang.StringBuffer buffer,
                                             java.lang.String columnName,
                                             java.util.Collection values,
                                             java.util.List bindVariableList)

addToWhereClauseForSearch

public static void addToWhereClauseForSearch(java.lang.StringBuffer buffer,
                                             java.lang.String columnName,
                                             java.lang.Class expectedClass,
                                             java.util.Collection refs,
                                             boolean caseSensitive,
                                             java.util.List bindVariableList)

addToWhereClauseForSearch

public static void addToWhereClauseForSearch(java.lang.StringBuffer buffer,
                                             java.lang.String columnName,
                                             java.lang.Class expectedClass,
                                             java.util.Collection refs,
                                             java.util.List bindVariableList)

addToWhereClauseForSearch

public static void addToWhereClauseForSearch(java.lang.StringBuffer buffer,
                                             java.lang.String columnName,
                                             java.util.Collection expectedClasses,
                                             java.util.Collection refs,
                                             java.util.List bindVariableList)

addToWhereClauseForSearch

public static void addToWhereClauseForSearch(java.lang.StringBuffer sql,
                                             java.lang.String colName,
                                             java.lang.Object colVal,
                                             java.util.List bindVariablesList)

addToWhereClauseForSearchWithNoAppender

public static void addToWhereClauseForSearchWithNoAppender(java.lang.StringBuffer sql,
                                                           java.lang.String colName,
                                                           java.lang.Object colVal,
                                                           java.util.List bindVariablesList)

addInClause

public static void addInClause(java.lang.StringBuffer bufferSQL,
                               java.util.Collection values,
                               boolean useQuotes)

buildUnionInClause

public static void buildUnionInClause(java.lang.StringBuffer bufferSQL,
                                      java.util.Collection values,
                                      int maxSize,
                                      boolean useQuotes)

formatLikeStr

public static java.lang.String formatLikeStr(java.lang.String str)

handleAppend

public static void handleAppend(java.lang.StringBuffer sql,
                                java.lang.String appender)

handleAppend

public static void handleAppend(java.lang.StringBuffer sql)

handleOrAppend

public static void handleOrAppend(java.lang.StringBuffer buffer)

handleSqlDate

public static final java.lang.String handleSqlDate(RDate sqlDate,
                                                   java.util.List bindVariableList)
Create sql date query clause. This variation of the operation truncates time in the TO_DATE format function.

Parameters:
sqlDate - date variable
bindVariableList - bind variable list
Returns:
sql string for the date clause

handleSqlDate

public static final java.lang.String handleSqlDate(RDate sqlDate,
                                                   java.util.List bindVariableList,
                                                   boolean truncateTime)
Create sql date query clause. Note: If you are truncating time using the TRUNC function, set the truncateTime paramater to false.

Parameters:
sqlDate - date variable
bindVariableList - bind variable list
truncateTime - indicator whether to truncate time in the TO_DATE format function
Returns:
sql string for the date clause

setParameters

public static void setParameters(RetekPreparedStatement stmt,
                                 java.util.List bindVariablesList)
                          throws java.sql.SQLException
Throws:
java.sql.SQLException

extractIdStrings

public static java.util.Set extractIdStrings(java.util.Set refs)

checkForInvalidReferences

public static void checkForInvalidReferences(java.util.Set searchRefs,
                                             java.util.Set foundRefs)
                                      throws InvalidReferenceException
Throws:
InvalidReferenceException - Is thrown if not all searchRefs contained in foundRefs

checkForInvalidReferences

public static void checkForInvalidReferences(java.util.Collection searchRefs,
                                             java.util.Collection foundRefs)
                                      throws InvalidReferenceException
Throws:
InvalidReferenceException - Is thrown if not all searchRefs contained in foundRefs


Copyright © 2005 Retek Inc. All Rights Reserved. - Generated at Fri, 01/21/2005 14:25