The init-params value defines default properties of Hibernate, including DB URL, driver and credentials in use.

For any portals, those configurations can be overridden, depending on needs of your environment.

HSQLDB can only be used for development environments and for demonstration. In production, many databases are supported. For example, MySQL:

<component> 

   <key>org.exoplatform.services.database.HibernateService</key>

   <jmx-name>database:type=HibernateService</jmx-name>

   <type>org.exoplatform.services.database.impl.HibernateServiceImpl</type>

   <init-params>

      <properties-param>

         <name>hibernate.properties</name>

         <description>Default Hibernate Service</description>

         <property name="hibernate.show_sql" value="false"/>

         <property name="hibernate.cglib.use_reflection_optimizer" value="true"/>

         <property name="hibernate.connection.url" value="jdbc:mysql://localhost:3306/exodb?relaxAutoCommit=true&amp;amp;autoReconnect=true&amp;amp;useUnicode=true&amp;amp;characterEncoding=utf8"/>

         <property name="hibernate.connection.driver_class" value="com.mysql.jdbc.Driver"/>

         <property name="hibernate.connection.autocommit" value="true"/>

         <property name="hibernate.connection.username" value="exo"/>

         <property name="hibernate.connection.password" value="exo"/>

         <property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect"/>

         <property name="hibernate.c3p0.min_size" value="5"/>

         <property name="hibernate.c3p0.max_size" value="20"/>

         <property name="hibernate.c3p0.timeout" value="1800"/>

         <property name="hibernate.c3p0.max_statements" value="50"/>

       </properties-param>

   </init-params>

</component>