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