SQL Script for UDDI database and MySQL

Setup MySQL

Although jUDDI contains a SQL script for MySQL, basic knowledge of administrating a MySQL database is needed for understanding the following section.

• Install MySQL and create a root user.
• Create a UDDI database by typing create database juddi on the MySQL command line
• Create the UDDI database by running the SQL script for MySQL: Type \. juddi_mysql.ddl on 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.
• Create a new user called juddi which will be used by jUDDI for accessing the UDDI database
• Make sure this user has the appropriate permissions for connecting to, reading from and writing to the UDDI database.

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:

• Install the JDBC driver by putting the .jar file into your classpath
• If you are running the MySQL server not on the same machine as jUDDI, replace localhost with the appropriate machine name in the juddi.properties file.

If you decide to use the ODBC driver:

• Go to the ODBC setup (On Windows machines located in the Administrative Tools section of the Control Panel)
• Add a data source for database UDDI with alias UDDI
• Configure the data source to use user UDDI for access
• Test the connection

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.