oracle.ifs.core.util

Class ColumnUtilities

java.lang.Object

oracle.ifs.core.util.ColumnUtilities

public class ColumnUtilities
extends Object

ColumnUtilities contains utilities that perform various SQL operations to obtain column information.

Author:

Dave Long

(Published)

Method Summary

Modifier and Type	Method and Description
static void	checkExistingMultivalueTable(LibrarySession session, String tableName, int dataType, int dataLength, int dataScale) Check the specified existing multivalue table to check if it compatible with the specified attribute settings.
static void	checkExistingMultivalueTable(S_LibrarySession session, String tableName, int dataType, int dataLength, int dataScale) Check the specified existing multivalue table to check if it compatible with the specified attribute settings, using a server-side session context.
static void	closeResultSet(ResultSet rset) Close a ResultSet, ignoring any Exceptions.
static void	closeStatement(Statement stmt) Close a Statement, ignoring any Exceptions.
static void	closeStatement(StatementWrapper stmt) Close a StatementWrapper, ignoring any Exceptions.
static boolean	columnExists(LibrarySession session, String tableName, String columnName) Return true if the specified column exists in the specified table.
static AttributeValueTable	getColumnInfo(Connection conn, String tableName, String columnName) Get the column info for the specified column of a table, using a JDBC Connection context.
static AttributeValueTable	getColumnInfo(IfsConnection conn, String tableName, String columnName) Get the column info for the specified column of a table, using a IfsConnection context.
static AttributeValueTable	getColumnInfo(LibrarySession session, String tableName, String columnName) Get the column info for the specified column of a table.
static AttributeValueTable	getColumnInfo(S_LibrarySession session, String tableName, String columnName) Get the column info for the specified column of a table, using a server-side session context.

Methods inherited from class java.lang.Object

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

Method Detail

columnExists

public static boolean columnExists(LibrarySession session,
                                   String tableName,
                                   String columnName)
                            throws IfsException

Return true if the specified column exists in the specified table.

Parameters:

session - the session context

tableName - the table name

columnName - the column name

Returns:

true if the column exists in the specified table

Throws:

IfsException - if the operation fails

(Unpublished)

getColumnInfo

public static AttributeValueTable getColumnInfo(LibrarySession session,
                                                String tableName,
                                                String columnName)
                                         throws IfsException

Get the column info for the specified column of a table.

Parameters:

session - the session context

tableName - the table name

columnName - the column name

Returns:

the column info table

Throws:

IfsException - if the operation fails

(Unpublished)

getColumnInfo

public static AttributeValueTable getColumnInfo(S_LibrarySession session,
                                                String tableName,
                                                String columnName)
                                         throws IfsException

Get the column info for the specified column of a table, using a server-side session context.

Parameters:

session - the session context

tableName - the table name

columnName - the column name

Returns:

the column info table

Throws:

IfsException - if the operation fails

(Unpublished)

getColumnInfo

public static AttributeValueTable getColumnInfo(IfsConnection conn,
                                                String tableName,
                                                String columnName)
                                         throws IfsException,
                                                SQLException

Get the column info for the specified column of a table, using a IfsConnection context.

Parameters:

conn - the IfsConnection context

tableName - the table name

columnName - the column name

Returns:

the column info table

Throws:

IfsException - if the operation fails

SQLException - if the operation fails

(Unpublished)

getColumnInfo

public static AttributeValueTable getColumnInfo(Connection conn,
                                                String tableName,
                                                String columnName)
                                         throws IfsException,
                                                SQLException

Get the column info for the specified column of a table, using a JDBC Connection context.

Parameters:

conn - the JDBC Connection context

tableName - the table name

columnName - the column name

Returns:

the column info table

Throws:

IfsException - if the operation fails

SQLException - if the operation fails

(Unpublished)

checkExistingMultivalueTable

public static void checkExistingMultivalueTable(LibrarySession session,
                                                String tableName,
                                                int dataType,
                                                int dataLength,
                                                int dataScale)
                                         throws IfsException

Check the specified existing multivalue table to check if it compatible with the specified attribute settings.

Parameters:

session - the session context

tableName - the table name

dataType - the data type for the map/array Attribute

dataLength - the data length

dataScale - the data scale

Throws:

IfsException - if the operation fails

(Published)

checkExistingMultivalueTable

public static void checkExistingMultivalueTable(S_LibrarySession session,
                                                String tableName,
                                                int dataType,
                                                int dataLength,
                                                int dataScale)
                                         throws IfsException

Check the specified existing multivalue table to check if it compatible with the specified attribute settings, using a server-side session context.

Parameters:

session - the session context

tableName - the table name

dataType - the data type for the map/array Attribute

dataLength - the data length

dataScale - the data scale

Throws:

IfsException - if the operation fails

(Published)

closeResultSet

public static void closeResultSet(ResultSet rset)

Close a ResultSet, ignoring any Exceptions.

Parameters:

rset - the ResultSet to close

(Unpublished)

closeStatement

public static void closeStatement(StatementWrapper stmt)

Close a StatementWrapper, ignoring any Exceptions.

Parameters:

stmt - the statement to close

(Unpublished)

closeStatement

public static void closeStatement(Statement stmt)

Close a Statement, ignoring any Exceptions.

Parameters:

stmt - the statement to close

(Unpublished)