Although jUDDI contains a SQL script for MySQL, basic knowledge of administrating a MySQL database is needed for understanding the following section.
create database juddion the MySQL command line
\. juddi_mysql.ddlon the MySQL command line. The juddi_mysql.ddl file is located in the judd/ddl directory. It contains create table-statements for the jUDDI database. It can be run multiple times, because it has a bunch of drop table-statements at the beginning. Be careful! If you run the script again after the installation is complete, all your data will be lost! These drop table-statements cause error messages when you run the script for the first time. This is normal and no reason to worry.
You have two choices on how to make the UDDI database available to Java. The preferred option is to install the pure Java MySQL JDBC driver. The alternative option is to install the MySQL ODBC driver and connect to MySQL using the JDBC-ODBC bridge.
If you are using the JDBC driver:
localhostwith the appropriate machine name in the juddi.properties file.
If you decide to use the ODBC driver:
You will have to change the juddi.properties file, if you use the ODBC driver. A short explanation how to do this is in the jUDDI section on the HowTo page. jUDDI is preconfigured to use the JDBC MySQL driver. If you have problems setting up the ODBC connection, consult the MySQL manual or a JDBC manual.