jUDDI 安裝指南
（使用 Tomcat 5、MS SQL Server 2000）
蔡煥麟
Dec-22-2003

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

摘要：本文說明如何安裝 jUDDI 於 Tomcat 伺服器，資料庫使用 Microsoft SQL Server 2000。

1.0 簡介
UDDI 是 Universal Description, Discovery and Integration 的縮寫，它是一份包含了註冊、發布、以及尋找 Web Services 等仲介服務的技術規範。而 jUDDI（讀音 "judy"）則是符合此規範的一份實作，透過 jUDDI，你可以建立一個屬於自己的 UDDI 註冊中心。本文說明如何安裝 jUDDI 於 Tomcat 伺服器上，雖然官方文件也有說明如何安裝，但是稍嫌簡略，而且在資料庫的部分，只提到 MySQL、HSQL、Sybase、DB2 這四種資料庫，對於 SQL Server 的使用者來說，可能還要花許多時間來摸索嘗試。本文則是使用 SQL Server 2000 作為 jUDDI 的資料庫，並且將安裝 jUDDI 的所有必要的步驟都涵蓋進來，包括 JDK、Tomcat、SQL Server 2000 JDBC Driver、JNDI Data Source 的設定...等等，希望能盡量減少安裝時可能遭遇的問題。

2.0 安裝步驟
本文件使用的軟體如下（建議您使用相同或更新的版本）：

JDK 1.4。
Jakarta Tomcat 5.0.16。
jUDDI 0.8.0。
Microsoft SQL Server 2000。
Microsoft SQL Server 2000 Driver for JDBC。
以上除了 SQL Server 2000 之外，其餘軟體均可免費下載，而且大部分附有原始碼，但是我們只需要下載編譯好的版本（binary distribution）。請先將 SQL Server 2000 安裝好，並且安裝最新的 SQL Server 2000 service pack，確定資料庫伺服器已經啟動，然後依照下列各小節的順序進行安裝。

2.1 安裝 Java 2 SDK
到 http://java.sun.com/ 下載 JDK 1.4 或更新的版本，將安裝到 JDK 安裝到 c:\j2sdk 目錄下。

安裝完成後：

將 c:\j2sdk\bin 加入 PATH 環境變數。
新增一個環境變數 JAVA_HOME，其值為 c:\j2sdk（後面均以 %JAVA_HOME% 代表此目錄）。
註：Windows 2000 更改環境變數的方法是，在桌面的〔我的電腦〕圖示上面點一下滑鼠右鍵，選〔內容〕，然後切到〔進階〕頁夾，點一下〔環境變數〕按鈕。如果你修改了環境變數之後，發現好像沒有作用，可以嘗試重新開機看看。此動作並非必要，只是某些應用程式必須結束後重新開啟才會讀取到新的環境變數（例如： Total Commander），如果你發現新的環境變數沒有生效，又不知道應該重新執行哪些應用程式，重新開機就是最簡單的方式。

2.2 安裝 Jakarta Tomcat
到 http://jakarta.apache.org/ 下載 Tomcat 5.x 或最新的版本，安裝到 c:\Tomcat 目錄下。如果你希望 Tomcat 每次開機就執行，可以下載附檔名為 .exe 的安裝檔案，安裝時會有一個步驟讓你勾選是否要將 Tomcat 安裝成 Service。這裡我們下載的是 .zip 檔（jakarta-tomcat-5.0.16.zip），因此只要將檔案解壓縮到 c:\Tomcat 目錄下即完成安裝。

安裝完成後：

增加一個系統環境變數 CATALINA_HOME，其值為 c:\Tomcat（後面均以 %CATALINA_HOME% 代表此目錄）。
把 %CATALINA_HOME%\common\lib\servlet-api.jar 複製到 %JAVA_HOME%\jre\lib\ext 目錄下，讓 JDK 找得到這個檔案，才能順利執行 servlet 程式。
啟動 Tomcat（執行 c:\Tomcat\startup.bat）。
開啟瀏覽器，瀏覽網址 http://127.0.0.1:8080，如果有看到 Tomcat 歡迎頁（如圖 1），即表示安裝成功。
由於 Tomcat 5 已經內建 Xerces，所以不需要另外下載其它 XML parser，你也可以到 http://xml.apache.org/ 下載最新版的 Xerces 套件，然後覆蓋 Tomcat 內附的函式庫檔案。Tomcat 的 Xerces 套件放在 %CATALINA_HOME%\common\endorsed 目錄下。

圖 1. Tomcat 5 的歡迎頁

2.3 安裝 jUDDI
到 http://sourceforge.net/project/showfiles.php?group_id=42875 下載最新版的 jUDDI（這裡用的版本是 0.8.0，檔案名稱是 juddi_0.8.0_bin.zip），下載後把壓縮檔中的 juddi.war 解壓縮到 %CATALINA_HOME%\webapps 目錄下，Tomcat 啟動時會自動安裝此應用程式（如果 Tomcat 已事先啟動，則等待幾秒後 Tomcat 亦會偵測到並自動安裝此應用程式）。

安裝完成後，在瀏覽器中輸入網址 http://127.0.0.1:8080/juddi，應會看到 jUDDI 的歡迎畫面，點一下畫面上的 validate 超連結 ，以驗證安裝是否正確，參考圖 2。

圖 2. 初次安裝完 jUDDI 之後的驗證結果

注意畫面下方有兩行紅色的錯誤訊息，這是正常的，因為我們還沒有為 jUDDI 指定如何跟資料庫連接，我們稍後便會解決這個問題。如果你看到的錯誤訊息比圖 2 還要多，請根據錯誤訊息仔細檢查前面的安裝步驟是否遺漏了什麼。

2.4 安裝 Microsoft SQL Server 2000 Driver for JDBC
到 http://www.microsoft.com 下載 SQL Server 2000 的 JDBC driver，你可以在微軟網站上輸入關鍵字 "SQL server 2000 jdbc driver"，就可以找到最新版的驅動程式，此時我下載的版本是 SQL Server 2000 Driver for JDBC Service Pack 2。

假設你將 SQL Server 2000 JDBC driver 安裝到 c:\MssqlJdbc 目錄下，接著要設定 CLASSPATH 環境變數，好讓 JVM 能夠找到相關的類別檔。CLASSPATH 的設定如下：

CLASSPATH=.;c:\MssqlJdbc\lib\msbase.jar;c:\MssqlJdbc\lib\msutil.jar;c:\MssqlJdbc\lib\mssqlserver.jar
設定好之後，把 c:\MssqlJdbc\lib 目錄下的所有 .jar 檔案複製一份到 %CATALINA_HOME%\common\lib 目錄下，然後重新啟動 Tomcat（執行 shutdown.bat，然後 startup.bat）。

2.5 設定 jUDDI 的資料來源
對 Tomcat 而言，JNDI 資料來源是定義在 %CATALINA_HOME%\conf\server.xml 檔案裡，你可以為你的應用程式建立一個 <Context> 標籤，並在其中定義 JNDI 的資源名稱和參數，或者也可以將這些定義寫在 <DefaultContext> 標籤內，這樣的話，這個 JNDI 資源就可以被所有的 web 應用程式使用。如果 server.xml 中沒有 <DefaultContext> 標籤，請自行建立一個，最簡單的方式是以字串搜尋找到標籤 "<!-- Tomcat Root Context -->"，然後將 <DefaultContext> 定義在該標籤後面，像下面這樣：

        <!-- Tomcat Root Context -->
        <!--
          <Context path="" docBase="ROOT" debug="0"/>
        -->

        <DefaultContext reloadable="true" crossContext="true">
          <Resource name="jdbc/juddiDB" scope="Shareable" type="javax.sql.DataSource"/>
          <ResourceParams name="jdbc/juddiDB">
            <parameter>
              <name>url</name>
              <value>
                jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=juddi;user=sa;password=
              </value>
            </parameter>
            <parameter>
              <name>driverClassName</name>
              <value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
            </parameter>
          </ResourceParams>
        </DefaultContext>
你只要將上面的棕色部分的文字複製並貼到你的 Tomcat 的 server.xml 檔案中的適當位置即可，注意資料庫的使用者帳號是 sa，密碼未指定，如果你的 SQL Server 資料庫管理員帳號密碼有另外設定，請自行修改這部分的參數。另外，這裡假設 SQL Server 2000 跟 Tomcat 在同一台機器上，因此伺服器名稱使用 127.0.0.1，如果你的 SQL Server 位於其它電腦，請改成正確的 IP 位址。

修改完 server.xml 之後記得一定要重新啟動 Tomcat。

2.6 建立資料庫　
使用 SQL Server 2000 的 Enterprise Manager 建立一個資料庫，資料庫名稱是 "juddi"。資料庫建立好之後，我們還要建立一些 jUDDI 要用的 table 和資料，jUDDI 0.8.0 附了四種資料庫的 DDL 指令檔，但是沒有 SQL Server 2000 的，你可以使用本文提供的 juddi_mssql.ddl 的指令來建立資料庫。方法是先執行〔程式集 >  Microsoft SQL Server > Query Analyzer〕，進入後在工具列上有一個挑選資料庫的下拉盒，選擇 juddi 這個資料庫，如圖 3。

圖 3. SQL Server 2000 的 Query Analyzer

接著將檔案 juddi_mssql.ddl 的內容貼到 Query Analyzer 視窗裡的 SQL 指令面板，然後執行即可（點擊工具列上的綠色三角形圖示），執行時若有錯誤，將會顯示在下方面板當中。

上述動作完成後，再執行下面的 SQL 命令：

INSERT INTO PUBLISHER (PUBLISHER_ID, PUBLISHER_NAME, ADMIN) VALUES ('juddi', 'Juddi user', 'false');
2.7 驗證安裝
現在你已經完成所有的安裝程序了，可以再瀏覽網址 http://127.0.0.1:8080/juddi/happyjuddi.jsp 來驗證看看是否成功，成功的話，驗證結果應該看不到紅色的訊息，如圖 4 所示。

圖 4. jUDDI 完裝成功的驗證結果

3.0 結語
本文的安裝步驟中使用的各個軟體都是用最新的版本，但是隨著 jUDDI 以及相關軟體版本的演進（例如：JDK、Tomcat），實際的安裝步驟可能會與本文件描述的略有不同，但是應該不會有太大的差異，如果您在安裝時發現本文的內容已經過時，或者有錯誤之處，歡迎來信指正： huanlin.tsai@_NOSPAM_msa.hinet.net（把 _NOSPAM_ 拿掉）。

參考文獻
[1] jUDDI 官方文件。http://ws.apache.org/juddi/
[2] http://sourceforge.net/mailarchive/forum.php?thread_id=2429672&forum_id=7138
  
  
  

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

A. 補充資料
MySQL 的設定，提供：蕭聖穎。

步驟 2.4：
到 MySQL 網站下載 JDBC http://www.mysql.com/downloads/api-jdbc-stable.html，將mysql-connector-java-[版本編號]-stable-bin.jar置於 %CATALINA_HOME%\common\lib 資料夾下。

步驟 2.5：
在 server.xml 中加入
<DefaultContext reloadable="true" crossContext="true">
  <Resource name="jdbc/juddiDB" scope="Shareable" type="javax.sql.DataSource"/>
  <ResourceParams name="jdbc/juddiDB">
    <parameter>
      <name>url</name>
      <value>
        jdbc:mysql://localhost:3306/jUDDI?autoReconnect=true;DatabaseName=juddi;user=juddi;password=password
      </value>
    </parameter>
    <parameter>
      <name>driverClassName</name>
      <value>org.gjt.mm.mysql.Driver</value>
    </parameter>
  </ResourceParams>
</DefaultContext>
這裡存取 MySQL 資料庫的 user ID 是 "juddi"，密碼是 "password"，因此你必須事先在 MySQL 中建立這個 user 帳號。

（以上资料没有图片，如需看图片请下载下面的压缩包）

----------------------------------------------
-- MS SQL Server 2000/jUDDI version 1.0rc1
-- Written by Huanlin Tsai.
-- Modified from juddi_ase.dll.
----------------------------------------------

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 DATETIME 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 DATETIME 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 DATETIME 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 DATETIME 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 DATETIME NOT NULL,
  LAST_USED DATETIME NOT NULL,
  NUMBER_OF_USES INT NOT NULL,
  TOKEN_STATE INT NOT NULL,
  PRIMARY KEY (AUTH_TOKEN)
)

ALTER TABLE TMODEL ADD  CONSTRAINT [DF_TMODEL_LAST_UPDATE] DEFAULT (getdate()) FOR [LAST_UPDATE];

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');

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,
DELETED VARCHAR(5) NULL,//此处缺一个字段
  LAST_UPDATE DATETIME NOT NULL,
  PRIMARY KEY (TMODEL_KEY)
)
。。。。。
CREATE TABLE MONITOR
(
  REMOTE_HOST VARCHAR(51) NOT NULL,
  REQUEST_URI VARCHAR(255) NOT NULL,
  CALLED_FUNCTION VARCHAR(51) NOT NULL,
  UDDI_VERSION VARCHAR(51) NOT NULL,
  LOG_TIME DATETIME NOT NULL,
  AUTH_TOKEN VARCHAR(51) NULL,
  FAULT VARCHAR(255) NULL
)

觉得应该和sql无关吧

<Context path="/juddi" docBase="juddi" debug="5" reloadable="true"

  crossContext="true">

  <Logger className="org.apache.catalina.logger.FileLogger"

               prefix="localhost_juddiDB_log" suffix=".txt"

               timestamp="true"/>

  <Resource name="jdbc/juddiDB"

                 auth="Container"

                 type="javax.sql.DataSource"/>

  <ResourceParams name="jdbc/juddiDB">

    <parameter>

      <name>factory</name>

      <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>

    </parameter>

    <!-- Maximum number of dB connections in pool. Make sure you

         configure your mysqld max_connections large enough to handle

         all of your db connections. Set to 0 for no limit. -->

    <parameter><name>maxActive</name><value>100</value></parameter>

    <!-- Maximum number of idle dB connections to retain in pool.

         Set to 0 for no limit. -->

    <parameter><name>maxIdle</name><value>30</value></parameter>

    <parameter><name>maxWait</name><value>10000</value></parameter>

    <!-- MySQL dB username and password for dB connections -->

    <parameter><name>username</name><value>root</value></parameter>

    <parameter><name>password</name><value>****</value></parameter>

    <!-- Class name for mysql JDBC driver -->

    <parameter>

      <name>driverClassName</name>

      <value>com.mysql.jdbc.Driver</value>

    </parameter>

    <!-- The JDBC connection url for connecting to your MySQL dB.

         The autoReconnect=true argument to the url makes sure that the

         mm.mysql JDBC Driver will automatically reconnect if mysqld closed the

         connection.  mysqld by default closes idle connections after 8 hours.

    -->

    <parameter>

      <name>url</name>

      <value>jdbc:mysql://host.domain.com:3306/juddi?autoReconnect=true</value>

    </parameter>

    <parameter>

           <name>validationQuery</name>

           <value>select count(*) from PUBLISHER</value>

    </parameter>

  </ResourceParams>

</Context>

下面是我自己修改后运行成功时代码
<Context path="/juddi" docBase="juddi" debug="5" reloadable="true"
  crossContext="true">
  <Logger className="org.apache.catalina.logger.FileLogger"
               prefix="localhost_juddiDB_log" suffix=".txt"
               timestamp="true"/>
  <Resource name="jdbc/juddiDB"
                 auth="Container"
                 type="javax.sql.DataSource"/>
  <ResourceParams name="jdbc/juddiDB">
    <parameter>
      <name>factory</name>
      <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
    </parameter>
    <!-- Maximum number of dB connections in pool. Make sure you
         configure your mysqld max_connections large enough to handle
         all of your db connections. Set to 0 for no limit. -->
    <parameter><name>maxActive</name><value>100</value></parameter>
    <!-- Maximum number of idle dB connections to retain in pool.
         Set to 0 for no limit. -->
    <parameter><name>maxIdle</name><value>30</value></parameter>
    <parameter><name>maxWait</name><value>10000</value></parameter>
    <!-- MySQL dB username and password for dB connections  -->
    <parameter><name>username</name><value>juddi</value></parameter>
    <parameter><name>password</name><value>juddi</value></parameter>
    <!-- Class name for mm.mysql JDBC driver -->
    <parameter>
      <name>driverClassName</name>
      <value>org.gjt.mm.mysql.Driver</value>
    </parameter>
    <!-- The JDBC connection url for connecting to your MySQL dB.
         The autoReconnect=true argument to the url makes sure that the
         mm.mysql JDBC Driver will automatically reconnect if mysqld closed the
         connection.  mysqld by default closes idle connections after 8 hours.
    -->
    <parameter>
      <name>url</name>
      <value>jdbc:mysql://127.0.0.1:3306/juddi?autoReconnect=true</value>
    </parameter>
    <parameter>
           <name>validationQuery</name>
           <value>select count(*) from PUBLISHER</value>
    </parameter>
  </ResourceParams>
</Context>

** BEGIN NESTED EXCEPTION **

java.sql.SQLException
MESSAGE: Syntax error or access violation message from server: "Unknown database 'juddi'"

STACKTRACE:

java.sql.SQLException: Syntax error or access violation message from server: "Unknown database 'juddi'"
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1997)
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1906)
 at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:2520)
 at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:817)
 at com.mysql.jdbc.Connection.createNewIO(Connection.java:1902)
 at com.mysql.jdbc.Connection.(Connection.java:450)
 at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:411)
 at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:83)
 at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:184)
 at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(Unknown Source)
 at org.apache.commons.dbcp.AbandonedObjectPool.borrowObject(AbandonedObjectPool.java:117)
 at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:110)
 at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:312)
 at org.apache.jsp.happyjuddi_jsp._jspService(happyjuddi_jsp.java:333)
 at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:92)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:809)
 at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:162)
 at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:240)
 at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:187)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:809)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:200)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:146)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:209)
 at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
 at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:144)
 at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
 at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
 at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2358)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:133)
 at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
 at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:118)
 at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:116)
 at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594)
 at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:127)
 at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
 at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
 at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:152)
 at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
 at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
 at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
 at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
 at java.lang.Thread.run(Thread.java:534)

** END NESTED EXCEPTION **

Attempted reconnect 3 times. Giving up.)
- SELECT COUNT(*) FROM PUBLISHER failed (null)

我安装MySQL的时候用的默认username，设置了密码
那么
<parameter><name>username</name><value>root</value></parameter>
<parameter><name>password</name><value>****</value></parameter>
只要把密码改成自己的就可以了吧
<value>jdbc:mysql://host.domain.com:3306/juddi?autoReconnect=true</value>
因为服务器就是本地机器，就改成了
<value>jdbc:mysql://localhost:3306/juddi?autoReconnect=true</value>
然后检测就一片红了……请问这是到底为什么呀

+ Got a JNDI Context!
+ Got a JDBC DataSource (dsname=java:comp/env/jdbc/juddiDB)
- DB connection was not aquired. (Cannot create JDBC driver of class '' for connect URL 'null')
- SELECT COUNT(*) FROM PUBLISHER failed (null)

