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

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

public class SQLUtilities
extends java.lang.Object

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

Field Summary

static java.lang.String

TYPE_VARGRAPHIC

Constructor Summary

SQLUtilities()

Method Summary

static java.lang.String	formatVargraphic(java.lang.String value)
static java.util.Map<java.lang.String,java.lang.Object>	getRowData(java.sql.ResultSet resultSet, boolean ignoreFieldErrors)
static java.lang.Object	getValue(java.lang.String columnName, int columnType, java.sql.ResultSet resultSet, boolean ignoreFieldErrors)
static void	setValue(java.sql.PreparedStatement statement, int paramIndex, java.lang.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 java.lang.String TYPE_VARGRAPHIC

See Also:

Constant Field Values

Constructor Detail

SQLUtilities

public SQLUtilities()

Method Detail

formatVargraphic

public static java.lang.String formatVargraphic(java.lang.String value)

Parameters:

value -

Returns:

String

getValue

public static java.lang.Object getValue(java.lang.String columnName,
                                        int columnType,
                                        java.sql.ResultSet resultSet,
                                        boolean ignoreFieldErrors)
                                 throws java.sql.SQLException,
                                        java.io.IOException

Parameters:

columnName -

columnType -

resultSet -

ignoreFieldErrors -

Returns:

Object

Throws:

java.sql.SQLException

java.io.IOException

setValue

public static void setValue(java.sql.PreparedStatement statement,
                            int paramIndex,
                            java.lang.Object value)
                     throws java.sql.SQLException

Parameters:

statement -

paramIndex -

value -

Throws:

java.sql.SQLException

getRowData

public static java.util.Map<java.lang.String,java.lang.Object> getRowData(java.sql.ResultSet resultSet,
                                                                          boolean ignoreFieldErrors)
                                                                   throws java.sql.SQLException,
                                                                          java.io.IOException

Parameters:

resultSet -

ignoreFieldErrors -

Returns:

Map

Throws:

java.sql.SQLException

java.io.IOException