SQL Script for UDDI database and IBM DB2

Setup DB2

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

• Create the UDDI database by running the SQL script for DB2: db2 +c -stlf juddi_db2.ddl 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 named juddi, which will be used by jUDDI for accessing the UDDI database
• Make the UDDI database available to JDBC:
  • Open the Client Configuration Assistant
  • Add a data source for database juddi with alias juddi
  • Configure the data source to use user juddi for access
  • Test the connection
• You may have to issue some grant statements on the SQL command line, so that the UDDI user is allowed to select, delete etc.

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 MySQL driver, as this is the most common database. If you have problems setting up the ODBC connection, consult the DB2 manual or a JDBC manual.