You are viewing a plain text version of this content. The canonical link for it is here.
Posted to wsrp4j-dev@portals.apache.org by dl...@apache.org on 2006/12/29 01:47:19 UTC

svn commit: r490890 - in /portals/wsrp4j/trunk/consumer-proxyportlet/src/webapp: WEB-INF/classes/hibernate.cfg.xml sql/ sql/wsrp4j-proxyportlet.sql

Author: dlouzan
Date: Thu Dec 28 16:47:18 2006
New Revision: 490890

URL: http://svn.apache.org/viewvc?view=rev&rev=490890
Log:
- Added a sql script for loading default contents on the db for persistence-db module
- Modified hibernate conf: commented out auto-creation of db schema

Added:
    portals/wsrp4j/trunk/consumer-proxyportlet/src/webapp/sql/
    portals/wsrp4j/trunk/consumer-proxyportlet/src/webapp/sql/wsrp4j-proxyportlet.sql
Modified:
    portals/wsrp4j/trunk/consumer-proxyportlet/src/webapp/WEB-INF/classes/hibernate.cfg.xml

Modified: portals/wsrp4j/trunk/consumer-proxyportlet/src/webapp/WEB-INF/classes/hibernate.cfg.xml
URL: http://svn.apache.org/viewvc/portals/wsrp4j/trunk/consumer-proxyportlet/src/webapp/WEB-INF/classes/hibernate.cfg.xml?view=diff&rev=490890&r1=490889&r2=490890
==============================================================================
--- portals/wsrp4j/trunk/consumer-proxyportlet/src/webapp/WEB-INF/classes/hibernate.cfg.xml (original)
+++ portals/wsrp4j/trunk/consumer-proxyportlet/src/webapp/WEB-INF/classes/hibernate.cfg.xml Thu Dec 28 16:47:18 2006
@@ -39,9 +39,13 @@
         <property name="show_sql">true</property>
         <!-- Format SQL -->
         <property name="format_sql">true</property>
+        <!-- Use SQL comments (for easier debugging) -->
+        <property name="use_sql_comments">true</property>
 
         <!-- Drop and re-create the database schema on startup -->
+        <!--
         <property name="hbm2ddl.auto">create</property>
+        -->
 
         <mapping resource="org/apache/wsrp4j/commons/consumer/driver/page/PageImpl.hbm.xml"/>
         <mapping resource="org/apache/wsrp4j/commons/consumer/driver/portlet/ConsumerPortletContext.hbm.xml"/>

