[swats]

Why do i get this error when i run the scripts provided in C:\JBossESB\install\jUDDI-registry\sql\mysql


mysql> C:\JBossESB\install\jUDDI-registry\sql\mysql\create_database.sql
ERROR:
Unknown command '\J'.
ERROR:
Unknown command '\i'.
ERROR:
Unknown command '\j'.
--------------
C:\Program Files\MySQL\MySQL Server 6.0\bin\mysql.exe Ver 14.13 Distrib 6.0.0-a
lpha, for Win32 (ia32)

Connection id: 6
Current database:
Current user: root@localhost
SSL: Not in use
Using delimiter: ;
Server version: 6.0.0-alpha-community-nt-debug MySQL Community Server (G
PL)
Protocol version: 10
Connection: localhost via TCP/IP
Server characterset: latin1
Db characterset: latin1
Client characterset: latin1
Conn. characterset: latin1
TCP port: 3306
Uptime: 27 min 56 sec

Threads: 1 Questions: 9 Slow queries: 0 Opens: 14 Flush tables: 1 Open tabl
es: 7 Queries per second avg: %
--------------

ERROR:
Unknown command '\m'.
->

[swats]

Why does the readme in the quickstarts\helloworld_db_registration mention that "This example assumes your jUDDI registry is running in Mysql and it connects
directly to the database to register the component."

Cant hsqldb do the work of Mysql ? What is the difference in using MySQL to hsqldb ? I suppose ESB is by default configured to use hssqldb, then why this assumption. I am slightly confused. Please help.

[kurtstam]

Toby,

1. Sure you can do it manually, but just follow the steps I posted earlier and it will all happen automagically.

2. By default it is now using HSQLDB and you don't have to do anything at all for that to work.

--Kurt

[burrsutter]

"swats"

Concerning helloworld_db_registration, this question should be in its own thread since the subject of this one is "helloworld_action".

What follows is my quick response but it you would like to dig deeper let's start another thread.

JBoss ESB performs automatic UDDI registration for all services declared in the jboss-esb.xml. Almost all the quickstarts use RMI as the transport for this auto-registration. helloworld_db_registration is an example of how to perform the auto-registration by connecting directly to the database and not using RMI. If you review juddi.properties you can see it uses mysql. And the lib folder has a mysql client side connector jar in it as well.

In any case, this particular example is now very outdated and likely needs to be removed or at least updated so it doesn't confuse others.

RMI-based auto-registration is often the easiest way to go.