JBossDeveloper

How do you query your HSQL database? If you are using the starter's kit without reconfiguring the HSQL datatasource to use TCP/IP and port 1701 (or some other port), you are not able to connect to it from an outside application. The only way to view what is inside then is use the JBoss JMX console. Did you look at your database that way?

Regards,
Koen

Hi,

I suggest you try Koen's suggestion first. Then if you want to try other dbs, I assumed you have already a database that you're very comfortable with and you have the ide for it. Check out the jbpm-db folder under your starter's kit and see if its supported. These are the configurations for the different databases. Jbpm relies on hibernate for its perisistence, so if you know hibernate there wont be any problem. Configuring is not really that difficult but finding where jbpm looks for configurations is. There are several posts here regarding how to do it properly. I have done it using an unconventional way so my way may not be very helpful to you.

Regards,

Elmo

Deepali,

I suspect you have indeed two different datasources running. Did you have a try looking at the contents of the default datastore using the jms-console?
To do so, open a brower and surf to http://localhost:8080/jmx-console/. Then locate the entry 'database=localDB,service=Hypersonic' and click on it. Scroll down to the 'startDatabaseManager()' method and push the 'invoke' button. The HSQL database manager opens (the window may be opened in minimized mode, so look at your windows taskbar if you are working with windows). You should be able to see the jbpm tables and retrieve the contents using plain SQL.

Regards,
Koen