Added: portals/wsrp4j/trunk/consumer-proxyportlet/src/webapp/sql/wsrp4j-proxyportlet.sql
URL: http://svn.apache.org/viewvc/portals/wsrp4j/trunk/consumer-proxyportlet/src/webapp/sql/wsrp4j-proxyportlet.sql?view=auto&rev=490890
==============================================================================
--- portals/wsrp4j/trunk/consumer-proxyportlet/src/webapp/sql/wsrp4j-proxyportlet.sql (added)
+++ portals/wsrp4j/trunk/consumer-proxyportlet/src/webapp/sql/wsrp4j-proxyportlet.sql Thu Dec 28 16:47:18 2006
@@ -0,0 +1,93 @@
+-- Copyright 2003-2006 The Apache Software Foundation.
+-- 
+-- Licensed 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.
+
+-- This is a list of producers for persistence-db module.
+
+-- wsrp4j-producer producer
+INSERT INTO PRODUCER (PROD_ID, PROD_NAME, PROD_DESC,
+                      REG_RQR, REGDATA_CONS_NAME, REGDATA_CONS_AGENT,
+                      REGDATA_GET_SUPPORTED,
+                      MARKUP_INTERFACE, SERVICE_DESC_INTERFACE,
+                      REGISTRATION_INTERFACE, PORTLET_MGM_INTERFACE)
+    VALUES ('wsrp4j', 'WSRP4J Producer', 'WSRP4J Producer provided portlets',
+            true, 'WSRP4J Proxy Portlet', 'WSRP4J Proxy Portlet', false,
+            'http://localhost:9101/wsrp4j-producer/services/WSRPBaseService',
+            'http://localhost:9101/wsrp4j-producer/services/WSRPServiceDescriptionService',
+            'http://localhost:9101/wsrp4j-producer/services/WSRPRegistrationService',
+            'http://localhost:9101/wsrp4j-producer/services/WSRPPortletManagementService');
+
+-- netunity producer
+INSERT INTO PRODUCER (PROD_ID, PROD_NAME, PROD_DESC,
+                      REG_RQR, REGDATA_CONS_NAME, REGDATA_CONS_AGENT,
+                      REGDATA_GET_SUPPORTED,
+                      MARKUP_INTERFACE, SERVICE_DESC_INTERFACE,
+                      REGISTRATION_INTERFACE, PORTLET_MGM_INTERFACE)
+    VALUES ('netunity', 'NetUnity Producer', 'NetUnity Producer provided portlets (.NET)',
+            false, 'WSRP4J Proxy Portlet for NetUnity', 'WSRP Proxy Portlet for NetUnity', false,
+            'http://localhost:9102/WSRPTestService/WSRPTestService.asmx',
+            'http://localhost:9102/WSRPTestService/WSRPTestService.asmx',
+            'http://localhost:9102/WSRPTestService/WSRPTestService.asmx',
+            'http://localhost:9102/WSRPTestService/WSRPTestService.asmx');
+
+-- bea producer
+INSERT INTO PRODUCER (PROD_ID, PROD_NAME, PROD_DESC,
+                      REG_RQR, REGDATA_CONS_NAME, REGDATA_CONS_AGENT,
+                      REGDATA_GET_SUPPORTED,
+                      MARKUP_INTERFACE, SERVICE_DESC_INTERFACE,
+                      REGISTRATION_INTERFACE, PORTLET_MGM_INTERFACE)
+    VALUES ('bea', 'BEA Producer', 'BEA Producer provided portlets',
+            false, 'WSRP4J Proxy Portlet for BEA', 'WSRP4J Proxy Portlet for BEA', false,
+            'http://localhost:9103/portal/producer',
+            'http://localhost:9103/portal/producer',
+            'http://localhost:9103/portal/producer',
+            'http://localhost:9103/portal/producer');
+
+-- ibm producer
+INSERT INTO PRODUCER (PROD_ID, PROD_NAME, PROD_DESC,
+                      REG_RQR, REGDATA_CONS_NAME, REGDATA_CONS_AGENT,
+                      REGDATA_GET_SUPPORTED,
+                      MARKUP_INTERFACE, SERVICE_DESC_INTERFACE,
+                      REGISTRATION_INTERFACE, PORTLET_MGM_INTERFACE)
+    VALUES ('ibm', 'IBM Producer', 'IBM Producer provided portlets',
+            false, 'WSRP4J Proxy Portlet for IBM', 'WSRP4J Proxy Portlet for IBM', false,
+            'http://localhost:9104/wps/WSRPBaseService',
+            'http://localhost:9104/wps/WSRPServiceDescriptionService',
+            NULL,
+            'http://localhost:9104/wps/WSRPPortletManagementService');
+
+-- vignette producer
+INSERT INTO PRODUCER (PROD_ID, PROD_NAME, PROD_DESC,
+                      REG_RQR, REGDATA_CONS_NAME, REGDATA_CONS_AGENT,
+                      REGDATA_GET_SUPPORTED,
+                      MARKUP_INTERFACE, SERVICE_DESC_INTERFACE,
+                      REGISTRATION_INTERFACE, PORTLET_MGM_INTERFACE)
+    VALUES ('vignette', 'Vignette Producer', 'Vignette Producer provided portlets',
+            false, 'WSRP4J Proxy Portlet for Vignette', 'WSRP4J Proxy Portlet for Vignette', false,
+            'http://localhost:9105/producer/controller/services/WSRPBaseService',
+            'http://localhost:9105/producer/controller/services/WSRPServiceDescriptionService',
+            'http://localhost:9105/producer/controller/services/WSRPRegistrationService',
+            'http://localhost:9105/producer/controller/services/WSRPPortletManagementService');
+
+-- oracle producer
+INSERT INTO PRODUCER (PROD_ID, PROD_NAME, PROD_DESC,
+                      REG_RQR, REGDATA_CONS_NAME, REGDATA_CONS_AGENT,
+                      REGDATA_GET_SUPPORTED,
+                      MARKUP_INTERFACE, SERVICE_DESC_INTERFACE,
+                      REGISTRATION_INTERFACE, PORTLET_MGM_INTERFACE)
+    VALUES ('oracle', 'Oracle Producer', 'Oracle Producer provided portlets',
+            false, 'WSRP4J Proxy Portlet for Oracle', 'WSRP4J Proxy Portlet for Oracle', false,
+            'http://localhost:9106/portletapp/portlets/WSRPBaseService',
+            'http://localhost:9106/portletapp/portlets/WSRPServiceDescriptionService',
+            'http://localhost:9106/portletapp/portlets/WSRPRegistrationService',
+            'http://localhost:9106/portletapp/portlets/WSRPPortletManagementService');