--- /dev/null
+####\r
+# This file contains the configuration for database access.\r
+# The default configuration is for development / demonstration.\r
+# You can use the default configuration for simple deployment but it is not recommended.\r
+#\r
+# Several DBMS configurations are given as examples.\r
+####\r
+\r
+##\r
+# Cache configuration\r
+##\r
+\r
+hibernate.cache.use_second_level_cache true\r
+hibernate.cache.use_query_cache true\r
+hibernate.cache.region.factory_class net.sf.ehcache.hibernate.EhCacheRegionFactory\r
+net.sf.ehcache.configurationResourceName ehcache-history.xml\r
+\r
+##\r
+# SQL Logging\r
+##\r
+hibernate.show_sql false\r
+hibernate.format_sql false\r
+hibernate.use_sql_comments false\r
+\r
+##\r
+# Bonita Search\r
+##\r
+bonita.search.use true\r
+hibernate.search.default.indexBase ${BONITA_HOME}/server/default/work/indexes/history\r
+\r
+##\r
+# Bonita Tables\r
+##\r
+hibernate.hbm2ddl.auto update\r
+\r
+####################################\r
+# Database connection #\r
+####################################\r
+\r
+##\r
+# Default: H2 on filesystem\r
+##\r
+\r
+hibernate.dialect org.hibernate.dialect.H2Dialect\r
+hibernate.connection.shutdown true\r
+# Using an interceptor can change the database behaviour. \r
+# By default, an interceptor is defined to order the result of queries by adding null values at the end.\r
+# It is possible to define another interceptor.\r
+bonita.hibernate.interceptor org.ow2.bonita.env.interceptor.H2DescNullFirstInterceptor\r
+\r
+# The following properties must be commented out for deployment using datasource (e.g. when using bundles provided by BonitaSoft)\r
+hibernate.connection.driver_class org.h2.Driver\r
+hibernate.connection.url jdbc:h2:file:${BONITA_HOME}/server/default/work/databases/bonita_history.db;FILE_LOCK=NO;MVCC=TRUE;DB_CLOSE_ON_EXIT=TRUE\r
+hibernate.connection.username bonita\r
+hibernate.connection.password bpm\r
+\r
+##\r
+# Alternate databases configuration.\r
+# To use another database, please comment out the previous section (Default: H2 on filesystem), then uncomment \r
+# a configuration provided below.\r
+# In the production environment, you might use datasource capabilities provided by the web container.\r
+##\r
+\r
+##\r
+# HSQL\r
+\r
+#hibernate.dialect org.hibernate.dialect.HSQLDialect\r
+#hibernate.connection.shutdown true\r
+\r
+# The following properties must be commented out for deployment using datasource (e.g. when using bundles provided by BonitaSoft)\r
+#hibernate.connection.driver_class org.hsqldb.jdbcDriver\r
+#hibernate.connection.url jdbc:hsqldb:file:${BONITA_HOME}/server/default/work/databases/bonita_history.db;shutdown=true\r
+#hibernate.connection.username bonita\r
+#hibernate.connection.password bpm\r
+\r
+\r
+##\r
+# POSTGRESQL\r
+\r
+#hibernate.dialect org.hibernate.dialect.PostgreSQLDialect\r
+#hibernate.connection.shutdown true\r
+\r
+# The following properties must be commented out for deployment using datasource (e.g. when using bundles provided by BonitaSoft)\r
+#hibernate.connection.driver_class org.postgresql.Driver\r
+#hibernate.connection.url jdbc:postgresql://localhost:5433/bonita_history\r
+#hibernate.connection.username bonita\r
+#hibernate.connection.password bpm\r
+\r
+\r
+##\r
+# MYSQL\r
+\r
+#hibernate.dialect org.hibernate.dialect.MySQL5InnoDBDialect\r
+#hibernate.connection.shutdown true\r
+#bonita.hibernate.interceptor org.ow2.bonita.env.interceptor.MySQLDescNullFirstInterceptor\r
+\r
+# The following properties must be commented out for deployment using datasource (e.g. when using bundles provided by BonitaSoft)\r
+#hibernate.connection.driver_class com.mysql.jdbc.Driver\r
+#hibernate.connection.url jdbc:mysql://localhost:3306/bonita_history?dontTrackOpenResources=true\r
+#hibernate.connection.username bonita\r
+#hibernate.connection.password bpm\r
+\r
+\r
+\r
+##\r
+# ORACLE\r
+\r
+#hibernate.dialect org.hibernate.dialect.Oracle10gDialect\r
+#hibernate.connection.shutdown true\r
+\r
+# The following properties must be commented out for deployment using datasource (e.g. when using bundles provided by BonitaSoft)\r
+#hibernate.connection.driver_class oracle.jdbc.OracleDriver\r
+#hibernate.connection.url jdbc:oracle:thin:@localhost:1521:XE\r
+#hibernate.connection.username bonitahistory\r
+#hibernate.connection.password bpm\r
+\r
+\r
+##\r
+# SQLSERVER\r
+\r
+#hibernate.dialect org.hibernate.dialect.SQLServerDialect\r
+#hibernate.connection.shutdown true\r
+#bonita.hibernate.interceptor org.ow2.bonita.env.interceptor.MSSQLServerDescNullsFirstInterceptor\r
+\r
+# The following properties must be commented out for deployment using datasource (e.g. when using bundles provided by BonitaSoft)\r
+#hibernate.connection.driver_class net.sourceforge.jtds.jdbc.Driver\r
+#hibernate.connection.url jdbc:jtds:sqlserver:/192.168.1.210:1433/bonita_history\r
+#hibernate.connection.username bonita\r
+#hibernate.connection.password bpm\r
+\r
+\r
+#############################\r
+# Datasource configuration #\r
+#############################\r
+\r
+##\r
+# Tomcat\r
+\r
+#hibernate.connection.datasource java:/comp/env/bonita/default/history\r