geronimo-scm mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From jb...@apache.org
Subject svn commit: r664270 - in /geronimo/samples/trunk/samples/customer-service: customer-service-ear/src/main/resources/CustomerService.sql customer-service-jetty/src/main/plan/plan.xml customer-service-tomcat/src/main/plan/plan.xml
Date Sat, 07 Jun 2008 03:41:57 GMT
Author: jbohn
Date: Fri Jun  6 20:41:57 2008
New Revision: 664270

URL: http://svn.apache.org/viewvc?rev=664270&view=rev
Log:
updates for customer-service sample db initialization

Modified:
    geronimo/samples/trunk/samples/customer-service/customer-service-ear/src/main/resources/CustomerService.sql
    geronimo/samples/trunk/samples/customer-service/customer-service-jetty/src/main/plan/plan.xml
    geronimo/samples/trunk/samples/customer-service/customer-service-tomcat/src/main/plan/plan.xml

Modified: geronimo/samples/trunk/samples/customer-service/customer-service-ear/src/main/resources/CustomerService.sql
URL: http://svn.apache.org/viewvc/geronimo/samples/trunk/samples/customer-service/customer-service-ear/src/main/resources/CustomerService.sql?rev=664270&r1=664269&r2=664270&view=diff
==============================================================================
--- geronimo/samples/trunk/samples/customer-service/customer-service-ear/src/main/resources/CustomerService.sql
(original)
+++ geronimo/samples/trunk/samples/customer-service/customer-service-ear/src/main/resources/CustomerService.sql
Fri Jun  6 20:41:57 2008
@@ -1,26 +1,26 @@
-/**
- *  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.
- */
 
-create table customer (
-   customerid varchar(10) primary key,
-   fullname varchar(30),
-   emailaddress varchar(30),
-   interests varchar(100)
+--  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.
+
+
+CREATE TABLE customer(
+   customerid VARCHAR(10) PRIMARY KEY,
+   fullname VARCHAR(30),
+   emailaddress VARCHAR(30),
+   interests VARCHAR(100)
 );
 
-insert into customer values ('A100','John Doe10','Doe10@work.com','Java,Open Source, Computer
Graphics');
-insert into customer values ('b100','Jane Doe20','Doe20@home.net','Budget Travel, New Zealand,
Martial Arts');
+INSERT INTO customer VALUES ('A100','John Doe10','Doe10@work.com','Java,Open Source, Computer
Graphics');
+INSERT INTO customer VALUES ('b100','Jane Doe20','Doe20@home.net','Budget Travel, New Zealand,
Martial Arts');

Modified: geronimo/samples/trunk/samples/customer-service/customer-service-jetty/src/main/plan/plan.xml
URL: http://svn.apache.org/viewvc/geronimo/samples/trunk/samples/customer-service/customer-service-jetty/src/main/plan/plan.xml?rev=664270&r1=664269&r2=664270&view=diff
==============================================================================
--- geronimo/samples/trunk/samples/customer-service/customer-service-jetty/src/main/plan/plan.xml
(original)
+++ geronimo/samples/trunk/samples/customer-service/customer-service-jetty/src/main/plan/plan.xml
Fri Jun  6 20:41:57 2008
@@ -21,4 +21,12 @@
 <!-- $Rev: 497879 $ $Date: 2007-01-19 12:11:01 -0500 (Fri, 19 Jan 2007) $ -->
 <application xmlns="http://geronimo.apache.org/xml/ns/j2ee/application-1.2">
 
+    <gbean name="DBInitialization" class="org.apache.geronimo.connector.DatabaseInitializationGBean">
+        <attribute name="testSQL">select * from customer</attribute>
+        <attribute name="path">CustomerService.sql</attribute>
+        <reference name="DataSource">
+            <name>SampleTxDatasource</name>
+        </reference>
+    </gbean>
+
 </application>

Modified: geronimo/samples/trunk/samples/customer-service/customer-service-tomcat/src/main/plan/plan.xml
URL: http://svn.apache.org/viewvc/geronimo/samples/trunk/samples/customer-service/customer-service-tomcat/src/main/plan/plan.xml?rev=664270&r1=664269&r2=664270&view=diff
==============================================================================
--- geronimo/samples/trunk/samples/customer-service/customer-service-tomcat/src/main/plan/plan.xml
(original)
+++ geronimo/samples/trunk/samples/customer-service/customer-service-tomcat/src/main/plan/plan.xml
Fri Jun  6 20:41:57 2008
@@ -21,4 +21,12 @@
 <!-- $Rev: 497879 $ $Date: 2007-01-19 12:11:01 -0500 (Fri, 19 Jan 2007) $ -->
 <application xmlns="http://geronimo.apache.org/xml/ns/j2ee/application-1.2">
 
+    <gbean name="DBInitialization" class="org.apache.geronimo.connector.DatabaseInitializationGBean">
+        <attribute name="testSQL">select * from customer</attribute>
+        <attribute name="path">CustomerService.sql</attribute>
+        <reference name="DataSource">
+            <name>SampleTxDatasource</name>
+        </reference>
+    </gbean>
+
 </application>



Mime
View raw message