Uploaded image for project: 'JBeret'
  1. JBeret
  2. JBERET-57

Implement JDBC ItemReader

XMLWordPrintable

    • Icon: Feature Request Feature Request
    • Resolution: Done
    • Icon: Major Major
    • 1.1.0.Alpha1
    • 1.1.0.Alpha1
    • jberet-support
    • None

      Implement JdbcItemReader:

      • reads data from a query
      • deserializes each data item to POJO, or Map<String, ?>, or List<Object>

      The following resultSetProperties can be optionally configured in job xml:

      • fetchSize (use driver default)
      • fetchDirection
        • FETCH_FORWARD (default)
        • FETCH_REVERSE
        • FETCH_UNKNOWN
      • resultSetType:
        • TYPE_FORWARD_ONLY (default)
        • TYPE_SCROLL_INSENSITIVE
        • TYPE_SCROLL_SENSITIVE
      • resultSetConcurrency:
        • CONCUR_READ_ONLY (default)
        • CONCUR_UPDATABLE
      • resultSetHoldability:
        • HOLD_CURSORS_OVER_COMMIT (default)
        • CLOSE_CURSORS_AT_COMMIT

      For example, specify it in job xml:

      <property name="resultSetProperties" value="fetchSize=1000, resultSetConcurrency=CONCUR_UPDATABLE"/>

              cfang@redhat.com Cheng Fang
              cfang@redhat.com Cheng Fang
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: