4 Replies Latest reply on Apr 10, 2003 9:05 AM by Erwin Brinkhuis

    Setup second hsql datasource

    Erwin Brinkhuis Newbie

      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.

      Can anyone tell me how to do this, or point me to any available documentation on this subject?

      TIA,

      Erwin Brinkhuis

        • 1. Re: Setup second hsql datasource
          Erwin Brinkhuis Newbie

          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

          • 2. Re: Setup second hsql datasource
            Erwin Brinkhuis Newbie

            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

            • 3. Re: Setup second hsql datasource
              Erwin Brinkhuis Newbie

              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

              • 4. Re: Setup second hsql datasource
                Erwin Brinkhuis Newbie

                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