you have to override hibernate.cfg.xml as well in the sar file. Otherwise you get the result you see. You could also change the hibernate.cfg.xml file for this, but afaik you have to do that in two places. The deployment and runtime versions are not one and the same.
Thanks for your reply.
However, there is no sar file involved. This is a single ant task, deploying a single process definition. Within this single deployment I see the problem. At the beginning hibernate is talking to my database, but midway into the deployment, hibernate starts talking to hsqldb.
midway into the deployment of a jbpm process to the appserver?
Can you post the log, version of jbpm etc...etc...etc