Package com.ibm.di.connector.dpa.provider

Class SQLUtilities

  • public class SQLUtilities
extends java.lang.Object
    Class SQLUtilities provides static methods for manipulating SQL expressions and statements.

    • Field Summary

      Fields 
      Modifier and Type Field Description
      static java.lang.String TYPE_VARGRAPHIC  

    • Constructor Summary

      Constructors 
      Constructor Description
      SQLUtilities()  

    • Method Summary

      All Methods Static Methods Concrete Methods 
      Modifier and Type Method Description
      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

    • 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