summaryrefslogtreecommitdiffstats
path: root/sandbox/lresende/sca
diff options
context:
space:
mode:
authorlresende <lresende@13f79535-47bb-0310-9956-ffa450edef68>2010-01-13 01:41:50 +0000
committerlresende <lresende@13f79535-47bb-0310-9956-ffa450edef68>2010-01-13 01:41:50 +0000
commitaca1633212fe261c04861cd48ab53b5081089fd2 (patch)
tree41f9e8fa66e1b78204ae15071fd611d7205877a1 /sandbox/lresende/sca
parent8eb5bf1de6c82c6d6e2932630be767aaa086a2b8 (diff)
Cleaning up sandbox
git-svn-id: http://svn.us.apache.org/repos/asf/tuscany@898604 13f79535-47bb-0310-9956-ffa450edef68
Diffstat (limited to 'sandbox/lresende/sca')
-rw-r--r--sandbox/lresende/sca/samples/organization-das/organization.sql33
-rw-r--r--sandbox/lresende/sca/samples/organization-das/pom.xml203
-rw-r--r--sandbox/lresende/sca/samples/organization-das/src/main/java/organization/das/OrganizationDataService.java31
-rw-r--r--sandbox/lresende/sca/samples/organization-das/src/main/java/organization/das/OrganizationDataServiceImpl.java89
-rw-r--r--sandbox/lresende/sca/samples/organization-das/src/main/java/organization/services/OrganizationService.java33
-rw-r--r--sandbox/lresende/sca/samples/organization-das/src/main/java/organization/services/OrganizationServiceImpl.java53
-rw-r--r--sandbox/lresende/sca/samples/organization-das/src/main/java/util/ConnectionHelper.java28
-rw-r--r--sandbox/lresende/sca/samples/organization-das/src/main/resources/organization-spring-context.xml20
-rw-r--r--sandbox/lresende/sca/samples/organization-das/src/main/resources/organization.composite22
-rw-r--r--sandbox/lresende/sca/samples/organization-das/src/main/resources/organizationConfiguration.xml87
-rw-r--r--sandbox/lresende/sca/samples/organization-das/src/main/resources/sdo-types.xsd66
-rw-r--r--sandbox/lresende/sca/samples/organization-das/src/test/java/organization/OrganizationTestCase.java141
12 files changed, 0 insertions, 806 deletions
diff --git a/sandbox/lresende/sca/samples/organization-das/organization.sql b/sandbox/lresende/sca/samples/organization-das/organization.sql
deleted file mode 100644
index 3990fa3166..0000000000
--- a/sandbox/lresende/sca/samples/organization-das/organization.sql
+++ /dev/null
@@ -1,33 +0,0 @@
-DROP TABLE ACCOUNT;
-DROP TABLE ORGANIZATIONTYPELIST;
-
-CREATE TABLE ACCOUNT (
- ACCOUNT_ID INT PRIMARY KEY NOT NULL GENERATED ALWAYS AS IDENTITY,
- ACCOUNTTYPE_CD VARCHAR(30),
- ACCOUNT_NAME VARCHAR(30),
- WEB_SITE_ADDRESS VARCHAR(30),
- STREET_ADDRESS_1 VARCHAR(30),
- STREET_ADDRESS_2 VARCHAR(30),
- STREET_ADDRESS_3 VARCHAR(30),
- CITY VARCHAR(10),
- STATE_CD VARCHAR(2),
- POSTAL_CD VARCHAR(5),
- COUNTRY_CD VARCHAR(3),
- PHONE_NUMBER VARCHAR(15),
- FAX_NUMBER VARCHAR(15),
- NOTE VARCHAR(50));
-
-CREATE TABLE ORGANIZATIONTYPELIST (
- ORGANIZATIONTYPEID INT PRIMARY KEY NOT NULL GENERATED ALWAYS AS IDENTITY,
- CODE VARCHAR(10),
- DISPLAYVALUE VARCHAR(30),
- DESCRIPTION VARCHAR(30),
- ISEDITABLE INT);
-
-
-INSERT INTO ACCOUNT (ACCOUNTTYPE_CD, ACCOUNT_NAME, WEB_SITE_ADDRESS, STREET_ADDRESS_1, STREET_ADDRESS_2, STREET_ADDRESS_3, CITY, STATE_CD, POSTAL_CD, COUNTRY_CD, PHONE_NUMBER, FAX_NUMBER, NOTE) VALUES ('ACC_TYPE_01', 'NAME_001', 'http://name_001.com', '1234 Street 1', '', '', 'San Jose', 'CA', '95134', 'USA', '', '', 'NAME 001 NOTES');
-
-
-INSERT INTO ORGANIZATIONTYPELIST (CODE, DISPLAYVALUE, DESCRIPTION, ISEDITABLE) VALUES('ACME', 'ACME Organization', 'ACME Description', 0 );
-INSERT INTO ORGANIZATIONTYPELIST (CODE, DISPLAYVALUE, DESCRIPTION, ISEDITABLE) VALUES('DO-RITE', 'DO-RITE Plumbing', 'DO-RITE Plumbing Description', 0 );
-INSERT INTO ORGANIZATIONTYPELIST (CODE, DISPLAYVALUE, DESCRIPTION, ISEDITABLE) VALUES('MEGACORP', 'MEGACORP Organization', 'MEGACORP Description', 0 );
diff --git a/sandbox/lresende/sca/samples/organization-das/pom.xml b/sandbox/lresende/sca/samples/organization-das/pom.xml
deleted file mode 100644
index b39c125f25..0000000000
--- a/sandbox/lresende/sca/samples/organization-das/pom.xml
+++ /dev/null
@@ -1,203 +0,0 @@
-<?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>
- <modelVersion>4.0.0</modelVersion>
- <parent>
- <groupId>org.apache.tuscany.sca</groupId>
- <artifactId>tuscany-sca</artifactId>
- <version>1.4-SNAPSHOT</version>
- <relativePath>../pom.xml</relativePath>
- </parent>
-
- <artifactId>sample-organization-das</artifactId>
- <name>Apache Tuscany SCA Company Data Access Service Sample</name>
- <packaging>jar</packaging>
-
-
- <dependencies>
- <dependency>
- <groupId>org.apache.tuscany.sca</groupId>
- <artifactId>tuscany-sca-api</artifactId>
- <version>1.4-SNAPSHOT</version>
- </dependency>
-
- <dependency>
- <groupId>org.apache.tuscany.sca</groupId>
- <artifactId>tuscany-host-embedded</artifactId>
- <version>1.4-SNAPSHOT</version>
- </dependency>
-
- <dependency>
- <groupId>org.apache.tuscany.sca</groupId>
- <artifactId>tuscany-implementation-java-runtime</artifactId>
- <version>1.4-SNAPSHOT</version>
- <scope>runtime</scope>
- </dependency>
-
- <dependency>
- <groupId>org.apache.tuscany.sca</groupId>
- <artifactId>tuscany-binding-ws-axis2</artifactId>
- <version>1.4-SNAPSHOT</version>
- <scope>runtime</scope>
- </dependency>
-
- <dependency>
- <groupId>org.apache.tuscany.sca</groupId>
- <artifactId>tuscany-host-tomcat</artifactId>
- <version>1.4-SNAPSHOT</version>
- <scope>runtime</scope>
- </dependency>
-
- <dependency>
- <groupId>org.apache.tuscany.sca</groupId>
- <artifactId>tuscany-implementation-spring</artifactId>
- <version>1.4-SNAPSHOT</version>
- <scope>runtime</scope>
- </dependency>
-
- <dependency>
- <groupId>org.apache.tuscany.sca</groupId>
- <artifactId>tuscany-databinding-sdo</artifactId>
- <version>1.4-SNAPSHOT</version>
- <scope>compile</scope>
- </dependency>
-
- <dependency>
- <groupId>org.apache.tuscany.sdo</groupId>
- <artifactId>tuscany-sdo-impl</artifactId>
- <version>1.1.1</version>
- <scope>compile</scope>
- </dependency>
-
- <dependency>
- <groupId>org.apache.tuscany.das</groupId>
- <artifactId>tuscany-das-rdb</artifactId>
- <version>1.0-SNAPSHOT</version>
- <scope>compile</scope>
- </dependency>
-
- <dependency>
- <groupId>org.apache.derby</groupId>
- <artifactId>derby</artifactId>
- <version>10.1.2.1</version>
- <scope>test</scope>
- </dependency>
-
- <dependency>
- <groupId>junit</groupId>
- <artifactId>junit</artifactId>
- <version>4.2</version>
- <scope>test</scope>
- </dependency>
-
- </dependencies>
-
- <build>
- <plugins>
- <plugin>
- <groupId>org.codehaus.mojo</groupId>
- <artifactId>build-helper-maven-plugin</artifactId>
- <version>1.0</version>
- <executions>
- <execution>
- <id>add-source</id>
- <phase>generate-sources</phase>
- <goals>
- <goal>add-test-source</goal>
- </goals>
- <configuration>
- <sources>
- <source>target/sdo-source</source>
- </sources>
- </configuration>
- </execution>
- </executions>
- </plugin>
-
- <plugin>
- <groupId>org.apache.tuscany.sdo</groupId>
- <artifactId>tuscany-sdo-plugin</artifactId>
- <version>1.1.1</version>
- <executions>
- <execution>
- <id>config</id>
- <configuration>
- <schemaFile>${basedir}/src/main/resources/sdo-types.xsd</schemaFile>
- <noUnsettable>true</noUnsettable>
- </configuration>
- <goals>
- <goal>generate</goal>
- </goals>
- </execution>
- </executions>
- </plugin>
-
- <plugin>
- <groupId>org.codehaus.mojo</groupId>
- <artifactId>sql-maven-plugin</artifactId>
- <!-- 1.1 due to MOJO-619 -->
- <version>1.1-SNAPSHOT</version>
-
- <dependencies>
- <dependency>
- <groupId>org.apache.derby</groupId>
- <artifactId>derby</artifactId>
- <version>10.1.2.1</version>
- </dependency>
- </dependencies>
-
- <executions>
- <execution>
- <id>create-db</id>
- <phase>generate-resources</phase>
- <goals>
- <goal>execute</goal>
- </goals>
- <configuration>
- <driver>org.apache.derby.jdbc.EmbeddedDriver</driver>
- <url>jdbc:derby:${pom.basedir}/target/organization_db;create=true</url>
- <autocommit>true</autocommit>
- <onError>continue</onError>
- <onConnectionError>skip</onConnectionError>
- <delimiter>;</delimiter>
- <srcFiles>
- <srcFile>${pom.basedir}/organization.sql</srcFile>
- </srcFiles>
- </configuration>
- </execution>
-
- <!-- Shutdown DB in order to be able to run unit tests -->
- <execution>
- <id>shutdown-database-sothat-test-can-run</id>
- <phase>process-test-resources</phase>
- <goals>
- <goal>execute</goal>
- </goals>
- <configuration>
- <driver>org.apache.derby.jdbc.EmbeddedDriver</driver>
- <url>jdbc:derby:${pom.basedir}/target/organization_db;shutdown=true</url>
- <skipOnConnectionError>true</skipOnConnectionError>
- </configuration>
- </execution>
- </executions>
- </plugin>
- </plugins>
- </build>
-</project>
diff --git a/sandbox/lresende/sca/samples/organization-das/src/main/java/organization/das/OrganizationDataService.java b/sandbox/lresende/sca/samples/organization-das/src/main/java/organization/das/OrganizationDataService.java
deleted file mode 100644
index af71558b14..0000000000
--- a/sandbox/lresende/sca/samples/organization-das/src/main/java/organization/das/OrganizationDataService.java
+++ /dev/null
@@ -1,31 +0,0 @@
-/*
- * 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 organization.das;
-
-import org.soa.types.SchemaInfoType;
-
-public interface OrganizationDataService {
-
- public commonj.sdo.DataObject findOrganizationBugTwo(java.lang.String id, SchemaInfoType schemaInfo);
-
- public commonj.sdo.DataObject findOrganizationBugOne(java.lang.String id, SchemaInfoType schemaInfo);
-
- public void updateOrganization(commonj.sdo.DataObject organization, SchemaInfoType schemaInfo);
-}
diff --git a/sandbox/lresende/sca/samples/organization-das/src/main/java/organization/das/OrganizationDataServiceImpl.java b/sandbox/lresende/sca/samples/organization-das/src/main/java/organization/das/OrganizationDataServiceImpl.java
deleted file mode 100644
index 2f99dc84f5..0000000000
--- a/sandbox/lresende/sca/samples/organization-das/src/main/java/organization/das/OrganizationDataServiceImpl.java
+++ /dev/null
@@ -1,89 +0,0 @@
-/*
- * 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 organization.das;
-
-import java.io.InputStream;
-
-import org.apache.tuscany.das.rdb.Command;
-import org.apache.tuscany.das.rdb.DAS;
-import org.soa.types.SchemaInfoType;
-
-import util.ConnectionHelper;
-
-import commonj.sdo.DataObject;
-
-
-public class OrganizationDataServiceImpl implements OrganizationDataService {
-
-
- public DataObject findOrganizationBugTwo(String id, SchemaInfoType schemaInfo) {
- DataObject root = null;
- InputStream in = getClass().getClassLoader().getResourceAsStream("organizationConfiguration.xml");
-
- java.sql.Connection conn = ConnectionHelper.getConnection(schemaInfo);
-
- DAS das = DAS.FACTORY.createDAS(in, conn);
- Command read = das.getCommand("getAccountByID");
- read.setParameter(1, Integer.valueOf(id));
-
- root = read.executeQuery();
-
- // Testing the root datagraph after returning to test runner.
-
- return root;
- }
-
- public DataObject findOrganizationBugOne(String id, SchemaInfoType schemaInfo) {
- DataObject root = null;
- InputStream in = getClass().getClassLoader().getResourceAsStream("organizationConfiguration.xml");
-
- java.sql.Connection conn = ConnectionHelper.getConnection(schemaInfo);
-
- DAS das = DAS.FACTORY.createDAS(in, conn);
- Command read = das.getCommand("getAccountByID");
- read.setParameter(1, Integer.valueOf(id));
-
- root = read.executeQuery();
-
- // This is just testing to see if the call to das.applyChanges works
- // This doesn't work
-
- DataObject account = root.getDataObject("ACCOUNT[1]");
- account.set("ACCOUNT_NAME", "TestNode2");
- System.out.println("findOrganization data graph -> " + root.getDataGraph());
- System.out.println("findOrganization data graph root -> " + root.getDataGraph().getRootObject());
-
- das.applyChanges(root);
-
- return root;
- }
-
- public void updateOrganization(DataObject organization, SchemaInfoType schemaInfo) {
- InputStream in = getClass().getClassLoader().getResourceAsStream("organizationConfiguration.xml");
-
- java.sql.Connection conn = ConnectionHelper.getConnection(schemaInfo);
-
- DAS das = DAS.FACTORY.createDAS(in, conn);
- try {
- das.applyChanges(organization);
- } catch (Exception e) {
- e.printStackTrace();
- }
- }
-}
diff --git a/sandbox/lresende/sca/samples/organization-das/src/main/java/organization/services/OrganizationService.java b/sandbox/lresende/sca/samples/organization-das/src/main/java/organization/services/OrganizationService.java
deleted file mode 100644
index d821da47e5..0000000000
--- a/sandbox/lresende/sca/samples/organization-das/src/main/java/organization/services/OrganizationService.java
+++ /dev/null
@@ -1,33 +0,0 @@
-/*
- * 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 organization.services;
-
-import org.soa.types.SchemaInfoType;
-
-import commonj.sdo.DataObject;
-
-public interface OrganizationService {
-
- public DataObject findOrganizationBugTwo(String id, SchemaInfoType schemaInfo);
-
- public DataObject findOrganizationBugOne(String id, SchemaInfoType schemaInfo);
-
- public void updateOrganization(DataObject organization, SchemaInfoType schemaInfo);
-}
diff --git a/sandbox/lresende/sca/samples/organization-das/src/main/java/organization/services/OrganizationServiceImpl.java b/sandbox/lresende/sca/samples/organization-das/src/main/java/organization/services/OrganizationServiceImpl.java
deleted file mode 100644
index fe977aff55..0000000000
--- a/sandbox/lresende/sca/samples/organization-das/src/main/java/organization/services/OrganizationServiceImpl.java
+++ /dev/null
@@ -1,53 +0,0 @@
-/*
- * 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 organization.services;
-
-import org.osoa.sca.annotations.Service;
-import org.soa.types.SchemaInfoType;
-
-import organization.das.OrganizationDataService;
-
-import commonj.sdo.DataObject;
-
-@Service(OrganizationService.class)
-public class OrganizationServiceImpl implements OrganizationService {
-
- private OrganizationDataService organizationDataService;
-
- public OrganizationDataService getOrganizationDataService() {
- return organizationDataService;
- }
-
- public void setOrganizationDataService(OrganizationDataService organizationDataService) {
- this.organizationDataService = organizationDataService;
- }
-
- public DataObject findOrganizationBugTwo(String id, SchemaInfoType schemaInfo) {
- return organizationDataService.findOrganizationBugTwo(id, schemaInfo);
- }
-
- public DataObject findOrganizationBugOne(String id, SchemaInfoType schemaInfo) {
- return organizationDataService.findOrganizationBugOne(id, schemaInfo);
- }
-
- public void updateOrganization(DataObject organization, SchemaInfoType schemaInfo) {
- organizationDataService.updateOrganization(organization, schemaInfo);
- }
-}
diff --git a/sandbox/lresende/sca/samples/organization-das/src/main/java/util/ConnectionHelper.java b/sandbox/lresende/sca/samples/organization-das/src/main/java/util/ConnectionHelper.java
deleted file mode 100644
index 43903b3a11..0000000000
--- a/sandbox/lresende/sca/samples/organization-das/src/main/java/util/ConnectionHelper.java
+++ /dev/null
@@ -1,28 +0,0 @@
-package util;
-
-import java.sql.Connection;
-import java.sql.DriverManager;
-
-import org.soa.types.SchemaInfoType;
-
-public class ConnectionHelper {
- public static java.sql.Connection getConnection(SchemaInfoType schemaInfo)
- {
- Connection conn = null;
-
- // schemaInfo should be your SID. Something like xe (for Oracle Personal Edition)
- String url = "jdbc:derby:target/organization_db; create = true";
- String driver = "org.apache.derby.jdbc.EmbeddedDriver";
-
- try {
- Class.forName(driver);
- conn = DriverManager.getConnection(url, schemaInfo.getUSERNAME(), schemaInfo.getPASSWORD());
- conn.setAutoCommit(false);
- }
- catch (Exception e) {
- e.printStackTrace();
- }
-
- return conn;
- }
-}
diff --git a/sandbox/lresende/sca/samples/organization-das/src/main/resources/organization-spring-context.xml b/sandbox/lresende/sca/samples/organization-das/src/main/resources/organization-spring-context.xml
deleted file mode 100644
index c814afe28b..0000000000
--- a/sandbox/lresende/sca/samples/organization-das/src/main/resources/organization-spring-context.xml
+++ /dev/null
@@ -1,20 +0,0 @@
-<?xml version="1.0" encoding="UTF-8"?>
-
-<beans xmlns="http://www.springframework.org/schema/beans"
- xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
- xmlns:sca="http://www.springframework.org/schema/sca"
- xsi:schemaLocation="
- http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
- http://www.springframework.org/schema/sca http://www.springframework.org/schema/sca/spring-sca.xsd">
-
- <sca:service name="OrganizationService"
- type="organization.services.OrganizationService" target="OrganizationServiceBean"/>
-
- <bean id="OrganizationServiceBean" class="organization.services.OrganizationServiceImpl">
- <property name="organizationDataService" ref="OrganizationDataServiceBean"/>
- </bean>
-
- <bean id="OrganizationDataServiceBean" class="organization.das.OrganizationDataServiceImpl">
-
- </bean>
-</beans>
diff --git a/sandbox/lresende/sca/samples/organization-das/src/main/resources/organization.composite b/sandbox/lresende/sca/samples/organization-das/src/main/resources/organization.composite
deleted file mode 100644
index 0113ccf8a0..0000000000
--- a/sandbox/lresende/sca/samples/organization-das/src/main/resources/organization.composite
+++ /dev/null
@@ -1,22 +0,0 @@
-<?xml version="1.0" encoding="UTF-8"?>
-
-<composite xmlns="http://www.osoa.org/xmlns/sca/1.0"
- targetNamespace="http://org.soa.services"
- xmlns:soa="http://org.soa.services"
- name="Organization-Service-Composite">
-
- <service name="OrganizationService" promote="OrganizationServiceComponent/OrganizationService">
- <binding.ws/>
- </service>
-
- <component name="OrganizationServiceComponent">
- <implementation.spring location="organization-spring-context.xml"/>
- <service name="OrganizationService"/>
- </component>
-
- <component name="OrganizationDataServiceComponent">
- <implementation.spring location="organization-spring-context.xml"/>
- </component>
-
-
-</composite>
diff --git a/sandbox/lresende/sca/samples/organization-das/src/main/resources/organizationConfiguration.xml b/sandbox/lresende/sca/samples/organization-das/src/main/resources/organizationConfiguration.xml
deleted file mode 100644
index 2104c37404..0000000000
--- a/sandbox/lresende/sca/samples/organization-das/src/main/resources/organizationConfiguration.xml
+++ /dev/null
@@ -1,87 +0,0 @@
-<?xml version="1.0" encoding="ASCII"?>
-<Config xmlns="http:///org.apache.tuscany.das.rdb/config.xsd">
-
- <!--ConnectionInfo>
- <ConnectionProperties
- driverClass="org.apache.derby.jdbc.EmbeddedDriver"
- databaseURL="jdbc:derby:target/organization_db; create = true"
- loginTimeout="600000"/>
- </ConnectionInfo-->
-
-
- <Command name="getAllOrganizations" SQL="select * from ORGANIZATIONTYPELIST" kind="Select">
- <ResultDescriptor columnName="ORGANIZATIONTYPEID" tableName="ORGANIZATIONTYPELIST" columnType="commonj.sdo.IntObject"/>
- <ResultDescriptor columnName="CODE" tableName="ORGANIZATIONTYPELIST" columnType="commonj.sdo.String"/>
- <ResultDescriptor columnName="DISPLAYVALUE" tableName="ORGANIZATIONTYPELIST" columnType="commonj.sdo.String"/>
- <ResultDescriptor columnName="DESCRIPTION" tableName="ORGANIZATIONTYPELIST" columnType="commonj.sdo.String"/>
- <ResultDescriptor columnName="ISEDITABLE" tableName="ORGANIZATIONTYPELIST" columnType="commonj.sdo.Type"/>
- </Command>
-
- <Command name="findOrganization" SQL="select * from ORGANIZATIONTYPELIST where ORGANIZATIONTYPEID = ? " kind="Select">
- <ResultDescriptor columnName="ORGANIZATIONTYPEID" tableName="ORGANIZATIONTYPELIST" columnType="commonj.sdo.IntObject"/>
- <ResultDescriptor columnName="CODE" tableName="ORGANIZATIONTYPELIST" columnType="commonj.sdo.String"/>
- <ResultDescriptor columnName="DISPLAYVALUE" tableName="ORGANIZATIONTYPELIST" columnType="commonj.sdo.String"/>
- <ResultDescriptor columnName="DESCRIPTION" tableName="ORGANIZATIONTYPELIST" columnType="commonj.sdo.String"/>
- <ResultDescriptor columnName="ISEDITABLE" tableName="ORGANIZATIONTYPELIST" columnType="commonj.sdo.Integer"/>
- </Command>
-
- <Command name="getAllAccounts" SQL="select * from ACCOUNT" kind="Select">
- <ResultDescriptor columnName="ACCOUNT_ID" tableName="ACCOUNT" columnType="commonj.sdo.IntObject"/>
- <ResultDescriptor columnName="ACCOUNTTYPE_CD" tableName="ACCOUNT" columnType="commonj.sdo.String"/>
- <ResultDescriptor columnName="ACCOUNT_NAME" tableName="ACCOUNT" columnType="commonj.sdo.String"/>
- <ResultDescriptor columnName="WEB_SITE_ADDRESS" tableName="ACCOUNT" columnType="commonj.sdo.String"/>
- <ResultDescriptor columnName="STREET_ADDRESS_1" tableName="ACCOUNT" columnType="commonj.sdo.String"/>
- <ResultDescriptor columnName="STREET_ADDRESS_2" tableName="ACCOUNT" columnType="commonj.sdo.String"/>
- <ResultDescriptor columnName="STREET_ADDRESS_3" tableName="ACCOUNT" columnType="commonj.sdo.String"/>
- <ResultDescriptor columnName="CITY" tableName="ACCOUNT" columnType="commonj.sdo.String"/>
- <ResultDescriptor columnName="STATE_CD" tableName="ACCOUNT" columnType="commonj.sdo.String"/>
- <ResultDescriptor columnName="POSTAL_CD" tableName="ACCOUNT" columnType="commonj.sdo.String"/>
- <ResultDescriptor columnName="COUNTRY_CD" tableName="ACCOUNT" columnType="commonj.sdo.String"/>
- <ResultDescriptor columnName="PHONE_NUMBER" tableName="ACCOUNT" columnType="commonj.sdo.String"/>
- <ResultDescriptor columnName="FAX_NUMBER" tableName="ACCOUNT" columnType="commonj.sdo.String"/>
- <ResultDescriptor columnName="NOTE" tableName="ACCOUNT" columnType="commonj.sdo.String"/>
- </Command>
-
- <Command name="getAccountByID" SQL="select * from ACCOUNT where ACCOUNT_ID = ?" kind="Select">
- <ResultDescriptor columnName="ACCOUNT_ID" tableName="ACCOUNT" columnType="commonj.sdo.IntObject"/>
- <ResultDescriptor columnName="ACCOUNTTYPE_CD" tableName="ACCOUNT" columnType="commonj.sdo.String"/>
- <ResultDescriptor columnName="ACCOUNT_NAME" tableName="ACCOUNT" columnType="commonj.sdo.String"/>
- <ResultDescriptor columnName="WEB_SITE_ADDRESS" tableName="ACCOUNT" columnType="commonj.sdo.String"/>
- <ResultDescriptor columnName="STREET_ADDRESS_1" tableName="ACCOUNT" columnType="commonj.sdo.String"/>
- <ResultDescriptor columnName="STREET_ADDRESS_2" tableName="ACCOUNT" columnType="commonj.sdo.String"/>
- <ResultDescriptor columnName="STREET_ADDRESS_3" tableName="ACCOUNT" columnType="commonj.sdo.String"/>
- <ResultDescriptor columnName="CITY" tableName="ACCOUNT" columnType="commonj.sdo.String"/>
- <ResultDescriptor columnName="STATE_CD" tableName="ACCOUNT" columnType="commonj.sdo.String"/>
- <ResultDescriptor columnName="POSTAL_CD" tableName="ACCOUNT" columnType="commonj.sdo.String"/>
- <ResultDescriptor columnName="COUNTRY_CD" tableName="ACCOUNT" columnType="commonj.sdo.String"/>
- <ResultDescriptor columnName="PHONE_NUMBER" tableName="ACCOUNT" columnType="commonj.sdo.String"/>
- <ResultDescriptor columnName="FAX_NUMBER" tableName="ACCOUNT" columnType="commonj.sdo.String"/>
- <ResultDescriptor columnName="NOTE" tableName="ACCOUNT" columnType="commonj.sdo.String"/>
- </Command>
-
- <Table tableName="ORGANIZATIONTYPELIST">
- <Column columnName="ORGANIZATIONTYPEID" primaryKey="true" generated="true"/>
- <Column columnName="CODE" />
- <Column columnName="DISPLAYVALUE" />
- <Column columnName="DESCRIPTION" />
- <Column columnName="ISEDITABLE" />
- </Table>
-
- <Table tableName="ACCOUNT">
- <Column columnName="ACCOUNT_ID" primaryKey="true" generated="true"/>
- <Column columnName="ACCOUNTTYPE_CD" />
- <Column columnName="ACCOUNT_NAME" />
- <Column columnName="WEB_SITE_ADDRESS" />
- <Column columnName="STREET_ADDRESS_1" />
- <Column columnName="STREET_ADDRESS_2" />
- <Column columnName="STREET_ADDRESS_3" />
- <Column columnName="CITY" />
- <Column columnName="STATE_CD" />
- <Column columnName="POSTAL_CD" />
- <Column columnName="COUNTRY_CD" />
- <Column columnName="PHONE_NUMBER" />
- <Column columnName="FAX_NUMBER" />
- <Column columnName="NOTE" />
- </Table>
-
-</Config> \ No newline at end of file
diff --git a/sandbox/lresende/sca/samples/organization-das/src/main/resources/sdo-types.xsd b/sandbox/lresende/sca/samples/organization-das/src/main/resources/sdo-types.xsd
deleted file mode 100644
index 0b287bda24..0000000000
--- a/sandbox/lresende/sca/samples/organization-das/src/main/resources/sdo-types.xsd
+++ /dev/null
@@ -1,66 +0,0 @@
-
-<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
- targetNamespace="http://org/soa/types"
- xmlns:tns="http://org/soa/types"
- elementFormDefault="qualified">
-
- <xsd:element name="Organization" type="OrganizationType"/>
-
- <xsd:complexType name="OrganizationType">
- <xsd:sequence>
- <xsd:element name="ORGANIZATIONTYPEID" type="xsd:int" />
- <xsd:element name="CODE" type="xsd:string" />
- <xsd:element name="DISPLAYVALUE" type="xsd:string" />
- <xsd:element name="DESCRIPTION" type="xsd:string" />
- <xsd:element name="ISEDITABLE" type="xsd:int" />
- </xsd:sequence>
- </xsd:complexType>
-
- <xsd:element name="Address" type="AddressType"/>
-
- <xsd:complexType name="AddressType">
- <xsd:sequence>
- <xsd:element name="ADDRESS_ID" type="xsd:int" />
- <xsd:element name="ADDRESSTYPE_CD" type="xsd:string" />
- <xsd:element name="STREET_ADDRESS_1" type="xsd:string" />
- <xsd:element name="STREET_ADDRESS_2" type="xsd:string" />
- <xsd:element name="STREET_ADDRESS_3" type="xsd:string" />
- <xsd:element name="CITY" type="xsd:string" />
- <xsd:element name="STATE_CD" type="xsd:string" />
- <xsd:element name="POSTAL_CD" type="xsd:string" />
- <xsd:element name="COUNTRY_CD" type="xsd:string" />
- </xsd:sequence>
- </xsd:complexType>
-
- <xsd:element name="SchemaInfo" type="SchemaInfoType"/>
-
- <xsd:complexType name="SchemaInfoType">
- <xsd:sequence>
- <xsd:element name="USERNAME" type="xsd:string" />
- <xsd:element name="PASSWORD" type="xsd:string" />
- <xsd:element name="SCHEMA" type="xsd:string" />
- </xsd:sequence>
- </xsd:complexType>
-
- <xsd:element name="Account" type="AccountType"/>
-
- <xsd:complexType name="AccountType">
- <xsd:sequence>
- <xsd:element name="ACCOUNT_ID" type="xsd:string"/>
- <xsd:element name="ACCOUNTTYPE_CD" type="xsd:string"/>
- <xsd:element name="ACCOUNT_NAME" type="xsd:string"/>
- <xsd:element name="WEB_SITE_ADDRESS" type="xsd:string"/>
- <xsd:element name="STREET_ADDRESS_1" type="xsd:string"/>
- <xsd:element name="STREET_ADDRESS_2" type="xsd:string"/>
- <xsd:element name="STREET_ADDRESS_3" type="xsd:string"/>
- <xsd:element name="CITY" type="xsd:string"/>
- <xsd:element name="STATE_CD" type="xsd:string"/>
- <xsd:element name="POSTAL_CD" type="xsd:string"/>
- <xsd:element name="COUNTRY_CD" type="xsd:string"/>
- <xsd:element name="PHONE_NUMBER" type="xsd:string"/>
- <xsd:element name="FAX_NUMBER" type="xsd:string"/>
- <xsd:element name="NOTE" type="xsd:string"/>
- </xsd:sequence>
- </xsd:complexType>
-
-</xsd:schema> \ No newline at end of file
diff --git a/sandbox/lresende/sca/samples/organization-das/src/test/java/organization/OrganizationTestCase.java b/sandbox/lresende/sca/samples/organization-das/src/test/java/organization/OrganizationTestCase.java
deleted file mode 100644
index 33810f4325..0000000000
--- a/sandbox/lresende/sca/samples/organization-das/src/test/java/organization/OrganizationTestCase.java
+++ /dev/null
@@ -1,141 +0,0 @@
-/*
- * 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 organization;
-
-import java.io.InputStream;
-import java.util.Random;
-
-import org.apache.tuscany.das.rdb.Command;
-import org.apache.tuscany.das.rdb.DAS;
-import org.apache.tuscany.sca.host.embedded.SCADomain;
-import org.junit.Test;
-import org.soa.types.SchemaInfoType;
-import org.soa.types.TypesFactory;
-import organization.services.OrganizationService;
-
-import util.ConnectionHelper;
-
-import commonj.sdo.DataObject;
-
-public class OrganizationTestCase {
-
- private static final String id = "1";
-
- /**
- * This represents BUG_ONE from TUSCANY-2525
- */
- @Test
- public void testRetrieveOrganizationDAS() {
- DataObject root = null;
- InputStream in = getClass().getClassLoader().getResourceAsStream("organizationConfiguration.xml");
-
- // Need to put in valid values for your DB
- SchemaInfoType schemaInfo = TypesFactory.INSTANCE.createSchemaInfoType();
- schemaInfo.setPASSWORD("");
- schemaInfo.setSCHEMA("");
- schemaInfo.setUSERNAME("");
-
- java.sql.Connection conn = ConnectionHelper.getConnection(schemaInfo);
-
- DAS das = DAS.FACTORY.createDAS(in, conn);
- Command read = das.getCommand("getAccountByID");
- read.setParameter(1, Integer.valueOf(id));
-
- root = read.executeQuery();
-
- // This is just testing to see if the call to das.applyChanges works
- // This doesn't work
-
- Random generator = new Random();
- String accountName = "ACCOUNT_" + Integer.toString(generator.nextInt());
-
- DataObject account = root.getDataObject("ACCOUNT[1]");
- account.set("ACCOUNT_NAME", accountName);
- System.out.println("findOrganization data graph -> " + root.getDataGraph());
- System.out.println("findOrganization data graph root -> " + root.getDataGraph().getRootObject());
-
- das.applyChanges(root);
-
- root = read.executeQuery();
-
- DataObject updatedAccount = root.getDataObject("ACCOUNT[1]");
- org.junit.Assert.assertEquals(accountName, updatedAccount.get("ACCOUNT_NAME"));
-
- }
-
- @Test
- public void testRetrieveOrganizationAndSaveDAS() {
- DataObject root = null;
- InputStream in = getClass().getClassLoader().getResourceAsStream("organizationConfiguration.xml");
-
- // Need to put in valid values for your DB
- SchemaInfoType schemaInfo = TypesFactory.INSTANCE.createSchemaInfoType();
- schemaInfo.setPASSWORD("");
- schemaInfo.setSCHEMA("");
- schemaInfo.setUSERNAME("");
-
- java.sql.Connection conn = ConnectionHelper.getConnection(schemaInfo);
-
- DAS das = DAS.FACTORY.createDAS(in, conn);
- Command read = das.getCommand("getAccountByID");
- read.setParameter(1, Integer.valueOf(id));
-
- root = read.executeQuery();
-
- das.applyChanges(root);
- }
-
- /**
- * This represents BUG_TWO from TUSCANY-2525
- */
- @Test
- public void testRetrieveOrganizationSCA() {
-
- System.out.println("\n1. Organization-Service-Composite OrganizationClientRunner ");
-
- SCADomain scaDomain = SCADomain.newInstance("organization.composite");
-
- OrganizationService organizationService =
- scaDomain.getService(OrganizationService.class, "OrganizationServiceComponent");
-
- // Need to put in valid values for your DB
- SchemaInfoType schemaInfo = TypesFactory.INSTANCE.createSchemaInfoType();
- schemaInfo.setPASSWORD("");
- schemaInfo.setSCHEMA("");
- schemaInfo.setUSERNAME("");
-
- // This doesn't work. Just retreive account, make a change, then apply changes
- DataObject root = organizationService.findOrganizationBugOne(id, schemaInfo);
- DataObject account = root.getDataObject("ACCOUNT[1]");
-
- org.junit.Assert.assertEquals("TestNode2", account.get("ACCOUNT_NAME"));
-
-
- // This doesn't work either. The root datagraph is null
- // If you call das.applyChanges for a dataObject that has null as the dataGraph,
- // it hurls.
- DataObject rootOne = organizationService.findOrganizationBugTwo(id, schemaInfo);
- ////account = root.getDataObject("ACCOUNT[1]");
- ////account.set("ACCOUNT_NAME", "something");
- System.out.println("rootOne dataGraph -> " + rootOne.getDataGraph());
- organizationService.updateOrganization(rootOne, schemaInfo);
-
- scaDomain.close();
- }
-}