Configuration improvements

The following configuration improvements have been made.

Automatic detection of Hibernate dialect (#668846)

The system property hibernate.dialect of the module cmas-setup-hibernate is now automatically verified on every server startup. If the configured dialect does not match the actual database connection (e.g., after a database migration or version upgrade), ConSol CM automatically updates the system property with the detected dialect. This ensures that SQL generation always aligns with the connected database and prevents unexpected behavior caused by dialect mismatches.

Automatic correction is enabled by default. If you need to preserve a deliberately customized dialect that differs from the detected one, you can disable automatic correction by starting the server with the JVM argument -DenableCustomDialects=true. When this flag is set, the configured dialect is kept, and a corresponding notice is written to the log.

Translation cleanup script updated (#669195)

The translations_cleanup script has been updated to properly handle CLOB data types on Oracle databases.

Script execution logging (#669213)

A new system property has been added to enable detailed logging for script execution. When activated, the system records which scripts were executed and indicates whether each script was compiled on the fly or executed from cache. This helps administrators identify performance problems caused by runtime script compilation or a high number of script executions for certain user actions.

To enable the logging, set the system property script.execution.logging.enabled in the module cmas-core-server to true.