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

Support query with limit in jdbc job repository

    XMLWordPrintable

    Details

    • Type: Enhancement
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: jberet-core
    • Labels:
      None
    • [QE] How to address?:
      ---
    • [QE] Why QE missed?:
      ---

      Description

      JobOperator contains method to retrieve certain number of job data from the underlying job repository. When implement this in jdbc job repository, jberet currently retrieves all results from db, and get the subset as specified in JobOperator method. This can be slow or even blocking if a job repository contains large number of job data accumulated over time.

      jdbc job repository should be able to get the required number of rows from db, by including the limit clause in the query. No all database products implement the portable way of specifying query limit, so ideally we should have slightly different sql statement for different db product. Currently jberet only includes a single shared jberet-sql.properties file.

        Attachments

          Activity

            People

            Assignee:
            cfang Cheng Fang
            Reporter:
            cfang Cheng Fang
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated: