Uploaded image for project: 'Kogito'
  1. Kogito
  2. KOGITO-9298

Jobs Service Embedded Addon must create the jobs service tables only in the jobs-service datasource

XMLWordPrintable

    • False
    • None
    • False
    • ---
    • ---
    • 2023 Week 21-23 (from May 22), 2023 Week 24-26 (from Jun 12)

      When we use the   kogito-addons-quarkus-jobs-service-embedded, (eventually combined with the kogito-addons-quarkus-data-index-inmemory or the kogito runtimes jdbc persistence) we have the following situation:

       

      As part of the start-up procedure, the jobs service tables are created

      1) in the "default" database (i.e. the default datasource)

      2) and in the "jobs_service" database (i.e. the database created for the jobs_service datasource introduced by the jobs service embedded addon)

       

      Then, when the application is running, etc, the jobs related information is written in the tables in the jobs_service DB, which is the desired behavior.

       

      But, flyway, are updating both databases, which might introduce an issue in case the runtime persistence is enabled and we have a collision of tables, or version numbers in the xxxxx.sql files used by flyway.

       

      The correct functioning is that only the jobs_service database should be updated.

       

       

            tdolphin-1 Tiago Dolphine
            wmedvede@redhat.com Walter Medvedeo
            Marian Macik Marian Macik
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: