Uploaded image for project: 'Pentaho Data Integration - Kettle'
  1. Pentaho Data Integration - Kettle
  2. PDI-7586

When using a (native) JDBC oracle connection and setting the commit size to over 65535 lines will be omitted and NOT written

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: Medium
    • Resolution: Incomplete
    • Affects Version/s: 4.2.1 (4.1.0 GA Suite Release)
    • Fix Version/s: Backlog
    • Component/s: Database
    • Labels:
      None
    • Environment:
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.

      Description

      Bug occurs when:
      -writting more then 65535 lines in a transformation
      -connection used set to Oracle - Native (JDBC) and commit size > 65535 (no other options specified but the connection settings)

      Behavior:
      (commit size > 65535)
      -when less then or exactly 65535 should be written, all lines get written
      -when exactly 65536 lines should be written, kettle hangs
      -when more then 65536 lines should be written, lines get omited

      (more then 65536 lines should be written)
      -when the commit size is set to exactly 65535 all lines get written
      -when the commit size is set to exactly 65536 kettle hangs
      -when the commit size is larger then 65536 lines get omitted

      There is no hint of that happening, no errors issued whatsoever. This seems to be specific to Oracle, MySQL - InnoDB works with a greater commit size.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              jstrasse Jan Straßenburg
            • Votes:
              1 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: