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.

       

       

        1. image-2023-06-07-16-39-52-862.png
          190 kB
          Tiago Dolphine
        2. TablesInDefaultDatasource.png.png
          71 kB
          Walter Medvedeo
        3. TablesInJobsServiceDatasource.png
          67 kB
          Walter Medvedeo

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

                Created:
                Updated:
                Resolved: