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?
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?