Package lumis.util

Class JdbcUtil

  • public class JdbcUtil
extends Object
    Utility class for JDBC operations.
    Since:
    4.0.0
    Version:
    $Revision: 24813 $ $Date: 2022-01-19 00:05:05 -0300 (Wed, 19 Jan 2022) $

    • Constructor Detail

      • JdbcUtil

        public JdbcUtil()

    • Method Detail

      • getTimestampByDate

        public static Timestamp getTimestampByDate​(Date data)

      • generateInClause

        public static String generateInClause​(String fieldName,
                                      int numItems)
        Generates a SQL IN statement for a field. The IN statement is generated using ? for each parameter, according to the numItems argument.
        Parameters:
        fieldName - the field operand before the IN operator (e.g.: columnName or table.column).
        numItems - the number of parameters to be included in the IN statement.
        Returns:
        the SQL code fragment for the IN statement.
        Since:
        4.2.2.090330

      • generateInlineInClause

        public static String generateInlineInClause​(String fieldName,
                                            Collection<String> values)
                                     throws PortalException
        Generates a SQL IN statement for a field. The IN statement is generated using in-line value for each item, according to the values argument.
        Parameters:
        fieldName - the field operand before the IN operator (e.g.: columnName or table.column).
        values - the values to be included in the IN statement.
        Returns:
        the SQL code fragment for the IN statement.
        Throws:
        PortalException
        Since:
        10.3.0

      • setLargeFetchSize

        public static void setLargeFetchSize​(Statement statement)
                              throws SQLException
        Sets a statement's fetch size to a standard large value.
        Parameters:
        statement - the statement.
        Throws:
        SQLException - if an thrown by the JDBC driver.
        Since:
        10.0.0

      • prepareLargeTextCompareField

        public static String prepareLargeTextCompareField​(String fieldName)
        Properly convert SQL Text fields for comparisons in queries.
          The following conversions apply:
        • Oracle: to_char(fieldName)
        • MSSQL: convert(nvarchar(MAX), fieldName)
          • For all other Databases the fieldName is returned.
        Parameters:
        fieldName - the name of the field to be wrapped in the conversion statement, including the table aliases.
        Returns:
        The fieldName wrapped in the conversion statement when applicable
        Since:
        10.0.0