[jboss-user] [Beginners Corner] - Re: How to start up multiple hsql database?

Mussie, you should have started a new post, not appended to an old post, especially not one that is almost 3 years old. It has been a while since I used multiple hsqldb database, bit is I recall correctly, to do so I made a copy of hsqldb-ds.xml (for example, as hsqldb2-ds.xml), and change these lines: <jndi-name>OtherDS</jndi-name> | <connection-url>jdbc:hsqldb:${jboss.server.data.dir}${/}hypersonic${/}otherDB</connection-url> | Then in my code I used OtherDS to look up the datasource in JNDI. Personally, I would not bother with hsqldb and would use MySQL or PostgreSQL instead. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4119367#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...