com.ibm.di.connector.dpa.provider
Class SQLUtilities

java.lang.Object
  com.ibm.di.connector.dpa.provider.SQLUtilities

public class SQLUtilities
extends Object

Class SQLUtilities provides static methods for manipulating SQL expressions and statements.

Field Summary

static String

TYPE_VARGRAPHIC

Constructor Summary

SQLUtilities()

Method Summary

static String	formatVargraphic(String value)
static Map<String,Object>	getRowData(ResultSet resultSet, boolean ignoreFieldErrors)
static Object	getValue(String columnName, int columnType, ResultSet resultSet, boolean ignoreFieldErrors)
static void	setValue(PreparedStatement statement, int paramIndex, Object value)

Methods inherited from class java.lang.Object

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

Field Detail

TYPE_VARGRAPHIC

public static final String TYPE_VARGRAPHIC

See Also:

Constant Field Values

Constructor Detail

SQLUtilities

public SQLUtilities()

Method Detail

formatVargraphic

public static String formatVargraphic(String value)

Parameters:

value -

Returns:

String

getValue

public static Object getValue(String columnName,
                              int columnType,
                              ResultSet resultSet,
                              boolean ignoreFieldErrors)
                       throws SQLException,
                              IOException

Parameters:

columnName -

columnType -

resultSet -

ignoreFieldErrors -

Returns:

Object

Throws:

SQLException

IOException

setValue

public static void setValue(PreparedStatement statement,
                            int paramIndex,
                            Object value)
                     throws SQLException

Parameters:

statement -

paramIndex -

value -

Throws:

SQLException

getRowData

public static Map<String,Object> getRowData(ResultSet resultSet,
                                            boolean ignoreFieldErrors)
                                     throws SQLException,
                                            IOException

Parameters:

resultSet -

ignoreFieldErrors -

Returns:

Map

Throws:

SQLException

IOException