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

java.sql.SQLException: Value must be between 0 and getMaxRows()

    XMLWordPrintable

Details

    • Fix
    • Status: Released (View Workflow)
    • Major
    • Resolution: Fixed
    • 1.9.7, 1.10.1
    • 1.9.8, 1.10.2, 1.11
    • None

    Description

      Current situation
      The execution from some jitl jobs ends with this error if the com.mysql.jdbc.Driver is used or this driver is in classpath.
      See sos/notification/CheckHistory failing

      This error is related to ResultSet fetch size and not to the database data and occurs before the data is read.

      Affected Jitl jobs are:

      • com.sos.jitl.extract.job.ResultSet2CSVJob
      • Reporting jobs (com.sos.jitl.reporting.*)
      • Monitoring Interface jobs (com.sos.scheduler.notification.*)

      Desired Behavior

      • com.mysql.jdbc.Driver usage is enabled for all jitl jobs
      • new job option large_result_fetch_size to set a fetch size or using of the default jdbc|hibernate settings

      Attachments

        Activity

          People

            re Robert Ehrlich
            re Robert Ehrlich
            Robert Ehrlich Robert Ehrlich
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: