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

Implement JDBC ItemReader

    XMLWordPrintable

Details

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

    Description

      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"/>

      Attachments

        Issue Links

          is related to

          Feature Request - Feature requests from customers and/or users JBERET-58 Implement JDBC ItemWriter

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Resolved

          Feature Request - Feature requests from customers and/or users JBERET-264 Support Jpa Item Reader

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Resolved

          Feature Request - Feature requests from customers and/or users JBERET-307 Implement database stored procedure item reader

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Resolved

          Feature Request - Feature requests from customers and/or users JBERET-308 Implement JdbcBatchlet to execute sql statements in a batchlet

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Resolved

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: