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

[PeterJ]

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#4119367

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4119367