oracle.spatial.network.nfe.io.jdbc

Class JDBCUtils

java.lang.Object

oracle.spatial.network.nfe.io.jdbc.JDBCUtils

public class JDBCUtils
extends java.lang.Object

Utilities used by NFE to execute queries and perform common operations.

Constructor Summary

Constructors

Constructor and Description
JDBCUtils()

Method Summary

Modifier and Type	Method and Description
static <T> java.lang.String	createInSQLExpression(java.lang.String column, java.util.Collection<T> elements, boolean stringType) Creates a SQL IN expression of the form "column IN (elements)" taking care of the maximum number of elements supported in an in expression (1000).
static void	createSequence(java.sql.Connection conn, java.lang.String sequenceName, long initialValue, int increment) Creates a sequence.
static java.lang.String	createSequenceForTable(java.sql.Connection conn, java.lang.String tableName, long initialValue, int increment) Creates a sequence for a table, the name of the sequence will be the concatenation of the table name and _ID_SEQ.
static void	deleteTable(java.sql.Connection conn, java.lang.String tableName) Drops the table.
static void	execSimpleStatement(java.sql.Connection conn, java.lang.String sqlStatement) Executes the specified SQL statement using the specified connection.
static java.lang.Object	getResultSetColumnValue(java.sql.ResultSet resultSet, java.lang.String columnName, NFEAttributeType expectedType) Gets the resultSet column value of the specified column, the resultSet will get the value depending on the type.
static long	getSequenceNextValue(java.sql.Connection conn, java.lang.String seqName) Retrieves the next value from a given sequence name.
static long[]	getSequenceNextValues(java.sql.Connection conn, java.lang.String seqName, int valuesCount) Retrieves the next values from a given sequence name.
static boolean	tableExists(java.sql.Connection conn, java.lang.String tableName) Returns true if a table with the specified name already exists, false otherwise.
static void	validateSQLName(java.sql.Connection conn, java.lang.String sqlName) Validates a simple SQL name using database procedure DBMS_ASSERT.simple_sql_name.
static java.lang.Boolean[]	validateSQLNames(java.sql.Connection conn, java.lang.String[] sqlNames) Validates the list of given sql names checking that all of them are qualified sql names.

Methods inherited from class java.lang.Object

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

Constructor Detail

JDBCUtils

public JDBCUtils()

Method Detail

execSimpleStatement

public static void execSimpleStatement(java.sql.Connection conn,
                                       java.lang.String sqlStatement)
                                throws java.sql.SQLException

Executes the specified SQL statement using the specified connection.

Parameters:

conn - connection

sqlStatement - SQL statement to be executed.

Throws:

java.sql.SQLException - if an SQL exception is thrown

getSequenceNextValue

public static long getSequenceNextValue(java.sql.Connection conn,
                                        java.lang.String seqName)
                                 throws NFEIOException,
                                        java.sql.SQLException

Retrieves the next value from a given sequence name.

Parameters:

conn - connection

seqName - sequence Name

Returns:

next sequence value

Throws:

java.sql.SQLException - if an SQL exception is thrown

NFEIOException

getSequenceNextValues

public static long[] getSequenceNextValues(java.sql.Connection conn,
                                           java.lang.String seqName,
                                           int valuesCount)
                                    throws java.sql.SQLException

Retrieves the next values from a given sequence name.

Parameters:

conn - connection

seqName - sequence Name

valuesCount - number of values to retrieve

Returns:

next sequence values

Throws:

java.sql.SQLException - if an SQL exception is thrown

validateSQLName

public static void validateSQLName(java.sql.Connection conn,
                                   java.lang.String sqlName)
                            throws java.sql.SQLException

Validates a simple SQL name using database procedure DBMS_ASSERT.simple_sql_name.

Parameters:

conn - connection

sqlName - SQL name to be validated

Throws:

java.sql.SQLException - if an SQL exception is thrown

validateSQLNames

public static java.lang.Boolean[] validateSQLNames(java.sql.Connection conn,
                                                   java.lang.String[] sqlNames)
                                            throws java.sql.SQLException

Validates the list of given sql names checking that all of them are qualified sql names.

Parameters:

conn - Database connection

sqlNames - list of names to validate

Returns:

A boolean array indicating TRUE for valid names and FALSE for invalid ones.

Throws:

java.sql.SQLException - If an error occurs while executing the sql validation

createSequenceForTable

public static java.lang.String createSequenceForTable(java.sql.Connection conn,
                                                      java.lang.String tableName,
                                                      long initialValue,
                                                      int increment)
                                               throws NFEIOException,
                                                      java.sql.SQLException

Creates a sequence for a table, the name of the sequence will be the concatenation of the table name and _ID_SEQ.

Parameters:

conn - connection

tableName - table name

initialValue - initial value of the sequence

increment - sequence increment

Returns:

sequence name

Throws:

java.sql.SQLException - if an SQL exception is thrown

NFEIOException

createInSQLExpression

public static <T> java.lang.String createInSQLExpression(java.lang.String column,
                                                         java.util.Collection<T> elements,
                                                         boolean stringType)

Creates a SQL IN expression of the form "column IN (elements)" taking care of the maximum number of elements supported in an in expression (1000).

Parameters:

column - column name

elements - elements to add to SQL IN expression

stringType - true if the elements in the collection are strings false otherwise. If the elements are strings the quotes will be added

Returns:

one IN expression of the form "column IN (elements)" or two or more IN expressions of the form "column IN (elements 0 ....N ) OR column IN (elements N....M) .... OR column IN (elements X.....Y)"

getResultSetColumnValue

public static java.lang.Object getResultSetColumnValue(java.sql.ResultSet resultSet,
                                                       java.lang.String columnName,
                                                       NFEAttributeType expectedType)
                                                throws java.sql.SQLException

Gets the resultSet column value of the specified column, the resultSet will get the value depending on the type.

Parameters:

resultSet - resultSet

columnName - column

expectedType - expected type

Returns:

column value

Throws:

java.sql.SQLException - if an SQL exception is thrown

createSequence

public static void createSequence(java.sql.Connection conn,
                                  java.lang.String sequenceName,
                                  long initialValue,
                                  int increment)
                           throws NFEIOException,
                                  java.sql.SQLException

Creates a sequence.

Parameters:

conn - connection

sequenceName - name of the sequence

initialValue - initial value of the sequence

increment - sequence increment

Throws:

java.sql.SQLException - if an SQL exception is thrown

NFEIOException

tableExists

public static boolean tableExists(java.sql.Connection conn,
                                  java.lang.String tableName)
                           throws java.sql.SQLException

Returns true if a table with the specified name already exists, false otherwise.

Parameters:

conn - connection

tableName - table name

Returns:

true if a table with the specified name already exists, false otherwise

Throws:

java.sql.SQLException - if an SQL exception is thrown.

deleteTable

public static void deleteTable(java.sql.Connection conn,
                               java.lang.String tableName)
                        throws NFEIOException,
                               java.sql.SQLException

Drops the table.

Parameters:

conn - connection

tableName - name of the table to drop

Throws:

java.sql.SQLException - if an SQL exception is thrown.

NFEIOException