You are viewing a plain text version of this content. The canonical link for it is here.
Posted to scm@geronimo.apache.org by ge...@apache.org on 2010/12/22 14:27:19 UTC
svn commit: r1051888 - in /geronimo/server/trunk: ./
plugingroups/javaee6-tomcat/ plugingroups/javaee6-tomcat/src/main/history/
plugins/axis/ plugins/uddi/ plugins/uddi/uddi-db/src/main/sql/
plugins/uddi/uddi-jetty/ plugins/uddi/uddi-jetty/src/main/his...
Author: genspring
Date: Wed Dec 22 13:27:18 2010
New Revision: 1051888
URL: http://svn.apache.org/viewvc?rev=1051888&view=rev
Log:
GERONIMO-5005, updated juddi.sql for v3, repackage juddi war to use our own persistence.xml and libs.
Added:
geronimo/server/trunk/plugins/uddi/uddi-war-repackage/
geronimo/server/trunk/plugins/uddi/uddi-war-repackage/pom.xml
geronimo/server/trunk/plugins/uddi/uddi-war-repackage/src/
geronimo/server/trunk/plugins/uddi/uddi-war-repackage/src/main/
geronimo/server/trunk/plugins/uddi/uddi-war-repackage/src/main/resources/
geronimo/server/trunk/plugins/uddi/uddi-war-repackage/src/main/resources/WEB-INF/
geronimo/server/trunk/plugins/uddi/uddi-war-repackage/src/main/resources/WEB-INF/classes/
geronimo/server/trunk/plugins/uddi/uddi-war-repackage/src/main/resources/WEB-INF/classes/META-INF/
geronimo/server/trunk/plugins/uddi/uddi-war-repackage/src/main/resources/WEB-INF/classes/META-INF/persistence.xml
Modified:
geronimo/server/trunk/plugingroups/javaee6-tomcat/pom.xml
geronimo/server/trunk/plugingroups/javaee6-tomcat/src/main/history/dependencies.xml
geronimo/server/trunk/plugins/axis/pom.xml
geronimo/server/trunk/plugins/uddi/pom.xml
geronimo/server/trunk/plugins/uddi/uddi-db/src/main/sql/juddi.sql
geronimo/server/trunk/plugins/uddi/uddi-jetty/pom.xml
geronimo/server/trunk/plugins/uddi/uddi-jetty/src/main/history/dependencies.xml
geronimo/server/trunk/plugins/uddi/uddi-tomcat/pom.xml
geronimo/server/trunk/plugins/uddi/uddi-tomcat/src/main/history/dependencies.xml
geronimo/server/trunk/plugins/uddi/uddi-tomcat/src/main/plan/plan.xml
geronimo/server/trunk/pom.xml
Modified: geronimo/server/trunk/plugingroups/javaee6-tomcat/pom.xml
URL: http://svn.apache.org/viewvc/geronimo/server/trunk/plugingroups/javaee6-tomcat/pom.xml?rev=1051888&r1=1051887&r2=1051888&view=diff
==============================================================================
--- geronimo/server/trunk/plugingroups/javaee6-tomcat/pom.xml (original)
+++ geronimo/server/trunk/plugingroups/javaee6-tomcat/pom.xml Wed Dec 22 13:27:18 2010
@@ -88,12 +88,12 @@
<type>car</type>
</dependency>
- <!--<dependency>-->
- <!--<groupId>org.apache.geronimo.configs</groupId>-->
- <!--<artifactId>uddi-tomcat</artifactId>-->
- <!--<version>${project.version}</version>-->
- <!--<type>car</type>-->
- <!--</dependency>-->
+ <dependency>
+ <groupId>org.apache.geronimo.configs</groupId>
+ <artifactId>uddi-tomcat</artifactId>
+ <version>${project.version}</version>
+ <type>car</type>
+ </dependency>
<!--<dependency>-->
<!--<groupId>org.apache.geronimo.plugins.monitoring</groupId>-->
Modified: geronimo/server/trunk/plugingroups/javaee6-tomcat/src/main/history/dependencies.xml
URL: http://svn.apache.org/viewvc/geronimo/server/trunk/plugingroups/javaee6-tomcat/src/main/history/dependencies.xml?rev=1051888&r1=1051887&r2=1051888&view=diff
==============================================================================
--- geronimo/server/trunk/plugingroups/javaee6-tomcat/src/main/history/dependencies.xml (original)
+++ geronimo/server/trunk/plugingroups/javaee6-tomcat/src/main/history/dependencies.xml Wed Dec 22 13:27:18 2010
@@ -12,6 +12,11 @@
<type>car</type>
</dependency>
<dependency>
+ <groupId>org.apache.geronimo.configs</groupId>
+ <artifactId>uddi-tomcat</artifactId>
+ <type>car</type>
+ </dependency>
+ <dependency>
<groupId>org.apache.geronimo.plugingroups</groupId>
<artifactId>client</artifactId>
<type>car</type>
Modified: geronimo/server/trunk/plugins/axis/pom.xml
URL: http://svn.apache.org/viewvc/geronimo/server/trunk/plugins/axis/pom.xml?rev=1051888&r1=1051887&r2=1051888&view=diff
==============================================================================
--- geronimo/server/trunk/plugins/axis/pom.xml (original)
+++ geronimo/server/trunk/plugins/axis/pom.xml Wed Dec 22 13:27:18 2010
@@ -60,13 +60,21 @@
<dependency>
<groupId>org.apache.juddi</groupId>
<artifactId>uddi-ws</artifactId>
- <version>3.0.2</version>
+ <version>3.0.5-SNAPSHOT</version>
<exclusions>
<exclusion>
- <groupId>log4j</groupId>
- <artifactId>log4j</artifactId>
+ <groupId>javax.xml.bind</groupId>
+ <artifactId>jaxb-api</artifactId>
</exclusion>
- </exclusions>
+ <exclusion>
+ <groupId>com.sun.xml.ws</groupId>
+ <artifactId>jaxws-rt</artifactId>
+ </exclusion>
+ <exclusion>
+ <groupId>com.sun.xml.bind</groupId>
+ <artifactId>jaxb-impl</artifactId>
+ </exclusion>
+ </exclusions>
</dependency>
</dependencies>
</dependencyManagement>
Modified: geronimo/server/trunk/plugins/uddi/pom.xml
URL: http://svn.apache.org/viewvc/geronimo/server/trunk/plugins/uddi/pom.xml?rev=1051888&r1=1051887&r2=1051888&view=diff
==============================================================================
--- geronimo/server/trunk/plugins/uddi/pom.xml (original)
+++ geronimo/server/trunk/plugins/uddi/pom.xml Wed Dec 22 13:27:18 2010
@@ -31,13 +31,16 @@
<description>
UDDI plugin
</description>
-
+ <properties>
+ <juddiv3.version>3.0.5-SNAPSHOT</juddiv3.version>
+ </properties>
<modules>
<module>uddi-db</module>
+ <module>uddi-war-repackage</module>
<module>uddi-jetty</module>
<module>uddi-tomcat</module>
</modules>
-
+
<dependencyManagement>
<dependencies>
@@ -48,10 +51,17 @@
<type>pom</type>
<scope>import</scope>
</dependency>
+ <dependency>
+ <groupId>org.apache.geronimo.plugins</groupId>
+ <artifactId>axis</artifactId>
+ <version>${project.version}</version>
+ <type>pom</type>
+ <scope>import</scope>
+ </dependency>
<dependency>
<groupId>org.apache.juddi</groupId>
<artifactId>juddiv3-war</artifactId>
- <version>3.0.1</version>
+ <version>${juddiv3.version}</version>
<type>war</type>
<scope>provided</scope>
</dependency>
Modified: geronimo/server/trunk/plugins/uddi/uddi-db/src/main/sql/juddi.sql
URL: http://svn.apache.org/viewvc/geronimo/server/trunk/plugins/uddi/uddi-db/src/main/sql/juddi.sql?rev=1051888&r1=1051887&r2=1051888&view=diff
==============================================================================
--- geronimo/server/trunk/plugins/uddi/uddi-db/src/main/sql/juddi.sql (original)
+++ geronimo/server/trunk/plugins/uddi/uddi-db/src/main/sql/juddi.sql Wed Dec 22 13:27:18 2010
@@ -1,725 +1,619 @@
---
--- Licensed to the Apache Software Foundation (ASF) under one or more
--- contributor license agreements. See the NOTICE file distributed with
--- this work for additional information regarding copyright ownership.
--- The ASF licenses this file to You under the Apache License, Version 2.0
--- (the "License"); you may not use this file except in compliance with
--- the License. You may obtain a copy of the License at
---
--- http://www.apache.org/licenses/LICENSE-2.0
---
--- Unless required by applicable law or agreed to in writing, software
--- distributed under the License is distributed on an "AS IS" BASIS,
--- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
--- See the License for the specific language governing permissions and
--- limitations under the License.
---
--- $Rev$ $Date$
---
-
-CREATE TABLE BUSINESS_ENTITY
-(
- BUSINESS_KEY VARCHAR(41) NOT NULL,
- AUTHORIZED_NAME VARCHAR(255) NOT NULL,
- PUBLISHER_ID VARCHAR(20) ,
- 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(5),
- 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) ,
- KEY_NAME VARCHAR(255) ,
- 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) ,
- KEY_NAME VARCHAR(255) ,
- 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(5),
- 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) ,
- 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(5),
- 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) ,
- SORT_CODE VARCHAR(10) ,
- TMODEL_KEY VARCHAR(41) ,
- 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) ,
- KEY_VALUE VARCHAR(255) ,
- 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) ,
- 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) ,
- 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(5),
- 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) ,
- KEY_NAME VARCHAR(255) ,
- 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(5) ,
- 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) ,
- ACCESS_POINT_URL VARCHAR(2000) ,
- HOSTING_REDIRECTOR VARCHAR(255) ,
- LAST_UPDATE TIMESTAMP NOT NULL,
- PRIMARY KEY (BINDING_KEY),
- FOREIGN KEY (SERVICE_KEY)
- REFERENCES BUSINESS_SERVICE (SERVICE_KEY)
-);
-
-CREATE TABLE BINDING_CATEGORY
-(
- BINDING_KEY VARCHAR(41) NOT NULL,
- CATEGORY_ID INT NOT NULL,
- TMODEL_KEY_REF VARCHAR(41),
- KEY_NAME VARCHAR(255),
- KEY_VALUE VARCHAR(255) NOT NULL,
- PRIMARY KEY (BINDING_KEY,CATEGORY_ID),
- FOREIGN KEY (BINDING_KEY)
- REFERENCES BINDING_TEMPLATE (BINDING_KEY)
-);
-
-CREATE TABLE BINDING_DESCR
-(
- BINDING_KEY VARCHAR(41) NOT NULL,
- BINDING_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(5),
- 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) ,
- INSTANCE_PARMS VARCHAR(255) ,
- 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(5),
- 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(5),
- 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(5),
- 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) ,
- OPERATOR VARCHAR(255) NOT NULL,
- NAME VARCHAR(255) NOT NULL,
- LANG_CODE VARCHAR(5),
- OVERVIEW_URL VARCHAR(255) ,
- DELETED VARCHAR(5),
- 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(5),
- 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) ,
- KEY_NAME VARCHAR(255) ,
- 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) ,
- KEY_NAME VARCHAR(255) ,
- 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(5),
- 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,
- EMAIL_ADDRESS VARCHAR(255),
- IS_ADMIN VARCHAR(5),
- IS_ENABLED VARCHAR(5),
- MAX_BUSINESSES INT,
- MAX_SERVICES_PER_BUSINESS INT,
- MAX_BINDINGS_PER_SERVICE INT,
- MAX_TMODELS INT,
- 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,LAST_UPDATE)
-VALUES ('uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','Administrator','jUDDI.org','uddi-org:types','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#UDDItypes',CURRENT TIMESTAMP);
-
-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,LAST_UPDATE)
-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',CURRENT TIMESTAMP);
-
-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,LAST_UPDATE)
-VALUES ('uuid:CD153257-086A-4237-B336-6BDCBDCC6634','Administrator','jUDDI.org','unspsc-org:unspsc','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#UNSPSC',CURRENT TIMESTAMP);
-
-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,LAST_UPDATE)
-VALUES ('uuid:C0B9FE13-179F-413D-8A5B-5004DB8E5BB2','Administrator','jUDDI.org','ntis-gov:naics:1997','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#NAICS',CURRENT TIMESTAMP);
-
-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,LAST_UPDATE)
-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',CURRENT TIMESTAMP);
-
-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,LAST_UPDATE)
-VALUES ('uuid:A035A07C-F362-44DD-8F95-E2B134BF43B4','Administrator','jUDDI.org','uddi-org:general_keywords','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#GenKW',CURRENT TIMESTAMP);
-
-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,LAST_UPDATE)
-VALUES ('uuid:4064C064-6D14-4F35-8953-9652106476A9','Administrator','jUDDI.org','uddi-org:owningBusiness','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#owningBusiness',CURRENT TIMESTAMP);
-
-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,LAST_UPDATE)
-VALUES ('uuid:807A2C6A-EE22-470D-ADC7-E0424A337C03','Administrator','jUDDI.org','uddi-org:relationships','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#Relationships',CURRENT TIMESTAMP);
-
-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,LAST_UPDATE)
-VALUES ('uuid:327A56F0-3299-4461-BC23-5CD513E95C55','Administrator','jUDDI.org','uddi-org:operators','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#Operators',CURRENT TIMESTAMP);
-
-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,LAST_UPDATE)
-VALUES ('uuid:E59AE320-77A5-11D5-B898-0004AC49CC1E','Administrator','jUDDI.org','uddi-org:isReplacedBy','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#IsReplacedBy',CURRENT TIMESTAMP);
-
-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,LAST_UPDATE)
-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',CURRENT TIMESTAMP);
-
-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,LAST_UPDATE)
-VALUES ('uuid:B1B1BAF5-2329-43E6-AE13-BA8E97195039','Administrator','jUDDI.org','thomasregister-com:supplierID','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#Thomas',CURRENT TIMESTAMP);
-
-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');
-
-
-
-INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
-VALUES ('uuid:6E090AFA-33E5-36EB-81B7-1CA18373F457','Administrator','admin','jUDDI.org','uddi-org:wsdl:types','http://www.oasis-open.org/committees/uddi-spec/doc/tn/uddi-spec-tc-tn-wsdl-v2.htm#wsdlTypes',CURRENT TIMESTAMP);
-
-INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:6E090AFA-33E5-36EB-81B7-1CA18373F457',0,'en','WSDL Type Category System');
-
-INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:6E090AFA-33E5-36EB-81B7-1CA18373F457',0,'en','The WSDL Entity Type tModel uses a number of UDDI entities to represent the various entities within a WSDL document.');
-
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:6E090AFA-33E5-36EB-81B7-1CA18373F457',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','uddi-org:types','unchecked');
-
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:6E090AFA-33E5-36EB-81B7-1CA18373F457',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','uddi-org:types','categorization');
-
-
-INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
-VALUES ('uuid:D01987D1-AB2E-3013-9BE2-2A66EB99D824','Administrator','admin','jUDDI.org','uddi-org:xml:namespace','http://www.oasis-open.org/committees/uddi-spec/doc/tn/uddi-spec-tc-tn-wsdl-v2.htm#xmlNamespace',CURRENT TIMESTAMP);
-
-INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:D01987D1-AB2E-3013-9BE2-2A66EB99D824',0,'en','A category system used to indicate namespaces');
-
-INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:D01987D1-AB2E-3013-9BE2-2A66EB99D824',0,'en','A namespace provides necessary qualifying information about a technical concept or model. The XML Namespace tModel provides a mechanism to associate a namespace with a UDDI entity.');
-
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:D01987D1-AB2E-3013-9BE2-2A66EB99D824',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','uddi-org:types','unchecked');
-
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:D01987D1-AB2E-3013-9BE2-2A66EB99D824',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','uddi-org:types','categorization');
-
-
-INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
-VALUES ('uuid:2EC65201-9109-3919-9BEC-C9DBEFCACCF6','Administrator','admin','jUDDI.org','uddi-org:xml:localName','http://www.oasis-open.org/committees/uddi-spec/doc/tn/uddi-spec-tc-tn-wsdl-v2.htm#xmlLocalName',CURRENT TIMESTAMP);
-
-INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:2EC65201-9109-3919-9BEC-C9DBEFCACCF6',0,'en','A category system used to indicate XML local names');
-
-INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:2EC65201-9109-3919-9BEC-C9DBEFCACCF6',0,'en','The XML Local Name tModel provides a mechanism to indicate the name attribute for the uddi:businessService.');
-
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:2EC65201-9109-3919-9BEC-C9DBEFCACCF6',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','uddi-org:types','unchecked');
-
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:2EC65201-9109-3919-9BEC-C9DBEFCACCF6',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','uddi-org:types','categorization');
-
-
-INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
-VALUES ('uuid:082B0851-25D8-303C-B332-F24A6D53E38E','Administrator','admin','jUDDI.org','uddi-org:wsdl:portTypeReference','http://www.oasis-open.org/committees/uddi-spec/doc/tn/uddi-spec-tc-tn-wsdl-v2.htm#portTypeReference',CURRENT TIMESTAMP);
-
-INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:082B0851-25D8-303C-B332-F24A6D53E38E',0,'en','A category system used to reference a wsdl:portType tModel');
-
-INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:082B0851-25D8-303C-B332-F24A6D53E38E',0,'en','The WSDL portType Reference category system provides a mechanism to indicate that a UDDI entity has a relationship with a certain wsdl:portType tModel.');
-
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:082B0851-25D8-303C-B332-F24A6D53E38E',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','uddi-org:types','checked');
-
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:082B0851-25D8-303C-B332-F24A6D53E38E',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','uddi-org:types','categorization');
-
-
-INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
-VALUES ('uuid:AA254698-93DE-3870-8DF3-A5C075D64A0E','Administrator','admin','jUDDI.org','uddi-org:protocol:soap','http://www.oasis-open.org/committees/uddi-spec/doc/tn/uddi-spec-tc-tn-wsdl-v2.htm#soap',CURRENT TIMESTAMP);
-
-INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:AA254698-93DE-3870-8DF3-A5C075D64A0E',0,'en','A tModel that represents the SOAP 1.1 protocol');
-
-INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:AA254698-93DE-3870-8DF3-A5C075D64A0E',0,'en','The SOAP Protocol tModel can be used to indicate that a Web service supports the SOAP 1.1 protocol.');
-
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:AA254698-93DE-3870-8DF3-A5C075D64A0E',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','uddi-org:types','protocol');
-
-
-INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
-VALUES ('uuid:6E10B91B-BABC-3442-B8FC-5A3C8FDE0794','Administrator','admin','jUDDI.org','uddi-org:protocol:http','http://www.oasis-open.org/committees/uddi-spec/doc/tn/uddi-spec-tc-tn-wsdl-v2.htm#http',CURRENT TIMESTAMP);
-
-INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:6E10B91B-BABC-3442-B8FC-5A3C8FDE0794',0,'en','A tModel that represents the HTTP protocol');
-
-INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:6E10B91B-BABC-3442-B8FC-5A3C8FDE0794',0,'en','The HTTP Protocol tModel can be used to indicate that a Web service supports the HTTP protocol.');
-
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:6E10B91B-BABC-3442-B8FC-5A3C8FDE0794',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','uddi-org:types','protocol');
-
-
-INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
-VALUES ('uuid:4DC74177-7806-34D9-AECD-33C57DC3A865','Administrator','admin','jUDDI.org','uddi-org:wsdl:categorization:protocol','http://www.oasis-open.org/committees/uddi-spec/doc/tn/uddi-spec-tc-tn-wsdl-v2.htm#protocol',CURRENT TIMESTAMP);
-
-INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:4DC74177-7806-34D9-AECD-33C57DC3A865',0,'en','Category system used to describe the protocol supported by a wsdl:binding.');
-
-INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:4DC74177-7806-34D9-AECD-33C57DC3A865',0,'en','The Protocol Categorization tModel provides a mechanism to capture this protocol information in the UDDI binding tModel.');
-
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:4DC74177-7806-34D9-AECD-33C57DC3A865',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','uddi-org:types','categorization');
-
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:4DC74177-7806-34D9-AECD-33C57DC3A865',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','uddi-org:types','checked');
-
-
-INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
-VALUES ('uuid:E5C43936-86E4-37BF-8196-1D04B35C0099','Administrator','admin','jUDDI.org','uddi-org:wsdl:categorization:transport','http://www.oasis-open.org/committees/uddi-spec/doc/tn/uddi-spec-tc-tn-wsdl-v2.htm#transport',CURRENT TIMESTAMP);
-
-INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:E5C43936-86E4-37BF-8196-1D04B35C0099',0,'en','Category system used to describe the transport supported by a wsdl:binding.');
-
-INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:E5C43936-86E4-37BF-8196-1D04B35C0099',0,'en','The Transport Categorization tModel provides a mechanism to capture transport information in the UDDI binding tModel which allows a user to search for bindings that implement a specific transport protocol.');
-
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:E5C43936-86E4-37BF-8196-1D04B35C0099',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','uddi-org:types','categorization');
-
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:E5C43936-86E4-37BF-8196-1D04B35C0099',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','uddi-org:types','checked');
-
-
-INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
-VALUES ('uuid:AD61DE98-4DB8-31B2-A299-A2373DC97212','Administrator','admin','jUDDI.org','uddi-org:wsdl:address','http://www.oasis-open.org/committees/uddi-spec/doc/tn/uddi-spec-tc-tn-wsdl-v2.htm#Address',CURRENT TIMESTAMP);
-
-INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:AD61DE98-4DB8-31B2-A299-A2373DC97212',0,'en','A tModel used to indicate the WSDL address option.');
-
-INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:AD61DE98-4DB8-31B2-A299-A2373DC97212',0,'en','The WSDL Address tModel provides A mechanism to indicate that the endpoint address should be obtained from a WSDL document.');
-
--- ** http transport **
-INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
-VALUES ('uuid:68DE9E80-AD09-469D-8A37-088422BFBC36','Administrator','admin','jUDDI.org','uddi-org:http','http://www.uddi.org/taxonomies/UDDI_CoreOther_tModels.htm#overHTTP',CURRENT TIMESTAMP);
-INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:68DE9E80-AD09-469D-8A37-088422BFBC36',0,'en','An HTTP or web browser-based web service');
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:68DE9E80-AD09-469D-8A37-088422BFBC36',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','tModelType','transport');
-
--- ** uddi inquiry **
-INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
-VALUES ('uuid:AC104DCC-D623-452F-88A7-F8ACD94D9B2B','Administrator','admin','jUDDI.org','uddi-org:inquiry_v2','http://www.uddi.org/wsdl/inquire_v2.wsdl',CURRENT TIMESTAMP);
-INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:AC104DCC-D623-452F-88A7-F8ACD94D9B2B',0,'en','UDDI Inquiry API Version 2 - Core Specification');
-INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:AC104DCC-D623-452F-88A7-F8ACD94D9B2B',0,'en','This tModel defines the inquiry API calls for interacting with a V2 UDDI node.');
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:AC104DCC-D623-452F-88A7-F8ACD94D9B2B',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','specification');
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:AC104DCC-D623-452F-88A7-F8ACD94D9B2B',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','xmlSpec');
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:AC104DCC-D623-452F-88A7-F8ACD94D9B2B',2,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','soapSpec');
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:AC104DCC-D623-452F-88A7-F8ACD94D9B2B',3,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','wsdlSpec');
-
--- ** uddi-org:taxonomy_V2
-INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
-VALUES ('uuid:1E3E9CBC-F8CE-41ab-8F99-88326BAD324A','Administrator','admin','jUDDI.org','uddi-org:taxonomy_v2','http://www.uddi.org/taxonomies/UDDI_Registry_tModels.htm#TaxV2',CURRENT_TIMESTAMP);
-INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:1E3E9CBC-F8CE-41ab-8F99-88326BAD324A',0,'en','UDDI Taxonomy API Version 2 - Core Specification');
-INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
-VALUES ('uuid:1E3E9CBC-F8CE-41ab-8F99-88326BAD324A',0,'en','This tModel defines the taxonomy validation API calls for interacting with a V2 UDDI node.');
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:1E3E9CBC-F8CE-41ab-8F99-88326BAD324A',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','specification');
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:1E3E9CBC-F8CE-41ab-8F99-88326BAD324A',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','xmlSpec');
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
-VALUES ('uuid:1E3E9CBC-F8CE-41ab-8F99-88326BAD324A',2,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','soapSpec');
-
+--
+-- Licensed to the Apache Software Foundation (ASF) under one or more
+-- contributor license agreements. See the NOTICE file distributed with
+-- this work for additional information regarding copyright ownership.
+-- The ASF licenses this file to You under the Apache License, Version 2.0
+-- (the "License"); you may not use this file except in compliance with
+-- the License. You may obtain a copy of the License at
+--
+-- http://www.apache.org/licenses/LICENSE-2.0
+--
+-- Unless required by applicable law or agreed to in writing, software
+-- distributed under the License is distributed on an "AS IS" BASIS,
+-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+-- See the License for the specific language governing permissions and
+-- limitations under the License.
+--
+-- $Rev$ $Date$
+--
+
+CREATE TABLE J3_PERSON_NAME (
+ ID BIGINT NOT NULL,
+ LANG_CODE VARCHAR(5),
+ NAME VARCHAR(255) NOT NULL,
+ CONTACT_ID BIGINT NOT NULL
+ );
+
+CREATE TABLE J3_TRANSFER_TOKEN (
+ TRANSFER_TOKEN VARCHAR(51) NOT NULL,
+ EXPIRATION_DATE TIMESTAMP NOT NULL
+ );
+
+CREATE TABLE J3_ADDRESS_LINE (
+ ID BIGINT NOT NULL,
+ KEY_NAME VARCHAR(255),
+ KEY_VALUE VARCHAR(255),
+ LINE VARCHAR(80) NOT NULL,
+ ADDRESS_ID BIGINT NOT NULL
+ );
+
+CREATE TABLE J3_INSTANCE_DETAILS_DOC_DESCR (
+ ID BIGINT NOT NULL,
+ DESCR VARCHAR(1024) NOT NULL,
+ LANG_CODE VARCHAR(5),
+ TMODEL_INSTANCE_INFO_ID BIGINT NOT NULL
+ );
+
+CREATE TABLE J3_OVERVIEW_DOC_DESCR (
+ ID BIGINT NOT NULL,
+ DESCR VARCHAR(1024) NOT NULL,
+ LANG_CODE VARCHAR(5),
+ OVERVIEW_DOC_ID BIGINT
+ );
+
+CREATE TABLE J3_PUBLISHER (
+ AUTHORIZED_NAME VARCHAR(255) NOT NULL,
+ EMAIL_ADDRESS VARCHAR(255),
+ IS_ADMIN VARCHAR(5),
+ IS_ENABLED VARCHAR(5),
+ MAX_BINDINGS_PER_SERVICE INTEGER,
+ MAX_BUSINESSES INTEGER,
+ MAX_SERVICES_PER_BUSINESS INTEGER,
+ MAX_TMODELS INTEGER,
+ PUBLISHER_NAME VARCHAR(255) NOT NULL
+ );
+
+CREATE TABLE J3_PUBLISHER_ASSERTION (
+ FROM_KEY VARCHAR(255) NOT NULL,
+ TO_KEY VARCHAR(255) NOT NULL,
+ FROM_CHECK VARCHAR(5) NOT NULL,
+ KEY_NAME VARCHAR(255) NOT NULL,
+ KEY_VALUE VARCHAR(255) NOT NULL,
+ TMODEL_KEY VARCHAR(255) NOT NULL,
+ TO_CHECK VARCHAR(5) NOT NULL
+ );
+
+CREATE TABLE J3_ADDRESS (
+ ID BIGINT NOT NULL,
+ SORT_CODE VARCHAR(10),
+ TMODEL_KEY VARCHAR(255),
+ USE_TYPE VARCHAR(255),
+ ADDRESS_ID BIGINT NOT NULL
+ );
+
+CREATE TABLE J3_UDDI_ENTITY (
+ ENTITY_KEY VARCHAR(255) NOT NULL,
+ AUTHORIZED_NAME VARCHAR(255) NOT NULL,
+ CREATED TIMESTAMP,
+ MODIFIED TIMESTAMP NOT NULL,
+ MODIFIED_INCLUDING_CHILDREN TIMESTAMP,
+ NODE_ID VARCHAR(255)
+ );
+
+CREATE TABLE J3_SUBSCRIPTION (
+ SUBSCRIPTION_KEY VARCHAR(255) NOT NULL,
+ AUTHORIZED_NAME VARCHAR(255) NOT NULL,
+ BINDING_KEY VARCHAR(255),
+ BRIEF SMALLINT,
+ CREATE_DATE TIMESTAMP NOT NULL,
+ EXPIRES_AFTER TIMESTAMP,
+ LAST_NOTIFIED TIMESTAMP,
+ MAX_ENTITIES INTEGER,
+ NOTIFICATION_INTERVAL VARCHAR(255),
+ SUBSCRIPTION_FILTER CLOB(2147483647) NOT NULL
+ );
+
+CREATE TABLE J3_BUSINESS_SERVICE (
+ ENTITY_KEY VARCHAR(255) NOT NULL,
+ BUSINESS_KEY VARCHAR(255) NOT NULL
+ );
+
+CREATE TABLE J3_BUSINESS_DESCR (
+ ID BIGINT NOT NULL,
+ DESCR VARCHAR(1024) NOT NULL,
+ LANG_CODE VARCHAR(5),
+ ENTITY_KEY VARCHAR(255) NOT NULL
+ );
+
+CREATE TABLE J3_BUSINESS_CATEGORY_BAG (
+ ID BIGINT NOT NULL,
+ ENTITY_KEY VARCHAR(255)
+ );
+
+CREATE TABLE J3_CLIENT_SUBSCRIPTIONINFO (
+ SUBSCRIPTION_KEY VARCHAR(255) NOT NULL,
+ LAST_NOTIFIED TIMESTAMP,
+ FROMCLERK_CLERK_NAME VARCHAR(255),
+ TOCLERK_CLERK_NAME VARCHAR(255)
+ );
+
+CREATE TABLE J3_KEYED_REFERENCE_GROUP (
+ ID BIGINT NOT NULL,
+ TMODEL_KEY VARCHAR(255),
+ CATEGORY_BAG_ID BIGINT NOT NULL
+ );
+
+CREATE TABLE J3_CONTACT (
+ ID BIGINT NOT NULL,
+ USE_TYPE VARCHAR(255),
+ ENTITY_KEY VARCHAR(255) NOT NULL
+ );
+
+CREATE TABLE J3_TMODEL (
+ ENTITY_KEY VARCHAR(255) NOT NULL,
+ DELETED SMALLINT,
+ LANG_CODE VARCHAR(5),
+ NAME VARCHAR(255) NOT NULL
+ );
+
+CREATE TABLE OPENJPA_SEQUENCE_TABLE (
+ ID SMALLINT NOT NULL,
+ SEQUENCE_VALUE BIGINT
+ );
+
+CREATE TABLE J3_OVERVIEW_DOC (
+ ID BIGINT NOT NULL,
+ OVERVIEW_URL VARCHAR(255),
+ OVERVIEW_URL_USE_TYPE VARCHAR(255),
+ ENTITY_KEY VARCHAR(255),
+ TOMODEL_INSTANCE_INFO_ID BIGINT
+ );
+
+CREATE TABLE J3_TMODEL_INSTANCE_INFO (
+ ID BIGINT NOT NULL,
+ INSTANCE_PARMS VARCHAR(512),
+ TMODEL_KEY VARCHAR(255) NOT NULL,
+ ENTITY_KEY VARCHAR(255) NOT NULL
+ );
+
+CREATE TABLE J3_INSTANCE_DETAILS_DESCR (
+ ID BIGINT NOT NULL,
+ DESCR VARCHAR(1024) NOT NULL,
+ LANG_CODE VARCHAR(5),
+ TMODEL_INSTANCE_INFO_ID BIGINT NOT NULL
+ );
+
+CREATE TABLE J3_TMODEL_DESCR (
+ ID BIGINT NOT NULL,
+ DESCR VARCHAR(1024) NOT NULL,
+ LANG_CODE VARCHAR(5),
+ ENTITY_KEY VARCHAR(255) NOT NULL
+ );
+
+CREATE TABLE J3_SUBSCRIPTION_MATCH (
+ ID BIGINT NOT NULL,
+ ENTITY_KEY VARCHAR(255) NOT NULL,
+ SUBSCRIPTION_KEY VARCHAR(255) NOT NULL
+ );
+
+CREATE TABLE J3_BINDING_CATEGORY_BAG (
+ ID BIGINT NOT NULL,
+ ENTITY_KEY VARCHAR(255)
+ );
+
+CREATE TABLE J3_EMAIL (
+ ID BIGINT NOT NULL,
+ EMAIL_ADDRESS VARCHAR(255) NOT NULL,
+ USE_TYPE VARCHAR(255),
+ CONTACT_ID BIGINT NOT NULL
+ );
+
+CREATE TABLE J3_SERVICE_DESCR (
+ ID BIGINT NOT NULL,
+ DESCR VARCHAR(1024) NOT NULL,
+ LANG_CODE VARCHAR(5),
+ ENTITY_KEY VARCHAR(255) NOT NULL
+ );
+
+CREATE TABLE J3_PHONE (
+ ID BIGINT NOT NULL,
+ PHONE_NUMBER VARCHAR(50) NOT NULL,
+ USE_TYPE VARCHAR(255),
+ CONTACT_ID BIGINT NOT NULL
+ );
+
+CREATE TABLE J3_TMODEL_INSTANCE_INFO_DESCR (
+ ID BIGINT NOT NULL,
+ DESCR VARCHAR(1024) NOT NULL,
+ LANG_CODE VARCHAR(5),
+ TMODEL_INSTANCE_INFO_ID BIGINT NOT NULL
+ );
+
+CREATE TABLE J3_CLERK (
+ CLERK_NAME VARCHAR(255) NOT NULL,
+ CRED VARCHAR(255),
+ PUBLISHER_ID VARCHAR(255) NOT NULL,
+ NODE_NAME VARCHAR(255)
+ );
+
+CREATE TABLE J3_TMODEL_CATEGORY_BAG (
+ ID BIGINT NOT NULL,
+ ENTITY_KEY VARCHAR(255)
+ );
+
+CREATE TABLE J3_BINDING_DESCR (
+ ID BIGINT NOT NULL,
+ DESCR VARCHAR(1024) NOT NULL,
+ LANG_CODE VARCHAR(5),
+ ENTITY_KEY VARCHAR(255) NOT NULL
+ );
+
+CREATE TABLE J3_TRANSFER_TOKEN_KEYS (
+ ID BIGINT NOT NULL,
+ ENTITY_KEY VARCHAR(255),
+ TRANSFER_TOKEN VARCHAR(255) NOT NULL
+ );
+
+CREATE TABLE J3_DISCOVERY_URL (
+ ID BIGINT NOT NULL,
+ URL VARCHAR(255) NOT NULL,
+ USE_TYPE VARCHAR(255) NOT NULL,
+ ENTITY_KEY VARCHAR(255) NOT NULL
+ );
+
+CREATE TABLE J3_TMODEL_IDENTIFIER (
+ ID BIGINT NOT NULL,
+ KEY_NAME VARCHAR(255),
+ KEY_VALUE VARCHAR(255) NOT NULL,
+ TMODEL_KEY_REF VARCHAR(255),
+ ENTITY_KEY VARCHAR(255) NOT NULL
+ );
+
+CREATE TABLE J3_CONTACT_DESCR (
+ ID BIGINT NOT NULL,
+ DESCR VARCHAR(1024) NOT NULL,
+ LANG_CODE VARCHAR(5),
+ CONTACT_ID BIGINT NOT NULL
+ );
+
+CREATE TABLE J3_CATEGORY_BAG (
+ ID BIGINT NOT NULL
+ );
+
+CREATE TABLE J3_SERVICE_PROJECTION (
+ BUSINESS_KEY VARCHAR(255) NOT NULL,
+ SERVICE_KEY VARCHAR(255) NOT NULL
+ );
+
+CREATE TABLE J3_BUSINESS_NAME (
+ ID BIGINT NOT NULL,
+ LANG_CODE VARCHAR(5),
+ NAME VARCHAR(255) NOT NULL,
+ ENTITY_KEY VARCHAR(255) NOT NULL
+ );
+
+CREATE TABLE J3_SERVICE_CATEGORY_BAG (
+ ID BIGINT NOT NULL,
+ ENTITY_KEY VARCHAR(255)
+ );
+
+CREATE TABLE J3_NODE (
+ NAME VARCHAR(255) NOT NULL,
+ CUSTODY_TRANSFER_URL VARCHAR(255) NOT NULL,
+ FACTORY_INITIAL VARCHAR(255),
+ FACTORY_NAMING_PROVIDER VARCHAR(255),
+ FACTORY_URL_PKGS VARCHAR(255),
+ INQUIRY_URL VARCHAR(255) NOT NULL,
+ JUDDI_API_URL VARCHAR(255),
+ MANAGER_NAME VARCHAR(255) NOT NULL,
+ PROXY_TRANSPORT VARCHAR(255) NOT NULL,
+ PUBLISH_URL VARCHAR(255) NOT NULL,
+ SECURITY_URL VARCHAR(255) NOT NULL,
+ SUBSCRIPTION_URL VARCHAR(255) NOT NULL
+ );
+
+CREATE TABLE J3_BINDING_TEMPLATE (
+ ENTITY_KEY VARCHAR(255) NOT NULL,
+ ACCESS_POINT_TYPE VARCHAR(255),
+ ACCESS_POINT_URL VARCHAR(4000),
+ HOSTING_REDIRECTOR VARCHAR(255),
+ SERVICE_KEY VARCHAR(255) NOT NULL
+ );
+
+CREATE TABLE J3_KEYED_REFERENCE (
+ ID BIGINT NOT NULL,
+ KEY_NAME VARCHAR(255),
+ KEY_VALUE VARCHAR(255) NOT NULL,
+ TMODEL_KEY_REF VARCHAR(255),
+ CATEGORY_BAG_ID BIGINT,
+ KEYED_REFERENCE_GROUP_ID BIGINT
+ );
+
+CREATE TABLE J3_AUTH_TOKEN (
+ AUTH_TOKEN VARCHAR(51) NOT NULL,
+ AUTHORIZED_NAME VARCHAR(255) NOT NULL,
+ CREATED TIMESTAMP NOT NULL,
+ LAST_USED TIMESTAMP NOT NULL,
+ NUMBER_OF_USES INTEGER NOT NULL,
+ TOKEN_STATE INTEGER NOT NULL
+ );
+
+CREATE TABLE J3_SUBSCRIPTION_CHUNK_TOKEN (
+ CHUNK_TOKEN VARCHAR(255) NOT NULL,
+ DATA INTEGER NOT NULL,
+ END_POINT TIMESTAMP,
+ EXPIRES_AFTER TIMESTAMP NOT NULL,
+ START_POINT TIMESTAMP,
+ SUBSCRIPTION_KEY VARCHAR(255) NOT NULL
+ );
+
+CREATE TABLE J3_SERVICE_NAME (
+ ID BIGINT NOT NULL,
+ LANG_CODE VARCHAR(5),
+ NAME VARCHAR(255) NOT NULL,
+ ENTITY_KEY VARCHAR(255) NOT NULL
+ );
+
+CREATE TABLE J3_BUSINESS_IDENTIFIER (
+ ID BIGINT NOT NULL,
+ KEY_NAME VARCHAR(255),
+ KEY_VALUE VARCHAR(255) NOT NULL,
+ TMODEL_KEY_REF VARCHAR(255),
+ ENTITY_KEY VARCHAR(255) NOT NULL
+ );
+
+CREATE TABLE J3_BUSINESS_ENTITY (
+ ENTITY_KEY VARCHAR(255) NOT NULL
+ );
+
+CREATE INDEX I_J3_TSCR_TMODEL ON J3_TMODEL_DESCR (ENTITY_KEY ASC);
+
+CREATE UNIQUE INDEX SQL101221160128000 ON J3_TMODEL (ENTITY_KEY ASC);
+
+CREATE INDEX I_J3_PHON_CONTACT ON J3_PHONE (CONTACT_ID ASC);
+
+CREATE INDEX I_J3_BRVC_BUSINESSENTITY ON J3_BUSINESS_SERVICE (BUSINESS_KEY ASC);
+
+CREATE INDEX I_J3_S_NM_BUSINESSSERVICE ON J3_SERVICE_NAME (ENTITY_KEY ASC);
+
+CREATE INDEX I_J3_CNNF_TOCLERK ON J3_CLIENT_SUBSCRIPTIONINFO (TOCLERK_CLERK_NAME ASC);
+
+CREATE UNIQUE INDEX SQL101221160121420 ON J3_CLIENT_SUBSCRIPTIONINFO (SUBSCRIPTION_KEY ASC);
+
+CREATE INDEX I_J3_BSCR_BINDINGTEMPLATE ON J3_BINDING_DESCR (ENTITY_KEY ASC);
+
+CREATE INDEX I_J3_DRSS_CONTACT ON J3_ADDRESS (ADDRESS_ID ASC);
+
+CREATE UNIQUE INDEX SQL101221160120410 ON J3_BUSINESS_NAME (ID ASC);
+
+CREATE UNIQUE INDEX SQL101221160126530 ON J3_SERVICE_PROJECTION (BUSINESS_KEY ASC, SERVICE_KEY ASC);
+
+CREATE INDEX I_J3_P_NM_CONTACT ON J3_PERSON_NAME (CONTACT_ID ASC);
+
+CREATE UNIQUE INDEX SQL101221160129560 ON J3_TRANSFER_TOKEN (TRANSFER_TOKEN ASC);
+
+CREATE UNIQUE INDEX SQL101221160123590 ON J3_KEYED_REFERENCE_GROUP (ID ASC);
+
+CREATE INDEX I_J3_VSCR_OVERVIEWDOC ON J3_OVERVIEW_DOC_DESCR (OVERVIEW_DOC_ID ASC);
+
+CREATE UNIQUE INDEX SQL101221160129830 ON J3_TRANSFER_TOKEN_KEYS (ID ASC);
+
+CREATE UNIQUE INDEX SQL101221160126780 ON J3_SUBSCRIPTION (SUBSCRIPTION_KEY ASC);
+
+CREATE UNIQUE INDEX SQL101221160118890 ON J3_BINDING_DESCR (ID ASC);
+
+CREATE INDEX I_J3_CTCT_BUSINESSENTITY ON J3_CONTACT (ENTITY_KEY ASC);
+
+CREATE UNIQUE INDEX SQL101221160123870 ON J3_NODE (NAME ASC);
+
+CREATE UNIQUE INDEX SQL101221160128670 ON J3_TMODEL_IDENTIFIER (ID ASC);
+
+CREATE UNIQUE INDEX SQL101221160122440 ON J3_EMAIL (ID ASC);
+
+CREATE UNIQUE INDEX SQL101221160124160 ON J3_OVERVIEW_DOC (ID ASC);
+
+CREATE INDEX I_J3_TSCR_TMODELINSTANCEINFO ON J3_TMODEL_INSTANCE_INFO_DESCR (TMODEL_INSTANCE_INFO_ID ASC);
+
+CREATE UNIQUE INDEX SQL101221160130130 ON J3_UDDI_ENTITY (ENTITY_KEY ASC);
+
+CREATE INDEX I_J3_NSCR_TMODELINSTANCEINFO ON J3_INSTANCE_DETAILS_DESCR (TMODEL_INSTANCE_INFO_ID ASC);
+
+CREATE UNIQUE INDEX SQL101221160125640 ON J3_PUBLISHER_ASSERTION (FROM_KEY ASC, TO_KEY ASC);
+
+CREATE UNIQUE INDEX SQL101221160119730 ON J3_BUSINESS_DESCR (ID ASC);
+
+CREATE UNIQUE INDEX SQL101221160119500 ON J3_BUSINESS_CATEGORY_BAG (ID ASC);
+
+CREATE UNIQUE INDEX SQL101221160127550 ON J3_SUBSCRIPTION_CHUNK_TOKEN (CHUNK_TOKEN ASC);
+
+CREATE UNIQUE INDEX SQL101221160126090 ON J3_SERVICE_DESCR (ID ASC);
+
+CREATE INDEX I_J3_BTFR_BUSINESSENTITY ON J3_BUSINESS_IDENTIFIER (ENTITY_KEY ASC);
+
+CREATE UNIQUE INDEX SQL101221160120180 ON J3_BUSINESS_IDENTIFIER (ID ASC);
+
+CREATE UNIQUE INDEX SQL101221160128210 ON J3_TMODEL_CATEGORY_BAG (ID ASC);
+
+CREATE INDEX I_J3_BSCR_BUSINESSENTITY ON J3_BUSINESS_DESCR (ENTITY_KEY ASC);
+
+CREATE INDEX I_J3_BPLT_BUSINESSSERVICE ON J3_BINDING_TEMPLATE (SERVICE_KEY ASC);
+
+CREATE INDEX I_J3_T_NF_BINDINGTEMPLATE ON J3_TMODEL_INSTANCE_INFO (ENTITY_KEY ASC);
+
+CREATE UNIQUE INDEX SQL101221160118450 ON J3_AUTH_TOKEN (AUTH_TOKEN ASC);
+
+CREATE INDEX I_J3_B_BG_BINDINGTEMPLATE ON J3_BINDING_CATEGORY_BAG (ENTITY_KEY ASC);
+
+CREATE UNIQUE INDEX SQL101221160120860 ON J3_CATEGORY_BAG (ID ASC);
+
+CREATE INDEX I_J3_V_DC_TMODEL ON J3_OVERVIEW_DOC (ENTITY_KEY ASC);
+
+CREATE INDEX I_J3_S_BG_BUSINESSSERVICE ON J3_SERVICE_CATEGORY_BAG (ENTITY_KEY ASC);
+
+CREATE UNIQUE INDEX SQL101221160123320 ON J3_KEYED_REFERENCE (ID ASC);
+
+CREATE UNIQUE INDEX SQL101221160121930 ON J3_CONTACT_DESCR (ID ASC);
+
+CREATE UNIQUE INDEX SQL101221160121170 ON J3_CLERK (CLERK_NAME ASC);
+
+CREATE UNIQUE INDEX SQL101221160127780 ON J3_SUBSCRIPTION_MATCH (ID ASC);
+
+CREATE UNIQUE INDEX SQL101221160120640 ON J3_BUSINESS_SERVICE (ENTITY_KEY ASC);
+
+CREATE UNIQUE INDEX SQL101221160128950 ON J3_TMODEL_INSTANCE_INFO (ID ASC);
+
+CREATE INDEX I_J3_CLRK_NODE ON J3_CLERK (NODE_NAME ASC);
+
+CREATE INDEX I_J3_STCH_SUBSCRIPTION ON J3_SUBSCRIPTION_MATCH (SUBSCRIPTION_KEY ASC);
+
+CREATE UNIQUE INDEX SQL101221160119940 ON J3_BUSINESS_ENTITY (ENTITY_KEY ASC);
+
+CREATE INDEX I_J3_EMIL_CONTACT ON J3_EMAIL (CONTACT_ID ASC);
+
+CREATE UNIQUE INDEX SQL101221160118210 ON J3_ADDRESS_LINE (ID ASC);
+
+CREATE UNIQUE INDEX SQL101221160128420 ON J3_TMODEL_DESCR (ID ASC);
+
+CREATE INDEX I_J3_T_BG_TMODEL ON J3_TMODEL_CATEGORY_BAG (ENTITY_KEY ASC);
+
+CREATE INDEX I_J3_KRNC_CATEGORYBAG ON J3_KEYED_REFERENCE (CATEGORY_BAG_ID ASC);
+
+CREATE UNIQUE INDEX SQL101221160126300 ON J3_SERVICE_NAME (ID ASC);
+
+CREATE UNIQUE INDEX SQL101221160125370 ON J3_PUBLISHER (AUTHORIZED_NAME ASC);
+
+CREATE INDEX I_J3_SSCR_BUSINESSSERVICE ON J3_SERVICE_DESCR (ENTITY_KEY ASC);
+
+CREATE UNIQUE INDEX SQL101221160122740 ON J3_INSTANCE_DETAILS_DESCR (ID ASC);
+
+CREATE UNIQUE INDEX SQL101221160129300 ON J3_TMODEL_INSTANCE_INFO_DESCR (ID ASC);
+
+CREATE INDEX I_J3_KRNC_KEYEDREFERENCEGROUP ON J3_KEYED_REFERENCE (KEYED_REFERENCE_GROUP_ID ASC);
+
+CREATE INDEX I_J3_B_NM_BUSINESSENTITY ON J3_BUSINESS_NAME (ENTITY_KEY ASC);
+
+CREATE UNIQUE INDEX SQL101221160125870 ON J3_SERVICE_CATEGORY_BAG (ID ASC);
+
+CREATE INDEX I_J3_D_LN_ADDRESS ON J3_ADDRESS_LINE (ADDRESS_ID ASC);
+
+CREATE INDEX I_J3_TTFR_TMODEL ON J3_TMODEL_IDENTIFIER (ENTITY_KEY ASC);
+
+CREATE INDEX I_J3_NSCR_TMODELINSTANCEINFO1 ON J3_INSTANCE_DETAILS_DOC_DESCR (TMODEL_INSTANCE_INFO_ID ASC);
+
+CREATE UNIQUE INDEX SQL101221160124440 ON J3_OVERVIEW_DOC_DESCR (ID ASC);
+
+CREATE UNIQUE INDEX SQL101221160124690 ON J3_PERSON_NAME (ID ASC);
+
+CREATE INDEX I_J3_CNNF_FROMCLERK ON J3_CLIENT_SUBSCRIPTIONINFO (FROMCLERK_CLERK_NAME ASC);
+
+CREATE UNIQUE INDEX SQL101221160119280 ON J3_BINDING_TEMPLATE (ENTITY_KEY ASC);
+
+CREATE UNIQUE INDEX SQL101221160117940 ON J3_ADDRESS (ID ASC);
+
+CREATE INDEX I_J3_KGRP_CATEGORYBAG ON J3_KEYED_REFERENCE_GROUP (CATEGORY_BAG_ID ASC);
+
+CREATE UNIQUE INDEX SQL101221160124970 ON J3_PHONE (ID ASC);
+
+CREATE UNIQUE INDEX SQL101221160130460 ON OPENJPA_SEQUENCE_TABLE (ID ASC);
+
+CREATE UNIQUE INDEX SQL101221160123010 ON J3_INSTANCE_DETAILS_DOC_DESCR (ID ASC);
+
+CREATE INDEX I_J3_CSCR_CONTACT ON J3_CONTACT_DESCR (CONTACT_ID ASC);
+
+CREATE UNIQUE INDEX SQL101221160121690 ON J3_CONTACT (ID ASC);
+
+CREATE INDEX I_J3_TKYS_TRANSFERTOKEN ON J3_TRANSFER_TOKEN_KEYS (TRANSFER_TOKEN ASC);
+
+CREATE INDEX I_J3_V_DC_TMODELINSTANCEINFO ON J3_OVERVIEW_DOC (TOMODEL_INSTANCE_INFO_ID ASC);
+
+CREATE UNIQUE INDEX SQL101221160122200 ON J3_DISCOVERY_URL (ID ASC);
+
+CREATE INDEX I_J3_B_BG_BUSINESSENTITY ON J3_BUSINESS_CATEGORY_BAG (ENTITY_KEY ASC);
+
+CREATE UNIQUE INDEX SQL101221160118680 ON J3_BINDING_CATEGORY_BAG (ID ASC);
+
+CREATE INDEX I_J3_D_RL_BUSINESSENTITY ON J3_DISCOVERY_URL (ENTITY_KEY ASC);
+
+ALTER TABLE J3_SUBSCRIPTION_MATCH ADD CONSTRAINT SQL101221160127780 PRIMARY KEY (ID);
+
+ALTER TABLE J3_SERVICE_DESCR ADD CONSTRAINT SQL101221160126090 PRIMARY KEY (ID);
+
+ALTER TABLE J3_AUTH_TOKEN ADD CONSTRAINT SQL101221160118450 PRIMARY KEY (AUTH_TOKEN);
+
+ALTER TABLE J3_TMODEL_INSTANCE_INFO_DESCR ADD CONSTRAINT SQL101221160129300 PRIMARY KEY (ID);
+
+ALTER TABLE J3_TMODEL_DESCR ADD CONSTRAINT SQL101221160128420 PRIMARY KEY (ID);
+
+ALTER TABLE J3_BUSINESS_CATEGORY_BAG ADD CONSTRAINT SQL101221160119500 PRIMARY KEY (ID);
+
+ALTER TABLE J3_INSTANCE_DETAILS_DESCR ADD CONSTRAINT SQL101221160122740 PRIMARY KEY (ID);
+
+ALTER TABLE J3_TMODEL_IDENTIFIER ADD CONSTRAINT SQL101221160128670 PRIMARY KEY (ID);
+
+ALTER TABLE J3_TRANSFER_TOKEN ADD CONSTRAINT SQL101221160129560 PRIMARY KEY (TRANSFER_TOKEN);
+
+ALTER TABLE J3_TMODEL ADD CONSTRAINT SQL101221160128000 PRIMARY KEY (ENTITY_KEY);
+
+ALTER TABLE J3_TMODEL_INSTANCE_INFO ADD CONSTRAINT SQL101221160128950 PRIMARY KEY (ID);
+
+ALTER TABLE J3_CLERK ADD CONSTRAINT SQL101221160121170 PRIMARY KEY (CLERK_NAME);
+
+ALTER TABLE J3_OVERVIEW_DOC ADD CONSTRAINT SQL101221160124160 PRIMARY KEY (ID);
+
+ALTER TABLE J3_INSTANCE_DETAILS_DOC_DESCR ADD CONSTRAINT SQL101221160123010 PRIMARY KEY (ID);
+
+ALTER TABLE J3_ADDRESS_LINE ADD CONSTRAINT SQL101221160118210 PRIMARY KEY (ID);
+
+ALTER TABLE J3_OVERVIEW_DOC_DESCR ADD CONSTRAINT SQL101221160124440 PRIMARY KEY (ID);
+
+ALTER TABLE J3_NODE ADD CONSTRAINT SQL101221160123870 PRIMARY KEY (NAME);
+
+ALTER TABLE J3_BUSINESS_ENTITY ADD CONSTRAINT SQL101221160119940 PRIMARY KEY (ENTITY_KEY);
+
+ALTER TABLE J3_KEYED_REFERENCE_GROUP ADD CONSTRAINT SQL101221160123590 PRIMARY KEY (ID);
+
+ALTER TABLE J3_SUBSCRIPTION ADD CONSTRAINT SQL101221160126780 PRIMARY KEY (SUBSCRIPTION_KEY);
+
+ALTER TABLE OPENJPA_SEQUENCE_TABLE ADD CONSTRAINT SQL101221160130460 PRIMARY KEY (ID);
+
+ALTER TABLE J3_BUSINESS_IDENTIFIER ADD CONSTRAINT SQL101221160120180 PRIMARY KEY (ID);
+
+ALTER TABLE J3_EMAIL ADD CONSTRAINT SQL101221160122440 PRIMARY KEY (ID);
+
+ALTER TABLE J3_KEYED_REFERENCE ADD CONSTRAINT SQL101221160123320 PRIMARY KEY (ID);
+
+ALTER TABLE J3_CONTACT_DESCR ADD CONSTRAINT SQL101221160121930 PRIMARY KEY (ID);
+
+ALTER TABLE J3_PHONE ADD CONSTRAINT SQL101221160124970 PRIMARY KEY (ID);
+
+ALTER TABLE J3_CONTACT ADD CONSTRAINT SQL101221160121690 PRIMARY KEY (ID);
+
+ALTER TABLE J3_BINDING_DESCR ADD CONSTRAINT SQL101221160118890 PRIMARY KEY (ID);
+
+ALTER TABLE J3_PUBLISHER ADD CONSTRAINT SQL101221160125370 PRIMARY KEY (AUTHORIZED_NAME);
+
+ALTER TABLE J3_UDDI_ENTITY ADD CONSTRAINT SQL101221160130130 PRIMARY KEY (ENTITY_KEY);
+
+ALTER TABLE J3_CATEGORY_BAG ADD CONSTRAINT SQL101221160120860 PRIMARY KEY (ID);
+
+ALTER TABLE J3_BUSINESS_DESCR ADD CONSTRAINT SQL101221160119730 PRIMARY KEY (ID);
+
+ALTER TABLE J3_DISCOVERY_URL ADD CONSTRAINT SQL101221160122200 PRIMARY KEY (ID);
+
+ALTER TABLE J3_BUSINESS_SERVICE ADD CONSTRAINT SQL101221160120640 PRIMARY KEY (ENTITY_KEY);
+
+ALTER TABLE J3_TRANSFER_TOKEN_KEYS ADD CONSTRAINT SQL101221160129830 PRIMARY KEY (ID);
+
+ALTER TABLE J3_CLIENT_SUBSCRIPTIONINFO ADD CONSTRAINT SQL101221160121420 PRIMARY KEY (SUBSCRIPTION_KEY);
+
+ALTER TABLE J3_SUBSCRIPTION_CHUNK_TOKEN ADD CONSTRAINT SQL101221160127550 PRIMARY KEY (CHUNK_TOKEN);
+
+ALTER TABLE J3_SERVICE_CATEGORY_BAG ADD CONSTRAINT SQL101221160125870 PRIMARY KEY (ID);
+
+ALTER TABLE J3_PERSON_NAME ADD CONSTRAINT SQL101221160124690 PRIMARY KEY (ID);
+
+ALTER TABLE J3_ADDRESS ADD CONSTRAINT SQL101221160117940 PRIMARY KEY (ID);
+
+ALTER TABLE J3_PUBLISHER_ASSERTION ADD CONSTRAINT SQL101221160125640 PRIMARY KEY (FROM_KEY, TO_KEY);
+
+ALTER TABLE J3_TMODEL_CATEGORY_BAG ADD CONSTRAINT SQL101221160128210 PRIMARY KEY (ID);
+
+ALTER TABLE J3_SERVICE_PROJECTION ADD CONSTRAINT SQL101221160126530 PRIMARY KEY (BUSINESS_KEY, SERVICE_KEY);
+
+ALTER TABLE J3_SERVICE_NAME ADD CONSTRAINT SQL101221160126300 PRIMARY KEY (ID);
+
+ALTER TABLE J3_BINDING_CATEGORY_BAG ADD CONSTRAINT SQL101221160118680 PRIMARY KEY (ID);
+
+ALTER TABLE J3_BUSINESS_NAME ADD CONSTRAINT SQL101221160120410 PRIMARY KEY (ID);
+
+ALTER TABLE J3_BINDING_TEMPLATE ADD CONSTRAINT SQL101221160119280 PRIMARY KEY (ENTITY_KEY);
\ No newline at end of file
Modified: geronimo/server/trunk/plugins/uddi/uddi-jetty/pom.xml
URL: http://svn.apache.org/viewvc/geronimo/server/trunk/plugins/uddi/uddi-jetty/pom.xml?rev=1051888&r1=1051887&r2=1051888&view=diff
==============================================================================
--- geronimo/server/trunk/plugins/uddi/uddi-jetty/pom.xml (original)
+++ geronimo/server/trunk/plugins/uddi/uddi-jetty/pom.xml Wed Dec 22 13:27:18 2010
@@ -74,16 +74,11 @@
</dependency>
<dependency>
- <groupId>org.apache.juddi</groupId>
- <artifactId>juddiv3-war</artifactId>
- <type>war</type>
+ <groupId>org.apache.geronimo.plugins</groupId>
+ <artifactId>uddi-war-repackage</artifactId>
+ <version>${project.version}</version>
<scope>provided</scope>
</dependency>
-
- <dependency>
- <groupId>commons-collections</groupId>
- <artifactId>commons-collections</artifactId>
- </dependency>
<dependency>
<groupId>org.apache.geronimo.configs</groupId>
@@ -91,12 +86,55 @@
<version>${project.version}</version>
<type>car</type>
</dependency>
+
<dependency>
<groupId>org.apache.geronimo.configs</groupId>
<artifactId>jasper</artifactId>
<version>${project.version}</version>
<type>car</type>
</dependency>
+
+ <dependency>
+ <groupId>org.apache.openjpa</groupId>
+ <artifactId>openjpa</artifactId>
+ </dependency>
+
+ <dependency>
+ <groupId>org.apache.geronimo.specs</groupId>
+ <artifactId>geronimo-jaxr_1.0_spec</artifactId>
+ </dependency>
+
+ <dependency>
+ <groupId>org.apache.geronimo.bundles</groupId>
+ <artifactId>scout</artifactId>
+ </dependency>
+
+ <dependency>
+ <groupId>org.apache.juddi</groupId>
+ <artifactId>uddi-ws</artifactId>
+ </dependency>
+
+ <dependency>
+ <groupId>commons-collections</groupId>
+ <artifactId>commons-collections</artifactId>
+ </dependency>
+
+ <dependency>
+ <groupId>commons-lang</groupId>
+ <artifactId>commons-lang</artifactId>
+ </dependency>
+
+ <dependency>
+ <groupId>org.apache.geronimo.bundles</groupId>
+ <artifactId>commons-digester</artifactId>
+ </dependency>
+
+ <dependency>
+ <groupId>commons-beanutils</groupId>
+ <artifactId>commons-beanutils</artifactId>
+ </dependency>
+
+
</dependencies>
<build>
@@ -114,9 +152,9 @@
</deploymentConfigs>
<category>Web Services</category>
<module>
- <groupId>org.apache.juddi</groupId>
- <artifactId>juddiv3-war</artifactId>
- <type>war</type>
+ <groupId>org.apache.geronimo.plugins</groupId>
+ <artifactId>uddi-war-repackage</artifactId>
+ <type>jar</type>
</module>
</configuration>
</plugin>
Modified: geronimo/server/trunk/plugins/uddi/uddi-jetty/src/main/history/dependencies.xml
URL: http://svn.apache.org/viewvc/geronimo/server/trunk/plugins/uddi/uddi-jetty/src/main/history/dependencies.xml?rev=1051888&r1=1051887&r2=1051888&view=diff
==============================================================================
--- geronimo/server/trunk/plugins/uddi/uddi-jetty/src/main/history/dependencies.xml (original)
+++ geronimo/server/trunk/plugins/uddi/uddi-jetty/src/main/history/dependencies.xml Wed Dec 22 13:27:18 2010
@@ -7,6 +7,16 @@
<type>car</type>
</module-id>
<dependency>
+ <groupId>commons-logging</groupId>
+ <artifactId>commons-logging-api</artifactId>
+ <type>jar</type>
+ </dependency>
+ <dependency>
+ <groupId>org.apache.geronimo.bundles</groupId>
+ <artifactId>scout</artifactId>
+ <type>jar</type>
+ </dependency>
+ <dependency>
<groupId>org.apache.geronimo.configs</groupId>
<artifactId>cxf</artifactId>
<type>car</type>
@@ -26,4 +36,14 @@
<artifactId>uddi-db</artifactId>
<type>car</type>
</dependency>
+ <dependency>
+ <groupId>org.apache.juddi</groupId>
+ <artifactId>uddi-ws</artifactId>
+ <type>jar</type>
+ </dependency>
+ <dependency>
+ <groupId>org.apache.openjpa</groupId>
+ <artifactId>openjpa</artifactId>
+ <type>jar</type>
+ </dependency>
</plugin-artifact>
Modified: geronimo/server/trunk/plugins/uddi/uddi-tomcat/pom.xml
URL: http://svn.apache.org/viewvc/geronimo/server/trunk/plugins/uddi/uddi-tomcat/pom.xml?rev=1051888&r1=1051887&r2=1051888&view=diff
==============================================================================
--- geronimo/server/trunk/plugins/uddi/uddi-tomcat/pom.xml (original)
+++ geronimo/server/trunk/plugins/uddi/uddi-tomcat/pom.xml Wed Dec 22 13:27:18 2010
@@ -49,9 +49,10 @@
<type>car</type>
<scope>provided</scope>
</dependency>
+
<dependency>
<groupId>org.apache.geronimo.configs</groupId>
- <artifactId>cxf-deployer</artifactId>
+ <artifactId>axis2-deployer</artifactId>
<version>${project.version}</version>
<type>car</type>
<scope>provided</scope>
@@ -59,7 +60,7 @@
<dependency>
<groupId>org.apache.geronimo.configs</groupId>
- <artifactId>cxf</artifactId>
+ <artifactId>axis2</artifactId>
<version>${project.version}</version>
<type>car</type>
</dependency>
@@ -70,11 +71,11 @@
<version>${project.version}</version>
<type>car</type>
</dependency>
-
+
<dependency>
- <groupId>org.apache.juddi</groupId>
- <artifactId>juddiv3-war</artifactId>
- <type>war</type>
+ <groupId>org.apache.geronimo.plugins</groupId>
+ <artifactId>uddi-war-repackage</artifactId>
+ <version>${project.version}</version>
<scope>provided</scope>
</dependency>
@@ -84,12 +85,55 @@
<version>${project.version}</version>
<type>car</type>
</dependency>
+
<dependency>
<groupId>org.apache.geronimo.configs</groupId>
<artifactId>jasper</artifactId>
<version>${project.version}</version>
<type>car</type>
</dependency>
+
+ <dependency>
+ <groupId>org.apache.openjpa</groupId>
+ <artifactId>openjpa</artifactId>
+ </dependency>
+
+ <dependency>
+ <groupId>org.apache.geronimo.specs</groupId>
+ <artifactId>geronimo-jaxr_1.0_spec</artifactId>
+ </dependency>
+
+ <dependency>
+ <groupId>org.apache.geronimo.bundles</groupId>
+ <artifactId>scout</artifactId>
+ </dependency>
+
+ <dependency>
+ <groupId>org.apache.juddi</groupId>
+ <artifactId>uddi-ws</artifactId>
+ </dependency>
+
+ <dependency>
+ <groupId>commons-collections</groupId>
+ <artifactId>commons-collections</artifactId>
+ </dependency>
+
+ <dependency>
+ <groupId>commons-lang</groupId>
+ <artifactId>commons-lang</artifactId>
+ </dependency>
+
+ <dependency>
+ <groupId>org.apache.geronimo.bundles</groupId>
+ <artifactId>commons-digester</artifactId>
+ </dependency>
+
+ <dependency>
+ <groupId>commons-beanutils</groupId>
+ <artifactId>commons-beanutils</artifactId>
+ </dependency>
+
+
</dependencies>
<build>
@@ -102,14 +146,14 @@
<deploymentConfig>${gbeanDeployer}</deploymentConfig>
<deploymentConfig>${j2eeDeployer}</deploymentConfig>
<deploymentConfig>${tomcatDeployer}</deploymentConfig>
- <deploymentConfig>${cxfDeployer}</deploymentConfig>
+ <deploymentConfig>${axis2Deployer}</deploymentConfig>
<deploymentConfig>${jasperDeployer}</deploymentConfig>
</deploymentConfigs>
<category>Web Services</category>
<module>
- <groupId>org.apache.juddi</groupId>
- <artifactId>juddiv3-war</artifactId>
- <type>war</type>
+ <groupId>org.apache.geronimo.plugins</groupId>
+ <artifactId>uddi-war-repackage</artifactId>
+ <type>jar</type>
</module>
</configuration>
</plugin>
Modified: geronimo/server/trunk/plugins/uddi/uddi-tomcat/src/main/history/dependencies.xml
URL: http://svn.apache.org/viewvc/geronimo/server/trunk/plugins/uddi/uddi-tomcat/src/main/history/dependencies.xml?rev=1051888&r1=1051887&r2=1051888&view=diff
==============================================================================
--- geronimo/server/trunk/plugins/uddi/uddi-tomcat/src/main/history/dependencies.xml (original)
+++ geronimo/server/trunk/plugins/uddi/uddi-tomcat/src/main/history/dependencies.xml Wed Dec 22 13:27:18 2010
@@ -7,8 +7,23 @@
<type>car</type>
</module-id>
<dependency>
+ <groupId>commons-logging</groupId>
+ <artifactId>commons-logging-api</artifactId>
+ <type>jar</type>
+ </dependency>
+ <dependency>
+ <groupId>commons-pool</groupId>
+ <artifactId>commons-pool</artifactId>
+ <type>jar</type>
+ </dependency>
+ <dependency>
+ <groupId>org.apache.geronimo.bundles</groupId>
+ <artifactId>scout</artifactId>
+ <type>jar</type>
+ </dependency>
+ <dependency>
<groupId>org.apache.geronimo.configs</groupId>
- <artifactId>cxf</artifactId>
+ <artifactId>axis2</artifactId>
<type>car</type>
</dependency>
<dependency>
@@ -26,4 +41,14 @@
<artifactId>uddi-db</artifactId>
<type>car</type>
</dependency>
+ <dependency>
+ <groupId>org.apache.juddi</groupId>
+ <artifactId>uddi-ws</artifactId>
+ <type>jar</type>
+ </dependency>
+ <dependency>
+ <groupId>org.apache.openjpa</groupId>
+ <artifactId>openjpa</artifactId>
+ <type>jar</type>
+ </dependency>
</plugin-artifact>
Modified: geronimo/server/trunk/plugins/uddi/uddi-tomcat/src/main/plan/plan.xml
URL: http://svn.apache.org/viewvc/geronimo/server/trunk/plugins/uddi/uddi-tomcat/src/main/plan/plan.xml?rev=1051888&r1=1051887&r2=1051888&view=diff
==============================================================================
--- geronimo/server/trunk/plugins/uddi/uddi-tomcat/src/main/plan/plan.xml (original)
+++ geronimo/server/trunk/plugins/uddi/uddi-tomcat/src/main/plan/plan.xml Wed Dec 22 13:27:18 2010
@@ -18,7 +18,7 @@
<!-- $Rev$ $Date$ -->
-<web-app xmlns="http://geronimo.apache.org/xml/ns/j2ee/web/tomcat-2.0.1">
+<web-app xmlns="http://geronimo.apache.org/xml/ns/j2ee/web/tomcat-2.0.1" xmlns:naming="http://geronimo.apache.org/xml/ns/naming-1.2">
<context-root>/juddi</context-root>
<!--<gbean name="UDDIResources" class="org.apache.geronimo.system.util.DirectoryInitializationGBean">-->
@@ -29,4 +29,12 @@
<!--<name>ServerInfo</name>-->
<!--</reference>-->
<!--</gbean>-->
+ <naming:resource-ref>
+ <naming:ref-name>jdbc/juddiDB</naming:ref-name>
+ <naming:resource-link>jdbc/juddiDB</naming:resource-link>
+ </naming:resource-ref>
+ <naming:resource-ref>
+ <naming:ref-name>jdbc/NoTxJuddiDB</naming:ref-name>
+ <naming:resource-link>jdbc/NoTxJuddiDB</naming:resource-link>
+ </naming:resource-ref>
</web-app>
Added: geronimo/server/trunk/plugins/uddi/uddi-war-repackage/pom.xml
URL: http://svn.apache.org/viewvc/geronimo/server/trunk/plugins/uddi/uddi-war-repackage/pom.xml?rev=1051888&view=auto
==============================================================================
--- geronimo/server/trunk/plugins/uddi/uddi-war-repackage/pom.xml (added)
+++ geronimo/server/trunk/plugins/uddi/uddi-war-repackage/pom.xml Wed Dec 22 13:27:18 2010
@@ -0,0 +1,92 @@
+<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
+
+ <!--
+
+ Licensed to the Apache Software Foundation (ASF) under one or more
+ contributor license agreements. See the NOTICE file distributed with
+ this work for additional information regarding copyright ownership.
+ The ASF licenses this file to You under the Apache License, Version 2.0
+ (the "License"); you may not use this file except in compliance with
+ the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+ -->
+
+ <modelVersion>4.0.0</modelVersion>
+
+ <parent>
+ <groupId>org.apache.geronimo.plugins</groupId>
+ <artifactId>uddi</artifactId>
+ <version>3.0-SNAPSHOT</version>
+ </parent>
+
+ <artifactId>uddi-war-repackage</artifactId>
+ <packaging>jar</packaging>
+ <name>Geronimo Plugins, UDDI :: uddi-war-repackage</name>
+
+ <build>
+
+
+ <plugins>
+ <plugin>
+ <groupId>org.apache.maven.plugins</groupId>
+ <artifactId>maven-dependency-plugin</artifactId>
+ <executions>
+ <execution>
+ <id>unpack-uddi-war</id>
+ <phase>generate-resources</phase>
+ <goals>
+ <goal>unpack</goal>
+ </goals>
+ <configuration>
+ <artifactItems>
+ <artifactItem>
+ <groupId>org.apache.juddi</groupId>
+ <artifactId>juddiv3-war</artifactId>
+ <type>war</type>
+ <version>${juddiv3.version}</version>
+ </artifactItem>
+ </artifactItems>
+ <includes>**/*</includes>
+ <excludes>**/persistence.xml,**/uddi-ws*.jar,**/juddi-client*.jar,**/juddi-core-openjpa*.jar,**/commons-beanutils*.jar,**/commons-collections*.jar,**/commons-digester*.jar,**/commons-lang*.jar,**/commons-logging-api*.jar</excludes>
+ <outputDirectory>${project.build.directory}/classes</outputDirectory>
+ <overWriteReleases>false</overWriteReleases>
+ <overWriteSnapshots>true</overWriteSnapshots>
+ </configuration>
+ </execution>
+ <execution>
+ <id>unpack-uddi-core-openjpa</id>
+ <phase>generate-resources</phase>
+ <goals>
+ <goal>unpack</goal>
+ </goals>
+ <configuration>
+ <artifactItems>
+ <artifactItem>
+ <groupId>org.apache.juddi</groupId>
+ <artifactId>juddi-core-openjpa</artifactId>
+ <type>jar</type>
+ <version>${juddiv3.version}</version>
+ </artifactItem>
+ </artifactItems>
+ <includes>**/*</includes>
+ <excludes>**/persistence.xml</excludes>
+ <outputDirectory>${project.build.directory}/classes/WEB-INF/classes</outputDirectory>
+ <overWriteReleases>false</overWriteReleases>
+ <overWriteSnapshots>true</overWriteSnapshots>
+ </configuration>
+ </execution>
+ </executions>
+ </plugin>
+
+
+ </plugins>
+ </build>
+
+</project>
\ No newline at end of file
Added: geronimo/server/trunk/plugins/uddi/uddi-war-repackage/src/main/resources/WEB-INF/classes/META-INF/persistence.xml
URL: http://svn.apache.org/viewvc/geronimo/server/trunk/plugins/uddi/uddi-war-repackage/src/main/resources/WEB-INF/classes/META-INF/persistence.xml?rev=1051888&view=auto
==============================================================================
--- geronimo/server/trunk/plugins/uddi/uddi-war-repackage/src/main/resources/WEB-INF/classes/META-INF/persistence.xml (added)
+++ geronimo/server/trunk/plugins/uddi/uddi-war-repackage/src/main/resources/WEB-INF/classes/META-INF/persistence.xml Wed Dec 22 13:27:18 2010
@@ -0,0 +1,89 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<persistence xmlns="http://java.sun.com/xml/ns/persistence"
+ xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+ xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd"
+ version="1.0">
+ <persistence-unit name="juddiDatabase" transaction-type="RESOURCE_LOCAL">
+ <provider>org.apache.openjpa.persistence.PersistenceProviderImpl</provider>
+
+ <!-- entity classes -->
+ <class>org.apache.juddi.model.Address</class>
+ <class>org.apache.juddi.model.AddressLine</class>
+ <class>org.apache.juddi.model.AuthToken</class>
+ <class>org.apache.juddi.model.BindingCategoryBag</class>
+ <class>org.apache.juddi.model.BindingDescr</class>
+ <class>org.apache.juddi.model.BindingTemplate</class>
+ <class>org.apache.juddi.model.BusinessCategoryBag</class>
+ <class>org.apache.juddi.model.BusinessDescr</class>
+ <class>org.apache.juddi.model.BusinessEntity</class>
+ <class>org.apache.juddi.model.BusinessIdentifier</class>
+ <class>org.apache.juddi.model.BusinessName</class>
+ <class>org.apache.juddi.model.BusinessService</class>
+ <class>org.apache.juddi.model.CategoryBag</class>
+ <class>org.apache.juddi.model.Clerk</class>
+ <class>org.apache.juddi.model.ClientSubscriptionInfo</class>
+ <class>org.apache.juddi.model.Contact</class>
+ <class>org.apache.juddi.model.ContactDescr</class>
+ <class>org.apache.juddi.model.DiscoveryUrl</class>
+ <class>org.apache.juddi.model.Email</class>
+ <class>org.apache.juddi.model.InstanceDetailsDescr</class>
+ <class>org.apache.juddi.model.InstanceDetailsDocDescr</class>
+ <class>org.apache.juddi.model.KeyedReference</class>
+ <class>org.apache.juddi.model.KeyedReferenceGroup</class>
+ <class>org.apache.juddi.model.Node</class>
+ <class>org.apache.juddi.model.OverviewDoc</class>
+ <class>org.apache.juddi.model.OverviewDocDescr</class>
+ <class>org.apache.juddi.model.PersonName</class>
+ <class>org.apache.juddi.model.Phone</class>
+ <class>org.apache.juddi.model.Publisher</class>
+ <class>org.apache.juddi.model.PublisherAssertion</class>
+ <class>org.apache.juddi.model.PublisherAssertionId</class>
+ <class>org.apache.juddi.model.ServiceCategoryBag</class>
+ <class>org.apache.juddi.model.ServiceDescr</class>
+ <class>org.apache.juddi.model.ServiceName</class>
+ <class>org.apache.juddi.model.ServiceProjection</class>
+ <class>org.apache.juddi.model.ServiceProjectionId</class>
+ <class>org.apache.juddi.model.Subscription</class>
+ <class>org.apache.juddi.model.SubscriptionChunkToken</class>
+ <class>org.apache.juddi.model.SubscriptionMatch</class>
+ <class>org.apache.juddi.model.Tmodel</class>
+ <class>org.apache.juddi.model.TmodelCategoryBag</class>
+ <class>org.apache.juddi.model.TmodelDescr</class>
+ <class>org.apache.juddi.model.TmodelIdentifier</class>
+ <class>org.apache.juddi.model.TmodelInstanceInfo</class>
+ <class>org.apache.juddi.model.TmodelInstanceInfoDescr</class>
+ <class>org.apache.juddi.model.TransferToken</class>
+ <class>org.apache.juddi.model.TransferTokenKey</class>
+ <class>org.apache.juddi.model.UddiEntity</class>
+ <class>org.apache.juddi.model.UddiEntityPublisher</class>
+
+ <properties>
+ <!--property name="openjpa.jdbc.SynchronizeMappings" value="buildSchema(SchemaAction='dropDB,add')"/-->
+ <property name="openjpa.Log" value="DefaultLevel=WARN, Tool=INFO"/>
+ <property name="openjpa.jdbc.UpdateManager" value="operation-order"/>
+ <property name="openjpa.RuntimeUnenhancedClasses" value="warn"/>
+
+ <!-- derby connection properties -->
+ <property name="openjpa.ConnectionDriverName" value="org.apache.derby.jdbc.ClientDriver"/>
+ <property name="openjpa.ConnectionURL" value="jdbc:derby://localhost:1527/UddiDatabase;create=false;"/>
+ <property name="openjpa.ConnectionUserName" value="app"/>
+ <property name="openjpa.ConnectionPassword" value="app"/>
+
+
+ <!-- mysql connection properties
+ <property name="openjpa.ConnectionURL" value="jdbc:mysql://localhost:3306/juddi"/>
+ <property name="openjpa.ConnectionDriverName" value="com.mysql.jdbc.Driver"/>
+ <property name="openjpa.ConnectionUserName" value="juddiv3"/>
+ <property name="openjpa.ConnectionPassword" value=""/>
+ -->
+
+ <!-- pgsql connection properties
+ <property name="openjpa.ConnectionURL" value="jdbc:postgresql://localhost/juddi"/>
+ <property name="openjpa.ConnectionDriverName" value="org.postgresql.Driver"/>
+ <property name="openjpa.ConnectionUserName" value="juddi"/>
+ <property name="openjpa.ConnectionPassword" value="juddi"/>
+ -->
+
+ </properties>
+ </persistence-unit>
+</persistence>
\ No newline at end of file
Modified: geronimo/server/trunk/pom.xml
URL: http://svn.apache.org/viewvc/geronimo/server/trunk/pom.xml?rev=1051888&r1=1051887&r2=1051888&view=diff
==============================================================================
--- geronimo/server/trunk/pom.xml (original)
+++ geronimo/server/trunk/pom.xml Wed Dec 22 13:27:18 2010
@@ -725,7 +725,7 @@
<dependency>
<groupId>org.apache.geronimo.bundles</groupId>
<artifactId>scout</artifactId>
- <version>1.2.2_1-SNAPSHOT</version>
+ <version>1.2.2_1</version>
<exclusions>
<exclusion>
<groupId>commons-logging</groupId>
@@ -2402,7 +2402,19 @@ only found in cxf
<module>assemblies</module>
</modules>
- <repositories>
+ <repositories>
+ <repository>
+ <id>geornimo bundle stage</id>
+ <url>https://repository.apache.org/content/repositories/orgapachegeronimo-024/</url>
+ <layout>default</layout>
+ <snapshots>
+ <enabled>false</enabled>
+ </snapshots>
+ <releases>
+ <enabled>true</enabled>
+ </releases>
+ </repository>
+
<repository>
<!-- org.eclipse.jetty routing -->
<id>jetty.oss.sonatype.org</id>