Setup second hsql datasource

[erwin.brinkhuis]

Sorry for creating another topic, but I want to add additional info and I seem not to be able to reply to my one topic.

> I want to setup a second hsql datasource e.g. TestDS,
> that uses an underlying database files test.*.
>
> I also want to keep the default datasource DefaultDS
> and underlying database files.
>

Some additional info:

I use JBoss 3.0.6

And maybe I should state the problem differently: I want an application-specific datasource.

I already added a jbosscmp-jdbc.xml containing the datasource tag in the META-INF.

Now, when I deploy, of course I get the error:

[ServiceController] Problem starting service jboss.j2ee:jndiName=TimeSightUser,service=EJB
org.jboss.deployment.DeploymentException: Error: can't find data source: java:/TestDS; - nested throwable: (javax.naming.NameNotFoundException: TestDS not bound)

This is obvious, because I only referred to the datasource but did not set it up.

For setting up I looked at the hsqlb-service.xml, but I don't see how to add my new TestDS.

I already queried this forum with no success and also I can't find any related info on this problem in the Administration and Development guide and JBossCMP guide.

Anyone out there who can help me out?

TIA

Erwin Brinkhuis

[erwin.brinkhuis]

Forget I asked. I already solved the problem.

Simply make a copy of hsqldb-service.xml and change the names of the mbeans etc.

I also had to change the port number, because the original port is already in use buy the default embedded hsql database.

Aparently it's not possible to share ports / sockets?