I would *not* use hypersonic for production. Using two datasources is nothing different than normal.
No, it's not for a production environment!
I can imagine that it's not so complicated to add a secondary datasource, but I just donÂ´t know how to do it. I've added mysql-connector-java-5.1.8-bin.jar to the jbpm-jpdl-3.2.3\server\server\jbpm\lib directory, but when I try to get the connection, I have an exception: No suitable driver found.
I'll be glad if you can help me...
Adding secondary datasources has nothing to do with jBPM, it is a JBoss AS thing. Normally you get this error if the driver is not in classpath or the driver name (classname) in the config is wrong. Please take a look in the JBoss AS documentation on how to do this.