Andreas Hess // Computer // UDDI // DB2
Although jUDDI contains a SQL script for DB2, basic knowledge of administrating a DB2 database is needed for understanding the following section.
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.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.