3 Replies Latest reply on Apr 23, 2009 11:15 PM by Roberto Tajada

    can not connect esb to uddi database in hsqldb

    Roberto Tajada Newbie

      We’re trying to configure one jbossesb.

      It’s installed and working (the samples Works fine).
      The problem is when we try to configure the registry. By the manua, we’re trying to use scout+juddi by soap.

      queryManagerURI =http://localhost:8080/juddi/inquiry
      lifeCycleManagerURI= http://localhost:8080/juddi/publish
      transportClass=org.apache.ws.scout.transport.AxisTransport

      We see the dataBase operative in
      jdbc:hsqldb:D:\Archivos de programa\jbossesb-server-4.5.GA\server\default\data\hypersonic\juddiDB

      User=�sa�
      Pwd=��

      We’ve tried to connect in the esb.juddi.xml with datasource:
      true
      java:/juddiDB

      And without Datasource:
      false
      org.hsqldb.jdbcDriver
      jdbc:hsqldb:D:\Archivos de programa\jbossesb-server-4.5.GA\server\default\data\hypersonic\juddiDB
      sa


      The problem is when we try to connect with uddiBrowser. We configure the uddiRegistry and then we make a search.
      The error is:
      09:48:47,397 ERROR [FindBusinessFunction] java.sql.SQLException: Table not found in statement [SELECT B.BUSINESS_KEY,B.LAST_UPDATE,N.NAME FROM BUSINES
      S_ENTITY B,BUSINESS_NAME N WHERE B.BUSINESS_KEY = N.BUSINESS_KEY AND ((UPPER(NAME) LIKE ?)) ORDER BY N.NAME ASC,B.LAST_UPDATE DESC]

      We see the same error in the uddiBrowser console and in the jboss console. So it connects. The problema is that the ESB and the DS isn’t connected.
      Any help?

      In the jboss console we see the dataBase and we can open de hsqldbmanager, and we see the tables.

      We are lost.

        • 1. Re: can not connect esb to uddi database in hsqldb
          Roberto Tajada Newbie

          We're trying to configure one jbossesb.

          It's installed and working (the samples Works fine).
          The problem is when we try to configure the registry. By the manua, we're trying to use scout+juddi by soap.

          queryManagerURI =http://localhost:8080/juddi/inquiry
          lifeCycleManagerURI= http://localhost:8080/juddi/publish
          transportClass=org.apache.ws.scout.transport.AxisTransport

          We see the dataBase operative in
          jdbc:hsqldb:D:\Archivos de programa\jbossesb-server-4.5.GA\server\default\data\hypersonic\juddiDB

          User='sa'
          Pwd=''

          We've tried to connect in the esb.juddi.xml with datasource:
          true
          java:/juddiDB

          And without Datasource:
          false
          org.hsqldb.jdbcDriver
          jdbc:hsqldb:D:\Archivos de programa\jbossesb-server-4.5.GA\server\default\data\hypersonic\juddiDB
          sa


          The problem is when we try to connect with uddiBrowser. We configure the uddiRegistry and then we make a search.
          The error is:
          09:48:47,397 ERROR [FindBusinessFunction] java.sql.SQLException: Table not found in statement [SELECT B.BUSINESS_KEY,B.LAST_UPDATE,N.NAME FROM BUSINES
          S_ENTITY B,BUSINESS_NAME N WHERE B.BUSINESS_KEY = N.BUSINESS_KEY AND ((UPPER(NAME) LIKE ?)) ORDER BY N.NAME ASC,B.LAST_UPDATE DESC]

          We see the same error in the uddiBrowser console and in the jboss console. So it connects. The problema is that the ESB and the DS isn't connected.
          Any help?

          In the jboss console we see the dataBase and we can open de hsqldbmanager, and we see the tables.

          We are lost.

          • 2. Re: can not connect esb to uddi database in hsqldb
            Tom Cunningham Master

            I'm confused what's going on here. If the quickstart samples are working correct, that means that the database has been created and the registry is working okay within JBossESB.
            If you just want to use hsqldb, JBossESB is configured to use that right out of the box.

            It looks like you have changed the transport URL's - which I wouldn't particularly suggest doing unless you need to for some reason. If you end up changing that, you need to copy axis-1.4.jar and commons-discovery-0.2.jar into server/default/lib AND change your transport from LocalTransport to AxisTransport.

            What are you trying to do here?

            • 3. Re: can not connect esb to uddi database in hsqldb
              Roberto Tajada Newbie

              ok, it's now ok.
              i only update de uddi4j.jar in the uddi browser lib and it works fine.