[esb-users] problem configuring jbossesb. help me please

[Tom Cunningham]

Hi,

I think you asked the same question on the forums - I replied. Let's 
continue investigating this issue there.

--Tom


Koxkorrita wrote:
>
> 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 manual, 
> 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:
>
> <entry key="juddi.isUseDataSource">true</entry>
>
> <entry key="juddi.dataSource">java:/juddiDB</entry>
>
> And without Datasource:
>
> <entry key="juddi.isUseDataSource">false</entry>
>
> <entry key="juddi.jdbcDriver">org.hsqldb.jdbcDriver</entry>
>
> <entry key="juddi.jdbcUrl">jdbc:hsqldb:D:\Archivos de 
> programa\jbossesb-server-4.5.GA\server\default\data\hypersonic\juddiDB</entry> 
>
>
> <entry key="juddi.jdbcUsername">sa</entry>
>
> <entry key="juddi.jdbcPassword"></entry>
>
> 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.
>
> Can you help me?
>
> Thanks
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> esb-users mailing list
> esb-users at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/esb-users
>