Uploaded image for project: 'JITL - JobScheduler Integrated Template Library'
  1. JITL - JobScheduler Integrated Template Library
  2. JITL-323

Provide database access layer to allow jobs to run custom SQL statements

    XMLWordPrintable

Details

    • Feature
    • Status: Released (View Workflow)
    • Minor
    • Resolution: Fixed
    • None
    • 1.11.2, 1.12

    Description

      Feature

      • The database access layer is available for individual jobs and ships with JobScheduler
      • The Java classes from the SOSHibernateConnection access layer can be used with Java classes and with scripted JavaScript jobs. See the attached job sample sos_hibernate_connection.job.xml
        • SOSHibernateConnection is a wrapper class around Hibernate that allows to access a number of DBMS. Basically this class should include the functionality of its predecessor class SOSConnection.
          • SOSHibernateConnection includes utility methods such as _GetSingle(), GetArray() etc. that allow simplified access to the result set of a query and that map complex DBMS data types to primitive data types (string, long) that are automatically converted to a scripting language such as JavaScript.
          • Support for functions such as %lower(), %upper() etc.
        • SOSHibernateConnection should be documented in the same way as its predecessor SOSConnection, see http://www.sos-berlin.com/doc/en/connection_java.pdf

      Extensions

      • For PostgreSQL a method for the COPY function should be included. The COPY function should import files to a database that are available with the client, not with the database server.
      • See attached Java sample PgSqlJdbcCopyStreamsExample.java

      Attachments

        1. PgSqlJdbcCopyStreamsExample.java
          0.6 kB
          Andreas Püschel
        2. sos_hibernate_connection.job.xml
          2 kB
          Andreas Püschel

        Issue Links

          Activity

            People

              re Robert Ehrlich
              ap Andreas Püschel
              Andreas Püschel Andreas Püschel
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: