JBossDeveloper

@Ronald

This is the second time that people do not know that in memory hsql databases are not shared

hmmm it was 'table' not found so it could not load the processdefinition. jBPM does not create the tables runtime (it does work though if you configure hibernate to do so on most databases). So with an in-memory db, the tables are not there, hence.....

Where did you read about the datasource not being found?

Kukeltje, I can open here the HSQL Database Manager and can see all tables created, everything is fine, all data are in the tables. The persistence works if I run my process from the jBPM Console. The data are being stored in the tables.
The problem is if I try to instance a process from the eclipse, like I described. I receive the error "couldn't find process definition 'NameOfMyProcess'". I was using all default configurations that came in the hibernate.cfg.xml.

Then I tryied to change the hibernate.cfg.xml. When I changed the hibernate.cfg.xml I received other error: "Could Not Find DataSource".
The differences from the hibernate.cfg.xml file that I was using from the hibernate.cfg.cml file that I tried now (hibernate.cfg.xml that is inside the jbpm-console.war file) are the following lines:

hibernate.cfg.xml that I was using - Receive the error: "couldn't find process definition NameofMyProcess'"

 <!-- JDBC connection properties (begin) -->
 <property name="hibernate.connection.driver_class">org.hsqldb.jdbcDriver</property>
 <property name="hibernate.connection.url">jdbc:hsqldb:mem:jbpm</property>
 <property name="hibernate.connection.username">sa</property>
 <property name="hibernate.connection.password"></property>
 <!-- JDBC connection properties (end) -->

 <property name="hibernate.cache.provider_class">org.hibernate.cache.HashtableCacheProvider</property>

 <!-- DataSource properties (begin) ===
 <property name="hibernate.connection.datasource">java:/JbpmDS</property>
 ==== DataSource properties (end) -->

 <!-- JDBC connection properties (begin) ===
 <property name="hibernate.connection.driver_class">org.hsqldb.jdbcDriver</property>
 <property name="hibernate.connection.url">jdbc:hsqldb:mem:jbpm</property>
 <property name="hibernate.connection.username">sa</property>
 <property name="hibernate.connection.password"></property>
 ==== JDBC connection properties (end) -->

 <property name="hibernate.cache.provider_class">org.hibernate.cache.HashtableCacheProvider</property>

 <!-- DataSource properties (begin) -->
 <property name="hibernate.connection.datasource">java:/JbpmDS</property>
 <!-- DataSource properties (end) -->

The problem is if I try to instance a process from the eclipse, like I described.

Thank you mputz, I will do this!

Thank to all!