svn commit: r490888 - in /portals/wsrp4j/trunk/producer/src/webapp/WEB-INF: classes/hibernate.cfg.xml sql/ sql/wsrp4j-producer.sql

[dl...@apache.org]

Author: dlouzan
Date: Thu Dec 28 16:44:52 2006
New Revision: 490888

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

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

Modified: portals/wsrp4j/trunk/producer/src/webapp/WEB-INF/classes/hibernate.cfg.xml
URL: http://svn.apache.org/viewvc/portals/wsrp4j/trunk/producer/src/webapp/WEB-INF/classes/hibernate.cfg.xml?view=diff&rev=490888&r1=490887&r2=490888
==============================================================================
--- portals/wsrp4j/trunk/producer/src/webapp/WEB-INF/classes/hibernate.cfg.xml (original)
+++ portals/wsrp4j/trunk/producer/src/webapp/WEB-INF/classes/hibernate.cfg.xml Thu Dec 28 16:44:52 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/persistence/driver/WSRPServiceDescription.hbm.xml"/>
         <mapping resource="org/apache/wsrp4j/commons/producer/driver/RegistrationImpl.hbm.xml"/>

Added: portals/wsrp4j/trunk/producer/src/webapp/WEB-INF/sql/wsrp4j-producer.sql
URL: http://svn.apache.org/viewvc/portals/wsrp4j/trunk/producer/src/webapp/WEB-INF/sql/wsrp4j-producer.sql?view=auto&rev=490888
==============================================================================
--- portals/wsrp4j/trunk/producer/src/webapp/WEB-INF/sql/wsrp4j-producer.sql (added)
+++ portals/wsrp4j/trunk/producer/src/webapp/WEB-INF/sql/wsrp4j-producer.sql Thu Dec 28 16:44:52 2006
@@ -0,0 +1,19 @@
+-- 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 the service description needed by persistence-db module.
+
+-- wsrp4j-producer service description
+INSERT INTO SERVICE_DESC (SERVICE_DESC_ID, RQRCOOKIE, RQRREG)
+    VALUES ('wsrp4j-producer', 'perGroup', true);