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

Methods

Modifier and Type	Method and Description
static String	checkSQLName(String string, int maxStringLength) Checks for any illegal characters in a SQL name.
static String	enquoteColumnName(Connection conn, String columnName) Enquotes a column name.
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	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.

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

enquoteColumnName

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

Enquotes a column name.

Parameters:

conn -

columnName -

Returns:

String

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()

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

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

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