-
1. Re: can not connect esb to uddi database in hsqldb
rtajada Apr 17, 2009 8:30 AM (in response to rtajada)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
tcunning Apr 17, 2009 2:19 PM (in response to rtajada)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
rtajada Apr 23, 2009 11:15 PM (in response to rtajada)ok, it's now ok.
i only update de uddi4j.jar in the uddi browser lib and it works fine.