Unable to build Bookstore2 project

Support
#1

When I try to run the gradle build, I get the following error:

A problem occurred configuring root project ‘jmix-bookstore’.

Could not resolve all files for configuration ‘:widgets’.
Could not find io.jmix.maps:jmix-maps-ui-widgets:1.5.5.

I have included the folder ‘jmix-commercial-addons-demo-2.6.2’ from the jmix-enterprise-trial.zip into the root directory of the jmix-bookstore project, but it seems that these programm files are missing the requested package…

#2

Hi @peter.henzler

I did create a new IntelliJ Project from GitHub
image

and then click on debug
image

if a PostgreSQL database is installed, this runs fine.

Can you give us some information, how you come to this error ? Do you use a trial licence ?

Regards
Felix

#3

Building Locally

The application uses several commercial add-ons, so you need an active Jmix Enterprise subscription to build the application locally. You can also do it with the trial subscription by following the steps below.

First, get the jmix-commercial-addons-demo sample application. You may download it from your account page at https://store.jmix.io/.

Next, copy the trial-repository directory from the jmix-commercial-addons-demo sample project to the root of the jmix-bookstore project.

After that, modify the build.gradle file of the jmix-bookstore project: add the repository with the trial-repository directory.

repositories {
    mavenCentral()
    maven {
        url 'https://global.repo.jmix.io/repository/public'
    }
    if (file('trial_repository').exists()) {
        maven {
            url "file://${project.projectDir}/trial_repository"
        }
    } else {
        maven {
            url = 'https://global.repo.jmix.io/repository/premium'
            credentials {
                username = rootProject['premiumRepoUser']
                password = rootProject['premiumRepoPass']
            }
        }
    }
}

Note that the Bookstore project must be based on exactly the same Jmix version as the commercial add-ons sample project.

#4

I managed to solve the problem.
Somehow IntelliJ downloaded a wrong version.
I downloaded the sources manually and replaced them.
Now the build works.

But now I have another problem:
The database creation fails with the following error:

ERROR: Exception Details
ERROR: Exception Primary Class: ValidationFailedException
ERROR: Exception Primary Reason: Validierung war nicht erfolgreich:
1 Changes erf�llten die Anforderungen w�hrend der Validierung nicht
columnDataType is required for addNotNullConstraint on mssql, io/jmix/bookstore/liquibase/changelog/2023/01/24-add-order-number.xml::1::bookstore

ERROR: Exception Primary Source: 4.31.1
Validation Error:
Exception in thread “main” liquibase.exception.LiquibaseException: Unerwarteter Fehler bei der Ausf�hrung von Liquibase: Validierung war nicht erfolgreich:
1 Changes erf�llten die Anforderungen w�hrend der Validierung nicht
columnDataType is required for addNotNullConstraint on mssql, io/jmix/bookstore/liquibase/changelog/2023/01/24-add-order-number.xml::1::bookstore

#5

2025-10-10 13:40:30.820 INFO [main] [] liquibase.changelog : Change failed validation!
2025-10-10 13:40:30.829 INFO [main] [] liquibase.command : Logging exception.
2025-10-10 13:40:30.830 INFO [main] [] liquibase.ui : ERROR: Exception Details
2025-10-10 13:40:30.830 INFO [main] [] liquibase.ui : ERROR: Exception Primary Class: ValidationFailedException
2025-10-10 13:40:30.830 INFO [main] [] liquibase.ui : ERROR: Exception Primary Reason: Validierung war nicht erfolgreich:
1 Changes erfüllten die Anforderungen während der Validierung nicht
columnDataType is required for addNotNullConstraint on mssql, io/jmix/bookstore/liquibase/changelog/2023/01/24-add-order-number.xml::1::bookstore

2025-10-10 13:40:30.830 INFO [main] [] liquibase.ui : ERROR: Exception Primary Source: 4.31.1
2025-10-10 13:40:30.831 INFO [main] [] liquibase.command : Command execution complete
2025-10-10 13:40:31.415 WARN [main] [] ConfigServletWebServerApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘entityManagerFactory’ defined in class path resource [io/jmix/autoconfigure/eclipselink/EclipselinkAutoConfiguration.class]: Failed to initialize dependency ‘jmix_Liquibase’ of LoadTimeWeaverAware bean ‘entityManagerFactory’: Error creating bean with name ‘jmix_Liquibase’ defined in class path resource [io/jmix/autoconfigure/data/JmixLiquibaseAutoConfiguration.class]: liquibase.exception.CommandExecutionException: liquibase.exception.ValidationFailedException: Validierung war nicht erfolgreich:
1 Changes erfüllten die Anforderungen während der Validierung nicht
columnDataType is required for addNotNullConstraint on mssql, io/jmix/bookstore/liquibase/changelog/2023/01/24-add-order-number.xml::1::bookstore

#6

Hi @peter.henzler

I see you did change the database to MSSQL ?

This should work too; I will try it from my side.

Edit: I have this error with liquibase and MSSQL 2022 too and will check what to do. Which version of MSSQL do you have ?

Regards
Felix

#7

Hi @peter.henzler

To have a smooth and easy setup for the samples, all samples work with HSQLDB.

This complex project has the Main Data Store set to PostgreSQL.

If you change the Main Data Store, you have to

  • delete all changelog.xml files and
  • Generate Liquibase Changelog with the new Database ( I agree, the generation should automatically delete the old files himself … )

Then all is running smoothly

Regards
Felix Zehnder
Jmix DACH