1 Reply Latest reply on Apr 11, 2003 3:28 AM by Erwin Brinkhuis

    Setup second hsql datasource

    Erwin Brinkhuis Newbie

      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