Uploaded image for project: 'WildFly'
  1. WildFly
  2. WFLY-15583

Adjust sql statements during initialization of DatabaseTimerPersistence

XMLWordPrintable

      DatabaseTimerPersistence currently holds both portable and vendor-specific sql statements. When performing any database access, it tries to look up a vendor-specific sql statement, and then the portable one, so that the more optimized vendor-specific one has precedence.

      Since a database type, once determined, is unlikely to change during the life time of a DatabaseTimerPersistence, we should be able to normalize all sql statements using the standard key, removing those sql statements (either portable ones or vendor-specific ones) from the cache. Any database access can directly look up by the standard key to get the most appropriate sql statement.

            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: