JBoss Community

You can use a in-memory database with hsqldb.

Just put jbpm.hibernate.cfg.xml in the classpath with the following contents:

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE hibernate-configuration PUBLIC

"-//Hibernate/Hibernate Configuration DTD 3.0//EN"

"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<hibernate-configuration>

        <session-factory>

            <property name="hibernate.dialect">org.hibernate.dialect.HSQLDialect</property>

            <property name="hibernate.connection.driver_class">org.hsqldb.jdbcDriver</property>

            <property name="hibernate.connection.url">jdbc:hsqldb:mem:.</property>

            <property name="hibernate.connection.username">sa</property>

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

       

            <property name="hibernate.format_sql">true</property>

            <property name="hibernate.show_sql">true</property>

            <property name="hibernate.hbm2ddl.auto">create-drop</property>

            <mapping resource="jbpm.repository.hbm.xml" />

            <mapping resource="jbpm.execution.hbm.xml" />

            <mapping resource="jbpm.history.hbm.xml" />

            <mapping resource="jbpm.task.hbm.xml" />

            <mapping resource="jbpm.identity.hbm.xml" />

    </session-factory>

</hibernate-configuration>

I assume that you already have jbpm.cfg.xml on the classpath and that jbpm.cfg.xml includes directly or indirectly jbpm.hibernate.cfg.xml.

In my unit testing setup jbpm.cfg.xml includes jbpm.tx.hibernate.cfg.xml that then includes jbpm.hibernate.cfg.xml:

jbpm.cfg.xml

<jbpm-configuration>

[...]

     <import resource="jbpm.tx.hibernate.cfg.xml" />

[...]

     

</jbpm-configuration>

jbpm.tx.hibernate.cfg.xml (from jbpm.jar):

<jbpm-configuration>

 

  <process-engine-context>

[...]

    <hibernate-configuration>

      <cfg resource="jbpm.hibernate.cfg.xml" />    

    </hibernate-configuration>

[...]

 

</jbpm-configuration>