Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-5741 External JDBC Read Support
  3. IMPALA-13019

Add query option to keep DBCP DataSource objects in cache for longer time

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Resolved
    • Major
    • Resolution: Resolved
    • None
    • Impala 4.5.0
    • Frontend
    • None
    • ghx-label-11

    Description

      IMPALA-12910 adds a new class DataSourceObjectCache to save DBCP DataSource objects. DBCP DataSource objects hold JDBC driver. By sharing DBCP DataSource objects across multiple JDBC requests, we can avoid to load JDBC driver. Current code checks reference count for each DBCP DataSource object, and removes the cached object once reference count reaches 0.
      DBCP DataSource objects should be kept in cache even reference count reaches 0. We could add a query option to enable it. This need a working thread to periodically clean up objects which are idle for long time. Maybe separate maps to save active objects and idle objects. Query options could be passed to JDBC code in TOpenParams.

      Attachments

        Activity

          People

            wzhou Wenzhe Zhou
            wzhou Wenzhe Zhou
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: