You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@juddi.apache.org by Christina Leber <le...@ll.mit.edu> on 2006/06/21 19:54:34 UTC

Question about setting up jUDDI

Hello all,
I am trying to set up jUDDI 0.9rc4 in Tomcat 5.0 with MySQL.  I've 
gotten everything set up, however when I go to the "happyjuddi" page, 
under "DataSource Validation, I get the following:

+ Got a JNDI Context!
+ Got a JDBC DataSource (dsname=java:comp/env/jdbc/juddiDB)
- DB connection was not aquired. (Cannot load JDBC driver class 'com.microsoft.jdbc.sqlserver.SQLServerDriver')
- SELECT COUNT(*) FROM PUBLISHER failed (null)

I think I may have missed a step on this install, but I'm not sure what 
it is.  Can anyone help me out?  Thanks!
Christina

---------------------------------------------------------------------
To unsubscribe, e-mail: juddi-user-unsubscribe@ws.apache.org
For additional commands, e-mail: juddi-user-help@ws.apache.org

Re: Question about setting up jUDDI

Posted by Donald Woods <dr...@yahoo.com>.

Are you trying to use MySQL or MS SQL?  The JDBC driver is for MS SQL, 
but you mentioned using MySQL with Tomcat.....

-Donald

Christina Leber wrote:
> Hello all,
> I am trying to set up jUDDI 0.9rc4 in Tomcat 5.0 with MySQL.  I've 
> gotten everything set up, however when I go to the "happyjuddi" page, 
> under "DataSource Validation, I get the following:
> 
> + Got a JNDI Context!
> + Got a JDBC DataSource (dsname=java:comp/env/jdbc/juddiDB)
> - DB connection was not aquired. (Cannot load JDBC driver class 
> 'com.microsoft.jdbc.sqlserver.SQLServerDriver')
> - SELECT COUNT(*) FROM PUBLISHER failed (null)
> 
> I think I may have missed a step on this install, but I'm not sure what 
> it is.  Can anyone help me out?  Thanks!
> Christina
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: juddi-user-unsubscribe@ws.apache.org
> For additional commands, e-mail: juddi-user-help@ws.apache.org
> 
> 
>

Re: Question about setting up jUDDI

Posted by Christina Leber <le...@ll.mit.edu>.

Rathore,
Yes, got it now!  Thank you!
Christina

Rathore wrote:
> Hi Christina,
> By configuring jUddi.properties file I meant to change the configurations
> according to your MySQL username/password. Suppose by default the properties
> file have juddi as username and password for MySQL database, if you have
> some other credentials, you can change them in this file.
> I hope this helps.
> --
> View this message in context: http://www.nabble.com/Question-about-setting-up-jUDDI-t1825410.html#a4993834
> Sent from the jUDDI - User forum at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: juddi-user-unsubscribe@ws.apache.org
> For additional commands, e-mail: juddi-user-help@ws.apache.org
>   

---------------------------------------------------------------------
To unsubscribe, e-mail: juddi-user-unsubscribe@ws.apache.org
For additional commands, e-mail: juddi-user-help@ws.apache.org

Re: Question about setting up jUDDI

Posted by Rathore <ra...@hp.com>.

Hi Christina,
By configuring jUddi.properties file I meant to change the configurations
according to your MySQL username/password. Suppose by default the properties
file have juddi as username and password for MySQL database, if you have
some other credentials, you can change them in this file.
I hope this helps.
--
View this message in context: http://www.nabble.com/Question-about-setting-up-jUDDI-t1825410.html#a4993834
Sent from the jUDDI - User forum at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: juddi-user-unsubscribe@ws.apache.org
For additional commands, e-mail: juddi-user-help@ws.apache.org

Re: Question about setting up jUDDI

Posted by Christina Leber <le...@ll.mit.edu>.

Rathore,
Thank you very much for responding.  I'm a bit confused, though, as to 
what you meant when you said to configure the juddi.properties file "as 
per MySQL configurations".  What exactly am I supposed to change? 
Thank you,
Christina

Rathore wrote:
> Hi,
> I have created jUDDI installation guide, kindly follow the instructions to
> setup jUDDI with MySQL & tomcat. I am not able to attach this document this
> post so copy pasted the content. Let me know if you are not able to get it
> in a proper format. I will send it thru email.
>
> jUDDI Installation Guide
>
> Software Requirements:
>
> 1.	Apache Tomcat 5.5.x, installed at C:\Tomcat or some other directory
> location and set to %TOMCAT_HOME% environment variable.
> 2.	MySQL relational database installed at local or remote server.
> a.	Admin user name = root.
> b.	Password = root.
> 3.	JDBC driver should be present under %TOMCAT_HOME%\common\lib. In our case
> it will be MySQL JBDC driver.
>
>
> Installation steps:
>
> 1.	For installation on windows, download jUDDI UDDI directory server from
> http://nchc.dl.sourceforge.net/sourceforge/juddi/juddi_0.8.0_bin.zip
> 2.	Assuming you have unzipped this zip file at C:\, copy
> C:\juddi_0.8.0_bin\build\juddi.war to your %TOMCAT_HOME%\webapps application
> installation directory.
> 3.	Configure the JNDI DataSource in Tomcat by adding a declaration for your
> resource to %TOMCAT_HOME%\conf\server.xml file and add following between
> <context> or <host> XML element:
>
> <Context path="/juddi" docBase="juddi" debug="5" reloadable="true"
> crossContext="true">
> <Resource name="jdbc/juddiDB" auth="Container" type="javax.sql.DataSource"
>                maxActive="100" maxIdle="30" maxWait="10000"
>                username="root" password="root"
> driverClassName="com.mysql.jdbc.Driver"
>                url="jdbc:mysql://localhost:3306/juddi?autoReconnect=true"/>
> </Context>
>
> 4.	Modify juddi.properties file as per MySQL configurations present under
> %TOMCAT_HOME%\webapps\juddi\conf directory.
>
> 5.	Open MySQL console and execute the following SQL statements in-order to
> create some dummy entries into UDDI registry server:
>
> #########################################################################
> # MySQL/jUDDI version 1.0rc1
> #########################################################################
>
> Create database juddi;
> use juddi;
>
> #GRANT ALL ON juddi.* TO juddi@"%" IDENTIFIED BY "juddi";
> #GRANT ALL ON juddi.* TO juddi@"localhost" IDENTIFIED BY "juddi";
>
> DROP TABLE BUSINESS_DESCR;
> DROP TABLE BUSINESS_CATEGORY;
> DROP TABLE BUSINESS_IDENTIFIER;
> DROP TABLE BUSINESS_NAME;
> DROP TABLE DISCOVERY_URL;
> DROP TABLE ADDRESS_LINE;
> DROP TABLE ADDRESS;
> DROP TABLE PHONE;
> DROP TABLE EMAIL;
> DROP TABLE CONTACT_DESCR;
> DROP TABLE CONTACT;
> DROP TABLE SERVICE_DESCR;
> DROP TABLE SERVICE_CATEGORY;
> DROP TABLE SERVICE_NAME;
> DROP TABLE BINDING_DESCR;
> DROP TABLE INSTANCE_DETAILS_DESCR;
> DROP TABLE INSTANCE_DETAILS_DOC_DESCR;
> DROP TABLE TMODEL_CATEGORY;
> DROP TABLE TMODEL_DESCR;
> DROP TABLE TMODEL_DOC_DESCR;
> DROP TABLE TMODEL_IDENTIFIER;
> DROP TABLE TMODEL_INSTANCE_INFO_DESCR;
> DROP TABLE TMODEL_INSTANCE_INFO;
> DROP TABLE PUBLISHER_ASSERTION;
> DROP TABLE TMODEL;
> DROP TABLE BINDING_TEMPLATE;
> DROP TABLE BUSINESS_SERVICE;
> DROP TABLE BUSINESS_ENTITY;
> DROP TABLE PUBLISHER;
> DROP TABLE AUTH_TOKEN;
>
> CREATE TABLE BUSINESS_ENTITY
> (
>   BUSINESS_KEY VARCHAR(41) NOT NULL,
>   AUTHORIZED_NAME VARCHAR(255) NOT NULL,
>   PUBLISHER_ID VARCHAR(20) NULL,
>   OPERATOR VARCHAR(255) NOT NULL,
>   LAST_UPDATE TIMESTAMP NOT NULL,
>   PRIMARY KEY (BUSINESS_KEY)
> );
>
> CREATE TABLE BUSINESS_DESCR
> (
>   BUSINESS_KEY VARCHAR(41) NOT NULL,
>   BUSINESS_DESCR_ID INT NOT NULL,
>   LANG_CODE VARCHAR(2) NULL,
>   DESCR VARCHAR(255) NOT NULL,
>   PRIMARY KEY (BUSINESS_KEY,BUSINESS_DESCR_ID),
>   FOREIGN KEY (BUSINESS_KEY)
>     REFERENCES BUSINESS_ENTITY (BUSINESS_KEY)
> );
>
> CREATE TABLE BUSINESS_CATEGORY
> (
>   BUSINESS_KEY VARCHAR(41) NOT NULL,
>   CATEGORY_ID INT NOT NULL,
>   TMODEL_KEY_REF VARCHAR(41) NULL,
>   KEY_NAME VARCHAR(255) NULL,
>   KEY_VALUE VARCHAR(255) NOT NULL,
>   PRIMARY KEY (BUSINESS_KEY,CATEGORY_ID),
>   FOREIGN KEY (BUSINESS_KEY)
>     REFERENCES BUSINESS_ENTITY (BUSINESS_KEY)
> );
>
> CREATE TABLE BUSINESS_IDENTIFIER
> (
>   BUSINESS_KEY VARCHAR(41) NOT NULL,
>   IDENTIFIER_ID INT NOT NULL,
>   TMODEL_KEY_REF VARCHAR(41) NULL,
>   KEY_NAME VARCHAR(255) NULL,
>   KEY_VALUE VARCHAR(255) NOT NULL,
>   PRIMARY KEY (BUSINESS_KEY,IDENTIFIER_ID),
>   FOREIGN KEY (BUSINESS_KEY)
>     REFERENCES BUSINESS_ENTITY (BUSINESS_KEY)
> );
>
> CREATE TABLE BUSINESS_NAME
> (
>   BUSINESS_KEY VARCHAR(41) NOT NULL,
>   BUSINESS_NAME_ID INT NOT NULL,
>   LANG_CODE VARCHAR(2) NULL,
>   NAME VARCHAR(255) NOT NULL,
>   PRIMARY KEY (BUSINESS_KEY,BUSINESS_NAME_ID),
>   FOREIGN KEY (BUSINESS_KEY)
>     REFERENCES BUSINESS_ENTITY (BUSINESS_KEY)
> );
>
> CREATE TABLE CONTACT
> (
>   BUSINESS_KEY VARCHAR(41) NOT NULL,
>   CONTACT_ID INT NOT NULL,
>   USE_TYPE VARCHAR(255) NULL,
>   PERSON_NAME VARCHAR(255) NOT NULL,
>   PRIMARY KEY (BUSINESS_KEY,CONTACT_ID),
>   FOREIGN KEY (BUSINESS_KEY)
>     REFERENCES BUSINESS_ENTITY (BUSINESS_KEY)
> );
>
> CREATE TABLE CONTACT_DESCR
> (
>   BUSINESS_KEY VARCHAR(41) NOT NULL,
>   CONTACT_ID INT NOT NULL,
>   CONTACT_DESCR_ID INT NOT NULL,
>   LANG_CODE VARCHAR(2) NULL,
>   DESCR VARCHAR(255) NOT NULL,
>   PRIMARY KEY (BUSINESS_KEY,CONTACT_ID,CONTACT_DESCR_ID),
>   FOREIGN KEY (BUSINESS_KEY,CONTACT_ID)
>     REFERENCES CONTACT (BUSINESS_KEY,CONTACT_ID)
> );
>
> CREATE TABLE ADDRESS
> (
>   BUSINESS_KEY VARCHAR(41) NOT NULL,
>   CONTACT_ID INT NOT NULL,
>   ADDRESS_ID INT NOT NULL,
>   USE_TYPE VARCHAR(255) NULL,
>   SORT_CODE VARCHAR(10) NULL,
>   TMODEL_KEY VARCHAR(41) NULL,
>   PRIMARY KEY (BUSINESS_KEY,CONTACT_ID,ADDRESS_ID),
>   FOREIGN KEY (BUSINESS_KEY,CONTACT_ID)
>     REFERENCES CONTACT (BUSINESS_KEY,CONTACT_ID)
> );
>
> CREATE TABLE ADDRESS_LINE
> (
>   BUSINESS_KEY VARCHAR(41) NOT NULL,
>   CONTACT_ID INT NOT NULL,
>   ADDRESS_ID INT NOT NULL,
>   ADDRESS_LINE_ID INT NOT NULL,
>   LINE VARCHAR(80) NOT NULL,
>   KEY_NAME VARCHAR(255) NULL,
>   KEY_VALUE VARCHAR(255) NULL,
>   PRIMARY KEY (BUSINESS_KEY,CONTACT_ID,ADDRESS_ID,ADDRESS_LINE_ID),
>   FOREIGN KEY (BUSINESS_KEY,CONTACT_ID,ADDRESS_ID)
>     REFERENCES ADDRESS (BUSINESS_KEY,CONTACT_ID,ADDRESS_ID)
> );
>
> CREATE TABLE EMAIL
> (
>   BUSINESS_KEY VARCHAR(41) NOT NULL,
>   CONTACT_ID INT NOT NULL,
>   EMAIL_ID INT NOT NULL,
>   USE_TYPE VARCHAR(255) NULL,
>   EMAIL_ADDRESS VARCHAR(255) NOT NULL,
>   PRIMARY KEY (BUSINESS_KEY,CONTACT_ID,EMAIL_ID),
>   FOREIGN KEY (BUSINESS_KEY,CONTACT_ID)
>     REFERENCES CONTACT (BUSINESS_KEY,CONTACT_ID)
> );
>
> CREATE TABLE PHONE
> (
>   BUSINESS_KEY VARCHAR(41) NOT NULL,
>   CONTACT_ID INT NOT NULL,
>   PHONE_ID INT NOT NULL,
>   USE_TYPE VARCHAR(255) NULL,
>   PHONE_NUMBER VARCHAR(50) NOT NULL,
>   PRIMARY KEY (BUSINESS_KEY,CONTACT_ID,PHONE_ID),
>   FOREIGN KEY (BUSINESS_KEY,CONTACT_ID)
>     REFERENCES CONTACT (BUSINESS_KEY,CONTACT_ID)
> );
>
> CREATE TABLE DISCOVERY_URL
> (
>   BUSINESS_KEY VARCHAR(41) NOT NULL,
>   DISCOVERY_URL_ID INT NOT NULL,
>   USE_TYPE VARCHAR(255) NOT NULL,
>   URL VARCHAR(255) NOT NULL,
>   PRIMARY KEY (BUSINESS_KEY,DISCOVERY_URL_ID),
>   FOREIGN KEY (BUSINESS_KEY)
>     REFERENCES BUSINESS_ENTITY (BUSINESS_KEY)
> );
>
> CREATE TABLE BUSINESS_SERVICE
> (
>   BUSINESS_KEY VARCHAR(41) NOT NULL,
>   SERVICE_KEY VARCHAR(41) NOT NULL,
>   LAST_UPDATE TIMESTAMP NOT NULL,
>   PRIMARY KEY (SERVICE_KEY),
>   FOREIGN KEY (BUSINESS_KEY)
>     REFERENCES BUSINESS_ENTITY (BUSINESS_KEY)
> );
>
> CREATE TABLE SERVICE_DESCR
> (
>   SERVICE_KEY VARCHAR(41) NOT NULL,
>   SERVICE_DESCR_ID INT NOT NULL,
>   LANG_CODE VARCHAR(2) NULL,
>   DESCR VARCHAR(255) NOT NULL,
>   PRIMARY KEY (SERVICE_KEY,SERVICE_DESCR_ID),
>   FOREIGN KEY (SERVICE_KEY)
>     REFERENCES BUSINESS_SERVICE (SERVICE_KEY)
> );
>
> CREATE TABLE SERVICE_CATEGORY
> (
>   SERVICE_KEY VARCHAR(41) NOT NULL,
>   CATEGORY_ID INT NOT NULL,
>   TMODEL_KEY_REF VARCHAR(41) NULL,
>   KEY_NAME VARCHAR(255) NULL,
>   KEY_VALUE VARCHAR(255) NOT NULL,
>   PRIMARY KEY (SERVICE_KEY,CATEGORY_ID),
>   FOREIGN KEY (SERVICE_KEY)
>     REFERENCES BUSINESS_SERVICE (SERVICE_KEY)
> );
>
> CREATE TABLE SERVICE_NAME
> (
>   SERVICE_KEY VARCHAR(41) NOT NULL,
>   SERVICE_NAME_ID INT NOT NULL,
>   LANG_CODE VARCHAR(2) NULL,
>   NAME VARCHAR(255) NOT NULL,
>   PRIMARY KEY (SERVICE_KEY,SERVICE_NAME_ID),
>   FOREIGN KEY (SERVICE_KEY)
>     REFERENCES BUSINESS_SERVICE (SERVICE_KEY)
> );
>
> CREATE TABLE BINDING_TEMPLATE
> (
>   SERVICE_KEY VARCHAR(41) NOT NULL,
>   BINDING_KEY VARCHAR(41) NOT NULL,
>   ACCESS_POINT_TYPE VARCHAR(20) NULL,
>   ACCESS_POINT_URL VARCHAR(255) NULL,
>   HOSTING_REDIRECTOR VARCHAR(255) NULL,
>   LAST_UPDATE TIMESTAMP NOT NULL,
>   PRIMARY KEY (BINDING_KEY),
>   FOREIGN KEY (SERVICE_KEY)
>     REFERENCES BUSINESS_SERVICE (SERVICE_KEY)
> );
>
> CREATE TABLE BINDING_DESCR
> (
>   BINDING_KEY VARCHAR(41) NOT NULL,
>   BINDING_DESCR_ID INT NOT NULL,
>   LANG_CODE VARCHAR(2) NULL,
>   DESCR VARCHAR(255) NOT NULL,
>   PRIMARY KEY (BINDING_KEY,BINDING_DESCR_ID),
>   FOREIGN KEY (BINDING_KEY)
>     REFERENCES BINDING_TEMPLATE (BINDING_KEY)
> );
>
> CREATE TABLE TMODEL_INSTANCE_INFO
> (
>   BINDING_KEY VARCHAR(41) NOT NULL,
>   TMODEL_INSTANCE_INFO_ID INT NOT NULL,
>   TMODEL_KEY VARCHAR(41) NOT NULL,
>   OVERVIEW_URL VARCHAR(255) NULL,
>   INSTANCE_PARMS VARCHAR(255) NULL,
>   PRIMARY KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID),
>   FOREIGN KEY (BINDING_KEY)
>     REFERENCES BINDING_TEMPLATE (BINDING_KEY)
> );
>
> CREATE TABLE TMODEL_INSTANCE_INFO_DESCR
> (
>   BINDING_KEY VARCHAR(41) NOT NULL,
>   TMODEL_INSTANCE_INFO_ID INT NOT NULL,
>   TMODEL_INSTANCE_INFO_DESCR_ID INT NOT NULL,
>   LANG_CODE VARCHAR(2) NULL,
>   DESCR VARCHAR(255) NOT NULL,
>   PRIMARY KEY
> (BINDING_KEY,TMODEL_INSTANCE_INFO_ID,TMODEL_INSTANCE_INFO_DESCR_ID),
>   FOREIGN KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
>     REFERENCES TMODEL_INSTANCE_INFO (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
> );
>
> CREATE TABLE INSTANCE_DETAILS_DESCR
> (
>   BINDING_KEY VARCHAR(41) NOT NULL,
>   TMODEL_INSTANCE_INFO_ID INT NOT NULL,
>   INSTANCE_DETAILS_DESCR_ID INT NOT NULL,
>   LANG_CODE VARCHAR(2) NULL,
>   DESCR VARCHAR(255) NOT NULL,
>   PRIMARY KEY
> (BINDING_KEY,TMODEL_INSTANCE_INFO_ID,INSTANCE_DETAILS_DESCR_ID),
>   FOREIGN KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
>     REFERENCES TMODEL_INSTANCE_INFO (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
> );
>
> CREATE TABLE INSTANCE_DETAILS_DOC_DESCR
> (
>   BINDING_KEY VARCHAR(41) NOT NULL,
>   TMODEL_INSTANCE_INFO_ID INT NOT NULL,
>   INSTANCE_DETAILS_DOC_DESCR_ID INT NOT NULL,
>   LANG_CODE VARCHAR(2) NULL,
>   DESCR VARCHAR(255) NOT NULL,
>   PRIMARY KEY
> (BINDING_KEY,TMODEL_INSTANCE_INFO_ID,INSTANCE_DETAILS_DOC_DESCR_ID),
>   FOREIGN KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
>     REFERENCES TMODEL_INSTANCE_INFO (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
> );
>
> CREATE TABLE TMODEL
> (
>   TMODEL_KEY VARCHAR(41) NOT NULL,
>   AUTHORIZED_NAME VARCHAR(255) NOT NULL,
>   PUBLISHER_ID VARCHAR(20) NULL,
>   OPERATOR VARCHAR(255) NOT NULL,
>   NAME VARCHAR(255) NOT NULL,
>   OVERVIEW_URL VARCHAR(255) NULL,
>   LAST_UPDATE TIMESTAMP NOT NULL,
>   PRIMARY KEY (TMODEL_KEY)
> );
>
> CREATE TABLE TMODEL_DESCR
> (
>   TMODEL_KEY VARCHAR(41) NOT NULL,
>   TMODEL_DESCR_ID INT NOT NULL,
>   LANG_CODE VARCHAR(2) NULL,
>   DESCR VARCHAR(255) NOT NULL,
>   PRIMARY KEY (TMODEL_KEY,TMODEL_DESCR_ID),
>   FOREIGN KEY (TMODEL_KEY)
>     REFERENCES TMODEL (TMODEL_KEY)
> );
>
> CREATE TABLE TMODEL_CATEGORY
> (
>   TMODEL_KEY VARCHAR(41) NOT NULL,
>   CATEGORY_ID INT NOT NULL,
>   TMODEL_KEY_REF VARCHAR(255) NULL,
>   KEY_NAME VARCHAR(255) NULL,
>   KEY_VALUE VARCHAR(255) NOT NULL,
>   PRIMARY KEY (TMODEL_KEY,CATEGORY_ID),
>   FOREIGN KEY (TMODEL_KEY)
>     REFERENCES TMODEL (TMODEL_KEY)
> );
>
> CREATE TABLE TMODEL_IDENTIFIER
> (
>   TMODEL_KEY VARCHAR(41) NOT NULL,
>   IDENTIFIER_ID INT NOT NULL,
>   TMODEL_KEY_REF VARCHAR(255) NULL,
>   KEY_NAME VARCHAR(255) NULL,
>   KEY_VALUE VARCHAR(255) NOT NULL,
>   PRIMARY KEY (TMODEL_KEY,IDENTIFIER_ID),
>   FOREIGN KEY (TMODEL_KEY)
>     REFERENCES TMODEL (TMODEL_KEY)
> );
>
> CREATE TABLE TMODEL_DOC_DESCR
> (
>   TMODEL_KEY VARCHAR(41) NOT NULL,
>   TMODEL_DOC_DESCR_ID INT NOT NULL,
>   LANG_CODE VARCHAR(2) NULL,
>   DESCR VARCHAR(255) NOT NULL,
>   PRIMARY KEY (TMODEL_KEY,TMODEL_DOC_DESCR_ID),
>   FOREIGN KEY (TMODEL_KEY)
>     REFERENCES TMODEL (TMODEL_KEY)
> );
>
> CREATE TABLE PUBLISHER_ASSERTION
> (
>   FROM_KEY VARCHAR(41) NOT NULL,
>   TO_KEY VARCHAR(41) NOT NULL,
>   TMODEL_KEY VARCHAR(41) NOT NULL,
>   KEY_NAME VARCHAR(255) NOT NULL,
>   KEY_VALUE VARCHAR(255) NOT NULL,
>   FROM_CHECK VARCHAR(5) NOT NULL,
>   TO_CHECK VARCHAR(5) NOT NULL,
>   FOREIGN KEY (FROM_KEY) 
>     REFERENCES BUSINESS_ENTITY (BUSINESS_KEY),
>   FOREIGN KEY (TO_KEY) 
>     REFERENCES BUSINESS_ENTITY (BUSINESS_KEY) 
> );
>
> CREATE TABLE PUBLISHER
> (
>   PUBLISHER_ID VARCHAR(20) NOT NULL,
>   PUBLISHER_NAME VARCHAR(255) NOT NULL,
>   LAST_NAME VARCHAR(150) NULL,
>   FIRST_NAME VARCHAR(100) NULL,
>   MIDDLE_INIT VARCHAR(5) NULL,
>   WORK_PHONE VARCHAR(50) NULL,
>   MOBILE_PHONE VARCHAR(50) NULL,
>   PAGER VARCHAR(50) NULL,
>   EMAIL_ADDRESS VARCHAR(255) NULL,
>   ADMIN VARCHAR(5) NULL,
>   ENABLED VARCHAR(5) NULL,
>   PRIMARY KEY (PUBLISHER_ID)
> );
>
> CREATE TABLE AUTH_TOKEN
> (
>   AUTH_TOKEN VARCHAR(51) NOT NULL,
>   PUBLISHER_ID VARCHAR(20) NOT NULL,
>   PUBLISHER_NAME VARCHAR(255) NOT NULL,
>   CREATED TIMESTAMP NOT NULL,
>   LAST_USED TIMESTAMP NOT NULL,
>   NUMBER_OF_USES INT NOT NULL,
>   TOKEN_STATE INT NOT NULL,
>   PRIMARY KEY (AUTH_TOKEN)
> );
>
> INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,OPERATOR,NAME,OVERVIEW_URL)
> VALUES
> ('uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','Administrator','jUDDI.org','uddi-org:types','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#UDDItypes');
>
> INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
> VALUES ('uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4',0,'en','UDDI Type
> Taxonomy');
>  
> INSERT INTO TMODEL_DOC_DESCR
> (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
> VALUES ('uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4',0,'en','Taxonomy used to
> categorize Service Descriptions.');
>  
> INSERT INTO TMODEL_CATEGORY
> (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
> VALUES
> ('uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','categorization');
>  
> INSERT INTO TMODEL_CATEGORY
> (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
> VALUES
> ('uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','checked');
>
> INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,OPERATOR,NAME,OVERVIEW_URL)
> VALUES
> ('uuid:DB77450D-9FA8-45D4-A7BC-04411D14E384','Administrator','jUDDI.org','unspsc-org:unspsc:3-1','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#UNSPSC31');
>
> INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
> VALUES ('uuid:DB77450D-9FA8-45D4-A7BC-04411D14E384',0,'en','Product
> Taxonomy: UNSPSC (Version 3.1)');
>
> INSERT INTO TMODEL_DOC_DESCR
> (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
> VALUES ('uuid:DB77450D-9FA8-45D4-A7BC-04411D14E384',0,'en','This tModel
> defines the UNSPSC product taxonomy.');
>
> INSERT INTO TMODEL_CATEGORY
> (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
> VALUES
> ('uuid:DB77450D-9FA8-45D4-A7BC-04411D14E384',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','categorization');
>
> INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,OPERATOR,NAME,OVERVIEW_URL)
> VALUES
> ('uuid:CD153257-086A-4237-B336-6BDCBDCC6634','Administrator','jUDDI.org','unspsc-org:unspsc','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#UNSPSC');
>
> INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
> VALUES ('uuid:CD153257-086A-4237-B336-6BDCBDCC6634',0,'en','Product
> Taxonomy: UNSPSC (Version 7.3)');
>
> INSERT INTO TMODEL_DOC_DESCR
> (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
> VALUES ('uuid:CD153257-086A-4237-B336-6BDCBDCC6634',0,'en','This tModel
> defines Version 7.3 of the UNSPSC product taxonomy.');
>
> INSERT INTO TMODEL_CATEGORY
> (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
> VALUES
> ('uuid:CD153257-086A-4237-B336-6BDCBDCC6634',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','categorization');
>
> INSERT INTO TMODEL_CATEGORY
> (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
> VALUES
> ('uuid:CD153257-086A-4237-B336-6BDCBDCC6634',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','Checked');
>
> INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,OPERATOR,NAME,OVERVIEW_URL)
> VALUES
> ('uuid:C0B9FE13-179F-413D-8A5B-5004DB8E5BB2','Administrator','jUDDI.org','ntis-gov:naics:1997','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#NAICS');
>
> INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
> VALUES ('uuid:C0B9FE13-179F-413D-8A5B-5004DB8E5BB2',0,'en','Business
> Taxonomy: NAICS(1997 Release)');
>
> INSERT INTO TMODEL_DOC_DESCR
> (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
> VALUES ('uuid:C0B9FE13-179F-413D-8A5B-5004DB8E5BB2',0,'en','This tModel
> defines the NAICS industry taxonomy.');
>
> INSERT INTO TMODEL_CATEGORY
> (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
> VALUES
> ('uuid:C0B9FE13-179F-413D-8A5B-5004DB8E5BB2',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','categorization');
>
> INSERT INTO TMODEL_CATEGORY
> (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
> VALUES
> ('uuid:C0B9FE13-179F-413D-8A5B-5004DB8E5BB2',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','checked');
>
> INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,OPERATOR,NAME,OVERVIEW_URL)
> VALUES
> ('uuid:4E49A8D6-D5A2-4FC2-93A0-0411D8D19E88','Administrator','jUDDI.org','uddi-org:iso-ch:3166-1999','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#ISO3166');
>
> INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
> VALUES ('uuid:4E49A8D6-D5A2-4FC2-93A0-0411D8D19E88',0,'en','ISO 3166-1:1997
> and 3166-2:1998. Codes for names of countries and their subdivisions. Part
> 1: Country codes. Part 2:Country subdivision codes. Update newsletters
> include ISO 3166-1 V-1 (1998-02-05), V-2 (1999-10-01), ISO 3166-2 I-1
> (1998)');
>
> INSERT INTO TMODEL_DOC_DESCR
> (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
> VALUES ('uuid:4E49A8D6-D5A2-4FC2-93A0-0411D8D19E88',0,'en','Taxonomy used to
> categorize entries by geographic location.');
>
> INSERT INTO TMODEL_CATEGORY
> (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
> VALUES
> ('uuid:4E49A8D6-D5A2-4FC2-93A0-0411D8D19E88',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','categorization');
>
> INSERT INTO TMODEL_CATEGORY
> (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
> VALUES
> ('uuid:4E49A8D6-D5A2-4FC2-93A0-0411D8D19E88',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','checked');
>
> INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,OPERATOR,NAME,OVERVIEW_URL)
> VALUES
> ('uuid:A035A07C-F362-44DD-8F95-E2B134BF43B4','Administrator','jUDDI.org','uddi-org:general_keywords','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#GenKW');
>
> INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
> VALUES ('uuid:A035A07C-F362-44DD-8F95-E2B134BF43B4',0,'en','Special taxonomy
> consisting of namespace identifiers and the keywords associated with the
> namespaces');
>
> INSERT INTO TMODEL_DOC_DESCR
> (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
> VALUES ('uuid:A035A07C-F362-44DD-8F95-E2B134BF43B4',0,'en','This tModel
> defines an unidentified taxonomy.');
>
> INSERT INTO TMODEL_CATEGORY
> (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
> VALUES
> ('uuid:A035A07C-F362-44DD-8F95-E2B134BF43B4',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','categorization');
>
> INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,OPERATOR,NAME,OVERVIEW_URL)
> VALUES
> ('uuid:4064C064-6D14-4F35-8953-9652106476A9','Administrator','jUDDI.org','uddi-org:owningBusiness','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#owningBusiness');
>
> INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
> VALUES ('uuid:4064C064-6D14-4F35-8953-9652106476A9',0,'en','A pointer to a
> businessEntity that owns the tagged data.');
>
> INSERT INTO TMODEL_DOC_DESCR
> (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
> VALUES ('uuid:4064C064-6D14-4F35-8953-9652106476A9',0,'en','This tModel
> indicates the businessEntity that published or owns the tagged tModel. Used
> with tModels to establish an "owned" relationship with a registered
> businessEntity.');
>
> INSERT INTO TMODEL_CATEGORY
> (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
> VALUES
> ('uuid:4064C064-6D14-4F35-8953-9652106476A9',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','categorization');
>
> INSERT INTO TMODEL_CATEGORY
> (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
> VALUES
> ('uuid:4064C064-6D14-4F35-8953-9652106476A9',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','checked');
>
> INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,OPERATOR,NAME,OVERVIEW_URL)
> VALUES
> ('uuid:807A2C6A-EE22-470D-ADC7-E0424A337C03','Administrator','jUDDI.org','uddi-org:relationships','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#Relationships');
>
> INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
> VALUES ('uuid:807A2C6A-EE22-470D-ADC7-E0424A337C03',0,'en','Starter set
> classifications of businessEntity relationships');
>
> INSERT INTO TMODEL_DOC_DESCR
> (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
> VALUES ('uuid:807A2C6A-EE22-470D-ADC7-E0424A337C03',0,'en','This tModel is
> used to describe business relationships. Used in the publisher assertion
> messages.');
>
> INSERT INTO TMODEL_CATEGORY
> (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
> VALUES
> ('uuid:807A2C6A-EE22-470D-ADC7-E0424A337C03',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','relationship');
>
> INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,OPERATOR,NAME,OVERVIEW_URL)
> VALUES
> ('uuid:327A56F0-3299-4461-BC23-5CD513E95C55','Administrator','jUDDI.org','uddi-org:operators','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#Operators');
>
> INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
> VALUES ('uuid:327A56F0-3299-4461-BC23-5CD513E95C55',0,'en','Taxonomy for
> categorizing the businessEntity of an operator of a registry.');
>
> INSERT INTO TMODEL_DOC_DESCR
> (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
> VALUES ('uuid:327A56F0-3299-4461-BC23-5CD513E95C55',0,'en','This checked
> value set is used to identify UDDI operators.');
>
> INSERT INTO TMODEL_CATEGORY
> (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
> VALUES
> ('uuid:327A56F0-3299-4461-BC23-5CD513E95C55',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','categorization');
>
> INSERT INTO TMODEL_CATEGORY
> (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
> VALUES
> ('uuid:327A56F0-3299-4461-BC23-5CD513E95C55',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','checked');
>
> INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,OPERATOR,NAME,OVERVIEW_URL)
> VALUES
> ('uuid:E59AE320-77A5-11D5-B898-0004AC49CC1E','Administrator','jUDDI.org','uddi-org:isReplacedBy','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#IsReplacedBy');
>
> INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
> VALUES ('uuid:E59AE320-77A5-11D5-B898-0004AC49CC1E',0,'en','An identifier
> system used to point (using UDDI keys) to the tModel (or businessEntity)
> that is the logical replacement for the one in which isReplacedBy is used');
>
> INSERT INTO TMODEL_DOC_DESCR
> (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
> VALUES ('uuid:E59AE320-77A5-11D5-B898-0004AC49CC1E',0,'en','This is a
> checked value set.');
>
> INSERT INTO TMODEL_CATEGORY
> (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
> VALUES
> ('uuid:E59AE320-77A5-11D5-B898-0004AC49CC1E',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','identifier');
>
> INSERT INTO TMODEL_CATEGORY
> (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
> VALUES
> ('uuid:E59AE320-77A5-11D5-B898-0004AC49CC1E',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','checked');
>
> INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,OPERATOR,NAME,OVERVIEW_URL)
> VALUES
> ('uuid:8609C81E-EE1F-4D5A-B202-3EB13AD01823','Administrator','jUDDI.org','dnb-com:D-U-N-S','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#D-U-N-S');
>
> INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
> VALUES ('uuid:8609C81E-EE1F-4D5A-B202-3EB13AD01823',0,'en','Dun&Bradstreet
> D-U-N-S® Number');
>
> INSERT INTO TMODEL_DOC_DESCR
> (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
> VALUES ('uuid:8609C81E-EE1F-4D5A-B202-3EB13AD01823',0,'en','This tModel is
> used for the Dun&Bradstreet D-U-N-S® Number identifier.');
>
> INSERT INTO TMODEL_CATEGORY
> (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
> VALUES
> ('uuid:8609C81E-EE1F-4D5A-B202-3EB13AD01823',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','identifier');
>
> INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,OPERATOR,NAME,OVERVIEW_URL)
> VALUES
> ('uuid:B1B1BAF5-2329-43E6-AE13-BA8E97195039','Administrator','jUDDI.org','thomasregister-com:supplierID','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#Thomas');
>
> INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
> VALUES ('uuid:B1B1BAF5-2329-43E6-AE13-BA8E97195039',0,'en','Thomas Registry
> Suppliers');
>
> INSERT INTO TMODEL_DOC_DESCR
> (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
> VALUES ('uuid:B1B1BAF5-2329-43E6-AE13-BA8E97195039',0,'en','This tModel is
> used for the Thomas Register supplier identifier codes.');
>
> INSERT INTO TMODEL_CATEGORY
> (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
> VALUES
> ('uuid:B1B1BAF5-2329-43E6-AE13-BA8E97195039',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','identifier');
>
> 6.	Start your tomcat server and enter http://localhost:8080/juddi in a web
> browser. On jUDDI index page, you can click on validation link to validate
> your jUDDI installation.
>
> --
> View this message in context: http://www.nabble.com/Question-about-setting-up-jUDDI-t1825410.html#a4989052
> Sent from the jUDDI - User forum at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: juddi-user-unsubscribe@ws.apache.org
> For additional commands, e-mail: juddi-user-help@ws.apache.org
>
>   


---------------------------------------------------------------------
To unsubscribe, e-mail: juddi-user-unsubscribe@ws.apache.org
For additional commands, e-mail: juddi-user-help@ws.apache.org

Re: Question about setting up jUDDI

Posted by khiz <zu...@yahoo.com>.

hi rathore.

I am a student doing my final project in which i have to setup a web service
registry, I am new to java and jsp.

I followed your installation guide to install juddi.

I am using Tomcat 5.0.28 on windows XP, axis version 1.4 is happy. i have
installed mysql 5.0 and executed the sql script from your Installtion guide.
iam using juddi\juddi_0.8.0_bin version of juddi.

BUT happyjuddi.jsp gives me error: org.apache.jasper.JasperException: Unable
to compile class for JSP.

Actually i am confused where actually to copy the juddi what do you mean by
webapps application installation directory. (do yopu mean it
%TOMCAT_HOME%\webapps\ROOT or %TOMCAT_HOME%\webapps\juddi).

for MYSQL JDBC driver i copied mysql-connector-java-3.1.13-bin.jar to
%TOMCAT_HOME%\common\lib directory

to configure JNDI DataSource i copied the context element after the or
elements because in server.xml or is commented.

following are the full list of errors:

HTTP Status 500 -

--------------------------------------------------------------------------------

type Exception report

message

description The server encountered an internal error () that prevented it
from fulfilling this request.

exception

org.apache.jasper.JasperException: Unable to compile class for JSP

An error occurred at line: 291 in the jsp file: /juddi/happyjuddi.jsp
Generated servlet error:
E:\Apache Software Foundation\Tomcat
5.0\work\Catalina\localhost\_\org\apache\jsp\juddi\happyjuddi_jsp.java:347:
package org.juddi.util does not exist
Properties juddiProps = org.juddi.util.Config.getProperties();
^

An error occurred at line: 291 in the jsp file: /juddi/happyjuddi.jsp
Generated servlet error:
Note: E:\Apache Software Foundation\Tomcat
5.0\work\Catalina\localhost\_\org\apache\jsp\juddi\happyjuddi_jsp.java uses
unchecked or unsafe operations.

An error occurred at line: 291 in the jsp file: /juddi/happyjuddi.jsp
Generated servlet error:
Note: Recompile with -Xlint:unchecked for details.
1 error

org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:84)

org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:332)
org.apache.jasper.compiler.Compiler.generateClass(Compiler.java:412)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:472)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:451)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:439)

org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:511)

org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:295)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

If any one has idea what is going wrong please help me .

Thanks in advance.

--
View this message in context: http://www.nabble.com/Question-about-setting-up-jUDDI-tf1825410.html#a5351105
Sent from the jUDDI - User forum at Nabble.com.

Re: Question about setting up jUDDI

Posted by khiz <zu...@yahoo.com>.

thanks rathore.

now my JUDDI is HAPPY, every thing is working fine.

bye.
-- 
View this message in context: http://www.nabble.com/Question-about-setting-up-jUDDI-tf1825410.html#a5431657
Sent from the jUDDI - User forum at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: juddi-user-unsubscribe@ws.apache.org
For additional commands, e-mail: juddi-user-help@ws.apache.org

Re: Question about setting up jUDDI

Posted by Rathore <ra...@hp.com>.

Hi Khiz,
By webapps I mean tomcat's web application installation directory. Just copy
your juddi web application into tomcat/webapps directory and restart tomcat.
Access http://localhost:8080/juddi in a web browser, this should solve your
problem. 

FYI, webapps is the directory under tomcat where all web applications should
be installed. Since juddi installation is nothing but copying juddi
directory under tomcat installation directory(webapps).

--
Amit Singh Rathore
-- 
View this message in context: http://www.nabble.com/Question-about-setting-up-jUDDI-tf1825410.html#a5364243
Sent from the jUDDI - User forum at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: juddi-user-unsubscribe@ws.apache.org
For additional commands, e-mail: juddi-user-help@ws.apache.org

Re: Question about setting up jUDDI

Posted by khiz <zu...@yahoo.com>.

hi rathore.

I am a student doing my final project in which i have to setup a web service
registry, I am new to java and jsp.

I followed your installation guide to install juddi.

I am using Tomcat 5.0.28 on windows XP, axis version 1.4 is happy. i have
installed mysql 5.0 and executed the sql script from your Installtion guide.
iam using juddi\juddi_0.8.0_bin version of juddi.


BUT happyjuddi.jsp gives me error: org.apache.jasper.JasperException: Unable
to compile class for JSP. 

Actually i am confused where actually to copy the juddi what do you mean by 
webapps application installation directory. (do yopu mean it
%TOMCAT_HOME%\webapps\ROOT or %TOMCAT_HOME%\webapps\juddi). 

for MYSQL JDBC driver i copied mysql-connector-java-3.1.13-bin.jar to
%TOMCAT_HOME%\common\lib directory

to configure JNDI DataSource i copied the context element after the
<context> or <host> elements because in server.xml <context> or <host> is
commented.

following are the full list of errors:


HTTP Status 500 - 

--------------------------------------------------------------------------------

type Exception report

message 

description The server encountered an internal error () that prevented it
from fulfilling this request.

exception 

org.apache.jasper.JasperException: Unable to compile class for JSP

An error occurred at line: 291 in the jsp file: /juddi/happyjuddi.jsp
Generated servlet error:
E:\Apache Software Foundation\Tomcat
5.0\work\Catalina\localhost\_\org\apache\jsp\juddi\happyjuddi_jsp.java:347:
package org.juddi.util does not exist
    Properties juddiProps = org.juddi.util.Config.getProperties();
                                          ^


An error occurred at line: 291 in the jsp file: /juddi/happyjuddi.jsp
Generated servlet error:
Note: E:\Apache Software Foundation\Tomcat
5.0\work\Catalina\localhost\_\org\apache\jsp\juddi\happyjuddi_jsp.java uses
unchecked or unsafe operations.


An error occurred at line: 291 in the jsp file: /juddi/happyjuddi.jsp
Generated servlet error:
Note: Recompile with -Xlint:unchecked for details.
1 error




org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:84)

org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:332)
	org.apache.jasper.compiler.Compiler.generateClass(Compiler.java:412)
	org.apache.jasper.compiler.Compiler.compile(Compiler.java:472)
	org.apache.jasper.compiler.Compiler.compile(Compiler.java:451)
	org.apache.jasper.compiler.Compiler.compile(Compiler.java:439)

org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:511)

org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:295)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:802)



If any one has idea what is going wrong please help me . 

Thanks in advance.

Rathore wrote:
> 
> Hi,
> I have created jUDDI installation guide, kindly follow the instructions to
> setup jUDDI with MySQL & tomcat. I am not able to attach this document
> this post so copy pasted the content. Let me know if you are not able to
> get it in a proper format. I will send it thru email.
> 
> jUDDI Installation Guide
> 
> Software Requirements:
> 
> 1.	Apache Tomcat 5.5.x, installed at C:\Tomcat or some other directory
> location and set to %TOMCAT_HOME% environment variable.
> 2.	MySQL relational database installed at local or remote server.
> a.	Admin user name = root.
> b.	Password = root.
> 3.	JDBC driver should be present under %TOMCAT_HOME%\common\lib. In our
> case it will be MySQL JBDC driver.
> 
> 
> Installation steps:
> 
> 1.	For installation on windows, download jUDDI UDDI directory server from
> http://nchc.dl.sourceforge.net/sourceforge/juddi/juddi_0.8.0_bin.zip
> 2.	Assuming you have unzipped this zip file at C:\, copy
> C:\juddi_0.8.0_bin\build\juddi.war to your %TOMCAT_HOME%\webapps
> application installation directory.
> 3.	Configure the JNDI DataSource in Tomcat by adding a declaration for
> your resource to %TOMCAT_HOME%\conf\server.xml file and add following
> between <context> or <host> XML element:
> 
> <Context path="/juddi" docBase="juddi" debug="5" reloadable="true"
> crossContext="true">
> <Resource name="jdbc/juddiDB" auth="Container" type="javax.sql.DataSource"
>                maxActive="100" maxIdle="30" maxWait="10000"
>                username="root" password="root"
> driverClassName="com.mysql.jdbc.Driver"
>               
> url="jdbc:mysql://localhost:3306/juddi?autoReconnect=true"/>
> </Context>
> 
> 4.	Modify juddi.properties file as per MySQL configurations present under
> %TOMCAT_HOME%\webapps\juddi\conf directory.
> 
> 5.	Open MySQL console and execute the following SQL statements in-order to
> create some dummy entries into UDDI registry server:
> 
> #########################################################################
> # MySQL/jUDDI version 1.0rc1
> #########################################################################
> 
> Create database juddi;
> use juddi;
> 
> #GRANT ALL ON juddi.* TO juddi@"%" IDENTIFIED BY "juddi";
> #GRANT ALL ON juddi.* TO juddi@"localhost" IDENTIFIED BY "juddi";
> 
> DROP TABLE BUSINESS_DESCR;
> DROP TABLE BUSINESS_CATEGORY;
> DROP TABLE BUSINESS_IDENTIFIER;
> DROP TABLE BUSINESS_NAME;
> DROP TABLE DISCOVERY_URL;
> DROP TABLE ADDRESS_LINE;
> DROP TABLE ADDRESS;
> DROP TABLE PHONE;
> DROP TABLE EMAIL;
> DROP TABLE CONTACT_DESCR;
> DROP TABLE CONTACT;
> DROP TABLE SERVICE_DESCR;
> DROP TABLE SERVICE_CATEGORY;
> DROP TABLE SERVICE_NAME;
> DROP TABLE BINDING_DESCR;
> DROP TABLE INSTANCE_DETAILS_DESCR;
> DROP TABLE INSTANCE_DETAILS_DOC_DESCR;
> DROP TABLE TMODEL_CATEGORY;
> DROP TABLE TMODEL_DESCR;
> DROP TABLE TMODEL_DOC_DESCR;
> DROP TABLE TMODEL_IDENTIFIER;
> DROP TABLE TMODEL_INSTANCE_INFO_DESCR;
> DROP TABLE TMODEL_INSTANCE_INFO;
> DROP TABLE PUBLISHER_ASSERTION;
> DROP TABLE TMODEL;
> DROP TABLE BINDING_TEMPLATE;
> DROP TABLE BUSINESS_SERVICE;
> DROP TABLE BUSINESS_ENTITY;
> DROP TABLE PUBLISHER;
> DROP TABLE AUTH_TOKEN;
> 
> CREATE TABLE BUSINESS_ENTITY
> (
>   BUSINESS_KEY VARCHAR(41) NOT NULL,
>   AUTHORIZED_NAME VARCHAR(255) NOT NULL,
>   PUBLISHER_ID VARCHAR(20) NULL,
>   OPERATOR VARCHAR(255) NOT NULL,
>   LAST_UPDATE TIMESTAMP NOT NULL,
>   PRIMARY KEY (BUSINESS_KEY)
> );
> 
> CREATE TABLE BUSINESS_DESCR
> (
>   BUSINESS_KEY VARCHAR(41) NOT NULL,
>   BUSINESS_DESCR_ID INT NOT NULL,
>   LANG_CODE VARCHAR(2) NULL,
>   DESCR VARCHAR(255) NOT NULL,
>   PRIMARY KEY (BUSINESS_KEY,BUSINESS_DESCR_ID),
>   FOREIGN KEY (BUSINESS_KEY)
>     REFERENCES BUSINESS_ENTITY (BUSINESS_KEY)
> );
> 
> CREATE TABLE BUSINESS_CATEGORY
> (
>   BUSINESS_KEY VARCHAR(41) NOT NULL,
>   CATEGORY_ID INT NOT NULL,
>   TMODEL_KEY_REF VARCHAR(41) NULL,
>   KEY_NAME VARCHAR(255) NULL,
>   KEY_VALUE VARCHAR(255) NOT NULL,
>   PRIMARY KEY (BUSINESS_KEY,CATEGORY_ID),
>   FOREIGN KEY (BUSINESS_KEY)
>     REFERENCES BUSINESS_ENTITY (BUSINESS_KEY)
> );
> 
> CREATE TABLE BUSINESS_IDENTIFIER
> (
>   BUSINESS_KEY VARCHAR(41) NOT NULL,
>   IDENTIFIER_ID INT NOT NULL,
>   TMODEL_KEY_REF VARCHAR(41) NULL,
>   KEY_NAME VARCHAR(255) NULL,
>   KEY_VALUE VARCHAR(255) NOT NULL,
>   PRIMARY KEY (BUSINESS_KEY,IDENTIFIER_ID),
>   FOREIGN KEY (BUSINESS_KEY)
>     REFERENCES BUSINESS_ENTITY (BUSINESS_KEY)
> );
> 
> CREATE TABLE BUSINESS_NAME
> (
>   BUSINESS_KEY VARCHAR(41) NOT NULL,
>   BUSINESS_NAME_ID INT NOT NULL,
>   LANG_CODE VARCHAR(2) NULL,
>   NAME VARCHAR(255) NOT NULL,
>   PRIMARY KEY (BUSINESS_KEY,BUSINESS_NAME_ID),
>   FOREIGN KEY (BUSINESS_KEY)
>     REFERENCES BUSINESS_ENTITY (BUSINESS_KEY)
> );
> 
> CREATE TABLE CONTACT
> (
>   BUSINESS_KEY VARCHAR(41) NOT NULL,
>   CONTACT_ID INT NOT NULL,
>   USE_TYPE VARCHAR(255) NULL,
>   PERSON_NAME VARCHAR(255) NOT NULL,
>   PRIMARY KEY (BUSINESS_KEY,CONTACT_ID),
>   FOREIGN KEY (BUSINESS_KEY)
>     REFERENCES BUSINESS_ENTITY (BUSINESS_KEY)
> );
> 
> CREATE TABLE CONTACT_DESCR
> (
>   BUSINESS_KEY VARCHAR(41) NOT NULL,
>   CONTACT_ID INT NOT NULL,
>   CONTACT_DESCR_ID INT NOT NULL,
>   LANG_CODE VARCHAR(2) NULL,
>   DESCR VARCHAR(255) NOT NULL,
>   PRIMARY KEY (BUSINESS_KEY,CONTACT_ID,CONTACT_DESCR_ID),
>   FOREIGN KEY (BUSINESS_KEY,CONTACT_ID)
>     REFERENCES CONTACT (BUSINESS_KEY,CONTACT_ID)
> );
> 
> CREATE TABLE ADDRESS
> (
>   BUSINESS_KEY VARCHAR(41) NOT NULL,
>   CONTACT_ID INT NOT NULL,
>   ADDRESS_ID INT NOT NULL,
>   USE_TYPE VARCHAR(255) NULL,
>   SORT_CODE VARCHAR(10) NULL,
>   TMODEL_KEY VARCHAR(41) NULL,
>   PRIMARY KEY (BUSINESS_KEY,CONTACT_ID,ADDRESS_ID),
>   FOREIGN KEY (BUSINESS_KEY,CONTACT_ID)
>     REFERENCES CONTACT (BUSINESS_KEY,CONTACT_ID)
> );
> 
> CREATE TABLE ADDRESS_LINE
> (
>   BUSINESS_KEY VARCHAR(41) NOT NULL,
>   CONTACT_ID INT NOT NULL,
>   ADDRESS_ID INT NOT NULL,
>   ADDRESS_LINE_ID INT NOT NULL,
>   LINE VARCHAR(80) NOT NULL,
>   KEY_NAME VARCHAR(255) NULL,
>   KEY_VALUE VARCHAR(255) NULL,
>   PRIMARY KEY (BUSINESS_KEY,CONTACT_ID,ADDRESS_ID,ADDRESS_LINE_ID),
>   FOREIGN KEY (BUSINESS_KEY,CONTACT_ID,ADDRESS_ID)
>     REFERENCES ADDRESS (BUSINESS_KEY,CONTACT_ID,ADDRESS_ID)
> );
> 
> CREATE TABLE EMAIL
> (
>   BUSINESS_KEY VARCHAR(41) NOT NULL,
>   CONTACT_ID INT NOT NULL,
>   EMAIL_ID INT NOT NULL,
>   USE_TYPE VARCHAR(255) NULL,
>   EMAIL_ADDRESS VARCHAR(255) NOT NULL,
>   PRIMARY KEY (BUSINESS_KEY,CONTACT_ID,EMAIL_ID),
>   FOREIGN KEY (BUSINESS_KEY,CONTACT_ID)
>     REFERENCES CONTACT (BUSINESS_KEY,CONTACT_ID)
> );
> 
> CREATE TABLE PHONE
> (
>   BUSINESS_KEY VARCHAR(41) NOT NULL,
>   CONTACT_ID INT NOT NULL,
>   PHONE_ID INT NOT NULL,
>   USE_TYPE VARCHAR(255) NULL,
>   PHONE_NUMBER VARCHAR(50) NOT NULL,
>   PRIMARY KEY (BUSINESS_KEY,CONTACT_ID,PHONE_ID),
>   FOREIGN KEY (BUSINESS_KEY,CONTACT_ID)
>     REFERENCES CONTACT (BUSINESS_KEY,CONTACT_ID)
> );
> 
> CREATE TABLE DISCOVERY_URL
> (
>   BUSINESS_KEY VARCHAR(41) NOT NULL,
>   DISCOVERY_URL_ID INT NOT NULL,
>   USE_TYPE VARCHAR(255) NOT NULL,
>   URL VARCHAR(255) NOT NULL,
>   PRIMARY KEY (BUSINESS_KEY,DISCOVERY_URL_ID),
>   FOREIGN KEY (BUSINESS_KEY)
>     REFERENCES BUSINESS_ENTITY (BUSINESS_KEY)
> );
> 
> CREATE TABLE BUSINESS_SERVICE
> (
>   BUSINESS_KEY VARCHAR(41) NOT NULL,
>   SERVICE_KEY VARCHAR(41) NOT NULL,
>   LAST_UPDATE TIMESTAMP NOT NULL,
>   PRIMARY KEY (SERVICE_KEY),
>   FOREIGN KEY (BUSINESS_KEY)
>     REFERENCES BUSINESS_ENTITY (BUSINESS_KEY)
> );
> 
> CREATE TABLE SERVICE_DESCR
> (
>   SERVICE_KEY VARCHAR(41) NOT NULL,
>   SERVICE_DESCR_ID INT NOT NULL,
>   LANG_CODE VARCHAR(2) NULL,
>   DESCR VARCHAR(255) NOT NULL,
>   PRIMARY KEY (SERVICE_KEY,SERVICE_DESCR_ID),
>   FOREIGN KEY (SERVICE_KEY)
>     REFERENCES BUSINESS_SERVICE (SERVICE_KEY)
> );
> 
> CREATE TABLE SERVICE_CATEGORY
> (
>   SERVICE_KEY VARCHAR(41) NOT NULL,
>   CATEGORY_ID INT NOT NULL,
>   TMODEL_KEY_REF VARCHAR(41) NULL,
>   KEY_NAME VARCHAR(255) NULL,
>   KEY_VALUE VARCHAR(255) NOT NULL,
>   PRIMARY KEY (SERVICE_KEY,CATEGORY_ID),
>   FOREIGN KEY (SERVICE_KEY)
>     REFERENCES BUSINESS_SERVICE (SERVICE_KEY)
> );
> 
> CREATE TABLE SERVICE_NAME
> (
>   SERVICE_KEY VARCHAR(41) NOT NULL,
>   SERVICE_NAME_ID INT NOT NULL,
>   LANG_CODE VARCHAR(2) NULL,
>   NAME VARCHAR(255) NOT NULL,
>   PRIMARY KEY (SERVICE_KEY,SERVICE_NAME_ID),
>   FOREIGN KEY (SERVICE_KEY)
>     REFERENCES BUSINESS_SERVICE (SERVICE_KEY)
> );
> 
> CREATE TABLE BINDING_TEMPLATE
> (
>   SERVICE_KEY VARCHAR(41) NOT NULL,
>   BINDING_KEY VARCHAR(41) NOT NULL,
>   ACCESS_POINT_TYPE VARCHAR(20) NULL,
>   ACCESS_POINT_URL VARCHAR(255) NULL,
>   HOSTING_REDIRECTOR VARCHAR(255) NULL,
>   LAST_UPDATE TIMESTAMP NOT NULL,
>   PRIMARY KEY (BINDING_KEY),
>   FOREIGN KEY (SERVICE_KEY)
>     REFERENCES BUSINESS_SERVICE (SERVICE_KEY)
> );
> 
> CREATE TABLE BINDING_DESCR
> (
>   BINDING_KEY VARCHAR(41) NOT NULL,
>   BINDING_DESCR_ID INT NOT NULL,
>   LANG_CODE VARCHAR(2) NULL,
>   DESCR VARCHAR(255) NOT NULL,
>   PRIMARY KEY (BINDING_KEY,BINDING_DESCR_ID),
>   FOREIGN KEY (BINDING_KEY)
>     REFERENCES BINDING_TEMPLATE (BINDING_KEY)
> );
> 
> CREATE TABLE TMODEL_INSTANCE_INFO
> (
>   BINDING_KEY VARCHAR(41) NOT NULL,
>   TMODEL_INSTANCE_INFO_ID INT NOT NULL,
>   TMODEL_KEY VARCHAR(41) NOT NULL,
>   OVERVIEW_URL VARCHAR(255) NULL,
>   INSTANCE_PARMS VARCHAR(255) NULL,
>   PRIMARY KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID),
>   FOREIGN KEY (BINDING_KEY)
>     REFERENCES BINDING_TEMPLATE (BINDING_KEY)
> );
> 
> CREATE TABLE TMODEL_INSTANCE_INFO_DESCR
> (
>   BINDING_KEY VARCHAR(41) NOT NULL,
>   TMODEL_INSTANCE_INFO_ID INT NOT NULL,
>   TMODEL_INSTANCE_INFO_DESCR_ID INT NOT NULL,
>   LANG_CODE VARCHAR(2) NULL,
>   DESCR VARCHAR(255) NOT NULL,
>   PRIMARY KEY
> (BINDING_KEY,TMODEL_INSTANCE_INFO_ID,TMODEL_INSTANCE_INFO_DESCR_ID),
>   FOREIGN KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
>     REFERENCES TMODEL_INSTANCE_INFO (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
> );
> 
> CREATE TABLE INSTANCE_DETAILS_DESCR
> (
>   BINDING_KEY VARCHAR(41) NOT NULL,
>   TMODEL_INSTANCE_INFO_ID INT NOT NULL,
>   INSTANCE_DETAILS_DESCR_ID INT NOT NULL,
>   LANG_CODE VARCHAR(2) NULL,
>   DESCR VARCHAR(255) NOT NULL,
>   PRIMARY KEY
> (BINDING_KEY,TMODEL_INSTANCE_INFO_ID,INSTANCE_DETAILS_DESCR_ID),
>   FOREIGN KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
>     REFERENCES TMODEL_INSTANCE_INFO (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
> );
> 
> CREATE TABLE INSTANCE_DETAILS_DOC_DESCR
> (
>   BINDING_KEY VARCHAR(41) NOT NULL,
>   TMODEL_INSTANCE_INFO_ID INT NOT NULL,
>   INSTANCE_DETAILS_DOC_DESCR_ID INT NOT NULL,
>   LANG_CODE VARCHAR(2) NULL,
>   DESCR VARCHAR(255) NOT NULL,
>   PRIMARY KEY
> (BINDING_KEY,TMODEL_INSTANCE_INFO_ID,INSTANCE_DETAILS_DOC_DESCR_ID),
>   FOREIGN KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
>     REFERENCES TMODEL_INSTANCE_INFO (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
> );
> 
> CREATE TABLE TMODEL
> (
>   TMODEL_KEY VARCHAR(41) NOT NULL,
>   AUTHORIZED_NAME VARCHAR(255) NOT NULL,
>   PUBLISHER_ID VARCHAR(20) NULL,
>   OPERATOR VARCHAR(255) NOT NULL,
>   NAME VARCHAR(255) NOT NULL,
>   OVERVIEW_URL VARCHAR(255) NULL,
>   LAST_UPDATE TIMESTAMP NOT NULL,
>   PRIMARY KEY (TMODEL_KEY)
> );
> 
> CREATE TABLE TMODEL_DESCR
> (
>   TMODEL_KEY VARCHAR(41) NOT NULL,
>   TMODEL_DESCR_ID INT NOT NULL,
>   LANG_CODE VARCHAR(2) NULL,
>   DESCR VARCHAR(255) NOT NULL,
>   PRIMARY KEY (TMODEL_KEY,TMODEL_DESCR_ID),
>   FOREIGN KEY (TMODEL_KEY)
>     REFERENCES TMODEL (TMODEL_KEY)
> );
> 
> CREATE TABLE TMODEL_CATEGORY
> (
>   TMODEL_KEY VARCHAR(41) NOT NULL,
>   CATEGORY_ID INT NOT NULL,
>   TMODEL_KEY_REF VARCHAR(255) NULL,
>   KEY_NAME VARCHAR(255) NULL,
>   KEY_VALUE VARCHAR(255) NOT NULL,
>   PRIMARY KEY (TMODEL_KEY,CATEGORY_ID),
>   FOREIGN KEY (TMODEL_KEY)
>     REFERENCES TMODEL (TMODEL_KEY)
> );
> 
> CREATE TABLE TMODEL_IDENTIFIER
> (
>   TMODEL_KEY VARCHAR(41) NOT NULL,
>   IDENTIFIER_ID INT NOT NULL,
>   TMODEL_KEY_REF VARCHAR(255) NULL,
>   KEY_NAME VARCHAR(255) NULL,
>   KEY_VALUE VARCHAR(255) NOT NULL,
>   PRIMARY KEY (TMODEL_KEY,IDENTIFIER_ID),
>   FOREIGN KEY (TMODEL_KEY)
>     REFERENCES TMODEL (TMODEL_KEY)
> );
> 
> CREATE TABLE TMODEL_DOC_DESCR
> (
>   TMODEL_KEY VARCHAR(41) NOT NULL,
>   TMODEL_DOC_DESCR_ID INT NOT NULL,
>   LANG_CODE VARCHAR(2) NULL,
>   DESCR VARCHAR(255) NOT NULL,
>   PRIMARY KEY (TMODEL_KEY,TMODEL_DOC_DESCR_ID),
>   FOREIGN KEY (TMODEL_KEY)
>     REFERENCES TMODEL (TMODEL_KEY)
> );
> 
> CREATE TABLE PUBLISHER_ASSERTION
> (
>   FROM_KEY VARCHAR(41) NOT NULL,
>   TO_KEY VARCHAR(41) NOT NULL,
>   TMODEL_KEY VARCHAR(41) NOT NULL,
>   KEY_NAME VARCHAR(255) NOT NULL,
>   KEY_VALUE VARCHAR(255) NOT NULL,
>   FROM_CHECK VARCHAR(5) NOT NULL,
>   TO_CHECK VARCHAR(5) NOT NULL,
>   FOREIGN KEY (FROM_KEY) 
>     REFERENCES BUSINESS_ENTITY (BUSINESS_KEY),
>   FOREIGN KEY (TO_KEY) 
>     REFERENCES BUSINESS_ENTITY (BUSINESS_KEY) 
> );
> 
> CREATE TABLE PUBLISHER
> (
>   PUBLISHER_ID VARCHAR(20) NOT NULL,
>   PUBLISHER_NAME VARCHAR(255) NOT NULL,
>   LAST_NAME VARCHAR(150) NULL,
>   FIRST_NAME VARCHAR(100) NULL,
>   MIDDLE_INIT VARCHAR(5) NULL,
>   WORK_PHONE VARCHAR(50) NULL,
>   MOBILE_PHONE VARCHAR(50) NULL,
>   PAGER VARCHAR(50) NULL,
>   EMAIL_ADDRESS VARCHAR(255) NULL,
>   ADMIN VARCHAR(5) NULL,
>   ENABLED VARCHAR(5) NULL,
>   PRIMARY KEY (PUBLISHER_ID)
> );
> 
> CREATE TABLE AUTH_TOKEN
> (
>   AUTH_TOKEN VARCHAR(51) NOT NULL,
>   PUBLISHER_ID VARCHAR(20) NOT NULL,
>   PUBLISHER_NAME VARCHAR(255) NOT NULL,
>   CREATED TIMESTAMP NOT NULL,
>   LAST_USED TIMESTAMP NOT NULL,
>   NUMBER_OF_USES INT NOT NULL,
>   TOKEN_STATE INT NOT NULL,
>   PRIMARY KEY (AUTH_TOKEN)
> );
> 
> INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,OPERATOR,NAME,OVERVIEW_URL)
> VALUES
> ('uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','Administrator','jUDDI.org','uddi-org:types','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#UDDItypes');
> 
> INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
> VALUES ('uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4',0,'en','UDDI Type
> Taxonomy');
>  
> INSERT INTO TMODEL_DOC_DESCR
> (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
> VALUES ('uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4',0,'en','Taxonomy used
> to categorize Service Descriptions.');
>  
> INSERT INTO TMODEL_CATEGORY
> (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
> VALUES
> ('uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','categorization');
>  
> INSERT INTO TMODEL_CATEGORY
> (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
> VALUES
> ('uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','checked');
> 
> INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,OPERATOR,NAME,OVERVIEW_URL)
> VALUES
> ('uuid:DB77450D-9FA8-45D4-A7BC-04411D14E384','Administrator','jUDDI.org','unspsc-org:unspsc:3-1','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#UNSPSC31');
> 
> INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
> VALUES ('uuid:DB77450D-9FA8-45D4-A7BC-04411D14E384',0,'en','Product
> Taxonomy: UNSPSC (Version 3.1)');
> 
> INSERT INTO TMODEL_DOC_DESCR
> (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
> VALUES ('uuid:DB77450D-9FA8-45D4-A7BC-04411D14E384',0,'en','This tModel
> defines the UNSPSC product taxonomy.');
> 
> INSERT INTO TMODEL_CATEGORY
> (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
> VALUES
> ('uuid:DB77450D-9FA8-45D4-A7BC-04411D14E384',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','categorization');
> 
> INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,OPERATOR,NAME,OVERVIEW_URL)
> VALUES
> ('uuid:CD153257-086A-4237-B336-6BDCBDCC6634','Administrator','jUDDI.org','unspsc-org:unspsc','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#UNSPSC');
> 
> INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
> VALUES ('uuid:CD153257-086A-4237-B336-6BDCBDCC6634',0,'en','Product
> Taxonomy: UNSPSC (Version 7.3)');
> 
> INSERT INTO TMODEL_DOC_DESCR
> (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
> VALUES ('uuid:CD153257-086A-4237-B336-6BDCBDCC6634',0,'en','This tModel
> defines Version 7.3 of the UNSPSC product taxonomy.');
> 
> INSERT INTO TMODEL_CATEGORY
> (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
> VALUES
> ('uuid:CD153257-086A-4237-B336-6BDCBDCC6634',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','categorization');
> 
> INSERT INTO TMODEL_CATEGORY
> (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
> VALUES
> ('uuid:CD153257-086A-4237-B336-6BDCBDCC6634',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','Checked');
> 
> INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,OPERATOR,NAME,OVERVIEW_URL)
> VALUES
> ('uuid:C0B9FE13-179F-413D-8A5B-5004DB8E5BB2','Administrator','jUDDI.org','ntis-gov:naics:1997','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#NAICS');
> 
> INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
> VALUES ('uuid:C0B9FE13-179F-413D-8A5B-5004DB8E5BB2',0,'en','Business
> Taxonomy: NAICS(1997 Release)');
> 
> INSERT INTO TMODEL_DOC_DESCR
> (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
> VALUES ('uuid:C0B9FE13-179F-413D-8A5B-5004DB8E5BB2',0,'en','This tModel
> defines the NAICS industry taxonomy.');
> 
> INSERT INTO TMODEL_CATEGORY
> (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
> VALUES
> ('uuid:C0B9FE13-179F-413D-8A5B-5004DB8E5BB2',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','categorization');
> 
> INSERT INTO TMODEL_CATEGORY
> (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
> VALUES
> ('uuid:C0B9FE13-179F-413D-8A5B-5004DB8E5BB2',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','checked');
> 
> INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,OPERATOR,NAME,OVERVIEW_URL)
> VALUES
> ('uuid:4E49A8D6-D5A2-4FC2-93A0-0411D8D19E88','Administrator','jUDDI.org','uddi-org:iso-ch:3166-1999','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#ISO3166');
> 
> INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
> VALUES ('uuid:4E49A8D6-D5A2-4FC2-93A0-0411D8D19E88',0,'en','ISO
> 3166-1:1997 and 3166-2:1998. Codes for names of countries and their
> subdivisions. Part 1: Country codes. Part 2:Country subdivision codes.
> Update newsletters include ISO 3166-1 V-1 (1998-02-05), V-2 (1999-10-01),
> ISO 3166-2 I-1 (1998)');
> 
> INSERT INTO TMODEL_DOC_DESCR
> (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
> VALUES ('uuid:4E49A8D6-D5A2-4FC2-93A0-0411D8D19E88',0,'en','Taxonomy used
> to categorize entries by geographic location.');
> 
> INSERT INTO TMODEL_CATEGORY
> (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
> VALUES
> ('uuid:4E49A8D6-D5A2-4FC2-93A0-0411D8D19E88',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','categorization');
> 
> INSERT INTO TMODEL_CATEGORY
> (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
> VALUES
> ('uuid:4E49A8D6-D5A2-4FC2-93A0-0411D8D19E88',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','checked');
> 
> INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,OPERATOR,NAME,OVERVIEW_URL)
> VALUES
> ('uuid:A035A07C-F362-44DD-8F95-E2B134BF43B4','Administrator','jUDDI.org','uddi-org:general_keywords','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#GenKW');
> 
> INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
> VALUES ('uuid:A035A07C-F362-44DD-8F95-E2B134BF43B4',0,'en','Special
> taxonomy consisting of namespace identifiers and the keywords associated
> with the namespaces');
> 
> INSERT INTO TMODEL_DOC_DESCR
> (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
> VALUES ('uuid:A035A07C-F362-44DD-8F95-E2B134BF43B4',0,'en','This tModel
> defines an unidentified taxonomy.');
> 
> INSERT INTO TMODEL_CATEGORY
> (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
> VALUES
> ('uuid:A035A07C-F362-44DD-8F95-E2B134BF43B4',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','categorization');
> 
> INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,OPERATOR,NAME,OVERVIEW_URL)
> VALUES
> ('uuid:4064C064-6D14-4F35-8953-9652106476A9','Administrator','jUDDI.org','uddi-org:owningBusiness','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#owningBusiness');
> 
> INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
> VALUES ('uuid:4064C064-6D14-4F35-8953-9652106476A9',0,'en','A pointer to a
> businessEntity that owns the tagged data.');
> 
> INSERT INTO TMODEL_DOC_DESCR
> (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
> VALUES ('uuid:4064C064-6D14-4F35-8953-9652106476A9',0,'en','This tModel
> indicates the businessEntity that published or owns the tagged tModel.
> Used with tModels to establish an "owned" relationship with a registered
> businessEntity.');
> 
> INSERT INTO TMODEL_CATEGORY
> (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
> VALUES
> ('uuid:4064C064-6D14-4F35-8953-9652106476A9',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','categorization');
> 
> INSERT INTO TMODEL_CATEGORY
> (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
> VALUES
> ('uuid:4064C064-6D14-4F35-8953-9652106476A9',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','checked');
> 
> INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,OPERATOR,NAME,OVERVIEW_URL)
> VALUES
> ('uuid:807A2C6A-EE22-470D-ADC7-E0424A337C03','Administrator','jUDDI.org','uddi-org:relationships','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#Relationships');
> 
> INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
> VALUES ('uuid:807A2C6A-EE22-470D-ADC7-E0424A337C03',0,'en','Starter set
> classifications of businessEntity relationships');
> 
> INSERT INTO TMODEL_DOC_DESCR
> (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
> VALUES ('uuid:807A2C6A-EE22-470D-ADC7-E0424A337C03',0,'en','This tModel is
> used to describe business relationships. Used in the publisher assertion
> messages.');
> 
> INSERT INTO TMODEL_CATEGORY
> (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
> VALUES
> ('uuid:807A2C6A-EE22-470D-ADC7-E0424A337C03',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','relationship');
> 
> INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,OPERATOR,NAME,OVERVIEW_URL)
> VALUES
> ('uuid:327A56F0-3299-4461-BC23-5CD513E95C55','Administrator','jUDDI.org','uddi-org:operators','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#Operators');
> 
> INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
> VALUES ('uuid:327A56F0-3299-4461-BC23-5CD513E95C55',0,'en','Taxonomy for
> categorizing the businessEntity of an operator of a registry.');
> 
> INSERT INTO TMODEL_DOC_DESCR
> (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
> VALUES ('uuid:327A56F0-3299-4461-BC23-5CD513E95C55',0,'en','This checked
> value set is used to identify UDDI operators.');
> 
> INSERT INTO TMODEL_CATEGORY
> (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
> VALUES
> ('uuid:327A56F0-3299-4461-BC23-5CD513E95C55',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','categorization');
> 
> INSERT INTO TMODEL_CATEGORY
> (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
> VALUES
> ('uuid:327A56F0-3299-4461-BC23-5CD513E95C55',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','checked');
> 
> INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,OPERATOR,NAME,OVERVIEW_URL)
> VALUES
> ('uuid:E59AE320-77A5-11D5-B898-0004AC49CC1E','Administrator','jUDDI.org','uddi-org:isReplacedBy','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#IsReplacedBy');
> 
> INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
> VALUES ('uuid:E59AE320-77A5-11D5-B898-0004AC49CC1E',0,'en','An identifier
> system used to point (using UDDI keys) to the tModel (or businessEntity)
> that is the logical replacement for the one in which isReplacedBy is
> used');
> 
> INSERT INTO TMODEL_DOC_DESCR
> (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
> VALUES ('uuid:E59AE320-77A5-11D5-B898-0004AC49CC1E',0,'en','This is a
> checked value set.');
> 
> INSERT INTO TMODEL_CATEGORY
> (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
> VALUES
> ('uuid:E59AE320-77A5-11D5-B898-0004AC49CC1E',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','identifier');
> 
> INSERT INTO TMODEL_CATEGORY
> (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
> VALUES
> ('uuid:E59AE320-77A5-11D5-B898-0004AC49CC1E',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','checked');
> 
> INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,OPERATOR,NAME,OVERVIEW_URL)
> VALUES
> ('uuid:8609C81E-EE1F-4D5A-B202-3EB13AD01823','Administrator','jUDDI.org','dnb-com:D-U-N-S','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#D-U-N-S');
> 
> INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
> VALUES ('uuid:8609C81E-EE1F-4D5A-B202-3EB13AD01823',0,'en','Dun&Bradstreet
> D-U-N-S® Number');
> 
> INSERT INTO TMODEL_DOC_DESCR
> (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
> VALUES ('uuid:8609C81E-EE1F-4D5A-B202-3EB13AD01823',0,'en','This tModel is
> used for the Dun&Bradstreet D-U-N-S® Number identifier.');
> 
> INSERT INTO TMODEL_CATEGORY
> (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
> VALUES
> ('uuid:8609C81E-EE1F-4D5A-B202-3EB13AD01823',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','identifier');
> 
> INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,OPERATOR,NAME,OVERVIEW_URL)
> VALUES
> ('uuid:B1B1BAF5-2329-43E6-AE13-BA8E97195039','Administrator','jUDDI.org','thomasregister-com:supplierID','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#Thomas');
> 
> INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
> VALUES ('uuid:B1B1BAF5-2329-43E6-AE13-BA8E97195039',0,'en','Thomas
> Registry Suppliers');
> 
> INSERT INTO TMODEL_DOC_DESCR
> (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
> VALUES ('uuid:B1B1BAF5-2329-43E6-AE13-BA8E97195039',0,'en','This tModel is
> used for the Thomas Register supplier identifier codes.');
> 
> INSERT INTO TMODEL_CATEGORY
> (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
> VALUES
> ('uuid:B1B1BAF5-2329-43E6-AE13-BA8E97195039',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','identifier');
> 
> 6.	Start your tomcat server and enter http://localhost:8080/juddi in a web
> browser. On jUDDI index page, you can click on validation link to validate
> your jUDDI installation.
> 
> 
-- 
View this message in context: http://www.nabble.com/Question-about-setting-up-jUDDI-tf1825410.html#a5351117
Sent from the jUDDI - User forum at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: juddi-user-unsubscribe@ws.apache.org
For additional commands, e-mail: juddi-user-help@ws.apache.org

Re: Question about setting up jUDDI

Posted by Rathore <ra...@hp.com>.

Hi,
I have created jUDDI installation guide, kindly follow the instructions to
setup jUDDI with MySQL & tomcat. I am not able to attach this document this
post so copy pasted the content. Let me know if you are not able to get it
in a proper format. I will send it thru email.

jUDDI Installation Guide

Software Requirements:

1.	Apache Tomcat 5.5.x, installed at C:\Tomcat or some other directory
location and set to %TOMCAT_HOME% environment variable.
2.	MySQL relational database installed at local or remote server.
a.	Admin user name = root.
b.	Password = root.
3.	JDBC driver should be present under %TOMCAT_HOME%\common\lib. In our case
it will be MySQL JBDC driver.


Installation steps:

1.	For installation on windows, download jUDDI UDDI directory server from
http://nchc.dl.sourceforge.net/sourceforge/juddi/juddi_0.8.0_bin.zip
2.	Assuming you have unzipped this zip file at C:\, copy
C:\juddi_0.8.0_bin\build\juddi.war to your %TOMCAT_HOME%\webapps application
installation directory.
3.	Configure the JNDI DataSource in Tomcat by adding a declaration for your
resource to %TOMCAT_HOME%\conf\server.xml file and add following between
<context> or <host> XML element:

<Context path="/juddi" docBase="juddi" debug="5" reloadable="true"
crossContext="true">
<Resource name="jdbc/juddiDB" auth="Container" type="javax.sql.DataSource"
               maxActive="100" maxIdle="30" maxWait="10000"
               username="root" password="root"
driverClassName="com.mysql.jdbc.Driver"
               url="jdbc:mysql://localhost:3306/juddi?autoReconnect=true"/>
</Context>

4.	Modify juddi.properties file as per MySQL configurations present under
%TOMCAT_HOME%\webapps\juddi\conf directory.

5.	Open MySQL console and execute the following SQL statements in-order to
create some dummy entries into UDDI registry server:

#########################################################################
# MySQL/jUDDI version 1.0rc1
#########################################################################

Create database juddi;
use juddi;

#GRANT ALL ON juddi.* TO juddi@"%" IDENTIFIED BY "juddi";
#GRANT ALL ON juddi.* TO juddi@"localhost" IDENTIFIED BY "juddi";

DROP TABLE BUSINESS_DESCR;
DROP TABLE BUSINESS_CATEGORY;
DROP TABLE BUSINESS_IDENTIFIER;
DROP TABLE BUSINESS_NAME;
DROP TABLE DISCOVERY_URL;
DROP TABLE ADDRESS_LINE;
DROP TABLE ADDRESS;
DROP TABLE PHONE;
DROP TABLE EMAIL;
DROP TABLE CONTACT_DESCR;
DROP TABLE CONTACT;
DROP TABLE SERVICE_DESCR;
DROP TABLE SERVICE_CATEGORY;
DROP TABLE SERVICE_NAME;
DROP TABLE BINDING_DESCR;
DROP TABLE INSTANCE_DETAILS_DESCR;
DROP TABLE INSTANCE_DETAILS_DOC_DESCR;
DROP TABLE TMODEL_CATEGORY;
DROP TABLE TMODEL_DESCR;
DROP TABLE TMODEL_DOC_DESCR;
DROP TABLE TMODEL_IDENTIFIER;
DROP TABLE TMODEL_INSTANCE_INFO_DESCR;
DROP TABLE TMODEL_INSTANCE_INFO;
DROP TABLE PUBLISHER_ASSERTION;
DROP TABLE TMODEL;
DROP TABLE BINDING_TEMPLATE;
DROP TABLE BUSINESS_SERVICE;
DROP TABLE BUSINESS_ENTITY;
DROP TABLE PUBLISHER;
DROP TABLE AUTH_TOKEN;

CREATE TABLE BUSINESS_ENTITY
(
  BUSINESS_KEY VARCHAR(41) NOT NULL,
  AUTHORIZED_NAME VARCHAR(255) NOT NULL,
  PUBLISHER_ID VARCHAR(20) NULL,
  OPERATOR VARCHAR(255) NOT NULL,
  LAST_UPDATE TIMESTAMP NOT NULL,
  PRIMARY KEY (BUSINESS_KEY)
);

CREATE TABLE BUSINESS_DESCR
(
  BUSINESS_KEY VARCHAR(41) NOT NULL,
  BUSINESS_DESCR_ID INT NOT NULL,
  LANG_CODE VARCHAR(2) NULL,
  DESCR VARCHAR(255) NOT NULL,
  PRIMARY KEY (BUSINESS_KEY,BUSINESS_DESCR_ID),
  FOREIGN KEY (BUSINESS_KEY)
    REFERENCES BUSINESS_ENTITY (BUSINESS_KEY)
);

CREATE TABLE BUSINESS_CATEGORY
(
  BUSINESS_KEY VARCHAR(41) NOT NULL,
  CATEGORY_ID INT NOT NULL,
  TMODEL_KEY_REF VARCHAR(41) NULL,
  KEY_NAME VARCHAR(255) NULL,
  KEY_VALUE VARCHAR(255) NOT NULL,
  PRIMARY KEY (BUSINESS_KEY,CATEGORY_ID),
  FOREIGN KEY (BUSINESS_KEY)
    REFERENCES BUSINESS_ENTITY (BUSINESS_KEY)
);

CREATE TABLE BUSINESS_IDENTIFIER
(
  BUSINESS_KEY VARCHAR(41) NOT NULL,
  IDENTIFIER_ID INT NOT NULL,
  TMODEL_KEY_REF VARCHAR(41) NULL,
  KEY_NAME VARCHAR(255) NULL,
  KEY_VALUE VARCHAR(255) NOT NULL,
  PRIMARY KEY (BUSINESS_KEY,IDENTIFIER_ID),
  FOREIGN KEY (BUSINESS_KEY)
    REFERENCES BUSINESS_ENTITY (BUSINESS_KEY)
);

CREATE TABLE BUSINESS_NAME
(
  BUSINESS_KEY VARCHAR(41) NOT NULL,
  BUSINESS_NAME_ID INT NOT NULL,
  LANG_CODE VARCHAR(2) NULL,
  NAME VARCHAR(255) NOT NULL,
  PRIMARY KEY (BUSINESS_KEY,BUSINESS_NAME_ID),
  FOREIGN KEY (BUSINESS_KEY)
    REFERENCES BUSINESS_ENTITY (BUSINESS_KEY)
);

CREATE TABLE CONTACT
(
  BUSINESS_KEY VARCHAR(41) NOT NULL,
  CONTACT_ID INT NOT NULL,
  USE_TYPE VARCHAR(255) NULL,
  PERSON_NAME VARCHAR(255) NOT NULL,
  PRIMARY KEY (BUSINESS_KEY,CONTACT_ID),
  FOREIGN KEY (BUSINESS_KEY)
    REFERENCES BUSINESS_ENTITY (BUSINESS_KEY)
);

CREATE TABLE CONTACT_DESCR
(
  BUSINESS_KEY VARCHAR(41) NOT NULL,
  CONTACT_ID INT NOT NULL,
  CONTACT_DESCR_ID INT NOT NULL,
  LANG_CODE VARCHAR(2) NULL,
  DESCR VARCHAR(255) NOT NULL,
  PRIMARY KEY (BUSINESS_KEY,CONTACT_ID,CONTACT_DESCR_ID),
  FOREIGN KEY (BUSINESS_KEY,CONTACT_ID)
    REFERENCES CONTACT (BUSINESS_KEY,CONTACT_ID)
);

CREATE TABLE ADDRESS
(
  BUSINESS_KEY VARCHAR(41) NOT NULL,
  CONTACT_ID INT NOT NULL,
  ADDRESS_ID INT NOT NULL,
  USE_TYPE VARCHAR(255) NULL,
  SORT_CODE VARCHAR(10) NULL,
  TMODEL_KEY VARCHAR(41) NULL,
  PRIMARY KEY (BUSINESS_KEY,CONTACT_ID,ADDRESS_ID),
  FOREIGN KEY (BUSINESS_KEY,CONTACT_ID)
    REFERENCES CONTACT (BUSINESS_KEY,CONTACT_ID)
);

CREATE TABLE ADDRESS_LINE
(
  BUSINESS_KEY VARCHAR(41) NOT NULL,
  CONTACT_ID INT NOT NULL,
  ADDRESS_ID INT NOT NULL,
  ADDRESS_LINE_ID INT NOT NULL,
  LINE VARCHAR(80) NOT NULL,
  KEY_NAME VARCHAR(255) NULL,
  KEY_VALUE VARCHAR(255) NULL,
  PRIMARY KEY (BUSINESS_KEY,CONTACT_ID,ADDRESS_ID,ADDRESS_LINE_ID),
  FOREIGN KEY (BUSINESS_KEY,CONTACT_ID,ADDRESS_ID)
    REFERENCES ADDRESS (BUSINESS_KEY,CONTACT_ID,ADDRESS_ID)
);

CREATE TABLE EMAIL
(
  BUSINESS_KEY VARCHAR(41) NOT NULL,
  CONTACT_ID INT NOT NULL,
  EMAIL_ID INT NOT NULL,
  USE_TYPE VARCHAR(255) NULL,
  EMAIL_ADDRESS VARCHAR(255) NOT NULL,
  PRIMARY KEY (BUSINESS_KEY,CONTACT_ID,EMAIL_ID),
  FOREIGN KEY (BUSINESS_KEY,CONTACT_ID)
    REFERENCES CONTACT (BUSINESS_KEY,CONTACT_ID)
);

CREATE TABLE PHONE
(
  BUSINESS_KEY VARCHAR(41) NOT NULL,
  CONTACT_ID INT NOT NULL,
  PHONE_ID INT NOT NULL,
  USE_TYPE VARCHAR(255) NULL,
  PHONE_NUMBER VARCHAR(50) NOT NULL,
  PRIMARY KEY (BUSINESS_KEY,CONTACT_ID,PHONE_ID),
  FOREIGN KEY (BUSINESS_KEY,CONTACT_ID)
    REFERENCES CONTACT (BUSINESS_KEY,CONTACT_ID)
);

CREATE TABLE DISCOVERY_URL
(
  BUSINESS_KEY VARCHAR(41) NOT NULL,
  DISCOVERY_URL_ID INT NOT NULL,
  USE_TYPE VARCHAR(255) NOT NULL,
  URL VARCHAR(255) NOT NULL,
  PRIMARY KEY (BUSINESS_KEY,DISCOVERY_URL_ID),
  FOREIGN KEY (BUSINESS_KEY)
    REFERENCES BUSINESS_ENTITY (BUSINESS_KEY)
);

CREATE TABLE BUSINESS_SERVICE
(
  BUSINESS_KEY VARCHAR(41) NOT NULL,
  SERVICE_KEY VARCHAR(41) NOT NULL,
  LAST_UPDATE TIMESTAMP NOT NULL,
  PRIMARY KEY (SERVICE_KEY),
  FOREIGN KEY (BUSINESS_KEY)
    REFERENCES BUSINESS_ENTITY (BUSINESS_KEY)
);

CREATE TABLE SERVICE_DESCR
(
  SERVICE_KEY VARCHAR(41) NOT NULL,
  SERVICE_DESCR_ID INT NOT NULL,
  LANG_CODE VARCHAR(2) NULL,
  DESCR VARCHAR(255) NOT NULL,
  PRIMARY KEY (SERVICE_KEY,SERVICE_DESCR_ID),
  FOREIGN KEY (SERVICE_KEY)
    REFERENCES BUSINESS_SERVICE (SERVICE_KEY)
);

CREATE TABLE SERVICE_CATEGORY
(
  SERVICE_KEY VARCHAR(41) NOT NULL,
  CATEGORY_ID INT NOT NULL,
  TMODEL_KEY_REF VARCHAR(41) NULL,
  KEY_NAME VARCHAR(255) NULL,
  KEY_VALUE VARCHAR(255) NOT NULL,
  PRIMARY KEY (SERVICE_KEY,CATEGORY_ID),
  FOREIGN KEY (SERVICE_KEY)
    REFERENCES BUSINESS_SERVICE (SERVICE_KEY)
);

CREATE TABLE SERVICE_NAME
(
  SERVICE_KEY VARCHAR(41) NOT NULL,
  SERVICE_NAME_ID INT NOT NULL,
  LANG_CODE VARCHAR(2) NULL,
  NAME VARCHAR(255) NOT NULL,
  PRIMARY KEY (SERVICE_KEY,SERVICE_NAME_ID),
  FOREIGN KEY (SERVICE_KEY)
    REFERENCES BUSINESS_SERVICE (SERVICE_KEY)
);

CREATE TABLE BINDING_TEMPLATE
(
  SERVICE_KEY VARCHAR(41) NOT NULL,
  BINDING_KEY VARCHAR(41) NOT NULL,
  ACCESS_POINT_TYPE VARCHAR(20) NULL,
  ACCESS_POINT_URL VARCHAR(255) NULL,
  HOSTING_REDIRECTOR VARCHAR(255) NULL,
  LAST_UPDATE TIMESTAMP NOT NULL,
  PRIMARY KEY (BINDING_KEY),
  FOREIGN KEY (SERVICE_KEY)
    REFERENCES BUSINESS_SERVICE (SERVICE_KEY)
);

CREATE TABLE BINDING_DESCR
(
  BINDING_KEY VARCHAR(41) NOT NULL,
  BINDING_DESCR_ID INT NOT NULL,
  LANG_CODE VARCHAR(2) NULL,
  DESCR VARCHAR(255) NOT NULL,
  PRIMARY KEY (BINDING_KEY,BINDING_DESCR_ID),
  FOREIGN KEY (BINDING_KEY)
    REFERENCES BINDING_TEMPLATE (BINDING_KEY)
);

CREATE TABLE TMODEL_INSTANCE_INFO
(
  BINDING_KEY VARCHAR(41) NOT NULL,
  TMODEL_INSTANCE_INFO_ID INT NOT NULL,
  TMODEL_KEY VARCHAR(41) NOT NULL,
  OVERVIEW_URL VARCHAR(255) NULL,
  INSTANCE_PARMS VARCHAR(255) NULL,
  PRIMARY KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID),
  FOREIGN KEY (BINDING_KEY)
    REFERENCES BINDING_TEMPLATE (BINDING_KEY)
);

CREATE TABLE TMODEL_INSTANCE_INFO_DESCR
(
  BINDING_KEY VARCHAR(41) NOT NULL,
  TMODEL_INSTANCE_INFO_ID INT NOT NULL,
  TMODEL_INSTANCE_INFO_DESCR_ID INT NOT NULL,
  LANG_CODE VARCHAR(2) NULL,
  DESCR VARCHAR(255) NOT NULL,
  PRIMARY KEY
(BINDING_KEY,TMODEL_INSTANCE_INFO_ID,TMODEL_INSTANCE_INFO_DESCR_ID),
  FOREIGN KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
    REFERENCES TMODEL_INSTANCE_INFO (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
);

CREATE TABLE INSTANCE_DETAILS_DESCR
(
  BINDING_KEY VARCHAR(41) NOT NULL,
  TMODEL_INSTANCE_INFO_ID INT NOT NULL,
  INSTANCE_DETAILS_DESCR_ID INT NOT NULL,
  LANG_CODE VARCHAR(2) NULL,
  DESCR VARCHAR(255) NOT NULL,
  PRIMARY KEY
(BINDING_KEY,TMODEL_INSTANCE_INFO_ID,INSTANCE_DETAILS_DESCR_ID),
  FOREIGN KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
    REFERENCES TMODEL_INSTANCE_INFO (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
);

CREATE TABLE INSTANCE_DETAILS_DOC_DESCR
(
  BINDING_KEY VARCHAR(41) NOT NULL,
  TMODEL_INSTANCE_INFO_ID INT NOT NULL,
  INSTANCE_DETAILS_DOC_DESCR_ID INT NOT NULL,
  LANG_CODE VARCHAR(2) NULL,
  DESCR VARCHAR(255) NOT NULL,
  PRIMARY KEY
(BINDING_KEY,TMODEL_INSTANCE_INFO_ID,INSTANCE_DETAILS_DOC_DESCR_ID),
  FOREIGN KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
    REFERENCES TMODEL_INSTANCE_INFO (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
);

CREATE TABLE TMODEL
(
  TMODEL_KEY VARCHAR(41) NOT NULL,
  AUTHORIZED_NAME VARCHAR(255) NOT NULL,
  PUBLISHER_ID VARCHAR(20) NULL,
  OPERATOR VARCHAR(255) NOT NULL,
  NAME VARCHAR(255) NOT NULL,
  OVERVIEW_URL VARCHAR(255) NULL,
  LAST_UPDATE TIMESTAMP NOT NULL,
  PRIMARY KEY (TMODEL_KEY)
);

CREATE TABLE TMODEL_DESCR
(
  TMODEL_KEY VARCHAR(41) NOT NULL,
  TMODEL_DESCR_ID INT NOT NULL,
  LANG_CODE VARCHAR(2) NULL,
  DESCR VARCHAR(255) NOT NULL,
  PRIMARY KEY (TMODEL_KEY,TMODEL_DESCR_ID),
  FOREIGN KEY (TMODEL_KEY)
    REFERENCES TMODEL (TMODEL_KEY)
);

CREATE TABLE TMODEL_CATEGORY
(
  TMODEL_KEY VARCHAR(41) NOT NULL,
  CATEGORY_ID INT NOT NULL,
  TMODEL_KEY_REF VARCHAR(255) NULL,
  KEY_NAME VARCHAR(255) NULL,
  KEY_VALUE VARCHAR(255) NOT NULL,
  PRIMARY KEY (TMODEL_KEY,CATEGORY_ID),
  FOREIGN KEY (TMODEL_KEY)
    REFERENCES TMODEL (TMODEL_KEY)
);

CREATE TABLE TMODEL_IDENTIFIER
(
  TMODEL_KEY VARCHAR(41) NOT NULL,
  IDENTIFIER_ID INT NOT NULL,
  TMODEL_KEY_REF VARCHAR(255) NULL,
  KEY_NAME VARCHAR(255) NULL,
  KEY_VALUE VARCHAR(255) NOT NULL,
  PRIMARY KEY (TMODEL_KEY,IDENTIFIER_ID),
  FOREIGN KEY (TMODEL_KEY)
    REFERENCES TMODEL (TMODEL_KEY)
);

CREATE TABLE TMODEL_DOC_DESCR
(
  TMODEL_KEY VARCHAR(41) NOT NULL,
  TMODEL_DOC_DESCR_ID INT NOT NULL,
  LANG_CODE VARCHAR(2) NULL,
  DESCR VARCHAR(255) NOT NULL,
  PRIMARY KEY (TMODEL_KEY,TMODEL_DOC_DESCR_ID),
  FOREIGN KEY (TMODEL_KEY)
    REFERENCES TMODEL (TMODEL_KEY)
);

CREATE TABLE PUBLISHER_ASSERTION
(
  FROM_KEY VARCHAR(41) NOT NULL,
  TO_KEY VARCHAR(41) NOT NULL,
  TMODEL_KEY VARCHAR(41) NOT NULL,
  KEY_NAME VARCHAR(255) NOT NULL,
  KEY_VALUE VARCHAR(255) NOT NULL,
  FROM_CHECK VARCHAR(5) NOT NULL,
  TO_CHECK VARCHAR(5) NOT NULL,
  FOREIGN KEY (FROM_KEY) 
    REFERENCES BUSINESS_ENTITY (BUSINESS_KEY),
  FOREIGN KEY (TO_KEY) 
    REFERENCES BUSINESS_ENTITY (BUSINESS_KEY) 
);

CREATE TABLE PUBLISHER
(
  PUBLISHER_ID VARCHAR(20) NOT NULL,
  PUBLISHER_NAME VARCHAR(255) NOT NULL,
  LAST_NAME VARCHAR(150) NULL,
  FIRST_NAME VARCHAR(100) NULL,
  MIDDLE_INIT VARCHAR(5) NULL,
  WORK_PHONE VARCHAR(50) NULL,
  MOBILE_PHONE VARCHAR(50) NULL,
  PAGER VARCHAR(50) NULL,
  EMAIL_ADDRESS VARCHAR(255) NULL,
  ADMIN VARCHAR(5) NULL,
  ENABLED VARCHAR(5) NULL,
  PRIMARY KEY (PUBLISHER_ID)
);

CREATE TABLE AUTH_TOKEN
(
  AUTH_TOKEN VARCHAR(51) NOT NULL,
  PUBLISHER_ID VARCHAR(20) NOT NULL,
  PUBLISHER_NAME VARCHAR(255) NOT NULL,
  CREATED TIMESTAMP NOT NULL,
  LAST_USED TIMESTAMP NOT NULL,
  NUMBER_OF_USES INT NOT NULL,
  TOKEN_STATE INT NOT NULL,
  PRIMARY KEY (AUTH_TOKEN)
);

INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,OPERATOR,NAME,OVERVIEW_URL)
VALUES
('uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','Administrator','jUDDI.org','uddi-org:types','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#UDDItypes');

INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
VALUES ('uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4',0,'en','UDDI Type
Taxonomy');
 
INSERT INTO TMODEL_DOC_DESCR
(TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
VALUES ('uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4',0,'en','Taxonomy used to
categorize Service Descriptions.');
 
INSERT INTO TMODEL_CATEGORY
(TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
VALUES
('uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','categorization');
 
INSERT INTO TMODEL_CATEGORY
(TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
VALUES
('uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','checked');

INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,OPERATOR,NAME,OVERVIEW_URL)
VALUES
('uuid:DB77450D-9FA8-45D4-A7BC-04411D14E384','Administrator','jUDDI.org','unspsc-org:unspsc:3-1','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#UNSPSC31');

INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
VALUES ('uuid:DB77450D-9FA8-45D4-A7BC-04411D14E384',0,'en','Product
Taxonomy: UNSPSC (Version 3.1)');

INSERT INTO TMODEL_DOC_DESCR
(TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
VALUES ('uuid:DB77450D-9FA8-45D4-A7BC-04411D14E384',0,'en','This tModel
defines the UNSPSC product taxonomy.');

INSERT INTO TMODEL_CATEGORY
(TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
VALUES
('uuid:DB77450D-9FA8-45D4-A7BC-04411D14E384',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','categorization');

INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,OPERATOR,NAME,OVERVIEW_URL)
VALUES
('uuid:CD153257-086A-4237-B336-6BDCBDCC6634','Administrator','jUDDI.org','unspsc-org:unspsc','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#UNSPSC');

INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
VALUES ('uuid:CD153257-086A-4237-B336-6BDCBDCC6634',0,'en','Product
Taxonomy: UNSPSC (Version 7.3)');

INSERT INTO TMODEL_DOC_DESCR
(TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
VALUES ('uuid:CD153257-086A-4237-B336-6BDCBDCC6634',0,'en','This tModel
defines Version 7.3 of the UNSPSC product taxonomy.');

INSERT INTO TMODEL_CATEGORY
(TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
VALUES
('uuid:CD153257-086A-4237-B336-6BDCBDCC6634',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','categorization');

INSERT INTO TMODEL_CATEGORY
(TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
VALUES
('uuid:CD153257-086A-4237-B336-6BDCBDCC6634',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','Checked');

INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,OPERATOR,NAME,OVERVIEW_URL)
VALUES
('uuid:C0B9FE13-179F-413D-8A5B-5004DB8E5BB2','Administrator','jUDDI.org','ntis-gov:naics:1997','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#NAICS');

INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
VALUES ('uuid:C0B9FE13-179F-413D-8A5B-5004DB8E5BB2',0,'en','Business
Taxonomy: NAICS(1997 Release)');

INSERT INTO TMODEL_DOC_DESCR
(TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
VALUES ('uuid:C0B9FE13-179F-413D-8A5B-5004DB8E5BB2',0,'en','This tModel
defines the NAICS industry taxonomy.');

INSERT INTO TMODEL_CATEGORY
(TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
VALUES
('uuid:C0B9FE13-179F-413D-8A5B-5004DB8E5BB2',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','categorization');

INSERT INTO TMODEL_CATEGORY
(TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
VALUES
('uuid:C0B9FE13-179F-413D-8A5B-5004DB8E5BB2',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','checked');

INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,OPERATOR,NAME,OVERVIEW_URL)
VALUES
('uuid:4E49A8D6-D5A2-4FC2-93A0-0411D8D19E88','Administrator','jUDDI.org','uddi-org:iso-ch:3166-1999','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#ISO3166');

INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
VALUES ('uuid:4E49A8D6-D5A2-4FC2-93A0-0411D8D19E88',0,'en','ISO 3166-1:1997
and 3166-2:1998. Codes for names of countries and their subdivisions. Part
1: Country codes. Part 2:Country subdivision codes. Update newsletters
include ISO 3166-1 V-1 (1998-02-05), V-2 (1999-10-01), ISO 3166-2 I-1
(1998)');

INSERT INTO TMODEL_DOC_DESCR
(TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
VALUES ('uuid:4E49A8D6-D5A2-4FC2-93A0-0411D8D19E88',0,'en','Taxonomy used to
categorize entries by geographic location.');

INSERT INTO TMODEL_CATEGORY
(TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
VALUES
('uuid:4E49A8D6-D5A2-4FC2-93A0-0411D8D19E88',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','categorization');

INSERT INTO TMODEL_CATEGORY
(TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
VALUES
('uuid:4E49A8D6-D5A2-4FC2-93A0-0411D8D19E88',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','checked');

INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,OPERATOR,NAME,OVERVIEW_URL)
VALUES
('uuid:A035A07C-F362-44DD-8F95-E2B134BF43B4','Administrator','jUDDI.org','uddi-org:general_keywords','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#GenKW');

INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
VALUES ('uuid:A035A07C-F362-44DD-8F95-E2B134BF43B4',0,'en','Special taxonomy
consisting of namespace identifiers and the keywords associated with the
namespaces');

INSERT INTO TMODEL_DOC_DESCR
(TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
VALUES ('uuid:A035A07C-F362-44DD-8F95-E2B134BF43B4',0,'en','This tModel
defines an unidentified taxonomy.');

INSERT INTO TMODEL_CATEGORY
(TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
VALUES
('uuid:A035A07C-F362-44DD-8F95-E2B134BF43B4',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','categorization');

INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,OPERATOR,NAME,OVERVIEW_URL)
VALUES
('uuid:4064C064-6D14-4F35-8953-9652106476A9','Administrator','jUDDI.org','uddi-org:owningBusiness','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#owningBusiness');

INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
VALUES ('uuid:4064C064-6D14-4F35-8953-9652106476A9',0,'en','A pointer to a
businessEntity that owns the tagged data.');

INSERT INTO TMODEL_DOC_DESCR
(TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
VALUES ('uuid:4064C064-6D14-4F35-8953-9652106476A9',0,'en','This tModel
indicates the businessEntity that published or owns the tagged tModel. Used
with tModels to establish an "owned" relationship with a registered
businessEntity.');

INSERT INTO TMODEL_CATEGORY
(TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
VALUES
('uuid:4064C064-6D14-4F35-8953-9652106476A9',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','categorization');

INSERT INTO TMODEL_CATEGORY
(TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
VALUES
('uuid:4064C064-6D14-4F35-8953-9652106476A9',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','checked');

INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,OPERATOR,NAME,OVERVIEW_URL)
VALUES
('uuid:807A2C6A-EE22-470D-ADC7-E0424A337C03','Administrator','jUDDI.org','uddi-org:relationships','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#Relationships');

INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
VALUES ('uuid:807A2C6A-EE22-470D-ADC7-E0424A337C03',0,'en','Starter set
classifications of businessEntity relationships');

INSERT INTO TMODEL_DOC_DESCR
(TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
VALUES ('uuid:807A2C6A-EE22-470D-ADC7-E0424A337C03',0,'en','This tModel is
used to describe business relationships. Used in the publisher assertion
messages.');

INSERT INTO TMODEL_CATEGORY
(TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
VALUES
('uuid:807A2C6A-EE22-470D-ADC7-E0424A337C03',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','relationship');

INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,OPERATOR,NAME,OVERVIEW_URL)
VALUES
('uuid:327A56F0-3299-4461-BC23-5CD513E95C55','Administrator','jUDDI.org','uddi-org:operators','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#Operators');

INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
VALUES ('uuid:327A56F0-3299-4461-BC23-5CD513E95C55',0,'en','Taxonomy for
categorizing the businessEntity of an operator of a registry.');

INSERT INTO TMODEL_DOC_DESCR
(TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
VALUES ('uuid:327A56F0-3299-4461-BC23-5CD513E95C55',0,'en','This checked
value set is used to identify UDDI operators.');

INSERT INTO TMODEL_CATEGORY
(TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
VALUES
('uuid:327A56F0-3299-4461-BC23-5CD513E95C55',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','categorization');

INSERT INTO TMODEL_CATEGORY
(TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
VALUES
('uuid:327A56F0-3299-4461-BC23-5CD513E95C55',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','checked');

INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,OPERATOR,NAME,OVERVIEW_URL)
VALUES
('uuid:E59AE320-77A5-11D5-B898-0004AC49CC1E','Administrator','jUDDI.org','uddi-org:isReplacedBy','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#IsReplacedBy');

INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
VALUES ('uuid:E59AE320-77A5-11D5-B898-0004AC49CC1E',0,'en','An identifier
system used to point (using UDDI keys) to the tModel (or businessEntity)
that is the logical replacement for the one in which isReplacedBy is used');

INSERT INTO TMODEL_DOC_DESCR
(TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
VALUES ('uuid:E59AE320-77A5-11D5-B898-0004AC49CC1E',0,'en','This is a
checked value set.');

INSERT INTO TMODEL_CATEGORY
(TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
VALUES
('uuid:E59AE320-77A5-11D5-B898-0004AC49CC1E',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','identifier');

INSERT INTO TMODEL_CATEGORY
(TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
VALUES
('uuid:E59AE320-77A5-11D5-B898-0004AC49CC1E',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','checked');

INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,OPERATOR,NAME,OVERVIEW_URL)
VALUES
('uuid:8609C81E-EE1F-4D5A-B202-3EB13AD01823','Administrator','jUDDI.org','dnb-com:D-U-N-S','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#D-U-N-S');

INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
VALUES ('uuid:8609C81E-EE1F-4D5A-B202-3EB13AD01823',0,'en','Dun&Bradstreet
D-U-N-S® Number');

INSERT INTO TMODEL_DOC_DESCR
(TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
VALUES ('uuid:8609C81E-EE1F-4D5A-B202-3EB13AD01823',0,'en','This tModel is
used for the Dun&Bradstreet D-U-N-S® Number identifier.');

INSERT INTO TMODEL_CATEGORY
(TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
VALUES
('uuid:8609C81E-EE1F-4D5A-B202-3EB13AD01823',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','identifier');

INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,OPERATOR,NAME,OVERVIEW_URL)
VALUES
('uuid:B1B1BAF5-2329-43E6-AE13-BA8E97195039','Administrator','jUDDI.org','thomasregister-com:supplierID','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#Thomas');

INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
VALUES ('uuid:B1B1BAF5-2329-43E6-AE13-BA8E97195039',0,'en','Thomas Registry
Suppliers');

INSERT INTO TMODEL_DOC_DESCR
(TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
VALUES ('uuid:B1B1BAF5-2329-43E6-AE13-BA8E97195039',0,'en','This tModel is
used for the Thomas Register supplier identifier codes.');

INSERT INTO TMODEL_CATEGORY
(TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
VALUES
('uuid:B1B1BAF5-2329-43E6-AE13-BA8E97195039',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','identifier');

6.	Start your tomcat server and enter http://localhost:8080/juddi in a web
browser. On jUDDI index page, you can click on validation link to validate
your jUDDI installation.

--
View this message in context: http://www.nabble.com/Question-about-setting-up-jUDDI-t1825410.html#a4989052
Sent from the jUDDI - User forum at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: juddi-user-unsubscribe@ws.apache.org
For additional commands, e-mail: juddi-user-help@ws.apache.org