Does optaweb-employee-rostering support mssql

190 Views Asked by At

I'm just wondering if the app supports mssql. I found datasource configuration for H2 and PostgreSQL but non for other datasources supported by Quarkus.

1

There are 1 best solutions below

4
On

Optaweb-employee-rostering is a rich example application that shows how the employee rostering problem can be solved with OptaPlanner. As such, users are expected to take inspiration from it and change the app as they need.

If you want to try the app with MS SQL, replace a JDBC driver dependency: https://github.com/kiegroup/optaweb-employee-rostering/blob/main/optaweb-employee-rostering-backend/pom.xml#L81-L84

and change the Quarkus profile: https://github.com/kiegroup/optaweb-employee-rostering/blob/main/optaweb-employee-rostering-backend/src/main/resources/application.properties#L24-L28

The Quarkus profile can be activated during the build by specifying the quarkus.profile maven property, e.g.: mvn clean install -Dquarkus.profile=postgres