invalid default database schema

[Ralf Claussnitzer]

The database schema setup files /setup/schema.sql and /setup/default.sql are not up to date with application series 1.7.

A migration script from goobi-contrib project can be used to migrate from 1.5 schema to 1.7 schema:
http://bazaar.launchpad.net/~slub.team/goobi-contrib/trunk/view/head:/db/db_migrate_153_170.sql

The setup SQL files should be updated as well.

[Matthias Ronge (matthias-ronge)]

What about integrating the generation of schema.sql in the ant build process?

An example can be found here: http://uaihebert.com/?p=32

[Ralf Claussnitzer (ralf-claussnitzer-deactivatedaccount)]

The database schema is an crucial artifact to the application. Generating it from just the hibernate mappings involves exclusive and concise usage of the hibernate framework, which is not the case. Relying on ORM tools for this is not a good solution anyway, because database changes are handled in a fuzzy manner, often depending on a specific database driver version.

I heavily advocate the use of plain SQL script for setup as well for updates.

Database migrations could be handled by tools like http://www.liquibase.org/ or http://migratedb.sourceforge.net/ (although it uses XML). Running HBM2DDL is by no means professional database change management and it's use has been discouraged by the developers from the very beginning.