You are viewing a plain text version of this content. The canonical link for it is here.
Posted to scm@geronimo.apache.org by jb...@apache.org on 2008/06/07 05:41:57 UTC
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
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>