pefernan opened a new issue, #7004:
URL: https://github.com/apache/incubator-kie/issues/7004

   Investigate if there's a better way to configure `Flyway` in order to 
improve the DDBB initialization when using collocating different kogito 
subsystems (apps) with the runtime.
   
   Right now, if we colocate different subsystems with the runtime (audit, 
jobs, data-index-persistence) `Flyway` initializes the DDBB in a single 
instalation mixing all the subsystems sql (ordering by script version) and 
storing the registry in a single table. At this point it has some 
inconveniences:
   - Possible classghes if different subsistems define script using the same 
version in the name.
   - if all scripts are installed in the same location (`db/migrations`) 
they'll be automatically loaded, so not possible to separate subsystem 
installations
   - if subsistems store scripts in different locations the kogito app needs a 
complex `Flyway` config in the `application.properties` 
(`quarkus.flyway.locations=classpath:/db/migration,classpath:/db/jobs-service,classpath:/db/data-audit/postgresql`)


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to