Class ITER_SQL

  • All Implemented Interfaces:
    IteratorFunction

    public class ITER_SQL
    extends IteratorFunctionBase2
    Iterator function SQL issues a SQL query to a database.
    • Param 1: (database): the JDBC URI of the database
    • Param 2: (sql) the SQL query;
    The following variables may be bound:
    • Output 1 .. N: value of the ith column, encoded as a boolean, float, double, integer, string, dateTimeStamp, as it best fits.
    Author:
    Omar Qawasmeh, Maxime Lefrançois
    • Field Detail

      • properties

        public static final java.util.Properties properties
    • Constructor Detail

      • ITER_SQL

        public ITER_SQL()
    • Method Detail

      • getProperties

        public static java.util.Properties getProperties()
      • getConnection

        public static java.sql.Connection getConnection​(NodeValue sql)
                                                 throws java.lang.Exception
        Throws:
        java.lang.Exception
      • getListSQL

        public static java.util.List<java.util.List<NodeValue>> getListSQL​(java.sql.Connection conn,
                                                                           NodeValue querySQL)