oracle.pg.common

Class Util

java.lang.Object

oracle.pg.common.Util

public class Util
extends Object

This class contains some useful helper functions. Many of the methods are wrapper functions of what are provided in oracle.spatial.util.Util.

Constructor Summary

Constructors

Constructor and Description
Util()

Method Summary

Modifier and Type	Method and Description
static String	checkSQLName(String string, int maxStringLength) Checks for any illegal characters in a SQL name.
static boolean	compareDates(Object o1, Object o2) Returns true if two given objects (either a Date object or a String representation of a Date object) are the same.
static String	enquoteColumnName(Connection conn, String columnName) Enquotes a column name.
static String	enquoteColumnNameCaseSensitive(Connection conn, String name) Enquotes a column name.
static String	enquoteLiteral(Connection conn, String name) This method enquotes a literal value.
static String	enquoteLiteral(Connection conn, String literal, int maxLengthAllowed) Returns the enquoted literal
static String	enquoteNameSQLName(Connection conn, String name) Returns the ENQUOTE_NAME formatted String for the SQL name If the Oracle JDBC is present, use the new OracleStatement.enquoteIdentifier API in the JDK8 JDBC.
static String	enquoteTableName(Connection conn, String tableName) Enquotes a table name with or without schema name which is separated by ".".
static int	getMaxLengthAllowed()
static String	getValidatedGraphName(Connection conn, String graphName) Returns the validated graph name
static String	getValidatedGraphName(Connection conn, String graphName, int maxLengthAllowed) Returns the validated graph name
static String	myCheckName(String string) Checks for any illegal characters in a SQL name.
static String	qualifiedSQLName(Connection conn, String name) Checks if the specified name is a qualified SQL name.
static String	sanitizeSimpleFileName(String fileName) do sanity checking to the filename, only allowed characters can appear in the file name
static String	simpleSqlNameCheck(Connection conn, String name) This method returns the result of SYS.DBMS_ASSERT.simple_sql_name function.

Methods inherited from class java.lang.Object

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

Constructor Detail

Util

public Util()

Method Detail

checkSQLName

public static String checkSQLName(String string,
                                  int maxStringLength)
                           throws SQLException

Checks for any illegal characters in a SQL name. Only alpha-numeric characters and "_","$","#" are allowed.

Parameters:

string - input string

maxStringLength - maximum length for input string

Returns:

string Retruns the string if passes the check

Throws:

SQLException - An exception is thrown if the input string contains any illegal characters or exceeds the maximum length

compareDates

public static boolean compareDates(Object o1,
                                   Object o2)

Returns true if two given objects (either a Date object or a String representation of a Date object) are the same.

Parameters:

o1 - must be either a Date object or String

o2 - must be either a Date object or String

enquoteColumnName

public static String enquoteColumnName(Connection conn,
                                       String columnName)
                                throws SQLException

Enquotes a column name.

Parameters:

conn -

columnName -

Returns:

String

Throws:

SQLException

enquoteColumnNameCaseSensitive

public static String enquoteColumnNameCaseSensitive(Connection conn,
                                                    String name)
                                             throws SQLException

Enquotes a column name.

Throws:

SQLException

enquoteLiteral

public static String enquoteLiteral(Connection conn,
                                    String name)
                             throws SQLException

This method enquotes a literal value. It calls SYS.DBMS_ASSERT.enquoteLiteral function.

Parameters:

conn - the database connection

name - the input literal

Returns:

string Retruns the string if passes the check

Throws:

SQLException - A SQLexception is thrown if the dbms_assert.qualified_sql_name failed

enquoteLiteral

public static String enquoteLiteral(Connection conn,
                                    String literal,
                                    int maxLengthAllowed)
                             throws SQLException

Returns the enquoted literal

Parameters:

conn - the database connection

literal - the input name

Throws:

SQLException

enquoteNameSQLName

public static String enquoteNameSQLName(Connection conn,
                                        String name)
                                 throws SQLException

Returns the ENQUOTE_NAME formatted String for the SQL name If the Oracle JDBC is present, use the new OracleStatement.enquoteIdentifier API in the JDK8 JDBC. Otherwise use the DBMS_ASSERT.ENQUOTE_NAME formatted String for the SQL name using "false" for the second parameter (i.e., no capitalization of SQL name). This method is added due to avoid SQL Injection issues.

Parameters:

conn - the database connection

name - the input name

Throws:

SQLException

enquoteTableName

public static String enquoteTableName(Connection conn,
                                      String tableName)
                               throws SQLException

Enquotes a table name with or without schema name which is separated by ".". This method also can be used to enquote all column names, including object column names like col.attr1.attr2.attr3 == "COL"."ATTR1"."ATTR2"."ATTR3"

Parameters:

conn -

tableName -

Returns:

String

Throws:

SQLException

getMaxLengthAllowed

public static int getMaxLengthAllowed()

getValidatedGraphName

public static String getValidatedGraphName(Connection conn,
                                           String graphName)
                                    throws SQLException

Returns the validated graph name

Parameters:

conn - the database connection

graphName - the input graph name

Throws:

SQLException

getValidatedGraphName

public static String getValidatedGraphName(Connection conn,
                                           String graphName,
                                           int maxLengthAllowed)
                                    throws SQLException

Returns the validated graph name

Parameters:

conn - the database connection

graphName - the input graph name

Throws:

SQLException

myCheckName

public static String myCheckName(String string)
                          throws SQLException

Checks for any illegal characters in a SQL name. Only alpha-numeric characters and ".", "_","$","#" are allowed.

Parameters:

string - input string

Returns:

string Retruns the string if passes the check

Throws:

SQLException - An exception is thrown if the input string contains any illegal characters or exceeds the maximum length

qualifiedSQLName

public static String qualifiedSQLName(Connection conn,
                                      String name)
                               throws SQLException

Checks if the specified name is a qualified SQL name. It calls SYS.DBMS_ASSERT.qualified_sql_name function.

Parameters:

conn - the database connection

name - the input name

Returns:

string Retruns the string if passes the check

Throws:

SQLException - A SQLexception is thrown if the dbms_assert.qualified_sql_name failed

sanitizeSimpleFileName

public static String sanitizeSimpleFileName(String fileName)
                                     throws IllegalArgumentException

do sanity checking to the filename, only allowed characters can appear in the file name

Parameters:

fileName -

Returns:

String

Throws:

IllegalArgumentException

simpleSqlNameCheck

public static String simpleSqlNameCheck(Connection conn,
                                        String name)
                                 throws SQLException

This method returns the result of SYS.DBMS_ASSERT.simple_sql_name function.

Parameters:

conn - the database connection

name - the input literal

Returns:

string Retruns the output of DBMS_ASSERT.simple_sql_name if passes the check

Throws:

SQLException - A SQLexception is thrown if the dbms_assert.simple_sql_name failed