diff options
| author | dims <dims@13f79535-47bb-0310-9956-ffa450edef68> | 2008-06-17 00:23:01 +0000 |
|---|---|---|
| committer | dims <dims@13f79535-47bb-0310-9956-ffa450edef68> | 2008-06-17 00:23:01 +0000 |
| commit | bdd0a41aed7edf21ec2a65cfa17a86af2ef8c48a (patch) | |
| tree | 38a92061c0793434c4be189f1d70c3458b6bc41d /sandbox/lresende/backup/container.das.client | |
Move Tuscany from Incubator to top level.
git-svn-id: http://svn.us.apache.org/repos/asf/tuscany@668359 13f79535-47bb-0310-9956-ffa450edef68
Diffstat (limited to 'sandbox/lresende/backup/container.das.client')
17 files changed, 1520 insertions, 0 deletions
diff --git a/sandbox/lresende/backup/container.das.client/build.xml b/sandbox/lresende/backup/container.das.client/build.xml new file mode 100644 index 0000000000..feef76481b --- /dev/null +++ b/sandbox/lresende/backup/container.das.client/build.xml @@ -0,0 +1,55 @@ +<?xml version="1.0" encoding="UTF-8"?>
+<!--
+ 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.
+ -->
+<project name="samples" default="compile">
+ <property name="mainDir" value="../../.."/>
+ <path id="javac.classpath">
+ <fileset dir="${mainDir}/lib">
+ <include name="tuscany-runtime-incubating-M1.jar"/>
+ </fileset>
+ </path>
+ <path id="java.classpath">
+ <fileset dir="${mainDir}/lib">
+ <include name="tuscany-runtime-incubating-M1.jar"/>
+ </fileset>
+ <pathelement path="target/sample-companyweb.jar"/>
+ </path>
+
+ <target name="init">
+ <mkdir dir="target/classes"/>
+ </target>
+
+ <target name="compile" depends="init">
+ <javac srcdir="src/main/java" destdir="target/classes" debug="on" source="1.5" target="1.5">
+ <classpath refid="javac.classpath"/>
+ </javac>
+ <copy todir="target/classes">
+ <fileset dir="src/main/resources"/>
+ </copy>
+ <war destfile="target/sample-companyweb.war" webxml="src/main/webapp/WEB-INF/web.xml">
+ <classes dir="target/classes"/>
+ </war>
+ </target>
+
+ <target name="clean">
+ <delete quiet="true" includeemptydirs="true">
+ <fileset dir="target" excludes="sample-companyweb-incubating-M1.war"/>
+ </delete>
+ </target>
+</project>
diff --git a/sandbox/lresende/backup/container.das.client/pom.xml b/sandbox/lresende/backup/container.das.client/pom.xml new file mode 100644 index 0000000000..1d1acf6df5 --- /dev/null +++ b/sandbox/lresende/backup/container.das.client/pom.xml @@ -0,0 +1,113 @@ +<?xml version="1.0" encoding="UTF-8"?>
+<!--
+ * 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.
+-->
+<project>
+
+ <parent>
+ <groupId>org.apache.tuscany.das.samples</groupId>
+ <artifactId>tuscany-samples-das</artifactId>
+ <version>1.0-incubator-SNAPSHOT</version>
+ </parent>
+
+ <modelVersion>4.0.0</modelVersion>
+ <artifactId>container-das-sample-client</artifactId>
+ <packaging>war</packaging>
+ <name>Tuscany DAS Container Client Application Sample</name>
+ <description>Sample web application using a DAS Container</description>
+
+ <dependencies>
+
+ <!-- runtime is need for webapp integration to include jar -->
+ <dependency>
+ <groupId>org.apache.tuscany.sca.kernel</groupId>
+ <artifactId>tuscany-api</artifactId>
+ <version>${pom.version}</version>
+ <scope>compile</scope>
+ </dependency>
+
+ <dependency>
+ <groupId>org.apache.tuscany.sca.runtime.webapp</groupId>
+ <artifactId>webapp-api</artifactId>
+ <version>${pom.version}</version>
+ <scope>runtime</scope>
+ </dependency>
+
+ <dependency>
+ <groupId>org.apache.tuscany.sca</groupId>
+ <artifactId>test</artifactId>
+ <version>${pom.version}</version>
+ <scope>test</scope>
+ </dependency>
+
+ <dependency>
+ <groupId>org.apache.tuscany.das</groupId>
+ <artifactId>tuscany-das-rdb</artifactId>
+ <version>${pom.version}</version>
+ <scope>compile</scope>
+ </dependency>
+
+ <dependency>
+ <groupId>org.apache.tuscany.sdo</groupId>
+ <artifactId>tuscany-sdo-impl</artifactId>
+ <version>${pom.version}</version>
+ <scope>compile</scope>
+ </dependency>
+
+ </dependencies>
+
+ <!-- this will place the java source files inside the war -->
+ <build>
+ <plugins>
+ <plugin>
+ <groupId>org.apache.tuscany.sca.plugins</groupId>
+ <artifactId>tuscany-war-plugin</artifactId>
+ <executions>
+ <execution>
+ <id>tuscany-war</id>
+ <goals>
+ <goal>tuscany-war</goal>
+ </goals>
+ </execution>
+ </executions>
+ <configuration>
+ <extensions>
+ <dependency>
+ <groupId>org.apache.tuscany.sca.services.containers</groupId>
+ <artifactId>das</artifactId>
+ <version>${pom.version}</version>
+ </dependency>
+ </extensions>
+ </configuration>
+ </plugin>
+ </plugins>
+
+
+
+
+ <sourceDirectory>src/main/java</sourceDirectory>
+ <resources>
+ <resource>
+ <directory>src/main/java</directory>
+ </resource>
+ <resource>
+ <directory>src/main/resources</directory>
+ </resource>
+ </resources>
+ </build>
+</project>
diff --git a/sandbox/lresende/backup/container.das.client/readme.html b/sandbox/lresende/backup/container.das.client/readme.html new file mode 100644 index 0000000000..65a50de320 --- /dev/null +++ b/sandbox/lresende/backup/container.das.client/readme.html @@ -0,0 +1,199 @@ +<!--
+ 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.
+ -->
+<html>
+
+<head>
+<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
+<title>Tuscany RDB DAS Service client</title>
+
+<style>
+.code {font-size: 11px; color: #006699}
+.codebox {border: 1px solid #6699CC; background-color: #F1F7FA;padding:15px}
+.codebox2 {border: 1px solid #6699CC; background-color: #F1F7FA;padding:15px; width:85%}
+.codeboxW {border: 1px solid #6699CC; background-color: #FFFFFF;padding:15px}
+.codeboxB {background-color: #C9DBED;padding:1px 10px 10px 10px}
+</style>
+
+</head>
+
+
+
+
+<body>
+
+<h1>Tuscany RDB DAS Service client</h1>
+
+
+<h3>Introduction</h3>
+
+<p>
+This stand-alone sample application demonstrate how to consume the DAS Service exposed trough an SCA service.<br>
+The application starts with a canned database of Companies and their related Departments.<br>
+Through the web page interface, a user can consume the DAS Service to display the list of available companies.<br>
+The sample runs on Tomcat 5.5 and employs a Derby database accessed via a DataSource.
+</p>
+
+
+
+
+
+<h3>Running the sample</h3>
+
+<p>There are two options for running this sample:</p>
+
+<ol>
+ <li>Run from Tomcat configured by the build</li>
+ <li>Deploying the DASService.client WAR into a Tomcat you configure yourself</li>
+</ol>
+
+
+<h3>Running from Tomcat configured by the build</h3>
+
+<p>
+This sample application is deployed (along with the canned test database) to an instance of Tomcat as part of our automated sample
+testing.This means you can run the java/samples/testing/tomcat build (see java/das/samples/testing/tomcat/readme.htm ) and then access
+the application by pointing your browser to http://localhost:8080/companyweb-service-client/
+</p>
+
+
+
+<h3>Deploying the DASService.client WAR into a Tomcat you configure yourself</h3>
+
+<p>
+Alternatively, you can deploy the sample to your own configured Tomcat installation by following the instructions below.
+These instructions assume that you have either 1) downloaded the Tuscany sample distribution or 2) Downloaded the Tuscany
+source and run our maven build, see the following link to more details steps on how to build DAS Sample applications <a
+href="http://incubator.apache.org/tuscany/java_das_overview.html">http://incubator.apache.org/tuscany/java_das_overview.html</a>.
+</p>
+
+<p><b><u>Set Up:</u></b></p>
+
+
+<ol>
+ <li>Download and install the most recent stable version of Tomcat 5.5. You can find it here: <a
+ href="http://tomcat.apache.org/download-55.cgi">http://tomcat.apache.org/download-55.cgi</a></li>
+ <li>Download the most recent official release of Derby from here: <a href="http://db.apache.org/derby/index.html">http://db.apache.org/derby/index.html</a>.
+ The only file you’ll need from this download is derby.jar</li>
+ <li>Stop Tomcat</li>
+ <li>Copy derby.jar (from the derby distribution) to {Tomcat_Home}/common/lib:</li>
+ <li>Add the sample war file to {Tomcat_Home}/webapps</li>
+ <ol start=1 type=a>
+ <li>sample-das-service-client-xxx.war (e.g.sample-das-service-client-1.0-incubator-SNAPSHOT.war)</li>
+ </ol>
+ <li>Install the canned Derby database to Tomcat: </li>
+ <ol start=1 type=a>
+ <li>First, create a new directory named “Databases” to hold the sample database. Create {Tomcat_Home}/Databases</li>
+ <li>Copy the <b>dastest</b> folder (and all its contents) from {build directory root OR
+ where samples where unzipped}/java/das/samples/DASService.client to {Tomcat_Home}/Databases.<br>
+ <br>
+ <b>NOTE</b>: If you are running this from a sample distribution, the canned database is available in the
+ distribution, inside the databases directory. </li>
+ </ol>
+ <li>Define a DataSource by adding a datasource definition to {Tomcat_Home}/conf/server.xml.</li>
+ <ol start=1 type=a>
+ <li>Find the end-of-section marker </GlobalNamingResources> and add the following lines just above it:
+ <p>
+ <div class="codebox2">
+ <pre>
+ <!-- Global Datasource for Derby dastest database -->
+ <Resource name="jdbc/dastest"
+ type="javax.sql.DataSource" auth="Container"
+ description="Derby database for DAS Company sample"
+ maxActive="100" maxIdle="30" maxWait="10000"
+ username="" password=""
+ driverClassName="org.apache.derby.jdbc.EmbeddedDriver"
+ url="jdbc:derby:{absolute path}Databases/dastest"/>
+ </pre>
+ </div>
+ </p>
+ <p><b>Requirement</b>:You must include the absolute path to the “Databases” directory in the above url attribute. Fore example:</p>
+ <p><pre> url="jdbc:derby:c:\apache-tomcat-5.5.17\Databases/dastest"</pre></p>
+ </li>
+ </ol>
+ <li><p>Start tomcat and point your browser to: <a href="http://localhost:8080/sample-das-service-client-%7bversion%20tag%7d/">http://localhost:8080/sample-das-service-client-{version
+ tag}/</a>. Example:</p>
+ <p><pre> http://localhost:8080/sample-das-service-client-1.0-incubator-SNAPSHOT/</pre></p>
+
+ </li>
+
+</ol>
+
+
+
+
+<h3>Sample Architecture</h3>
+
+<p>This is a simple, single-page, web application to consume DAS exposed as an SCA service.</p>
+<p>The main components of this application are:</p>
+
+<ul type=disc>
+ <li>The SCA DAS Service</li>
+ <li>SDO</li>
+ <li>Company.jsp</li>
+ <li>The canned Derby database</li>
+</ul>
+
+
+<p>The <b>Company.jsp</b> directly invoke the DAS Service to get a list of companies available and then iterate trough the SDO data graphs and manipulate SDO directly to display data</p>
+
+<p>The canned <b>Derby database</b> comes preloaded with Companies and related Departments. The Derby database instance is a simple file folder.</p>
+
+<p>The <b>SCA DAS Service</b> accepts directives (commands) and reads and writes to the derby database instance appropriately using DAS as the service implementation.</p>
+
+
+
+<h3>Consuming the DAS service</h3>
+
+<p>First, note that the application have dependencies on the DAS Service:</p>
+
+
+<p>
+<div class="codebox2">
+<pre>
+<!-- DAS Service -->
+<dependency>
+ <groupId>org.apache.tuscany.das.samples</groupId>
+ <artifactId>sample-das-service</artifactId>
+ <version>${pom.version}</version>
+</dependency>
+</pre>
+</div>
+</p>
+
+<br>
+<p>And the SCDL references the service:</p>
+
+<p>
+<div class="codebox2">
+<pre>
+<composite xmlns="http://www.osoa.org/xmlns/sca/1.0" name="DASServiceComposite">
+ <component name="DASServiceComponent">
+ <implementation.composite name="DASServiceComposite" jarLocation="lib/sample-das-service-1.0-incubator-SNAPSHOT.jar"/>
+ </component>
+</composite>
+</pre>
+</div>
+</p>
+
+
+
+
+</body>
+
+</html>
diff --git a/sandbox/lresende/backup/container.das.client/src/main/java/org/apache/tuscany/samples/das/orders/CustomersOrdersService.java b/sandbox/lresende/backup/container.das.client/src/main/java/org/apache/tuscany/samples/das/orders/CustomersOrdersService.java new file mode 100644 index 0000000000..f301483be3 --- /dev/null +++ b/sandbox/lresende/backup/container.das.client/src/main/java/org/apache/tuscany/samples/das/orders/CustomersOrdersService.java @@ -0,0 +1,43 @@ +/*
+ * 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.
+ */
+package org.apache.tuscany.samples.das.orders;
+
+import java.util.ArrayList;
+import java.util.Vector;
+
+import commonj.sdo.DataObject;
+
+public interface CustomersOrdersService {
+
+ //dynamic way - demoed in J2SE client only
+ public void execute(Vector params);
+ public DataObject executeQuery(Vector params);
+ public void applyChanges(Vector params);
+ public DataObject executeAdhoc(Vector params);//adhoc query implementation - not done
+
+ //static way - demoed in JSP, J2SE clients
+ public DataObject getAllCustomers(Vector paramsList);
+ public DataObject getRangeCustomers(Vector paramsList);
+ public void getInsertCustomerExecute(Vector paramsList);
+ public void getInsertCustomerApplyChanges(Vector paramsList);
+ public void getDeleteCustomerExecute(Vector paramsList);
+ public void getDeleteCustomerApplyChanges(Vector paramsList);
+ public void getUpdateCustomer(Vector paramsList);
+ public DataObject getNamedCustomers(Vector paramsList);
+}
diff --git a/sandbox/lresende/backup/container.das.client/src/main/java/org/apache/tuscany/samples/das/orders/CustomersOrdersServiceImpl.java b/sandbox/lresende/backup/container.das.client/src/main/java/org/apache/tuscany/samples/das/orders/CustomersOrdersServiceImpl.java new file mode 100644 index 0000000000..ffd02a8f85 --- /dev/null +++ b/sandbox/lresende/backup/container.das.client/src/main/java/org/apache/tuscany/samples/das/orders/CustomersOrdersServiceImpl.java @@ -0,0 +1,74 @@ +/*
+ * 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.
+ */
+package org.apache.tuscany.samples.das.orders;
+
+import java.util.Vector;
+import commonj.sdo.DataObject;
+
+public class CustomersOrdersServiceImpl implements CustomersOrdersService {
+
+ //dynamic way
+ public void execute(Vector params) {
+ }
+
+ public DataObject executeQuery(Vector params){
+ return null;
+ }
+
+ public void applyChanges(Vector params){
+
+ }
+
+ public DataObject executeAdhoc(Vector params){
+ return null;
+ }
+
+ // static way
+ public DataObject getAllCustomers(Vector paramsList){
+ return null;
+ }
+
+ public DataObject getRangeCustomers(Vector paramsList){
+ return null;
+ }
+
+ public void getInsertCustomerExecute(Vector paramsList){
+ return ;
+ }
+
+ public void getInsertCustomerApplyChanges(Vector paramsList){
+ return ;
+ }
+
+ public void getDeleteCustomerExecute(Vector paramsList){
+ return ;
+ }
+
+ public void getDeleteCustomerApplyChanges(Vector paramsList){
+ return ;
+ }
+
+ public void getUpdateCustomer(Vector paramsList){
+ return;
+ }
+
+ public DataObject getNamedCustomers(Vector paramsList){
+ return null;
+ }
+}
diff --git a/sandbox/lresende/backup/container.das.client/src/main/java/org/apache/tuscany/samples/das/orders/StoredProcs.java b/sandbox/lresende/backup/container.das.client/src/main/java/org/apache/tuscany/samples/das/orders/StoredProcs.java new file mode 100644 index 0000000000..fd064f006e --- /dev/null +++ b/sandbox/lresende/backup/container.das.client/src/main/java/org/apache/tuscany/samples/das/orders/StoredProcs.java @@ -0,0 +1,42 @@ +/*
+ * 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.
+ */
+package org.apache.tuscany.samples.das.orders;
+import java.sql.Connection;
+import java.sql.DriverManager;
+import java.sql.PreparedStatement;
+import java.sql.ResultSet;
+import java.sql.SQLException;
+
+//Example stored procedure in Derby
+public class StoredProcs {
+ public static void getNamedCustomers(String theName, int[] outCount, ResultSet[] results) throws SQLException {
+
+ Connection conn = DriverManager.getConnection("jdbc:default:connection");
+ PreparedStatement ps = conn.prepareStatement("SELECT * FROM CUSTOMER WHERE LASTNAME = ?");
+ ps.setString(1, theName);
+ results[0] = ps.executeQuery();
+
+ ps = conn.prepareStatement("SELECT COUNT(*) FROM CUSTOMER WHERE LASTNAME = ?");
+ ps.setString(1, theName);
+
+ ResultSet rs = ps.executeQuery();
+ rs.next();
+ outCount[0] = rs.getInt(1);
+ }
+}
diff --git a/sandbox/lresende/backup/container.das.client/src/main/resources/CustomersOrders.componentType b/sandbox/lresende/backup/container.das.client/src/main/resources/CustomersOrders.componentType new file mode 100644 index 0000000000..67307e7275 --- /dev/null +++ b/sandbox/lresende/backup/container.das.client/src/main/resources/CustomersOrders.componentType @@ -0,0 +1,26 @@ +<?xml version="1.0" encoding="ASCII"?>
+<!--
+ * 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.
+-->
+
+<componentType xmlns="http://www.osoa.org/xmlns/sca/1.0" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
+
+ <service name="CustomersOrdersService">
+ <interface.java interface="org.apache.tuscany.samples.das.orders.CustomersOrdersService"/>
+ </service>
+</componentType>
diff --git a/sandbox/lresende/backup/container.das.client/src/main/resources/CustomersOrders.xml b/sandbox/lresende/backup/container.das.client/src/main/resources/CustomersOrders.xml new file mode 100644 index 0000000000..12f4bf8bac --- /dev/null +++ b/sandbox/lresende/backup/container.das.client/src/main/resources/CustomersOrders.xml @@ -0,0 +1,82 @@ +<?xml version="1.0" encoding="ASCII"?>
+<!--
+ 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.
+ -->
+<Config xsi:noNamespaceSchemaLocation="http:///org.apache.tuscany.das.rdb/config.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
+ <ConnectionInfo dataSource="derby:dastest" managedtx="true"/>
+
+ <Command name="AllCustomers" SQL="select * from CUSTOMER" kind="Select"/>
+
+ <Command name="RangeCustomers" SQL="select * from CUSTOMER where ID >= ?" kind="Select"/>
+
+ <Command name="customer and orders"
+ SQL="select * from CUSTOMER left join ANORDER on CUSTOMER.ID = ANORDER.CUSTOMER_ID where CUSTOMER.ID = ?"
+ kind="Select">
+ </Command>
+
+ <Command name="InsertCustomerExecute"
+ SQL="insert into CUSTOMER (ID, LASTNAME, ADDRESS) values (?, ?, ?)"
+ kind="Insert">
+ </Command>
+
+ <Command name="delete customer"
+ SQL="delete from CUSTOMER where ID = ?"
+ kind="Delete">
+ </Command>
+
+ <Command name="DeleteCustomerExecute"
+ SQL="delete from CUSTOMER where ID = ?"
+ kind="Delete">
+ </Command>
+
+ <Command name="orderby id" SQL="select * from ANORDER where ANORDER.ID = ?"
+ kind="Select">
+ </Command>
+
+ <Command name="UpdateCustomer"
+ SQL="update CUSTOMER set LASTNAME = ? where ID = ?"
+ kind="update">
+ </Command>
+
+ <Command name="update customer"
+ SQL="update CUSTOMER set LASTNAME = 'Pavick' where ID = ?"
+ kind="update">
+ </Command>
+
+ <Table tableName="CUSTOMER">
+ <Column columnName="ID" primaryKey="true"/>
+ </Table>
+
+ <Table tableName="ANORDER">
+ <Column columnName="ID" primaryKey="true"/>
+ </Table>
+
+ <Command name="getAllCompanies" SQL="{call GETALLCOMPANIES()}" kind="procedure">
+ </Command>
+
+ <Command name="NamedCustomers" SQL="{call GETNAMEDCUSTOMERS(?,?)}" kind="procedure">
+ <Parameter direction="IN" index="1" columnType="commonj.sdo.String"/>
+ <Parameter direction="OUT" index="2" columnType="commonj.sdo.IntObject"/>
+ </Command>
+
+ <Relationship name="orders" primaryKeyTable="CUSTOMER"
+ foreignKeyTable="ANORDER" many="true">
+ <KeyPair primaryKeyColumn="ID" foreignKeyColumn="CUSTOMER_ID"/>
+ </Relationship>
+
+</Config>
\ No newline at end of file diff --git a/sandbox/lresende/backup/container.das.client/src/main/resources/META-INF/LICENSE.txt b/sandbox/lresende/backup/container.das.client/src/main/resources/META-INF/LICENSE.txt new file mode 100644 index 0000000000..75b52484ea --- /dev/null +++ b/sandbox/lresende/backup/container.das.client/src/main/resources/META-INF/LICENSE.txt @@ -0,0 +1,202 @@ +
+ Apache License
+ Version 2.0, January 2004
+ http://www.apache.org/licenses/
+
+ TERMS AND CONDITIONS FOR USE, REPRODUCTION, AND DISTRIBUTION
+
+ 1. Definitions.
+
+ "License" shall mean the terms and conditions for use, reproduction,
+ and distribution as defined by Sections 1 through 9 of this document.
+
+ "Licensor" shall mean the copyright owner or entity authorized by
+ the copyright owner that is granting the License.
+
+ "Legal Entity" shall mean the union of the acting entity and all
+ other entities that control, are controlled by, or are under common
+ control with that entity. For the purposes of this definition,
+ "control" means (i) the power, direct or indirect, to cause the
+ direction or management of such entity, whether by contract or
+ otherwise, or (ii) ownership of fifty percent (50%) or more of the
+ outstanding shares, or (iii) beneficial ownership of such entity.
+
+ "You" (or "Your") shall mean an individual or Legal Entity
+ exercising permissions granted by this License.
+
+ "Source" form shall mean the preferred form for making modifications,
+ including but not limited to software source code, documentation
+ source, and configuration files.
+
+ "Object" form shall mean any form resulting from mechanical
+ transformation or translation of a Source form, including but
+ not limited to compiled object code, generated documentation,
+ and conversions to other media types.
+
+ "Work" shall mean the work of authorship, whether in Source or
+ Object form, made available under the License, as indicated by a
+ copyright notice that is included in or attached to the work
+ (an example is provided in the Appendix below).
+
+ "Derivative Works" shall mean any work, whether in Source or Object
+ form, that is based on (or derived from) the Work and for which the
+ editorial revisions, annotations, elaborations, or other modifications
+ represent, as a whole, an original work of authorship. For the purposes
+ of this License, Derivative Works shall not include works that remain
+ separable from, or merely link (or bind by name) to the interfaces of,
+ the Work and Derivative Works thereof.
+
+ "Contribution" shall mean any work of authorship, including
+ the original version of the Work and any modifications or additions
+ to that Work or Derivative Works thereof, that is intentionally
+ submitted to Licensor for inclusion in the Work by the copyright owner
+ or by an individual or Legal Entity authorized to submit on behalf of
+ the copyright owner. For the purposes of this definition, "submitted"
+ means any form of electronic, verbal, or written communication sent
+ to the Licensor or its representatives, including but not limited to
+ communication on electronic mailing lists, source code control systems,
+ and issue tracking systems that are managed by, or on behalf of, the
+ Licensor for the purpose of discussing and improving the Work, but
+ excluding communication that is conspicuously marked or otherwise
+ designated in writing by the copyright owner as "Not a Contribution."
+
+ "Contributor" shall mean Licensor and any individual or Legal Entity
+ on behalf of whom a Contribution has been received by Licensor and
+ subsequently incorporated within the Work.
+
+ 2. Grant of Copyright License. Subject to the terms and conditions of
+ this License, each Contributor hereby grants to You a perpetual,
+ worldwide, non-exclusive, no-charge, royalty-free, irrevocable
+ copyright license to reproduce, prepare Derivative Works of,
+ publicly display, publicly perform, sublicense, and distribute the
+ Work and such Derivative Works in Source or Object form.
+
+ 3. Grant of Patent License. Subject to the terms and conditions of
+ this License, each Contributor hereby grants to You a perpetual,
+ worldwide, non-exclusive, no-charge, royalty-free, irrevocable
+ (except as stated in this section) patent license to make, have made,
+ use, offer to sell, sell, import, and otherwise transfer the Work,
+ where such license applies only to those patent claims licensable
+ by such Contributor that are necessarily infringed by their
+ Contribution(s) alone or by combination of their Contribution(s)
+ with the Work to which such Contribution(s) was submitted. If You
+ institute patent litigation against any entity (including a
+ cross-claim or counterclaim in a lawsuit) alleging that the Work
+ or a Contribution incorporated within the Work constitutes direct
+ or contributory patent infringement, then any patent licenses
+ granted to You under this License for that Work shall terminate
+ as of the date such litigation is filed.
+
+ 4. Redistribution. You may reproduce and distribute copies of the
+ Work or Derivative Works thereof in any medium, with or without
+ modifications, and in Source or Object form, provided that You
+ meet the following conditions:
+
+ (a) You must give any other recipients of the Work or
+ Derivative Works a copy of this License; and
+
+ (b) You must cause any modified files to carry prominent notices
+ stating that You changed the files; and
+
+ (c) You must retain, in the Source form of any Derivative Works
+ that You distribute, all copyright, patent, trademark, and
+ attribution notices from the Source form of the Work,
+ excluding those notices that do not pertain to any part of
+ the Derivative Works; and
+
+ (d) If the Work includes a "NOTICE" text file as part of its
+ distribution, then any Derivative Works that You distribute must
+ include a readable copy of the attribution notices contained
+ within such NOTICE file, excluding those notices that do not
+ pertain to any part of the Derivative Works, in at least one
+ of the following places: within a NOTICE text file distributed
+ as part of the Derivative Works; within the Source form or
+ documentation, if provided along with the Derivative Works; or,
+ within a display generated by the Derivative Works, if and
+ wherever such third-party notices normally appear. The contents
+ of the NOTICE file are for informational purposes only and
+ do not modify the License. You may add Your own attribution
+ notices within Derivative Works that You distribute, alongside
+ or as an addendum to the NOTICE text from the Work, provided
+ that such additional attribution notices cannot be construed
+ as modifying the License.
+
+ You may add Your own copyright statement to Your modifications and
+ may provide additional or different license terms and conditions
+ for use, reproduction, or distribution of Your modifications, or
+ for any such Derivative Works as a whole, provided Your use,
+ reproduction, and distribution of the Work otherwise complies with
+ the conditions stated in this License.
+
+ 5. Submission of Contributions. Unless You explicitly state otherwise,
+ any Contribution intentionally submitted for inclusion in the Work
+ by You to the Licensor shall be under the terms and conditions of
+ this License, without any additional terms or conditions.
+ Notwithstanding the above, nothing herein shall supersede or modify
+ the terms of any separate license agreement you may have executed
+ with Licensor regarding such Contributions.
+
+ 6. Trademarks. This License does not grant permission to use the trade
+ names, trademarks, service marks, or product names of the Licensor,
+ except as required for reasonable and customary use in describing the
+ origin of the Work and reproducing the content of the NOTICE file.
+
+ 7. Disclaimer of Warranty. Unless required by applicable law or
+ agreed to in writing, Licensor provides the Work (and each
+ Contributor provides its Contributions) on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or
+ implied, including, without limitation, any warranties or conditions
+ of TITLE, NON-INFRINGEMENT, MERCHANTABILITY, or FITNESS FOR A
+ PARTICULAR PURPOSE. You are solely responsible for determining the
+ appropriateness of using or redistributing the Work and assume any
+ risks associated with Your exercise of permissions under this License.
+
+ 8. Limitation of Liability. In no event and under no legal theory,
+ whether in tort (including negligence), contract, or otherwise,
+ unless required by applicable law (such as deliberate and grossly
+ negligent acts) or agreed to in writing, shall any Contributor be
+ liable to You for damages, including any direct, indirect, special,
+ incidental, or consequential damages of any character arising as a
+ result of this License or out of the use or inability to use the
+ Work (including but not limited to damages for loss of goodwill,
+ work stoppage, computer failure or malfunction, or any and all
+ other commercial damages or losses), even if such Contributor
+ has been advised of the possibility of such damages.
+
+ 9. Accepting Warranty or Additional Liability. While redistributing
+ the Work or Derivative Works thereof, You may choose to offer,
+ and charge a fee for, acceptance of support, warranty, indemnity,
+ or other liability obligations and/or rights consistent with this
+ License. However, in accepting such obligations, You may act only
+ on Your own behalf and on Your sole responsibility, not on behalf
+ of any other Contributor, and only if You agree to indemnify,
+ defend, and hold each Contributor harmless for any liability
+ incurred by, or claims asserted against, such Contributor by reason
+ of your accepting any such warranty or additional liability.
+
+ END OF TERMS AND CONDITIONS
+
+ APPENDIX: How to apply the Apache License to your work.
+
+ To apply the Apache License to your work, attach the following
+ boilerplate notice, with the fields enclosed by brackets "[]"
+ replaced with your own identifying information. (Don't include
+ the brackets!) The text should be enclosed in the appropriate
+ comment syntax for the file format. We also recommend that a
+ file or class name and description of purpose be included on the
+ same "printed page" as the copyright notice for easier
+ identification within third-party archives.
+
+ Copyright [yyyy] [name of copyright owner]
+
+ 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.
diff --git a/sandbox/lresende/backup/container.das.client/src/main/resources/META-INF/NOTICE b/sandbox/lresende/backup/container.das.client/src/main/resources/META-INF/NOTICE new file mode 100644 index 0000000000..59f0b4314f --- /dev/null +++ b/sandbox/lresende/backup/container.das.client/src/main/resources/META-INF/NOTICE @@ -0,0 +1,32 @@ +Apache Tuscany DAS for Java
+Copyright 2006 The Apache Software Foundation
+
+This product includes software developed at
+The Apache Software Foundation (http://www.apache.org/).
+
+Apache Tuscany is an effort undergoing incubation at The Apache Software Foundation (ASF),
+sponsored by the Apache Web Services PMC. Incubation is required of all newly accepted
+projects until a further review indicates that the infrastructure, communications,
+and decision making process have stabilized in a manner consistent with other successful
+ASF projects. While incubation status is not necessarily a reflection of the completeness
+or stability of the code, it does indicate that the project has yet to be fully endorsed
+by the ASF.
+
+Unless otherwise indicated, all distribution made available by the Apache Software Foundation
+is provided to you under the terms and conditions of the Apache License Version 2.0 ("AL").
+A copy of the AL is provided with this distribution as the LICENSE.txt file present in the
+root directory, and is also available at http://www.apache.org/licenses/.
+
+The terms and conditions governing the distribution may refer to the AL or other license
+agreements, notices or terms and conditions. Some of these other license agreements may
+include (but are not limited to):
+
+ . Eclipse Public License Version 1.0 (available at http://www.eclipse.org/legal/epl-v10.html)
+ . Common Public License Version 1.0 (available at http://www.eclipse.org/legal/cpl-v10.html)
+
+This product also includes software developed by:
+- the Eclipse Modeling Framework project (http://www.eclipse.org/emf/)
+
+It is your obligation to read and accept all such terms and conditions prior to use of the
+distribution. If term or condition is provided, please contact the Apache Software Foundation
+to determine what terms and conditions govern that particular distribution.
diff --git a/sandbox/lresende/backup/container.das.client/src/main/resources/META-INF/README.txt b/sandbox/lresende/backup/container.das.client/src/main/resources/META-INF/README.txt new file mode 100644 index 0000000000..d1905ee3e8 --- /dev/null +++ b/sandbox/lresende/backup/container.das.client/src/main/resources/META-INF/README.txt @@ -0,0 +1,35 @@ +Apache Tuscany M2 build (October, 2006)
+===================================
+
+http://incubator.apache.org/tuscany/
+
+Tuscany is an effort undergoing incubation at the Apache Software Foundation
+(ASF), sponsored by the Web Services PMC.
+
+Incubation is required of all newly accepted projects until a further review
+indicates that the infrastructure, communications, and decision making process
+have stabilized in a manner consistent with other successful ASF projects.
+
+While incubation status is not necessarily a reflection of the completeness or
+stability of the code, it does indicate that the project has yet to be fully
+endorsed by the ASF.
+
+
+Support
+-------
+
+Any problem with this release can be reported to the Tuscany mailing list
+or in the JIRA issue tracker.
+
+Mailing list subscription:
+ tuscany-dev-subscribe@ws.apache.org
+
+Jira:
+ http://issues.apache.org/jira/browse/Tuscany
+
+
+Thank you for using Tuscany!
+
+
+The Tuscany Team.
+
diff --git a/sandbox/lresende/backup/container.das.client/src/main/resources/log4j.properties b/sandbox/lresende/backup/container.das.client/src/main/resources/log4j.properties new file mode 100644 index 0000000000..c5c2868aaa --- /dev/null +++ b/sandbox/lresende/backup/container.das.client/src/main/resources/log4j.properties @@ -0,0 +1,29 @@ +# 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.
+#
+# Set root logger level to DEBUG and its only appender to A1.
+log4j.rootLogger=INFO, A1
+
+# A1 is set to be a ConsoleAppender.
+log4j.appender.A1=org.apache.log4j.ConsoleAppender
+
+# A1 uses PatternLayout.
+log4j.appender.A1.layout=org.apache.log4j.PatternLayout
+log4j.appender.A1.layout.ConversionPattern=[DAS RDB] - %c{1}.%M (%L) : %m %n
+
+# Print only messages of level WARN or above in the package com.foo.
+log4j.logger.org.apache.tuscany=NONE
\ No newline at end of file diff --git a/sandbox/lresende/backup/container.das.client/src/main/webapp/Company.jsp b/sandbox/lresende/backup/container.das.client/src/main/webapp/Company.jsp new file mode 100644 index 0000000000..9fadd79766 --- /dev/null +++ b/sandbox/lresende/backup/container.das.client/src/main/webapp/Company.jsp @@ -0,0 +1,70 @@ +<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
+<!--
+ 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.
+ -->
+
+<%@ page import="java.util.*" %>
+
+<%@ page import="org.osoa.sca.CompositeContext" %>
+<%@ page import="org.osoa.sca.CurrentCompositeContext" %>
+
+<%@ page import="commonj.sdo.*" %>
+
+<%@ page import="org.apache.tuscany.samples.das.orders.*" %>
+
+<html>
+<head>
+<%@ page language="java" contentType="text/html;charset=UTF-8" pageEncoding="UTF-8"%>
+<%
+//
+ CompositeContext context = CurrentCompositeContext.getContext();
+ CustomersOrdersService service = context.locateService(CustomersOrdersService.class, "CustomersOrdersComponent");
+ List customers = null;
+ try{
+ DataObject root = service.getAllCustomers(null);
+ customers = root.getList("CUSTOMERS");
+ }catch(Exception e){
+ //TODO: handle case where dasService can't be initiated properly
+ }
+%>
+
+<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
+<title>DASService Client Test</title>
+</head>
+<body>
+
+<H2>Tuscany DAS Service WEB Client Application Example</H2>
+
+<!-- Do Fill -->
+<table border>
+ <thead>
+ <tr>
+ <th>ID</th>
+ <th>Name</th>
+ </tr>
+ </thead>
+ <tbody>
+
+ </tbody>
+</table>
+
+
+
+</form>
+</body>
+</html>
diff --git a/sandbox/lresende/backup/container.das.client/src/main/webapp/Customer.jsp b/sandbox/lresende/backup/container.das.client/src/main/webapp/Customer.jsp new file mode 100644 index 0000000000..b963d51263 --- /dev/null +++ b/sandbox/lresende/backup/container.das.client/src/main/webapp/Customer.jsp @@ -0,0 +1,419 @@ +<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
+<!--
+ 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.
+ -->
+
+<%@ page import="java.util.*" %>
+
+<%@ page import="org.osoa.sca.CompositeContext" %>
+<%@ page import="org.osoa.sca.CurrentCompositeContext" %>
+
+<%@ page import="commonj.sdo.*" %>
+
+<%@ page import="org.apache.tuscany.samples.das.orders.*" %>
+
+<html>
+<head>
+<%@ page language="java" contentType="text/html;charset=ISO-8859-1" pageEncoding="ISO-8859-1"%>
+<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
+<title>DAS - SCA Container Test</title>
+</head>
+<body>
+
+<H2>Tuscany DAS - SCA container Test </H2>
+<H3>(demo for static service API approach e.g. getAllCustomers())</H3>
+<form>
+<input type="submit" id="doSelectStatic" name="doSelectStatic" value="RangeCustomers (SELECT/WHERE as executeQuery())">
+<input type="submit" id="doInsertExecute" name="doInsertExecute" value="InsertCustomer (INSERT AS execute())">
+<input type="submit" id="doInsertApplyChanges" name="doInsertApplyChanges" value="InsertCustomer (INSERT AS applyChanges())">
+<input type="submit" id="doDeleteExecute" name="doDeleteExecute" value="DeleteCustomer (DELETE AS execute())">
+<input type="submit" id="doDeleteApplyChanges" name="doDeleteApplyChanges" value="DeleteCustomer (DELETE AS applyChanges())">
+<input type="submit" id="doUpdateApplyChanges" name="doUpdateApplyChanges" value="UpdateCustomer (UPDATE AS applyChanges())">
+<input type="submit" id="doSP" name="doSP" value="SPCustomer - get customer for name">
+
+<%
+CompositeContext context = CurrentCompositeContext.getContext();
+CustomersOrdersService service = context.locateService(CustomersOrdersService.class, "CustomersOrdersComponent");
+List customers = null;
+Map<Integer, Object> inParams = new Hashtable<Integer, Object>();
+Vector params = new Vector();
+%>
+
+<%! //common code to display latest results
+ public Iterator getResult(){
+ List custList = null;
+ java.util.Iterator i = null;
+ try{
+ Map<Integer, Object> inParams = new Hashtable<Integer, Object>();
+ Vector params = new Vector();
+ CompositeContext context = CurrentCompositeContext.getContext();
+ CustomersOrdersService service = context.locateService(CustomersOrdersService.class, "CustomersOrdersComponent");
+ params.clear();
+ params.add("");//of no use - as is derived using CommandMapper
+ params.add("select"); //is needed to understand whether execute/executeQuery/applyChanges
+ inParams.clear();
+ inParams.put(1, new Integer(1));
+ params.add(inParams);
+
+ DataObject root = service.getRangeCustomers(params);
+ custList = root.getList("CUSTOMER");
+ if(custList != null){
+ i = custList.iterator();
+ return i;
+ }
+ }catch(Exception e){
+ e.printStackTrace();
+ //TODO: handle case where dasService can't be initiated properly
+ }finally{
+ }
+
+ return i;
+ }
+%>
+<hr>
+
+<!--------------------------------------------------------------------------->
+<!--doSelectStatic -->
+<%if(request.getParameter("doSelectStatic") != null){%>
+
+<table border>
+ <thead>
+ <tr>
+ <th>ID</th>
+ <th>LastName</th>
+ </tr>
+ </thead>
+ <tbody>
+ <%
+ java.util.Iterator i = getResult();
+ while (i.hasNext()) {
+ DataObject customer = (DataObject)i.next();
+ %>
+ <tr>
+ <td><%=customer.getInt("ID")%></td>
+ <td><%=customer.getString("LASTNAME")%></td>
+ <tr>
+ <%
+ }//while
+ %>
+ </tbody>
+</table>
+
+<%}//doSelectStatic %>
+<!--------------------------------------------------------------------------->
+<!--doInsertExecute -->
+<%if(request.getParameter("doInsertExecute") != null){%>
+
+ <%try{
+ params.clear();
+ inParams.clear();
+
+ System.out.println("Calling InsertCustomerExecute");
+ params.clear();
+ inParams.clear();
+ params.add("");
+ params.add("insert");
+
+ inParams.put(1, new Integer(4));
+ inParams.put(2, new String("11"));
+ inParams.put(3, new String("111"));
+
+ params.add(inParams);
+
+ service.getInsertCustomerExecute(params);
+
+ }catch(Exception e){
+ e.printStackTrace();
+ }%>
+<table border>
+ <thead>
+ <tr>
+ <th>ID</th>
+ <th>LastName</th>
+ </tr>
+ </thead>
+ <tbody>
+ <%
+ java.util.Iterator i = getResult();
+ while (i.hasNext()) {
+ DataObject customer = (DataObject)i.next();
+ %>
+ <tr>
+ <td><%=customer.getInt("ID")%></td>
+ <td><%=customer.getString("LASTNAME")%></td>
+ <tr>
+ <%
+ }//while
+ %>
+ </tbody>
+</table>
+<%}//doInsertExecute %>
+<!--------------------------------------------------------------------------->
+<!--doInsertApplyChanges -->
+<%if(request.getParameter("doInsertApplyChanges") != null){%>
+
+ <%try{
+ Map<String, Object> insertParams = new Hashtable<String, Object>();
+ System.out.println("Calling InsertCustomerApplyChanges");
+ params.clear();
+ insertParams.clear();
+ params.add("");
+ params.add("insert:CUSTOMER");
+
+ insertParams.put("ID", new Integer("9"));
+ insertParams.put("LASTNAME", "222");
+ insertParams.put("ADDRESS", "2222");
+
+ params.add(insertParams);
+
+ service.getInsertCustomerApplyChanges(params);
+ }catch(Exception e){
+ e.printStackTrace();
+ }%>
+<table border>
+ <thead>
+ <tr>
+ <th>ID</th>
+ <th>LastName</th>
+ </tr>
+ </thead>
+ <tbody>
+ <%
+ java.util.Iterator i = getResult();
+ while (i.hasNext()) {
+ DataObject customer = (DataObject)i.next();
+ %>
+ <tr>
+ <td><%=customer.getInt("ID")%></td>
+ <td><%=customer.getString("LASTNAME")%></td>
+ <tr>
+ <%
+ }//while
+ %>
+ </tbody>
+</table>
+<%}//doInsertApplyChanges %>
+<!--------------------------------------------------------------------------->
+<!--doDeleteExecute -->
+<%if(request.getParameter("doDeleteExecute") != null){%>
+
+ <%
+ try{
+ System.out.println("Calling DeleteCustomerExecute");
+ params.clear();
+ inParams.clear();
+ params.add("");
+ params.add("delete");
+
+ inParams.put(1, new Integer(9));
+
+ params.add(inParams);
+
+ service.getDeleteCustomerExecute(params);
+
+ }catch(Exception e){
+ e.printStackTrace();
+ }%>
+
+<table border>
+ <thead>
+ <tr>
+ <th>ID</th>
+ <th>LastName</th>
+ </tr>
+ </thead>
+ <tbody>
+ <%
+ java.util.Iterator i = getResult();
+ while (i.hasNext()) {
+ DataObject customer = (DataObject)i.next();
+ %>
+ <tr>
+ <td><%=customer.getInt("ID")%></td>
+ <td><%=customer.getString("LASTNAME")%></td>
+ <tr>
+ <%
+ }//while
+ %>
+ </tbody>
+</table>
+<%}//doDeleteExecute %>
+<!--------------------------------------------------------------------------->
+<!--doDeleteApplyChanges -->
+<%if(request.getParameter("doDeleteApplyChanges") != null){%>
+ <%try{
+ Map<String, Object> whereParams = new Hashtable<String, Object>();
+ params.clear();
+
+ whereParams.clear();
+ whereParams.put("ID", new Integer(1));
+
+ params.add("");
+ params.add("delete:CUSTOMER");//command type:tableName
+ params.add(whereParams);
+ service.getDeleteCustomerApplyChanges(params);
+ }catch(Exception e){
+ e.printStackTrace();
+ }%>
+
+<table border>
+ <thead>
+ <tr>
+ <th>ID</th>
+ <th>LastName</th>
+ </tr>
+ </thead>
+ <tbody>
+ <%
+ java.util.Iterator i = getResult();
+ while (i.hasNext()) {
+ DataObject customer = (DataObject)i.next();
+ %>
+ <tr>
+ <td><%=customer.getInt("ID")%></td>
+ <td><%=customer.getString("LASTNAME")%></td>
+ <tr>
+ <%
+ }//while
+ %>
+ </tbody>
+</table>
+<%}//doDeleteApplyChanges %>
+<!--------------------------------------------------------------------------->
+<!--doUpdateApplyChanges -->
+<%if(request.getParameter("doUpdateApplyChanges") != null){%>
+<%try{
+ Map<String, Object> updParams = new Hashtable<String, Object>();//as its not position based but name based
+ Map<String, Object> whereParams = new Hashtable<String, Object>();
+
+ params.clear();
+
+ updParams.clear();
+ updParams.put("LASTNAME", "Berry");
+
+ whereParams.put("ID", new Integer(1));
+
+ params.add("");
+ params.add("update:CUSTOMER");//command type:tableName
+ params.add(updParams);
+ params.add(whereParams);
+ System.out.println("whereParams:"+whereParams.get("ID"));
+ service.getUpdateCustomer(params);
+
+ }catch(Exception e){
+ e.printStackTrace();
+ }%>
+
+<table border>
+ <thead>
+ <tr>
+ <th>ID</th>
+ <th>LastName</th>
+ </tr>
+ </thead>
+ <tbody>
+ <%
+ java.util.Iterator i = getResult();
+ while (i.hasNext()) {
+ DataObject customer = (DataObject)i.next();
+ %>
+ <tr>
+ <td><%=customer.getInt("ID")%></td>
+ <td><%=customer.getString("LASTNAME")%></td>
+ <tr>
+ <%
+ }//while
+ %>
+ </tbody>
+</table>
+<%}//doUpdateApplyChanges %>
+<!--------------------------------------------------------------------------->
+<!--doSP -->
+<%if(request.getParameter("doSP") != null){%>
+<%try{
+ Map<Integer, Object> outParams = new Hashtable<Integer, Object>();
+ System.out.println("Calling getNamedCustomers");
+
+ params.clear();
+ inParams.clear();
+ outParams.clear();
+
+ inParams.put(1, new String("Berry"));
+
+ outParams.put(2, new Object());
+
+ params.add("");
+ params.add("procedure");
+ params.add(inParams);
+ params.add(outParams);
+
+ Object returnObj = service.getNamedCustomers(params);
+
+ //check values in OUT params
+ Map<Integer, Object> resParams = (Map<Integer, Object> )params.get(3);
+ int cnt = 0;
+ if(resParams.size() != 0){
+ Set<Integer> resSet = (Set<Integer>)resParams.keySet();
+ Iterator res = resSet.iterator();
+ Object resObj = null;
+ while(res.hasNext()){
+ Integer rdx = (Integer)res.next();
+ resObj = (Object)resParams.get(rdx);
+ System.out.println("result :"+rdx +","+resObj);
+ cnt = ((Integer)resObj).intValue();
+ }
+ }
+
+ //check value in return result
+ if(cnt > 0){
+ if(returnObj instanceof DataObject){
+ DataObject doResult = (DataObject)returnObj;
+ customers = doResult.getList("CUSTOMER");
+ java.util.Iterator i = customers.iterator();
+ System.out.println("customers:"+customers.size());
+%>
+
+<table border>
+ <thead>
+ <tr>
+ <th>ID</th>
+ <th>LastName</th>
+ </tr>
+ </thead>
+ <tbody>
+
+<% while (i.hasNext()) {
+ DataObject customer = (DataObject)i.next();
+%>
+ <tr>
+ <td><%=customer.getInt("ID")%></td>
+ <td><%=customer.getString("LASTNAME")%></td>
+ <tr>
+ <%}//while
+ }//if DataObj
+ }//if cnt
+
+}catch(Exception e){
+ e.printStackTrace();
+}%>
+
+<%}//doSP %>
+<!--------------------------------------------------------------------------->
+</form>
+</body>
+</html>
diff --git a/sandbox/lresende/backup/container.das.client/src/main/webapp/META-INF/context.xml b/sandbox/lresende/backup/container.das.client/src/main/webapp/META-INF/context.xml new file mode 100644 index 0000000000..0e90eb0a83 --- /dev/null +++ b/sandbox/lresende/backup/container.das.client/src/main/webapp/META-INF/context.xml @@ -0,0 +1,25 @@ +<?xml version="1.0" encoding="UTF-8"?>
+<!--
+ 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.
+ -->
+<Context path="/DAS Stand alone app" debug="5" reloadable="true" crossContext="true">
+
+ <Manager pathname=""/>
+ <ResourceLink name="jdbc/dastest" global="jdbc/dastest" type="javax.sql.DataSource" />
+
+</Context>
diff --git a/sandbox/lresende/backup/container.das.client/src/main/webapp/WEB-INF/default.scdl b/sandbox/lresende/backup/container.das.client/src/main/webapp/WEB-INF/default.scdl new file mode 100644 index 0000000000..db438a88c0 --- /dev/null +++ b/sandbox/lresende/backup/container.das.client/src/main/webapp/WEB-INF/default.scdl @@ -0,0 +1,30 @@ +<?xml version="1.0" encoding="UTF-8"?>
+<!--
+ * 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.
+-->
+<composite xmlns="http://www.osoa.org/xmlns/sca/1.0" name="CustomersOrdersComposite">
+
+ <component name="CustomersOrdersComponent">
+ <implementation.das config="CustomersOrders.xml" dataAccessType="rdb"/>
+ </component>
+
+ <component name="CustomersOrdersJavaReference">
+ <implementation.java class="org.apache.tuscany.samples.das.orders.CustomersOrdersServiceImpl"/>
+ </component>
+
+</composite>
diff --git a/sandbox/lresende/backup/container.das.client/src/main/webapp/WEB-INF/web.xml b/sandbox/lresende/backup/container.das.client/src/main/webapp/WEB-INF/web.xml new file mode 100644 index 0000000000..b464b082d7 --- /dev/null +++ b/sandbox/lresende/backup/container.das.client/src/main/webapp/WEB-INF/web.xml @@ -0,0 +1,44 @@ +<?xml version="1.0" encoding="ISO-8859-1"?>
+<!--
+ 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.
+ -->
+<!DOCTYPE web-app PUBLIC "-//Sun Microsystems, Inc.//DTD Web
+Application 2.3//EN" "http://java.sun.com/dtd/web-app_2_3.dtd">
+
+<web-app>
+ <display-name>Tuscany DAS Container Sample Client Application</display-name>
+
+ <welcome-file-list id="WelcomeFileList">
+ <welcome-file>Customer.jsp</welcome-file>
+ </welcome-file-list>
+
+ <!-- SCA Related configuration -->
+ <filter>
+ <filter-name>TuscanyFilter</filter-name>
+ <filter-class>org.apache.tuscany.runtime.webapp.TuscanyFilter</filter-class>
+ </filter>
+ <filter-mapping>
+ <filter-name>TuscanyFilter</filter-name>
+ <url-pattern>/*</url-pattern>
+ </filter-mapping>
+
+ <listener>
+ <listener-class>org.apache.tuscany.runtime.webapp.TuscanyContextListener</listener-class>
+ </listener>
+ <!-- END of SCA Related configuration -->
+</web-app>
|