弄了一整天，google了很多网站，还是没有搞定！真是郁闷啊！

恳请碰到过此问题并成功解决的xd指点一下！

+ Got a JNDI Context!
+ Got a JDBC DataSource (dsname=java:comp/env/jdbc/juddiDB)
- DB connection was not aquired. (Cannot create PoolableConnectionFactory)
- SELECT COUNT(*) FROM PUBLISHER failed (null)

mysql> use juddi;
Database changed
mysql> 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)
    ->  );
Query OK, 0 rows affected (0.13 sec)

mysql> INSERT INTO PUBLISHER (PUBLISHER_ID, PUBLISHER_NAME, ADMIN) valueS ('ju
i', 'Juddi user', 'false');
Query OK, 1 row affected (0.05 sec)
6.重新启动tomcat,但还是显示刚刚安上juddi时的两个错误:
- DB connection was not aquired. (Cannot create JDBC driver of class '' for connect URL 'null')
- SELECT COUNT(*) FROM PUBLISHER failed (null)

好像server.xml的修改没有任何作用一样.
我好着急,好郁闷,望版主给与指点,不胜感激!!!!

我用的是jdk1.5.0+tomcat5.0.30,tomcat正常使用.(win2000系统)
我按装juddi的步骤如下:
1.从mysql的官方网站上下载mysql-5.0.13-rc-win32.zip解压后安装到C:\Program Files\MySQL\MySQL Server 5.0.
2.从apache官方网站上下载juddi-0.9rc4.zip,解压后将juddi.war复制到..\tomcat\webapps\下.
3.从http://www.mysql.com/downloads/api-jdbc-stable.html,下载mysql-connector-java-3.0.17-ga.zip,解压后将mysql-connector-java-3.0.17-ga-bin.jar复制到../tomcat/common/lib/下(并添加到环境变量)../tomcat/webapps/juddi/WEB-INF/lib.
4.修改../tomcat/conf/server.xml在</Host>后添加如下:
<DefaultContext reloadable="true" crossContext="true">
  <Resource name="jdbc/juddiDB" scope="Shareable" type="javax.sql.DataSource"/>
  <ResourceParams name="jdbc/juddiDB">
   <parameter>
      <name>username</name>
      <value>myy</value>
    </parameter>
    <parameter>
      <name>password</name>
      <value>123456</value>
    </parameter>
    <parameter>
      <name>url</name>
      <value>
        jdbc:mysql://localhost/javatest
      </value>
    </parameter>
    <parameter>
      <name>driverClassName</name>
      <value>org.gjt.mm.mysql.Driver</value>
    </parameter>
  </ResourceParams>
</DefaultContext>
5.打开mysql,以root身份登陆,并建立用户(注意用户一定要建立),数据库及表格如下:
mysql> GRANT ALL PRIVILEGES ON *.* TO 'myy'@'localhost'  
    ->     IDENTIFIED BY '123456' WITH GRANT OPTION;

//我的用户名是myy,密码:123456

mysql> create database javatest;
Query OK, 1 row affected (0.02 sec)

mysql> use juddi;
Database changed
mysql> 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)
    ->  );
Query OK, 0 rows affected (0.13 sec)

mysql> INSERT INTO PUBLISHER (PUBLISHER_ID, PUBLISHER_NAME, ADMIN) valueS ('ju
i', 'Juddi user', 'false');
Query OK, 1 row affected (0.05 sec)
6.重新启动tomcat.

注意:
1.tomcat的版本很重要,我刚开始时使用的是tomcat5.5.9,无论如何都配置不好,而且错误从来都不变,后来发现tomcat5.5.9和conf目录中的内容和tomcat5.0.30不一样,指示其配置信息无法加载.

后来参考一些文章，把驱动放在tomcat的common/lib下面就好了，再出这种问题的朋友可以试试
我的环境配置是：jdk1.5+tomcat4.1.30+juddi.09rc4