3.2. Database Management

The default configuration of Nova Orchestra uses the Database persistence service and the HSQL Database. Nova Orchestra has also been tested with Oracle and Postgres database system. To change to postgres or Oracle, you need to put the corresponding JDBC driver in the directory catalina_base/webapps/orchestra/WEB-INF/lib and modify the hibernate.properties file : uncomment the corresponding lines :

# Hibernate configuration

# For using Orchestra with HSQL 
# hibernate.dialect                      org.hibernate.dialect.HSQLDialect
# hibernate.connection.driver_class      org.hsqldb.jdbcDriver
# hibernate.connection.url               jdbc:hsqldb:file:db_orchestra
# hibernate.connection.username          sa
# hibernate.connection.password

# For using Orchestra with postgreSQL  
# hibernate.dialect                      org.hibernate.dialect.PostgreSQLDialect
# hibernate.connection.driver_class      org.postgresql.Driver
# hibernate.connection.url               jdbc:postgresql://server:port/db
# hibernate.connection.username          user
# hibernate.connection.password          pass

hibernate.dialect                      org.hibernate.dialect.HSQLDialect
hibernate.connection.driver_class      org.hsqldb.jdbcDriver
hibernate.connection.url               jdbc:hsqldb:file:db_orchestra
hibernate.connection.username          sa
hibernate.connection.password

hibernate.hbm2ddl.auto                 update
hibernate.cache.use_second_level_cache true
hibernate.cache.provider_class         org.hibernate.cache.HashtableCacheProvider
hibernate.show_sql                     false
hibernate.format_sql                   false
hibernate.use_sql_comments             false
hibernate.bytecode.use_reflection_optimizer true