Details
-
Fix
-
Status: Released (View Workflow)
-
Major
-
Resolution: Fixed
-
1.9.2
-
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.