summaryrefslogtreecommitdiffstats
path: root/branches/sca-java-1.x/tutorials/store/www-services/catalog-amazon/store-db
diff options
context:
space:
mode:
authorantelder <antelder@13f79535-47bb-0310-9956-ffa450edef68>2009-08-08 10:03:33 +0000
committerantelder <antelder@13f79535-47bb-0310-9956-ffa450edef68>2009-08-08 10:03:33 +0000
commit2691aa6986e852c4dea45a26411335a65538a9be (patch)
tree5c44071b7577c96e4476ef144cf4cbf930e324bd /branches/sca-java-1.x/tutorials/store/www-services/catalog-amazon/store-db
parent8f0d21f91e640f972e4f4203db8b590b664f3b1f (diff)
Move www-services to sandbox area until the license of the Amazon jars is clarified
git-svn-id: http://svn.us.apache.org/repos/asf/tuscany@802332 13f79535-47bb-0310-9956-ffa450edef68
Diffstat (limited to 'branches/sca-java-1.x/tutorials/store/www-services/catalog-amazon/store-db')
-rw-r--r--branches/sca-java-1.x/tutorials/store/www-services/catalog-amazon/store-db/pom.xml149
-rw-r--r--branches/sca-java-1.x/tutorials/store/www-services/catalog-amazon/store-db/src/main/java/launch/LaunchCatalog.java34
-rw-r--r--branches/sca-java-1.x/tutorials/store/www-services/catalog-amazon/store-db/src/main/java/services/Catalog.java27
-rw-r--r--branches/sca-java-1.x/tutorials/store/www-services/catalog-amazon/store-db/src/main/java/services/CatalogImpl.java120
-rw-r--r--branches/sca-java-1.x/tutorials/store/www-services/catalog-amazon/store-db/src/main/java/services/CurrencyConverter.java29
-rw-r--r--branches/sca-java-1.x/tutorials/store/www-services/catalog-amazon/store-db/src/main/java/util/CreateDB.java79
-rw-r--r--branches/sca-java-1.x/tutorials/store/www-services/catalog-amazon/store-db/src/main/resources/store-catalog-database.composite31
-rw-r--r--branches/sca-java-1.x/tutorials/store/www-services/catalog-amazon/store-db/store.sql37
8 files changed, 0 insertions, 506 deletions
diff --git a/branches/sca-java-1.x/tutorials/store/www-services/catalog-amazon/store-db/pom.xml b/branches/sca-java-1.x/tutorials/store/www-services/catalog-amazon/store-db/pom.xml
deleted file mode 100644
index 6e2691185a..0000000000
--- a/branches/sca-java-1.x/tutorials/store/www-services/catalog-amazon/store-db/pom.xml
+++ /dev/null
@@ -1,149 +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-tutorial-store</artifactId>
- <version>1.6-SNAPSHOT</version>
- <relativePath>../pom.xml</relativePath>
- </parent>
- <artifactId>tutorial-store-db</artifactId>
- <name>Apache Tuscany SCA Store Tutorial Catalog Database</name>
-
- <repositories>
- <repository>
- <id>apache.incubator</id>
- <url>http://people.apache.org/repo/m2-incubating-repository</url>
- </repository>
- </repositories>
-
- <dependencies>
- <dependency>
- <groupId>org.apache.tuscany.sca</groupId>
- <artifactId>tuscany-host-jetty</artifactId>
- <version>1.6-SNAPSHOT</version>
- <scope>runtime</scope>
- </dependency>
-
- <dependency>
- <groupId>org.apache.tuscany.sca</groupId>
- <artifactId>tutorial-assets</artifactId>
- <version>1.6-SNAPSHOT</version>
- </dependency>
-
- <dependency>
- <groupId>org.apache.tuscany.sca</groupId>
- <artifactId>tuscany-node-api</artifactId>
- <version>1.6-SNAPSHOT</version>
- </dependency>
-
- <dependency>
- <groupId>org.apache.tuscany.sca</groupId>
- <artifactId>tuscany-node-impl</artifactId>
- <version>1.6-SNAPSHOT</version>
- <scope>runtime</scope>
- </dependency>
-
- <dependency>
- <groupId>org.apache.tuscany.sca</groupId>
- <artifactId>tuscany-implementation-java-runtime</artifactId>
- <version>1.6-SNAPSHOT</version>
- <scope>runtime</scope>
- </dependency>
-
- <dependency>
- <groupId>org.apache.tuscany.sca</groupId>
- <artifactId>tuscany-binding-sca-axis2</artifactId>
- <version>1.6-SNAPSHOT</version>
- </dependency>
-
- <dependency>
- <groupId>org.apache.derby</groupId>
- <artifactId>derby</artifactId>
- <version>10.3.1.4</version>
- </dependency>
-
- <dependency>
- <groupId>junit</groupId>
- <artifactId>junit</artifactId>
- <version>4.2</version>
- <scope>test</scope>
- </dependency>
-
- </dependencies>
-
- <build>
- <finalName>${artifactId}</finalName>
- <plugins>
- <plugin>
- <groupId>org.apache.tuscany.sca</groupId>
- <artifactId>tuscany-maven-ant-generator</artifactId>
- <version>1.6-SNAPSHOT</version>
- <executions>
- <execution>
- <configuration>
- <mainClass>launch.LaunchCatalog</mainClass>
- </configuration>
- <goals>
- <goal>generate</goal>
- </goals>
- </execution>
- </executions>
- </plugin>
-
- <plugin>
- <groupId>org.codehaus.mojo</groupId>
- <artifactId>sql-maven-plugin</artifactId>
- <version>1.3</version>
-
- <dependencies>
- <dependency>
- <groupId>org.apache.derby</groupId>
- <artifactId>derby</artifactId>
- <version>10.3.1.4</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:target/store_db;create=true</url>
- <autocommit>true</autocommit>
- <onError>continue</onError>
- <delimiter>;</delimiter>
- <srcFiles>
- <srcFile>${pom.basedir}/store.sql</srcFile>
- </srcFiles>
- </configuration>
- </execution>
- </executions>
- </plugin>
-
- </plugins>
- </build>
-
-</project>
diff --git a/branches/sca-java-1.x/tutorials/store/www-services/catalog-amazon/store-db/src/main/java/launch/LaunchCatalog.java b/branches/sca-java-1.x/tutorials/store/www-services/catalog-amazon/store-db/src/main/java/launch/LaunchCatalog.java
deleted file mode 100644
index c46845722c..0000000000
--- a/branches/sca-java-1.x/tutorials/store/www-services/catalog-amazon/store-db/src/main/java/launch/LaunchCatalog.java
+++ /dev/null
@@ -1,34 +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 launch;
-
-import org.apache.tuscany.sca.host.embedded.SCADomain;
-
-public class LaunchCatalog {
- public static void main(String[] args) throws Exception {
- System.out.println("Starting ...");
- SCADomain scaDomain = SCADomain.newInstance("store-catalog-database.composite");
- System.out.println("store-catalog-database.composite ready for big business !!!");
- System.in.read();
- System.out.println("Stopping ...");
- scaDomain.close();
- System.out.println();
- }
-}
diff --git a/branches/sca-java-1.x/tutorials/store/www-services/catalog-amazon/store-db/src/main/java/services/Catalog.java b/branches/sca-java-1.x/tutorials/store/www-services/catalog-amazon/store-db/src/main/java/services/Catalog.java
deleted file mode 100644
index 9f784b0848..0000000000
--- a/branches/sca-java-1.x/tutorials/store/www-services/catalog-amazon/store-db/src/main/java/services/Catalog.java
+++ /dev/null
@@ -1,27 +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 services;
-
-import org.osoa.sca.annotations.Remotable;
-
-@Remotable
-public interface Catalog {
- String[] get();
-}
diff --git a/branches/sca-java-1.x/tutorials/store/www-services/catalog-amazon/store-db/src/main/java/services/CatalogImpl.java b/branches/sca-java-1.x/tutorials/store/www-services/catalog-amazon/store-db/src/main/java/services/CatalogImpl.java
deleted file mode 100644
index c8b3bbf621..0000000000
--- a/branches/sca-java-1.x/tutorials/store/www-services/catalog-amazon/store-db/src/main/java/services/CatalogImpl.java
+++ /dev/null
@@ -1,120 +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 services;
-
-import java.sql.Connection;
-import java.sql.DriverManager;
-import java.sql.PreparedStatement;
-import java.sql.ResultSet;
-import java.sql.SQLException;
-
-import org.osoa.sca.annotations.Property;
-import org.osoa.sca.annotations.Reference;
-
-public class CatalogImpl implements Catalog {
- @Property
- public String currencyCode = "USD";
-
- @Reference
- public CurrencyConverter currencyConverter;
-
- private String currencySymbol;
-
- public String[] get() {
-
- String[] catalogArray = null;
-
- String itemName;
- float itemPrice;
- String itemCurrencyCode;
-
- Connection conn = null;
- PreparedStatement pstmt = null;
- ResultSet rs = null;
-
- currencySymbol = currencyConverter.getCurrencySymbol(currencyCode);
-
- try {
- //initialize driver and register it with DriverManager
- Class.forName("org.apache.derby.jdbc.EmbeddedDriver");
-
- conn = DriverManager.getConnection(
- "jdbc:derby:target/store_db",
- "",
- "");
-
- pstmt = conn.prepareStatement("select * from \"Catalog\"",
- ResultSet.TYPE_SCROLL_INSENSITIVE,
- ResultSet.CONCUR_READ_ONLY);
-
- rs = pstmt.executeQuery();
- rs.last();
-
- catalogArray = new String[rs.getRow()];
-
- do {
- itemName = rs.getString(2);
- itemPrice = rs.getFloat(4);
- itemCurrencyCode = rs.getString(3);
-
- catalogArray[rs.getRow()-1] = new String(itemName+" - "+
- currencySymbol+" "+
- currencyConverter.getConversion(itemCurrencyCode, currencyCode, itemPrice));
-
- } while(rs.previous());
-
- } catch (SQLException ex) {
- ex.printStackTrace();
- }catch (ClassNotFoundException ex) {
- ex.printStackTrace();
- } finally {
- cleanup(conn,pstmt,rs);
- }
-
- return catalogArray;
- }
-
- private void cleanup(Connection conn, PreparedStatement pstmt, ResultSet rs) {
-
- if (rs!=null) {
- try {
- rs.close();
- } catch (SQLException ex) {
- ex.printStackTrace();
- }
- }
-
- if (pstmt!=null) {
- try {
- pstmt.close();
- } catch (SQLException ex) {
- ex.printStackTrace();
- }
- }
-
- if (conn!=null) {
- try {
- conn.close();
- } catch (SQLException ex) {
- ex.printStackTrace();
- }
- }
- }
-}
diff --git a/branches/sca-java-1.x/tutorials/store/www-services/catalog-amazon/store-db/src/main/java/services/CurrencyConverter.java b/branches/sca-java-1.x/tutorials/store/www-services/catalog-amazon/store-db/src/main/java/services/CurrencyConverter.java
deleted file mode 100644
index 8b0f70907d..0000000000
--- a/branches/sca-java-1.x/tutorials/store/www-services/catalog-amazon/store-db/src/main/java/services/CurrencyConverter.java
+++ /dev/null
@@ -1,29 +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 services;
-
-import org.osoa.sca.annotations.Remotable;
-
-@Remotable
-public interface CurrencyConverter {
- public float getConversion(String fromCurrenycCode, String toCurrencyCode, float amount);
-
- public String getCurrencySymbol(String currencyCode);
-}
diff --git a/branches/sca-java-1.x/tutorials/store/www-services/catalog-amazon/store-db/src/main/java/util/CreateDB.java b/branches/sca-java-1.x/tutorials/store/www-services/catalog-amazon/store-db/src/main/java/util/CreateDB.java
deleted file mode 100644
index a4dc2e67e6..0000000000
--- a/branches/sca-java-1.x/tutorials/store/www-services/catalog-amazon/store-db/src/main/java/util/CreateDB.java
+++ /dev/null
@@ -1,79 +0,0 @@
-package util;
-
-
-import java.sql.Connection;
-import java.sql.DriverManager;
-import java.sql.PreparedStatement;
-import java.sql.SQLException;
-
-public class CreateDB {
-
- public static void main(String[] args) {
- System.out.println("Creating database ...");
-
- Connection connection = null;
- PreparedStatement preparedStatement = null;
-
- try {
- //initialize driver and register it with DriverManager
- Class.forName("org.apache.derby.jdbc.EmbeddedDriver");
-
- //connect and create the db if not present
- connection = DriverManager.getConnection(
- "jdbc:derby:target/store_db;create=true",
- "",
- "");
-
-
- try {
- preparedStatement = connection.prepareStatement("DROP TABLE CATALOG");
- preparedStatement.execute();
- }catch(Exception e) {
- //ignore to avoid erros when db is being created from scratch
- }
-
-
- preparedStatement = connection.prepareStatement("CREATE TABLE CATALOG("
- + "id NUMERIC(5 , 0) NOT NULL,"
- + "product_name VARCHAR(30),"
- + "currency_code CHAR(3),"
- + "price REAL,"
- + "primary key (id)"
- + ")");
- preparedStatement.execute();
-
- preparedStatement = connection.prepareStatement("INSERT INTO CATALOG VALUES(0,'Apple', 'USD', 2.99)");
- preparedStatement.execute();
-
- preparedStatement = connection.prepareStatement("INSERT INTO CATALOG VALUES(1,'Orange', 'USD', 3.55)");
- preparedStatement.execute();
-
- preparedStatement = connection.prepareStatement("INSERT INTO CATALOG VALUES(2,'Pear', 'USD', 1.55)");
- preparedStatement.execute();
-
- System.out.println("Done !");
-
- } catch (SQLException ex) {
- ex.printStackTrace();
- }catch (ClassNotFoundException ex) {
- ex.printStackTrace();
- } finally {
- if (preparedStatement!=null) {
- try {
- preparedStatement.close();
- } catch (SQLException ex) {
- ex.printStackTrace();
- }
- }
-
- if (connection!=null) {
- try {
- connection.close();
- } catch (SQLException ex) {
- ex.printStackTrace();
- }
- }
- }
- }
-
-}
diff --git a/branches/sca-java-1.x/tutorials/store/www-services/catalog-amazon/store-db/src/main/resources/store-catalog-database.composite b/branches/sca-java-1.x/tutorials/store/www-services/catalog-amazon/store-db/src/main/resources/store-catalog-database.composite
deleted file mode 100644
index aea8a6972c..0000000000
--- a/branches/sca-java-1.x/tutorials/store/www-services/catalog-amazon/store-db/src/main/resources/store-catalog-database.composite
+++ /dev/null
@@ -1,31 +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.
--->
-<composite xmlns="http://www.osoa.org/xmlns/sca/1.0"
- xmlns:t="http://tuscany.apache.org/xmlns/sca/1.0"
- xmlns:s="http://store"
- name="store-catalog-database">
-
- <component name="Catalog">
- <implementation.java class="services.CatalogImpl"/>
- <property name="currencyCode">USD</property>
- <reference name="currencyConverter" target="CurrencyConverter"/>
- </component>
-
-</composite>
diff --git a/branches/sca-java-1.x/tutorials/store/www-services/catalog-amazon/store-db/store.sql b/branches/sca-java-1.x/tutorials/store/www-services/catalog-amazon/store-db/store.sql
deleted file mode 100644
index 904fab3ce3..0000000000
--- a/branches/sca-java-1.x/tutorials/store/www-services/catalog-amazon/store-db/store.sql
+++ /dev/null
@@ -1,37 +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.
---
-
-DROP TABLE CATALOG;
-
-CREATE TABLE CATALOG(
- id NUMERIC(5 , 0) NOT NULL,
- product_name VARCHAR(30),
- currency_code CHAR(3),
- price REAL,
- primary key (id)
-);
-
-
-
-INSERT INTO CATALOG
- VALUES(0,'Apple', 'USD', 2.99);
-INSERT INTO CATALOG
- VALUES(1,'Orange', 'USD', 3.55);
-INSERT INTO CATALOG
- VALUES(2,'Pear', 'USD', 1.55); \ No newline at end of file