Uploaded image for project: 'JS - JobScheduler'
  1. JS - JobScheduler
  2. JS-1429

PostgreSQL driver should be 8.1-404.jdbc3.jar

    XMLWordPrintable

Details

    • Fix
    • Status: Released (View Workflow)
    • Major
    • Resolution: Fixed
    • 1.9.2
    • 1.9.3
    • None
    • None

    Description

      Current Situation

      • With release 1.9.2. a more recent postgres JBDC driver postgresql-9.4-1201-jdbc4.jar is provided that causes JobScheduler to run into the following error:
        ERROR SCHEDULER-360  Error when accessing database table SCHEDULER_ORDERS [SOS-1343  Datensatz Record_type(7 Felder) wird mit dem Feld distributed_next_time String0(2147483647) offset=(ohne Offset?) zu groß [jdbc  -id=spooler -class=org.postgresql.Driver jdbc:postgresql://xxx/xxx -user=xxx  -read-transaction %native select "ID", "PRIORITY", "STATE", "STATE_TEXT", "INITIAL_STATE", "TITLE", "CREATED_TIME", to_char(SCHEDULER_ORDERS."DISTRIBUTED_NEXT_TIME",'YYYY-MM-DD HH24:MI:SS') as distributed_next_time  from SCHEDULER_ORDERS  where "SPOOLER_ID"='xxx....]
        

      Desired Behavior

      • The PostgreSQL driver 8.1-404.jdbc3.jar is provided by the JobScheduler setup.

      Workaround

      • Remove postgresql-9.4-1201-jdbc4.jar from your ./lib/jdbc directory.
      • Download postgresql-8.1-404.jdbc3.jar from our web site and store the driver to the ./lib/jdbc directory.
      • Restart JobScheduler.

      Attachments

        Activity

          People

            oh Oliver Haufe
            ap Andreas Püschel
            Oliver Haufe Oliver Haufe
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: