Move Tuscany from Incubator to top level.

git-svn-id: http://svn.us.apache.org/repos/asf/tuscany@668359 13f79535-47bb-0310-9956-ffa450edef68

20 files changed, 3373 insertions, 0 deletions

diff --git a/branches/sca-java-0.99/samples/old/bigbank/account/pom.xml b/branches/sca-java-0.99/samples/old/bigbank/account/pom.xml
new file mode 100644
index 0000000000..991935e07b
--- /dev/null
+++ b/branches/sca-java-0.99/samples/old/bigbank/account/pom.xml
@@ -0,0 +1,178 @@
+<?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.samples.bigbank</groupId>
+        <artifactId>bigbank-scenario</artifactId>
+        <version>0.1-integration-incubating-SNAPSHOT</version>
+    </parent>
+    <modelVersion>4.0.0</modelVersion>
+    <artifactId>sample-bigbank-account</artifactId>
+    <packaging>war</packaging>
+    <name>Tuscany BigBank Account Module</name>
+    <description>BigBank Scenario - Account Management Module</description>
+    <dependencies>
+
+
+        <dependency>
+            <groupId>org.apache.tuscany.sca.kernel</groupId>
+            <artifactId>tuscany-api</artifactId>
+            <version>${scaKernelVersion}</version>
+            <scope>compile</scope>
+        </dependency>
+        <dependency>
+            <groupId>org.apache.tuscany.sca.runtime.webapp</groupId>
+            <artifactId>webapp-api</artifactId>
+            <version>${scaKernelVersion}</version>
+            <scope>runtime</scope>
+        </dependency>
+
+        <!-- java.xml.stream API -->
+        <dependency>
+            <groupId>stax</groupId>
+            <artifactId>stax-api</artifactId>
+            <version>1.0.1</version>
+            <scope>compile</scope>
+        </dependency>
+        <!-- StAX implementation -->
+        <dependency>
+            <groupId>org.codehaus.woodstox</groupId>
+            <artifactId>wstx-asl</artifactId>
+            <version>3.2.0</version>
+            <scope>runtime</scope>
+        </dependency>
+
+
+
+        <dependency>
+            <groupId>org.apache.tuscany.sdo</groupId>
+            <artifactId>tuscany-sdo-impl</artifactId>
+            <version>1.0-incubatingversion>
+            <scope>compile</scope>
+        </dependency>
+
+
+        <dependency>
+            <groupId>org.apache.tuscany.das</groupId>
+            <artifactId>tuscany-das-rdb</artifactId>
+            <version>${dasVersion}</version>
+            <scope>compile</scope>
+        </dependency>
+        <dependency>
+            <groupId>javax.servlet</groupId>
+            <artifactId>servlet-api</artifactId>
+            <version>2.5</version>
+            <scope>provided</scope>
+        </dependency>
+        <dependency>
+            <groupId>org.apache.derby</groupId>
+            <artifactId>derby</artifactId>
+            <version>10.1.2.1</version>
+            <scope>compile</scope>
+        </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.sdo</groupId>
+                <artifactId>tuscany-sdo-plugin</artifactId>
+                <version>1.0-incubating</version>
+                <executions>
+                    <execution>
+                        <configuration>
+                            <!-- schemaFile>${basedir}/src/main/resources/wsdl/AccountService.wsdl</schemaFile -->
+                            <schemaDir>${basedir}/src/main/resources/wsdl</schemaDir>
+                            <noNotification>true</noNotification>
+                            <noContainer>true</noContainer>
+                            <noUnsettable>true</noUnsettable>
+                        </configuration>
+                        <goals>
+                            <goal>generate</goal>
+                        </goals>
+                    </execution>
+                </executions>
+            </plugin>
+            <plugin>
+                <groupId>org.apache.tuscany.sca.extensions.axis2.plugins</groupId>
+                <artifactId>tuscany-plugin-wsdl2java</artifactId>
+                   <version>${scaKernelVersion}</version>
+                <executions>
+                    <execution>
+                        <configuration>
+                            <wsdlFiles>
+                                <wsdlFile>
+                                    <fileName>${basedir}/src/main/resources/wsdl/stockquotes.webservicex.wsdl</fileName>
+                                    <ports>
+                                        <port>StockQuoteSoap</port>
+                                    </ports>
+                                </wsdlFile>
+                                <wsdlFile>
+                                    <fileName>${basedir}/src/main/resources/wsdl/AccountService.wsdl</fileName>
+                                </wsdlFile>
+                            </wsdlFiles>
+                        </configuration>
+                        <goals>
+                            <goal>generate</goal>
+                        </goals>
+                    </execution>
+                </executions>
+            </plugin>
+            <plugin>
+                <groupId>org.apache.tuscany.sca.runtime.webapp</groupId>
+                <artifactId>tuscany-war-plugin</artifactId>
+                   <version>${scaKernelVersion}</version>
+                <executions>
+                    <execution>
+                        <id>tuscany-war</id>
+                        <goals>
+                            <goal>tuscany-war</goal>
+                        </goals>
+                    </execution>
+                </executions>
+                <configuration>
+                    <!-- Set to true to embed external jars for extensions in the WAR -->
+                    <!-- Set to false to leave external jars for extensions to be resolved from maven repository -->
+                    <loadExtensionDependencies>false</loadExtensionDependencies>
+
+                    <extensions>
+                        <dependency>
+                            <groupId>org.apache.tuscany.sca.services.databinding</groupId>
+                            <artifactId>databinding-sdo</artifactId>
+                            <version>${scaKernelVersion}</version>
+                        </dependency>
+                        <dependency>
+                            <groupId>org.apache.tuscany.sca.extensions.axis2</groupId>
+                            <artifactId>tuscany-axis2</artifactId>
+                            <version>${scaKernelVersion}</version>
+                        </dependency>
+                    </extensions>
+
+                </configuration>
+            </plugin>
+        </plugins>
+    </build>
+</project>
diff --git a/branches/sca-java-0.99/samples/old/bigbank/account/src/main/java/bigbank/account/services/account/AccountServiceImpl.java b/branches/sca-java-0.99/samples/old/bigbank/account/src/main/java/bigbank/account/services/account/AccountServiceImpl.java
new file mode 100644
index 0000000000..74baa636f5
--- /dev/null
+++ b/branches/sca-java-0.99/samples/old/bigbank/account/src/main/java/bigbank/account/services/account/AccountServiceImpl.java
@@ -0,0 +1,279 @@
+/*
+ * 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 bigbank.account.services.account;
+
+import java.rmi.RemoteException;
+import java.text.DateFormat;
+import java.text.SimpleDateFormat;
+import java.util.ArrayList;
+import java.util.Date;
+import java.util.HashSet;
+import java.util.List;
+import java.util.Map;
+import java.util.TimeZone;
+
+import org.osoa.sca.annotations.Property;
+import org.osoa.sca.annotations.Reference;
+import org.osoa.sca.annotations.Service;
+
+import bigbank.account.services.accountdata.AccountDataService;
+import bigbank.account.services.stockquote.StockQuote;
+import bigbank.account.services.stockquote.StockQuoteService;
+
+import com.bigbank.account.AccountLog;
+import com.bigbank.account.AccountReport;
+import com.bigbank.account.AccountService;
+import com.bigbank.account.AccountSummary;
+import com.bigbank.account.CustomerProfileData;
+import com.bigbank.account.StockSummary;
+
+@Service(interfaces = AccountService.class)
+public class AccountServiceImpl implements AccountService {
+
+    public static final String CHECKING_ACCOUNT_PREFIX = "134-43-394";
+
+    public static final String SAVINGS_ACCOUNT_PREFIX = "134-42-623";
+
+    public static final String ACCOUNT_TYPE_SAVINGS = "savings";
+
+    public static final String ACCOUNT_TYPE_CHECKINGS = "checkings";
+
+    public static final DateFormat tsformatXSDDateTime = new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss.SSSz");
+    static {
+        AccountServiceImpl.tsformatXSDDateTime.setTimeZone(TimeZone.getTimeZone("UTC"));
+    }
+
+    private float currencyConversion = 0.0f;
+
+    private String currency = "USD";
+
+    @Property
+    public void setCurrency(final String currency) {
+        this.currency = currency;
+    }
+
+    float getCurrencyConversion() {
+        if (currencyConversion == 0.0F) {
+            if ("USD".equals(currency)) {
+                currencyConversion = 1.0f;
+            } else if ("EURO".equals(currency)) {
+                currencyConversion = 0.8f;
+            } else {
+                try {
+                    currencyConversion = Float.parseFloat(currency);
+                } catch (Exception e) {
+                    currencyConversion = 1.0f;
+                }
+
+            }
+
+        }
+        return currencyConversion;
+
+    }
+
+    private AccountDataService accountDataService;
+
+    @Reference
+    public void setAccountDataService(AccountDataService accountDataService) {
+        this.accountDataService = accountDataService;
+    }
+
+    private StockQuoteService stockQuoteService;
+
+    @Reference
+    public void setStockQuoteService(StockQuoteService stockQuoteService) {
+        this.stockQuoteService = stockQuoteService;
+    }
+
+    public AccountServiceImpl() {
+    }
+
+    @SuppressWarnings("unchecked")
+    public AccountReport getAccountReport(int customerID) throws RemoteException {
+
+        try {
+            AccountReport accountReport = accountDataService.getAccountReport(customerID);
+            // convert to local currency.
+            List<AccountSummary> accounts = accountReport.getAccountSummaries();
+            for (AccountSummary accountSummary : accounts) {
+                accountSummary.setBalance(fromUSDollarToCurrency(accountSummary.getBalance()));
+
+            }
+            return updateStockInformation(accountReport);
+        } catch (Exception e) {
+            e.printStackTrace();
+            if (e instanceof RemoteException) {
+                throw (RemoteException) e;
+            } else {
+                throw new RemoteException(e.getClass() + " " + e.getMessage(), e);
+            }
+        }
+    }
+
+    private AccountReport updateStockInformation(AccountReport accountReport) throws RemoteException {
+        List<StockSummary> stocks = accountReport.getStockSummaries();
+        if (stocks.size() < 1) {
+            return accountReport; // nothing todo
+        }
+        HashSet<String> owned = new HashSet<String>(stocks.size());
+        for (StockSummary stock : stocks) {
+            owned.add(stock.getSymbol());
+        }
+        ArrayList<String> ownedStr = new ArrayList<String>(owned.size() * 5);
+        for (String s : owned) {
+
+            ownedStr.add(s);
+        }
+
+        Map<String, StockQuote> stockInfo = stockQuoteService.getQuotes(ownedStr.toArray(new String[owned.size()]));
+
+        for (StockSummary stock : stocks) {
+            String symbol = stock.getSymbol();
+            StockQuote stockquote = stockInfo.get(symbol);
+            if (stockquote == null) {
+                stock.setCurrentPrice(Float.NaN);
+                stock.setCompany("*not found*");
+                stock.setHighPrice(Float.NaN);
+                stock.setLowPrice(Float.NaN);
+
+            } else {
+                stock.setCurrentPrice(fromUSDollarToCurrency(convertToFloat(stockquote.getStockQuote())));
+                stock.setCompany(stockquote.getCompanyName());
+                stock.setHighPrice(fromUSDollarToCurrency(convertToFloat(stockquote.getDayHighPrice())));
+                stock.setLowPrice(fromUSDollarToCurrency(convertToFloat(stockquote.getDayLowPrice())));
+            }
+        }
+
+        return accountReport;
+    }
+
+    float convertToFloat(final String s) {
+
+        try {
+            return Float.parseFloat(s);
+        } catch (Exception e) {
+            return Float.NaN;
+        }
+
+    }
+
+    private float fromUSDollarToCurrency(float value) {
+        return value * getCurrencyConversion();
+
+    }
+
+    private float toUSDollarfromCurrency(float value) {
+
+        return value / getCurrencyConversion();
+    }
+
+    public CustomerProfileData getCustomerProfile(String logonID) throws RemoteException {
+
+        try {
+            return accountDataService.getCustomerProfile(logonID);
+        } catch (Exception e) {
+            e.printStackTrace();
+            if (e instanceof RemoteException) {
+                throw (RemoteException) e;
+            } else {
+                throw new RemoteException(e.getClass() + " " + e.getMessage(), e);
+            }
+        }
+
+    }
+
+    public float deposit(String account, float ammount) throws RemoteException {
+        try {
+            return accountDataService.deposit(account, toUSDollarfromCurrency(ammount));
+        } catch (RemoteException e) {
+            e.printStackTrace();
+            throw e;
+        } catch (Exception e) {
+            e.printStackTrace();
+            throw new RemoteException(e.getClass() + " " + e.getMessage(), e);
+        }
+    }
+
+    public StockSummary purchaseStock(int id, StockSummary stock) throws RemoteException {
+        try {
+            String symbol = stock.getSymbol();
+            Map<String, StockQuote> stockInfo = stockQuoteService.getQuotes(new String[] { symbol });
+
+            StockQuote stockQuote = stockInfo.get(symbol);
+            stock.setPurchasePrice(Float.parseFloat(stockQuote.getStockQuote()));
+            String purchaseDate = tsformatXSDDateTime.format(new Date());
+            if (purchaseDate.endsWith("UTC")) {
+                purchaseDate = purchaseDate.substring(0, purchaseDate.length() - 3) + "Z";
+            }
+            stock.setPurchaseDate(purchaseDate);
+
+            return accountDataService.purchaseStock(id, stock);
+        } catch (RemoteException e) {
+            e.printStackTrace();
+            throw e;
+        } catch (Exception e) {
+            e.printStackTrace();
+            throw new RemoteException(e.getClass() + " " + e.getMessage(), e);
+        }
+    }
+
+    public StockSummary sellStock(int purchaseLotNumber, int quantity) throws RemoteException {
+        try {
+            return accountDataService.sellStock(purchaseLotNumber, quantity);
+        } catch (RemoteException e) {
+            e.printStackTrace();
+            throw e;
+        } catch (Exception e) {
+            e.printStackTrace();
+            throw new RemoteException(e.getClass() + " " + e.getMessage(), e);
+        }
+    }
+
+    public float withdraw(String account, float ammount) throws RemoteException {
+        try {
+            return accountDataService.withdraw(account, toUSDollarfromCurrency(ammount));
+        } catch (RemoteException e) {
+            e.printStackTrace();
+            throw e;
+        } catch (Exception e) {
+            e.printStackTrace();
+            throw new RemoteException(e.getClass() + " " + e.getMessage(), e);
+        }
+    }
+
+    public CustomerProfileData createAccount(CustomerProfileData customerProfile, boolean createSavings, boolean createCheckings)
+            throws RemoteException {
+        try {
+            return accountDataService.createAccount(customerProfile, createSavings, createCheckings);
+        } catch (RemoteException e) {
+            e.printStackTrace();
+            throw e;
+        } catch (Exception e) {
+            e.printStackTrace();
+            throw new RemoteException(e.getClass() + " " + e.getMessage(), e);
+        }
+    }
+
+    public AccountLog getAccountLog(final int customerID) throws RemoteException {
+        return accountDataService.getAccountLog(customerID);
+    }
+
+}
diff --git a/branches/sca-java-0.99/samples/old/bigbank/account/src/main/java/bigbank/account/services/accountdata/AccountDataService.java b/branches/sca-java-0.99/samples/old/bigbank/account/src/main/java/bigbank/account/services/accountdata/AccountDataService.java
new file mode 100644
index 0000000000..884127cd9e
--- /dev/null
+++ b/branches/sca-java-0.99/samples/old/bigbank/account/src/main/java/bigbank/account/services/accountdata/AccountDataService.java
@@ -0,0 +1,87 @@
+/*
+ * 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 bigbank.account.services.accountdata;
+
+public interface AccountDataService {
+
+    /**
+     * Auto generated method signatures
+     * 
+     * @param param0*
+     * @param param1*
+     * @param param2
+     */
+    public com.bigbank.account.StockSummary purchaseStock(int param0, com.bigbank.account.StockSummary parm1) throws java.rmi.RemoteException;
+
+    /**
+     * Auto generated method signatures
+     * 
+     * @param param4
+     */
+    public com.bigbank.account.CustomerProfileData getCustomerProfile(java.lang.String param4) throws java.rmi.RemoteException;
+
+    /**
+     * Auto generated method signatures
+     * 
+     * @param param6*
+     * @param param7
+     */
+    public float deposit(java.lang.String param6, float param7) throws java.rmi.RemoteException;
+
+    /**
+     * Auto generated method signatures
+     * 
+     * @param param9*
+     * @param param10*
+     * @param param11
+     */
+    public com.bigbank.account.CustomerProfileData createAccount(com.bigbank.account.CustomerProfileData param9, boolean param10, boolean param11)
+            throws java.rmi.RemoteException;
+
+    /**
+     * Auto generated method signatures
+     * 
+     * @param param13*
+     * @param param14
+     */
+    public com.bigbank.account.StockSummary sellStock(int param13, int param14) throws java.rmi.RemoteException;
+
+    /**
+     * Auto generated method signatures
+     * 
+     * @param param16*
+     * @param param17
+     */
+    public float withdraw(java.lang.String param16, float param17) throws java.rmi.RemoteException;
+
+    /**
+     * Auto generated method signatures
+     * 
+     * @param param19
+     */
+    public com.bigbank.account.AccountReport getAccountReport(int param19) throws java.rmi.RemoteException;
+
+    /**
+     * Auto generated method signatures
+     * 
+     * @param param0
+     */
+    public com.bigbank.account.AccountLog getAccountLog(int param0) throws java.rmi.RemoteException;
+
+}
diff --git a/branches/sca-java-0.99/samples/old/bigbank/account/src/main/java/bigbank/account/services/accountdata/AccountDataServiceDASImpl.java b/branches/sca-java-0.99/samples/old/bigbank/account/src/main/java/bigbank/account/services/accountdata/AccountDataServiceDASImpl.java
new file mode 100644
index 0000000000..c346a3221f
--- /dev/null
+++ b/branches/sca-java-0.99/samples/old/bigbank/account/src/main/java/bigbank/account/services/accountdata/AccountDataServiceDASImpl.java
@@ -0,0 +1,400 @@
+/*

+ * 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 bigbank.account.services.accountdata;

+

+import java.io.InputStream;

+import java.rmi.RemoteException;

+import java.sql.Connection;

+import java.sql.DriverManager;

+import java.sql.ResultSet;

+import java.sql.SQLException;

+import java.sql.Statement;

+import java.text.DateFormat;

+import java.text.ParseException;

+import java.text.SimpleDateFormat;

+import java.util.Collection;

+import java.util.List;

+import java.util.Properties;

+import java.util.TimeZone;

+

+import org.apache.tuscany.das.rdb.Command;

+import org.apache.tuscany.das.rdb.Converter;

+import org.apache.tuscany.das.rdb.DAS;

+import org.osoa.sca.annotations.Service;

+

+import bigbank.account.services.account.AccountServiceImpl;

+

+import com.bigbank.account.AccountFactory;

+import com.bigbank.account.AccountReport;

+import com.bigbank.account.AccountSummary;

+import com.bigbank.account.CustomerProfileData;

+import com.bigbank.account.StockSummary;

+import commonj.sdo.DataObject;

+

+@Service(CustomerIdService.class)

+public class AccountDataServiceDASImpl implements CustomerIdService { // TODO fix this!

+

+    static public String dbDirectory = null;

+

+    public static final DateFormat tsformatXSDDateTime = new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss.SSSz");

+

+    public static final DateFormat sqlformatDateTime = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss.SSSz");

+

+    static {

+        tsformatXSDDateTime.setTimeZone(TimeZone.getTimeZone("UTC"));

+

+    }

+

+    public CustomerProfileData getCustomerProfile(String logonID) throws RemoteException {

+

+        try {

+            InputStream mapping = createConfigStream();

+            Connection conn = getConnection();

+            DAS das = DAS.FACTORY.createDAS(mapping, conn);

+

+            Command select = das.createCommand("SELECT firstName, lastName, loginID, password, id FROM customers where loginID = ?");

+

+            select.setParameter(1, logonID);

+

+            DataObject root = select.executeQuery();

+            conn.close();

+

+            Collection customers = root.getList("CustomerProfileData");

+            CustomerProfileData customerProfileData = (CustomerProfileData) customers.iterator().next();

+

+            return customerProfileData;

+        } catch (Exception e) {

+

+            e.printStackTrace();

+            RemoteException re = new RemoteException("Failed to get customer profile'" + logonID + "' ", e);

+            re.printStackTrace();

+            throw re;

+        }

+    }

+

+    protected static final String driver = "org.apache.derby.jdbc.EmbeddedDriver";

+

+    protected static final String protocol = "jdbc:derby:";

+

+    public CustomerProfileData createAccount(CustomerProfileData customerProfile, boolean createSavings, boolean createCheckings)

+            throws RemoteException {

+

+        try {

+            DAS das = DAS.FACTORY.createDAS(getConnection());

+            Command insert = das.createCommand("insert into customers (firstName,lastName,address,email, loginID, password  ) values ('"

+                    + customerProfile.getFirstName() + "', '" + customerProfile.getLastName() + "', '" + customerProfile.getAddress() + "', '"

+                    + customerProfile.getEmail() + "', '" + customerProfile.getLoginID() + "', '" + customerProfile.getPassword() + "')");

+

+            insert.execute();

+            CustomerProfileData ret = getCustomerProfile(customerProfile.getLoginID());

+            String cid = ret.getId() + "";

+            if (createSavings) {

+                insert = das.createCommand("insert into accounts (id,accountNumber, accountType, balance  ) values (" + cid + ", '"

+                        + AccountServiceImpl.SAVINGS_ACCOUNT_PREFIX + cid + "', '" + AccountServiceImpl.ACCOUNT_TYPE_SAVINGS + "', " + 1.0F + ")");

+                insert.execute();

+

+            }

+            if (createCheckings) {

+                insert = das.createCommand("insert into accounts (id,accountNumber, accountType, balance  ) values (" + cid + ", '"

+                        + AccountServiceImpl.CHECKING_ACCOUNT_PREFIX + cid + "', '" + AccountServiceImpl.ACCOUNT_TYPE_CHECKINGS + "', " + 1.0F + ")");

+                insert.execute();

+

+            }

+

+            return ret;

+        } catch (Exception e) {

+            if (e instanceof RemoteException) {

+                throw (RemoteException) e;

+            }

+            throw new RemoteException("createAccount " + e.getClass().getName() + "'. " + e.getMessage(), e);

+        }

+    }

+

+    public CustomerProfileData createAccountNOTWORKING(CustomerProfileData customerProfile, boolean createSavings, boolean createCheckings)

+            throws RemoteException {

+        try {

+            DAS das = DAS.FACTORY.createDAS(createConfigStream(), getConnection());

+            Command read = das.getCommand("all customers");

+

+            // select.setDataObjectModel();

+            DataObject root = read.executeQuery();

+

+            // Create a new stockPurchase

+            DataObject customer = root.createDataObject("customerProfileData");

+

+            // THIS SEEMS TO BE THE ONLY WAY TO DO THIS .. NO WAY TO JUST ADD AN EXISTING CUSTOMER.

+            customer.set("firstName", customerProfile.getFirstName());

+            customer.set("lastName", customerProfile.getLastName());

+            customer.set("address", customerProfile.getAddress());

+            customer.set("email", customerProfile.getEmail());

+            customer.set("loginID", customerProfile.getLoginID());

+            customer.set("password", customerProfile.getPassword());

+

+            das.applyChanges(root);

+            return getCustomerProfile(customerProfile.getLoginID());

+

+        } catch (Exception e) {

+            if (e instanceof RemoteException) {

+                throw (RemoteException) e;

+            }

+            throw new RemoteException("createAccount " + e.getClass().getName() + "'. " + e.getMessage(), e);

+        }

+

+    }

+

+    public AccountReport getAccountReport(final int customerID) throws RemoteException {

+        try {

+            final AccountFactory accountFactory = AccountFactory.INSTANCE;

+            final AccountReport accountReport = accountFactory.createAccountReport();

+            InputStream mapping = createConfigStream();

+

+            Connection conn = getConnection();

+            DAS das = DAS.FACTORY.createDAS(mapping, conn);

+

+            Command select = das.createCommand("SELECT accountNumber, accountType, balance FROM accounts where id = ?");

+            select.setParameter(1, customerID);

+

+            DataObject root = select.executeQuery();

+            accountReport.getAccountSummaries().addAll(root.getList("AccountSummary"));

+

+            // Get Stocks

+

+            select = das.createCommand("SELECT Symbol, quantity, purchasePrice, purchaseDate, purchaseLotNumber  FROM stocks where id = ?");

+            select.setParameter(1, customerID);

+

+            // select.addConverter("STOCKS.PURCHASEDATE", DateConverter.class.getName());

+

+            root = select.executeQuery();

+            accountReport.getStockSummaries().addAll(root.getList("StockSummary"));

+

+            conn.close();

+

+            return accountReport;

+        } catch (Exception e) {

+            if (e instanceof RemoteException) {

+                throw (RemoteException) e;

+            }

+            throw new RemoteException("getAccountReport failed. customerID ('" + customerID + "')" + e.getClass().getName() + "'. " + e.getMessage(),

+                    e);

+        }

+    }

+

+    public float withdraw(String account, float ammount) throws RemoteException {

+

+        return deposit(account, -ammount);

+    }

+

+    public float deposit(String account, float ammount) throws RemoteException {

+

+        try {

+            Connection conn = getConnection();

+            DAS das = DAS.FACTORY.createDAS(createConfigStream(), conn);

+

+            Command select = das.createCommand("SELECT accountNumber, balance FROM accounts where accountNumber = ?");

+            select.setParameter(1, account);

+

+            DataObject root = select.executeQuery();

+            Collection accounts = root.getList("AccountSummary");

+            AccountSummary accountData = (AccountSummary) accounts.iterator().next();

+            float newbalance = accountData.getBalance() + ammount;

+            accountData.setBalance(newbalance);

+            // update department set companyid = ? where department.name = ?

+

+            Command update = das.getCommand("update balance");

+            update.setParameter(1, new Float(newbalance));

+            update.setParameter(2, account);

+            update.execute();

+            conn.close();

+            return newbalance;

+        } catch (Exception e) {

+            throw new RemoteException(e.getClass().getName(), e);

+        }

+

+    }

+

+    public StockSummary sellStock(int purchaseLotNumber, int quantity) throws RemoteException {

+        try {

+            DAS das = DAS.FACTORY.createDAS(createConfigStream(), getConnection());

+

+            Command read = das.getCommand("stockbylotSelect");

+            read.setParameter(1, purchaseLotNumber);// autoboxing :-)

+            DataObject root = read.executeQuery();

+            List stocks = root.getList("StockSummary");

+            if (null != stocks && !stocks.isEmpty()) {

+                StockSummary stock = (StockSummary) stocks.get(0);

+                int newQuatity = Math.max(stock.getQuantity() - quantity, 0);

+                if (newQuatity < 1) {

+

+                    Command delete = das.createCommand("DELETE FROM STOCKS WHERE PURCHASELOTNUMBER = ?");

+                    delete.setParameter(1, purchaseLotNumber);

+                    delete.execute();

+

+                } else {

+

+                    Command update = das.getCommand("stockbylot");

+

+                    update.setParameter(1, newQuatity);

+                    update.setParameter(2, purchaseLotNumber);

+                    update.execute();

+

+                    stock.setQuantity(newQuatity);

+                }

+                return stock;

+            }

+

+            return null;

+        } catch (Exception e) {

+            throw new RemoteException("sellStock", e);

+        }

+    }

+

+    public StockSummary purchaseStock(int id, StockSummary stock) throws RemoteException {

+

+        try {

+            DAS das = DAS.FACTORY.createDAS(getConnection());

+            Command insert = das.createCommand("insert into stocks (id, symbol, quantity, purchasePrice, purchaseDate) values (?,?,?,?,?)");

+            insert.setParameter(1, new Integer(id));

+            insert.setParameter(2, stock.getSymbol());

+            insert.setParameter(3, stock.getQuantity());

+            insert.setParameter(4, stock.getPurchasePrice());

+            insert.setParameter(5, DateConverter.INSTANCE.getColumnValue(stock.getPurchaseDate()));

+

+            insert.execute();

+

+            return stock;

+        } catch (Exception e) {

+            if (e instanceof RemoteException) {

+                throw (RemoteException) e;

+            }

+            throw new RemoteException("purchaseStock " + e.getClass().getName() + "'. " + e.getMessage(), e);

+        }

+    }

+

+    protected Connection getConnection() throws InstantiationException, IllegalAccessException, ClassNotFoundException, SQLException {

+        Connection conn;

+        Class.forName(driver).newInstance();

+        Properties props = new Properties();

+        // props.put("user", "tuscany");

+        // props.put("password", "tuscany");

+        conn = DriverManager.getConnection(protocol + dbDirectory + ";create=true", props);

+

+        conn.setAutoCommit(false);

+        return conn;

+    }

+

+    protected InputStream createConfigStream() {

+        InputStream mapping = getClass().getClassLoader().getResourceAsStream("DasAccountConfiguration.xml");

+        return mapping;

+    }

+

+    public static class DateConverter implements Converter {

+        public final static DateConverter INSTANCE = new DateConverter();

+

+        public DateConverter() { // public empty constructor

+        }

+

+        public Object getPropertyValue(Object columnData) {

+

+            try {

+

+                String ret = tsformatXSDDateTime.format(columnData);

+                if (ret.endsWith("UTC")) {

+                    ret = ret.substring(0, ret.length() - 3) + "Z";

+                }

+                return ret;

+

+            } catch (Exception e) {

+

+                e.printStackTrace();

+                throw new IllegalArgumentException(e);

+            }

+

+        }

+

+        public Object getColumnValue(Object propertyData) {

+

+            if (propertyData instanceof java.util.Date) {

+                // Need to convert back to local time for DB and remove timezone notation at the end..

+                String ret = sqlformatDateTime.format(propertyData);

+                char lc = ret.charAt(ret.length() - 1);

+                while (!Character.isDigit(lc)) {

+                    ret = ret.substring(0, ret.length() - 1);

+                    lc = ret.charAt(ret.length() - 1);

+                }

+                return ret;

+            } else if (propertyData instanceof String) {

+

+                try {

+                    String time = (String) propertyData;

+                    char last = time.charAt(time.length() - 1);

+                    if (last == 'z' || last == 'Z') {

+                        time = time.substring(0, time.length() - 1);

+                    }

+                    if (!time.endsWith("UTC")) {

+                        time = time + "UTC";

+                    }

+                    return getColumnValue(tsformatXSDDateTime.parse(time));

+                } catch (ParseException e) {

+                    throw new IllegalArgumentException("'" + propertyData + "' does not parse to date.");

+                }

+            } else {

+                throw new IllegalArgumentException();

+            }

+

+        }

+

+    }

+

+    public int getCustomerIdByPurchaseLotNumber(int purchaseLotNumber) throws RemoteException {

+

+        return queryCustomerId("select id from stocks where purchaseLotNumber = " + purchaseLotNumber);

+    }

+

+    public int getCustomerIdByAccount(String account) throws RemoteException {

+

+        return queryCustomerId("select id from accounts where accountNumber = '" + account + "'");

+    }

+

+    private int queryCustomerId(String query) throws RemoteException {

+

+        try {

+            Connection conn = getConnection();

+

+            Statement s = conn.createStatement();

+

+            ResultSet rs = s.executeQuery(query);

+            int id = -1;

+            if (rs.next()) {

+                id = rs.getInt("id");

+            }

+

+            conn.commit();

+

+            rs.close();

+            s.close();

+            conn.close();

+

+            return id;

+

+        } catch (Exception e) {

+            e.printStackTrace();

+            throw new RemoteException(e.getClass().getName(), e);

+        }

+    }

+}

diff --git a/branches/sca-java-0.99/samples/old/bigbank/account/src/main/java/bigbank/account/services/accountdata/AccountDataServiceImpl.java b/branches/sca-java-0.99/samples/old/bigbank/account/src/main/java/bigbank/account/services/accountdata/AccountDataServiceImpl.java
new file mode 100644
index 0000000000..5e08cf634f
--- /dev/null
+++ b/branches/sca-java-0.99/samples/old/bigbank/account/src/main/java/bigbank/account/services/accountdata/AccountDataServiceImpl.java
@@ -0,0 +1,106 @@
+/*
+ * 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 bigbank.account.services.accountdata;
+
+import java.rmi.RemoteException;
+import java.util.List;
+
+import org.osoa.sca.annotations.Service;
+
+import com.bigbank.account.AccountFactory;
+import com.bigbank.account.AccountLog;
+import com.bigbank.account.AccountReport;
+import com.bigbank.account.AccountSummary;
+import com.bigbank.account.CustomerProfileData;
+import com.bigbank.account.StockSummary;
+
+@Service(AccountDataService.class)
+public class AccountDataServiceImpl implements AccountDataService {
+
+    public CustomerProfileData getCustomerProfile(String logonID) throws RemoteException {
+        // TODO Auto-generated method stub
+        return null;
+    }
+
+    public AccountReport getAccountReport(int customerID) {
+        final AccountFactory accountFactory = AccountFactory.INSTANCE;
+        AccountReport accountReport = accountFactory.createAccountReport();
+        List accounts = accountReport.getAccountSummaries();
+
+        AccountSummary account = accountFactory.createAccountSummary();
+        account.setAccountType("1111");
+        account.setAccountNumber("22-22-22");
+        account.setBalance(123.45F);
+        accounts.add(account);
+
+        account = accountFactory.createAccountSummary();
+        account.setAccountType("04-11-19");
+        account.setAccountNumber("11-23");
+        account.setBalance(543.21F);
+        accounts.add(account);
+
+        List stocks = accountReport.getStockSummaries();
+        StockSummary stock = accountFactory.createStockSummary();
+        stock.setSymbol("IBM");
+        stock.setPurchaseDate("1999-11-23");
+        stock.setPurchaseLotNumber(101);
+        stock.setPurchasePrice(33.33F);
+        stock.setQuantity(10);
+        stocks.add(stock);
+
+        stock = accountFactory.createStockSummary();
+        stock.setSymbol("TUSK");
+        stock.setPurchaseDate("2005-01-05");
+        stock.setPurchaseLotNumber(102);
+        stock.setPurchasePrice(11.11F);
+        stock.setQuantity(4);
+        stocks.add(stock);
+        return accountReport;
+    }
+
+    public CustomerProfileData createAccount(CustomerProfileData customerProfile, boolean createSavings, boolean createCheckings)
+            throws RemoteException {
+        // TODO Auto-generated method stub
+        return null;
+    }
+
+    public float deposit(String param6, float param7) throws RemoteException {
+        // TODO Auto-generated method stub
+        return 0;
+    }
+
+    public StockSummary purchaseStock(int param0, StockSummary stock) throws RemoteException {
+        // TODO Auto-generated method stub
+        return null;
+    }
+
+    public StockSummary sellStock(int param13, int param14) throws RemoteException {
+        // TODO Auto-generated method stub
+        return null;
+    }
+
+    public float withdraw(String param16, float param17) throws RemoteException {
+        // TODO Auto-generated method stub
+        return 0;
+    }
+
+    public AccountLog getAccountLog(final int customerID) throws RemoteException {
+        throw new RemoteException("This method should not be called");
+    }
+}
diff --git a/branches/sca-java-0.99/samples/old/bigbank/account/src/main/java/bigbank/account/services/accountdata/CustomerIdService.java b/branches/sca-java-0.99/samples/old/bigbank/account/src/main/java/bigbank/account/services/accountdata/CustomerIdService.java
new file mode 100644
index 0000000000..b355a09008
--- /dev/null
+++ b/branches/sca-java-0.99/samples/old/bigbank/account/src/main/java/bigbank/account/services/accountdata/CustomerIdService.java
@@ -0,0 +1,98 @@
+/*

+ * 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 bigbank.account.services.accountdata;

+

+import java.rmi.RemoteException;

+

+/**

+ * This interface allows access to a customer's id from the data service.

+ */

+public interface CustomerIdService {

+

+    /*

+     * Return -1 if purchaseLotNumber not found

+     */

+    public int getCustomerIdByPurchaseLotNumber(int purchaseLotNumber) throws RemoteException;

+

+    /*

+     * Return -1 if account not found

+     */

+    public int getCustomerIdByAccount(String account) throws RemoteException;

+

+    // TODO (isilval) Fix this !!!

+    // Apparently, configuration can't deal with extends so I am adding the contents of AccountDataService here

+

+    /**

+     * Auto generated method signatures

+     * 

+     * @param param0*

+     * @param param1*

+     * @param param2

+     */

+    public com.bigbank.account.StockSummary purchaseStock(int param0, com.bigbank.account.StockSummary parm1) throws java.rmi.RemoteException;

+

+    /**

+     * Auto generated method signatures

+     * 

+     * @param param4

+     */

+    public com.bigbank.account.CustomerProfileData getCustomerProfile(java.lang.String param4) throws java.rmi.RemoteException;

+

+    /**

+     * Auto generated method signatures

+     * 

+     * @param param6*

+     * @param param7

+     */

+    public float deposit(java.lang.String param6, float param7) throws java.rmi.RemoteException;

+

+    /**

+     * Auto generated method signatures

+     * 

+     * @param param9*

+     * @param param10*

+     * @param param11

+     */

+    public com.bigbank.account.CustomerProfileData createAccount(com.bigbank.account.CustomerProfileData param9, boolean param10, boolean param11)

+            throws java.rmi.RemoteException;

+

+    /**

+     * Auto generated method signatures

+     * 

+     * @param param13*

+     * @param param14

+     */

+    public com.bigbank.account.StockSummary sellStock(int param13, int param14) throws java.rmi.RemoteException;

+

+    /**

+     * Auto generated method signatures

+     * 

+     * @param param16*

+     * @param param17

+     */

+    public float withdraw(java.lang.String param16, float param17) throws java.rmi.RemoteException;

+

+    /**

+     * Auto generated method signatures

+     * 

+     * @param param19

+     */

+    public com.bigbank.account.AccountReport getAccountReport(int param19) throws java.rmi.RemoteException;

+

+}

diff --git a/branches/sca-java-0.99/samples/old/bigbank/account/src/main/java/bigbank/account/services/accountdb/AccountDBInit.java b/branches/sca-java-0.99/samples/old/bigbank/account/src/main/java/bigbank/account/services/accountdb/AccountDBInit.java
new file mode 100644
index 0000000000..1225c95f84
--- /dev/null
+++ b/branches/sca-java-0.99/samples/old/bigbank/account/src/main/java/bigbank/account/services/accountdb/AccountDBInit.java
@@ -0,0 +1,465 @@
+/*

+ * 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 bigbank.account.services.accountdb;

+

+import java.io.IOException;

+import java.io.InputStream;

+import java.io.PrintStream;

+import java.io.PrintWriter;

+import java.sql.Connection;

+import java.sql.DriverManager;

+import java.sql.ResultSet;

+import java.sql.SQLException;

+import java.sql.Statement;

+import java.text.DateFormat;

+import java.text.ParseException;

+import java.text.SimpleDateFormat;

+import java.util.Collection;

+import java.util.Date;

+import java.util.Properties;

+

+import javax.servlet.ServletConfig;

+import javax.servlet.ServletContext;

+import javax.servlet.ServletException;

+import javax.servlet.http.HttpServlet;

+import javax.servlet.http.HttpServletRequest;

+import javax.servlet.http.HttpServletResponse;

+

+import org.apache.tuscany.das.rdb.Command;

+import org.apache.tuscany.das.rdb.Converter;

+import org.apache.tuscany.das.rdb.DAS;

+import org.apache.tuscany.das.rdb.config.ConfigFactory;

+import org.apache.tuscany.sdo.util.SDOUtil;

+

+import bigbank.account.services.account.AccountServiceImpl;

+import bigbank.account.services.accountdata.AccountDataServiceDASImpl;

+import bigbank.account.services.accountlogger.AccountLoggerServiceImpl;

+

+import com.bigbank.account.AccountFactory;

+import com.bigbank.account.AccountSummary;

+import com.bigbank.account.CustomerProfileData;

+import com.bigbank.account.StockSummary;

+import commonj.sdo.DataObject;

+import com.bigbank.account.purchaseStock;

+import com.bigbank.account.withdraw;

+

+public class AccountDBInit extends HttpServlet {

+

+    private static final long serialVersionUID = -4795999792460944805L;

+

+    protected static final String driver = "org.apache.derby.jdbc.EmbeddedDriver";

+

+    protected static final String protocol = "jdbc:derby:";

+

+    protected String dbDirectory = null;

+

+    protected String dasConfigFile = null;

+

+    boolean deleteExisting = false;

+

+    @Override

+    public void init() throws ServletException {

+        try {

+

+            registerTypes();

+            ServletConfig servletConfig = getServletConfig();

+            ServletContext servletContext = servletConfig.getServletContext();

+            dbDirectory = servletContext.getRealPath("WEB-INF/bigbankdb/accounts");

+            dasConfigFile = servletContext.getRealPath("WEB-INF/classes/DasAccountConfiguration.xml");

+            deleteExisting = false;

+

+            createDB(dbDirectory);

+

+        } catch (Exception e) {

+

+            e.printStackTrace();

+            log(e.toString(), e);

+            throw new ServletException(e);

+        }

+    }

+

+    /*

+     * (non-Java-doc)

+     * 

+     * @see javax.servlet.http.HttpServlet#doGet(HttpServletRequest arg0, HttpServletResponse arg1)

+     */

+    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

+        response.setContentType("text/html");

+

+        PrintWriter out = response.getWriter();

+

+        out.println();

+        out.println("<center><h2>BigBank database initialization servlet !<h2></center>");

+        out.println();

+    }

+

+    public AccountDBInit() {

+    }

+

+    public AccountDBInit(String dbDirectory, String dasConfigFile, Boolean deleteExisting) {

+        this.dbDirectory = dbDirectory;

+        this.dasConfigFile = dasConfigFile;

+        this.deleteExisting = deleteExisting;

+    }

+

+    private Connection createConnection() throws InstantiationException, IllegalAccessException, ClassNotFoundException, SQLException {

+        return createConnection(dbDirectory);

+    }

+

+    private static Connection createConnection(final String location) throws InstantiationException, IllegalAccessException, ClassNotFoundException,

+            SQLException {

+        Connection conn;

+        Class.forName(driver).newInstance();

+        Properties props = new Properties();

+        conn = DriverManager.getConnection(protocol + location + ";create=true", props);

+

+        conn.setAutoCommit(false);

+        return conn;

+    }

+

+    public static void createDB(final String location) throws Exception {

+        Connection conn = null;

+        AccountDataServiceDASImpl.dbDirectory = location;

+        AccountLoggerServiceImpl.dbDirectory = location; // TODO get rid of this (isilval)

+        Exception processessingException = null;

+        try {

+            conn = createConnection(location);

+

+            creatTables(conn);

+

+            int id = createCustomer(conn, "Test", "User", "304 Fox Trot ln, Apex, NC", "test@das.org", "test", "password");

+            createAccount(conn, id, AccountServiceImpl.SAVINGS_ACCOUNT_PREFIX + id, AccountServiceImpl.ACCOUNT_TYPE_SAVINGS, 123.43F);

+            createAccount(conn, id, AccountServiceImpl.CHECKING_ACCOUNT_PREFIX + id, AccountServiceImpl.ACCOUNT_TYPE_CHECKINGS, 23.12F);

+            createStockPurchase(conn, id, "IBM", 33, 66.20F, "2005-11-23 13:22:02");

+            createStockPurchase(conn, id, "DELL", 13, 12.74F, "2003-01-03 11:04:03");

+            createStockPurchase(conn, id, "LU", 7, 2.74F, "2003-01-04 16:04:03");

+            createStockPurchase(conn, id, "IBM", 22, 81.43F, "2004-02-03 13:04:33");

+

+            id = createCustomer(conn, "test2", "demo2", "Pleasant Plains Rd, ViewMount, CO", "test2@das.org", "test2", "password");

+            createAccount(conn, id, AccountServiceImpl.SAVINGS_ACCOUNT_PREFIX + id, AccountServiceImpl.ACCOUNT_TYPE_SAVINGS, 924.40F);

+            createAccount(conn, id, AccountServiceImpl.CHECKING_ACCOUNT_PREFIX + id, AccountServiceImpl.ACCOUNT_TYPE_CHECKINGS, 33.26F);

+            createStockPurchase(conn, id, "FOO", 3, 6.20F, "2000-09-11 09:11:01");

+

+            conn.commit();

+

+        } catch (org.apache.derby.impl.jdbc.EmbedSQLException e) {

+            if (conn != null && !conn.isClosed()) {

+                conn.rollback();

+            }

+            if (e.getErrorCode() == 20000 && "X0Y32".equalsIgnoreCase(e.getSQLState()) && -1 != e.getMessage().indexOf("already exists")) {

+                // this is ok the database is there.

+

+            } else {

+

+                e.printStackTrace();

+                processessingException = e;

+                throw e;

+            }

+        } finally {

+            try {

+                if (null != conn && !conn.isClosed()) {

+

+                    conn.close();

+                }

+                conn = null;

+            } catch (Exception e) {

+                e.printStackTrace();

+                if (null != processessingException) {

+                    throw e;

+                }

+            }

+        }

+

+    }

+

+    protected static void creatTables(Connection conn) throws Exception {

+        Statement s = conn.createStatement();

+

+        s

+                .execute("create table customers(firstName varchar(80) NOT NULL, lastName varchar(80), address varchar(180),email varchar(40),loginID varchar(80) NOT NULL UNIQUE, password varchar(80), id int NOT NULL PRIMARY KEY GENERATED ALWAYS AS IDENTITY)");

+

+        s.execute("create table accounts(id int NOT NULL, accountNumber varchar(80) NOT NULL UNIQUE, accountType varchar(80), balance real )");

+

+        s

+                .execute("create table stocks(id int NOT NULL, Symbol varchar(8) NOT NULL, quantity int NOT NULL, purchasePrice real NOT NULL, purchaseDate TIMESTAMP, purchaseLotNumber int NOT NULL PRIMARY KEY GENERATED ALWAYS AS IDENTITY  )");

+

+        s

+                .execute("create table acctLog (logSeqNo int NOT NULL PRIMARY KEY GENERATED ALWAYS AS IDENTITY, id int NOT NULL, accountNumber varchar(80) NOT NULL, actionType varchar(32) NOT NULL, amount real )");

+

+        s

+                .execute("create table stockLog (logSeqNo int NOT NULL PRIMARY KEY GENERATED ALWAYS AS IDENTITY, id int NOT NULL, Symbol varchar(8) NOT NULL, quantity int NOT NULL, actionType varchar(32) NOT NULL, purchaseLotNumber int NOT NULL )");

+

+        s.close();

+    }

+

+    protected static int createCustomer(Connection conn, final String firstName, final String lastName, final String address, final String email,

+            final String logonID, final String password) throws SQLException, Exception {

+        Statement s = conn.createStatement();

+

+        s.execute("insert into customers (firstName,lastName,address,email, loginID, password  ) " + "values ('" + firstName + "', '" + lastName

+                + "', '" + address + "', '" + email + "', '" + logonID + "', '" + password + "')");

+

+        ResultSet rs = s.executeQuery("SELECT loginID, id FROM customers where loginID='" + logonID + "'");

+        if (!rs.next()) {

+            throw new Exception("Wrong number of rows");

+        }

+        int id = rs.getInt(2);

+        s.close();

+

+        return id;

+    }

+

+    protected static void createAccount(Connection conn, int customerID, final String accountNumber, final String accountType, final float balance)

+            throws SQLException, Exception {

+        Statement s = conn.createStatement();

+

+        s.execute("insert into accounts (id,accountNumber, accountType, balance  ) " + "values (" + customerID + ", '" + accountNumber + "', '"

+                + accountType + "', " + balance + ")");

+

+        s.close();

+    }

+

+    protected InputStream createConfigStream() {

+        InputStream mapping = getClass().getClassLoader().getResourceAsStream("DasAccountConfiguration.xml");

+        return mapping;

+    }

+

+    protected static void createStockPurchase(Connection conn, int customerID, final String stockSymbol, final int quantity,

+            final float purchasePrice, String purchaseDate) throws SQLException, Exception {

+        Statement s = conn.createStatement();

+

+        s.execute("insert into stocks (id, symbol, quantity, purchasePrice, purchaseDate  ) values (" + customerID + ", '" + stockSymbol + "', "

+                + quantity + ", " + purchasePrice + ", '" + purchaseDate + "')");

+

+        s.close();

+

+    }

+

+    protected static void registerTypes() {

+        SDOUtil.registerStaticTypes(AccountFactory.class);

+        // TODO remove

+        SDOUtil.registerStaticTypes(ConfigFactory.class);

+

+    }

+

+    public void testWithdrawThroughDAS(withdraw wd) throws Exception {

+

+        Connection conn = createConnection();

+        DAS das = DAS.FACTORY.createDAS(createConfigStream(), conn);

+        Command select = das.getCommand("get account");

+

+        select.setParameter(1, wd.getAccountNumber());

+

+        DataObject root = select.executeQuery();

+

+        Collection accounts = root.getList("AccountSummary");

+        AccountSummary account = (AccountSummary) accounts.iterator().next();

+        float newbalance = account.getBalance() - wd.getAmount();

+        account.setBalance(newbalance);

+        // update department set companyid = ? where department.name = ?

+

+        Command update = das.getCommand("update balance");

+        update.setParameter(1, new Float(newbalance));

+        update.setParameter(2, wd.getAccountNumber());

+

+        update.execute();

+        conn.close();

+    }

+

+    protected void testStrockPurchaseThroughDAS(purchaseStock sp) throws InstantiationException, IllegalAccessException, ClassNotFoundException,

+            SQLException {

+

+        DAS das = DAS.FACTORY.createDAS(createConfigStream(), createConnection());

+        Command read = das.getCommand("all stocks");

+

+        DataObject root = read.executeQuery();

+

+        // Create a new stockPurchase

+        DataObject stockPurchase = root.createDataObject("StockSummary");

+        stockPurchase.set("id", new Integer(sp.getId()));

+        stockPurchase.set("symbol", sp.getStock().getSymbol());

+        stockPurchase.set("quantity", new Integer(sp.getStock().getQuantity()));

+        stockPurchase.set("purchasePrice", new Float(11.00));

+        // String type = stockPurchase.getType().getProperty("purchaseDate").getType().toString();

+        stockPurchase.setDate("purchaseDate", new Date());

+

+        das.applyChanges(root);

+    }

+

+    public CustomerProfileData testgetCustomerByLoginIDThroughDASRead(final String logonID) throws Exception {

+        InputStream mapping = createConfigStream();

+        Connection conn = createConnection();

+        DAS das = DAS.FACTORY.createDAS(mapping, conn);

+        Command select = das.createCommand("SELECT firstName, lastName, loginID, password, id FROM customers where loginID = ?");

+

+        select.setParameter(1, logonID);

+

+        DataObject root = select.executeQuery();

+        conn.close();

+

+        Collection customers = root.getList("CustomerProfileData");

+        CustomerProfileData customerProfileData = (CustomerProfileData) customers.iterator().next();

+        System.out.println(customerProfileData);

+        System.out.flush();

+        return customerProfileData;

+

+    }

+

+    protected void readDBstdout(PrintStream stream) throws Exception {

+        Connection conn = null;

+        try {

+            conn = createConnection(dbDirectory);

+            Statement s = conn.createStatement();

+            ResultSet rs = s.executeQuery("SELECT firstName, lastName, loginID, password, id FROM customers ORDER BY lastName");

+            while (rs.next()) {

+                stream.print(rs.getString(1));

+                stream.print(" ");

+                stream.print(rs.getString(2));

+                stream.print(" ");

+                stream.print(rs.getString(3));

+                stream.print(" ");

+                stream.print(rs.getString(4));

+                stream.print(" ");

+                stream.print(rs.getString(5));

+                stream.println();

+                int id = rs.getInt(5);

+                Statement s1 = conn.createStatement();

+                ResultSet rs1 = s1.executeQuery("SELECT accountNumber, accountType, balance FROM accounts where id=" + id);

+                stream.println("====Customers accounts");

+                while (rs1.next()) {

+                    stream.print("\t");

+                    stream.print(rs1.getString(1));

+                    stream.print(" ");

+                    stream.print(rs1.getString(2));

+                    stream.print(" ");

+                    stream.print(rs1.getString(3));

+                    stream.println();

+                }

+                rs1.close();

+                rs1 = s1.executeQuery("SELECT symbol, quantity, purchasePrice, purchaseDate,  purchaseLotNumber FROM stocks where id=" + id);

+                stream.println("====Customers Stocks");

+                while (rs1.next()) {

+                    stream.print("\t");

+                    stream.print(rs1.getString(1));

+                    stream.print(" ");

+                    stream.print(rs1.getString(2));

+                    stream.print(" ");

+                    stream.print(rs1.getString(3));

+                    stream.print(" ");

+                    stream.print(rs1.getString(4));

+                    stream.print(" ");

+                    stream.print(rs1.getString(5));

+                    stream.println();

+                }

+                s1.close();

+                stream.println();

+

+            }

+            s.close();

+            conn.commit();

+        } catch (Exception e) {

+            e.printStackTrace();

+        } finally {

+            if (conn != null) {

+                conn.close();

+            }

+            conn = null;

+        }

+

+    }

+

+    public static class MyDateConverter implements Converter {

+

+        private static final DateFormat tsformat = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");

+

+        public Object getPropertyValue(Object columnData) {

+

+            try {

+                return tsformat.parse(columnData.toString());

+            } catch (ParseException e) {

+

+                e.printStackTrace();

+                throw new IllegalArgumentException(e);

+            }

+

+        }

+

+        public Object getColumnValue(Object propertyData) {

+

+            if (propertyData instanceof Date) {

+                return tsformat.format(propertyData);

+            } else {

+                throw new IllegalArgumentException();

+            }

+

+        }

+

+    }

+

+    /**

+     * @param args

+     */

+    public static void main(String[] args) throws Exception {

+        registerTypes();

+        String dbDirectory = null; // "c:/derbydbtest/foo";

+        String dasConfigFile = null;

+        Boolean deleteExisting = false;

+        for (String x : args) {

+            if ("-d".equals(x)) {

+                deleteExisting = true;

+            }

+            if (x.startsWith("-db:")) {

+                dbDirectory = x.substring("-db:".length());

+            }

+            if (x.startsWith("-config:")) {

+                dasConfigFile = x.substring("-config:".length());

+                ;

+            }

+

+        }

+        AccountDBInit accountDBInit = new AccountDBInit(dbDirectory, dasConfigFile, deleteExisting);

+

+        createDB(dbDirectory);

+

+        accountDBInit.readDBstdout(System.out);

+

+        // Test withdrawl

+        withdraw wd = AccountFactory.INSTANCE.createwithdraw();

+        wd.setAccountNumber("134-43-3942");

+        wd.setAmount(1.00F);

+        accountDBInit.testWithdrawThroughDAS(wd);

+

+        accountDBInit.readDBstdout(System.out);

+

+        // test stock purchase.

+        purchaseStock sp = AccountFactory.INSTANCE.createpurchaseStock();

+        StockSummary stock = AccountFactory.INSTANCE.createStockSummary();

+        stock.setSymbol("GOOG");

+        stock.setQuantity(10);

+        stock.setPurchasePrice(25.00F);

+        sp.setId(1);

+        sp.setStock(stock);

+

+        accountDBInit.testStrockPurchaseThroughDAS(sp);

+

+        accountDBInit.readDBstdout(System.out);

+

+        System.out.flush();

+    }

+}

diff --git a/branches/sca-java-0.99/samples/old/bigbank/account/src/main/java/bigbank/account/services/accountlogger/AccountLoggerDataServiceImpl.java b/branches/sca-java-0.99/samples/old/bigbank/account/src/main/java/bigbank/account/services/accountlogger/AccountLoggerDataServiceImpl.java
new file mode 100644
index 0000000000..2360344cd1
--- /dev/null
+++ b/branches/sca-java-0.99/samples/old/bigbank/account/src/main/java/bigbank/account/services/accountlogger/AccountLoggerDataServiceImpl.java
@@ -0,0 +1,129 @@
+/*

+ * 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 bigbank.account.services.accountlogger;

+

+import java.rmi.RemoteException;

+

+import org.osoa.sca.annotations.Reference;

+import org.osoa.sca.annotations.Service;

+

+import bigbank.account.services.accountdata.AccountDataService;

+import bigbank.account.services.accountdata.CustomerIdService;

+

+import com.bigbank.account.AccountLog;

+import com.bigbank.account.AccountReport;

+import com.bigbank.account.CustomerProfileData;

+import com.bigbank.account.StockSummary;

+

+/**

+ * This class implements the Account Data Logger service component.

+ */

+@Service(AccountDataService.class)

+public class AccountLoggerDataServiceImpl implements AccountDataService {

+

+    private CustomerIdService accountDataService; // TODO fix this!

+

+    @Reference

+    public void setAccountDataService(CustomerIdService accountDataService) {

+        this.accountDataService = accountDataService;

+    }

+

+    private AccountLoggerService accountLoggerService;

+

+    @Reference

+    public void setAccountLoggerService(AccountLoggerService accountLoggerService) {

+        this.accountLoggerService = accountLoggerService;

+    }

+

+    public StockSummary purchaseStock(int id, StockSummary stock) throws RemoteException {

+        accountLoggerService.logPurchaseStock(id, stock);

+

+        return accountDataService.purchaseStock(id, stock);

+    }

+

+    public CustomerProfileData getCustomerProfile(String logonID) throws RemoteException {

+

+        return accountDataService.getCustomerProfile(logonID);

+    }

+

+    public float deposit(String account, float amount) throws RemoteException {

+        try {

+            if (!(accountDataService instanceof CustomerIdService)) {

+                throw new RemoteException("Can't use data service as customer id service");

+            }

+            int id = accountDataService.getCustomerIdByAccount(account);

+            // int id = accountDataService.getCustomerIdByAccount(account);

+            accountLoggerService.logDeposit(id, account, amount);

+

+            return accountDataService.deposit(account, amount);

+        } catch (RemoteException e) {

+            e.printStackTrace();

+            throw e;

+        } catch (Exception e) {

+            e.printStackTrace();

+            throw new RemoteException(e.getClass() + " " + e.getMessage(), e);

+        }

+    }

+

+    public CustomerProfileData createAccount(CustomerProfileData customerProfile, boolean createSavings, boolean createChecking)

+            throws RemoteException {

+

+        return accountDataService.createAccount(customerProfile, createSavings, createChecking);

+    }

+

+    public StockSummary sellStock(int purchaseLotNumber, int quantity) throws RemoteException {

+        try {

+            int id = accountDataService.getCustomerIdByPurchaseLotNumber(purchaseLotNumber);

+            StockSummary ss = accountDataService.sellStock(purchaseLotNumber, quantity);

+            if (ss != null) {

+                if (!(accountDataService instanceof CustomerIdService)) {

+                    throw new RemoteException("Can't use data service as customer id service");

+                }

+                accountLoggerService.logSellStock(id, ss, quantity);

+            }

+            return ss;

+        } catch (RemoteException e) {

+            e.printStackTrace();

+            throw e;

+        } catch (Exception e) {

+            e.printStackTrace();

+            throw new RemoteException(e.getClass() + " " + e.getMessage(), e);

+        }

+    }

+

+    public float withdraw(String account, float amount) throws RemoteException {

+        if (!(accountDataService instanceof CustomerIdService)) {

+            throw new RemoteException("Can't use data service as customer id service");

+        }

+        int id = accountDataService.getCustomerIdByAccount(account);

+        // int id = accountDataService.getCustomerIdByAccount(account);

+        accountLoggerService.logWithdrawal(id, account, amount);

+

+        return accountDataService.withdraw(account, amount);

+    }

+

+    public AccountReport getAccountReport(final int customerID) throws RemoteException {

+

+        return accountDataService.getAccountReport(customerID);

+    }

+

+    public AccountLog getAccountLog(final int customerID) throws RemoteException {

+        return accountLoggerService.getAccountLog(customerID);

+    }

+}

diff --git a/branches/sca-java-0.99/samples/old/bigbank/account/src/main/java/bigbank/account/services/accountlogger/AccountLoggerService.java b/branches/sca-java-0.99/samples/old/bigbank/account/src/main/java/bigbank/account/services/accountlogger/AccountLoggerService.java
new file mode 100644
index 0000000000..b9b2821d38
--- /dev/null
+++ b/branches/sca-java-0.99/samples/old/bigbank/account/src/main/java/bigbank/account/services/accountlogger/AccountLoggerService.java
@@ -0,0 +1,47 @@
+/*

+ * 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 bigbank.account.services.accountlogger;

+

+import java.rmi.RemoteException;

+

+import org.osoa.sca.annotations.OneWay;

+

+import com.bigbank.account.AccountLog;

+import com.bigbank.account.StockSummary;

+

+/**

+ * This is the business interface of the Account Logger service component.

+ */

+public interface AccountLoggerService {

+

+    @OneWay

+    public void logDeposit(int id, String account, float amount) throws RemoteException;

+

+    @OneWay

+    public void logWithdrawal(int id, String account, float amount) throws RemoteException;

+

+    @OneWay

+    public void logPurchaseStock(int id, StockSummary stock) throws RemoteException;

+

+    @OneWay

+    public void logSellStock(int id, StockSummary stock, int quantity) throws RemoteException;

+

+    public AccountLog getAccountLog(int id) throws RemoteException;

+

+}

diff --git a/branches/sca-java-0.99/samples/old/bigbank/account/src/main/java/bigbank/account/services/accountlogger/AccountLoggerServiceImpl.java b/branches/sca-java-0.99/samples/old/bigbank/account/src/main/java/bigbank/account/services/accountlogger/AccountLoggerServiceImpl.java
new file mode 100644
index 0000000000..8919aad311
--- /dev/null
+++ b/branches/sca-java-0.99/samples/old/bigbank/account/src/main/java/bigbank/account/services/accountlogger/AccountLoggerServiceImpl.java
@@ -0,0 +1,216 @@
+/*

+ * 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 bigbank.account.services.accountlogger;

+

+import java.io.InputStream;

+import java.rmi.RemoteException;

+import java.sql.Connection;

+import java.sql.DriverManager;

+import java.sql.ResultSet;

+import java.sql.Statement;

+import java.util.Properties;

+

+import org.apache.tuscany.das.rdb.Command;

+import org.apache.tuscany.das.rdb.DAS;

+import org.osoa.sca.annotations.Service;

+

+import com.bigbank.account.AccountFactory;

+import com.bigbank.account.AccountLog;

+import com.bigbank.account.StockSummary;

+import commonj.sdo.DataObject;

+

+/**

+ * This class implements the Account Logger service component.

+ */

+@Service(AccountLoggerService.class)

+public class AccountLoggerServiceImpl implements AccountLoggerService {

+

+    public static final String ACCT_ACTION_TYPE_DEPOSIT = "deposit";

+

+    public static final String ACCT_ACTION_TYPE_WITHDRAW = "withdraw";

+

+    public static final String STOCK_ACTION_TYPE_PURCHASE = "purchase";

+

+    public static final String STOCK_ACTION_TYPE_SELL = "sell";

+

+    static public String dbDirectory = null;

+

+    protected static final String driver = "org.apache.derby.jdbc.EmbeddedDriver";

+

+    protected static final String protocol = "jdbc:derby:";

+

+    public void logDeposit(int id, String account, float amount) throws RemoteException {

+        DAS das = DAS.FACTORY.createDAS(getConnection());

+        Command insert = das.createCommand("insert into acctLog (id, accountNumber, actionType, amount) values (?,?,?,?)");

+        insert.setParameter(1, new Integer(id));

+        insert.setParameter(2, account);

+        insert.setParameter(3, ACCT_ACTION_TYPE_DEPOSIT);

+        insert.setParameter(4, new Float(amount));

+

+        insert.execute();

+        /*

+         * performLog("insert into acctLog (id, accountNumber, actionType, amount) values (" + id + ", '" + account + "', '" +

+         * ACCT_ACTION_TYPE_DEPOSIT + "', " + amount + ")");

+         */

+    }

+

+    public void logWithdrawal(int id, String account, float amount) throws RemoteException {

+        DAS das = DAS.FACTORY.createDAS(getConnection());

+        Command insert = das.createCommand("insert into acctLog (id, accountNumber, actionType, amount) values (?,?,?,?)");

+        insert.setParameter(1, new Integer(id));

+        insert.setParameter(2, account);

+        insert.setParameter(3, ACCT_ACTION_TYPE_WITHDRAW);

+        insert.setParameter(4, new Float(amount));

+

+        insert.execute();

+        /*

+         * performLog("insert into acctLog (id ,accountNumber, actionType, amount) values (" + id + ", '" + account + "', '" +

+         * ACCT_ACTION_TYPE_WITHDRAW + "', " + amount + ")");

+         */

+    }

+

+    public void logPurchaseStock(int id, StockSummary stock) throws RemoteException {

+        DAS das = DAS.FACTORY.createDAS(getConnection());

+        Command insert = das.createCommand("insert into stockLog (id, Symbol, quantity, actionType, purchaseLotNumber) values (?,?,?,?,?)");

+        insert.setParameter(1, new Integer(id));

+        insert.setParameter(2, stock.getSymbol());

+        insert.setParameter(3, new Integer(stock.getQuantity()));

+        insert.setParameter(4, STOCK_ACTION_TYPE_PURCHASE);

+        insert.setParameter(5, new Integer(stock.getPurchaseLotNumber()));

+

+        insert.execute();

+        /*

+         * performLog("insert into stockLog (id, Symbol, quantity, actionType, purchaseLotNumber) values (" + id + ", '" + stock.getSymbol() + "', " +

+         * stock.getQuantity() + ", '" + STOCK_ACTION_TYPE_PURCHASE + ", " + stock.getPurchaseLotNumber() + ")");

+         */

+    }

+

+    public void logSellStock(int id, StockSummary stock, int quantity) throws RemoteException {

+

+        String symbol = ((stock.getSymbol() != null) ? stock.getSymbol() : "null");

+        DAS das = DAS.FACTORY.createDAS(getConnection());

+        Command insert = das.createCommand("insert into stockLog (id, Symbol, quantity, actionType, purchaseLotNumber) values (?,?,?,?,?)");

+        insert.setParameter(1, new Integer(id));

+        insert.setParameter(2, symbol);

+        insert.setParameter(3, new Integer(quantity));

+        insert.setParameter(4, STOCK_ACTION_TYPE_SELL);

+        insert.setParameter(5, new Integer(stock.getPurchaseLotNumber()));

+

+        insert.execute();

+        /*

+         * performLog("insert into stockLog (id, Symbol, quantity, actionType, purchaseLotNumber) values (" + id + ", '" + stock.getSymbol() + "', " +

+         * quantity + ", '" + STOCK_ACTION_TYPE_SELL + ", " + stock.getPurchaseLotNumber() + ")");

+         */

+    }

+

+    private void performLog(String toLog) throws RemoteException {

+

+        try {

+            Connection conn = getConnection();

+

+            Statement s = conn.createStatement();

+

+            s.execute(toLog);

+

+            conn.commit();

+

+            System.out.println("SN id acctNo action amount");

+            ResultSet rs = s.executeQuery("select * from acctLog");

+            while (rs.next()) {

+                System.out.println(rs.getInt("logSeqNo") + " " + rs.getInt("id") + " " + rs.getString("accountNumber") + " "

+                        + rs.getString("actionType") + " " + rs.getFloat("amount"));

+            }

+

+            conn.commit();

+

+            System.out.println("SN Symbol qty action plot#");

+            rs = s.executeQuery("select * from stockLog");

+            while (rs.next()) {

+                System.out.println(rs.getInt("logSeqNo") + " " + rs.getString("Symbol") + " " + rs.getInt("quantity") + " "

+                        + rs.getString("actionType") + " " + rs.getInt("purchaseLotNumber"));

+            }

+

+            conn.commit();

+

+            s.close();

+

+            conn.close();

+        } catch (Exception e) {

+            e.printStackTrace();

+            throw new RemoteException(e.getClass().getName(), e);

+        }

+

+        System.out.println("Logged " + toLog);

+    }

+

+    protected Connection getConnection() throws RemoteException {

+        try {

+            Connection conn;

+            Class.forName(driver).newInstance();

+            Properties props = new Properties();

+            // props.put("user", "tuscany");

+            // props.put("password", "tuscany");

+            conn = DriverManager.getConnection(protocol + dbDirectory + ";create=true", props);

+

+            conn.setAutoCommit(false);

+            return conn;

+        } catch (Exception e) {

+            e.printStackTrace();

+            throw new RemoteException(e.getClass().getName(), e);

+        }

+    }

+

+    public AccountLog getAccountLog(final int customerID) throws RemoteException {

+

+        try {

+            final AccountFactory accountFactory = AccountFactory.INSTANCE;

+            final AccountLog accountLog = accountFactory.createAccountLog();

+            InputStream mapping = createConfigStream();

+

+            Connection conn = getConnection();

+            DAS das = DAS.FACTORY.createDAS(mapping, conn);

+            Command select = das.createCommand("SELECT logSeqNo, accountNumber, actionType, amount FROM acctLog where id = ?");

+

+            select.setParameter(1, customerID);

+

+            DataObject root = select.executeQuery();

+            accountLog.getAccountLogEntries().addAll(root.getList("AccountLogEntry"));

+

+            select = das.createCommand("SELECT logSeqNo, Symbol, quantity, actionType, purchaseLotNumber  FROM stockLog where id = ?");

+            select.setParameter(1, customerID);

+            root = select.executeQuery();

+            accountLog.getStockLogEntries().addAll(root.getList("StockLogEntry"));

+

+            conn.close();

+

+            return accountLog;

+        } catch (Exception e) {

+            if (e instanceof RemoteException) {

+                throw (RemoteException) e;

+            }

+            throw new RemoteException("getAccountLog failed. customerID ('" + customerID + "')" + e.getClass().getName() + "'. " + e.getMessage(), e);

+        }

+    }

+

+    protected InputStream createConfigStream() {

+        InputStream mapping = getClass().getClassLoader().getResourceAsStream("DasAccountConfiguration.xml");

+        return mapping;

+    }

+

+}

diff --git a/branches/sca-java-0.99/samples/old/bigbank/account/src/main/java/bigbank/account/services/stockquote/StockQuote.java b/branches/sca-java-0.99/samples/old/bigbank/account/src/main/java/bigbank/account/services/stockquote/StockQuote.java
new file mode 100644
index 0000000000..c7498f093d
--- /dev/null
+++ b/branches/sca-java-0.99/samples/old/bigbank/account/src/main/java/bigbank/account/services/stockquote/StockQuote.java
@@ -0,0 +1,228 @@
+/*

+ * 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 bigbank.account.services.stockquote;

+

+public class StockQuote {

+

+    private String companyName;

+

+    private String symbol;

+

+    private String stockQuote;

+

+    private String lastUpdated;

+

+    private String change;

+

+    private String openPrice;

+

+    private String dayHighPrice;

+

+    private String dayLowPrice;

+

+    private String volume;

+

+    private String marketCap;

+

+    private String yearRange;

+

+    private String exDividendDate;

+

+    private String dividendYield;

+

+    private String dividendPerShare;

+

+    /**

+     * <!-- begin-user-doc --> <!-- end-user-doc -->

+     * 

+     * @generated

+     */

+    protected StockQuote() {

+        super();

+    }

+

+    public String getCompanyName() {

+        return companyName;

+    }

+

+    public void setCompanyName(String newCompanyName) {

+        companyName = newCompanyName;

+    }

+

+    public String getSymbol() {

+        return symbol;

+    }

+

+    public void setSymbol(String newStockTicker) {

+        symbol = newStockTicker;

+    }

+

+    public String getStockQuote() {

+        return stockQuote;

+    }

+

+    public void setStockQuote(String newStockQuote) {

+        stockQuote = newStockQuote;

+    }

+

+    public String getLastUpdated() {

+        return lastUpdated;

+    }

+

+    public void setLastUpdated(String newLastUpdated) {

+        lastUpdated = newLastUpdated;

+    }

+

+    public String getChange() {

+        return change;

+    }

+

+    public void setChange(String newChange) {

+        change = newChange;

+    }

+

+    public String getOpenPrice() {

+        return openPrice;

+    }

+

+    public void setOpenPrice(String newOpenPrice) {

+        openPrice = newOpenPrice;

+    }

+

+    public String getDayHighPrice() {

+        return dayHighPrice;

+    }

+

+    public void setDayHighPrice(String newDayHighPrice) {

+        dayHighPrice = newDayHighPrice;

+    }

+

+    public String getDayLowPrice() {

+        return dayLowPrice;

+    }

+

+    public void setDayLowPrice(String newDayLowPrice) {

+        dayLowPrice = newDayLowPrice;

+    }

+

+    public String getVolume() {

+        return volume;

+    }

+

+    public void setVolume(String newVolume) {

+        volume = newVolume;

+    }

+

+    public String getMarketCap() {

+        return marketCap;

+    }

+

+    public void setMarketCap(String newMarketCap) {

+        marketCap = newMarketCap;

+    }

+

+    public String getYearRange() {

+        return yearRange;

+    }

+

+    public void setYearRange(String newYearRange) {

+        yearRange = newYearRange;

+    }

+

+    public String getExDividendDate() {

+        return exDividendDate;

+    }

+

+    public void setExDividendDate(String newExDividendDate) {

+        exDividendDate = newExDividendDate;

+    }

+

+    public String getDividendYield() {

+        return dividendYield;

+    }

+

+    public void setDividendYield(String newDividendYield) {

+        dividendYield = newDividendYield;

+    }

+

+    public String getDividendPerShare() {

+        return dividendPerShare;

+    }

+

+    public void setDividendPerShare(String newDividendPerShare) {

+        dividendPerShare = newDividendPerShare;

+    }

+

+    @Override

+    public String toString() {

+

+        StringBuffer result = new StringBuffer(super.toString());

+        result.append(" (companyName: ");

+        result.append(companyName);

+        result.append(", symbol: ");

+        result.append(symbol);

+        result.append(", stockQuote: ");

+        result.append(stockQuote);

+        result.append(", lastUpdated: ");

+        result.append(lastUpdated);

+        result.append(", change: ");

+        result.append(change);

+        result.append(", openPrice: ");

+        result.append(openPrice);

+        result.append(", dayHighPrice: ");

+        result.append(dayHighPrice);

+        result.append(", dayLowPrice: ");

+        result.append(dayLowPrice);

+        result.append(", volume: ");

+        result.append(volume);

+        result.append(", marketCap: ");

+        result.append(marketCap);

+        result.append(", yearRange: ");

+        result.append(yearRange);

+        result.append(", exDividendDate: ");

+        result.append(exDividendDate);

+        result.append(", dividendYield: ");

+        result.append(dividendYield);

+        result.append(", dividendPerShare: ");

+        result.append(dividendPerShare);

+        result.append(')');

+        return result.toString();

+    }

+

+    @Override

+    public StockQuote clone() {

+        StockQuote ret = new StockQuote();

+        ret.companyName = companyName;

+        ret.symbol = symbol;

+        ret.stockQuote = stockQuote;

+        ret.lastUpdated = lastUpdated;

+        ret.change = change;

+        ret.openPrice = openPrice;

+        ret.dayHighPrice = dayHighPrice;

+        ret.dayLowPrice = dayLowPrice;

+        ret.volume = volume;

+        ret.marketCap = marketCap;

+        ret.yearRange = yearRange;

+        ret.exDividendDate = exDividendDate;

+        ret.dividendYield = dividendYield;

+        ret.dividendPerShare = dividendPerShare;

+        return ret;

+    }

+

+}

diff --git a/branches/sca-java-0.99/samples/old/bigbank/account/src/main/java/bigbank/account/services/stockquote/StockQuoteService.java b/branches/sca-java-0.99/samples/old/bigbank/account/src/main/java/bigbank/account/services/stockquote/StockQuoteService.java
new file mode 100644
index 0000000000..9d5c243f9a
--- /dev/null
+++ b/branches/sca-java-0.99/samples/old/bigbank/account/src/main/java/bigbank/account/services/stockquote/StockQuoteService.java
@@ -0,0 +1,31 @@
+/*
+ * 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 bigbank.account.services.stockquote;
+
+import java.rmi.RemoteException;
+import java.util.Map;
+
+/**
+ * This is the business interface of the HelloWorld service component.
+ */
+public interface StockQuoteService {
+
+    public Map getQuotes(String[] symbols) throws RemoteException;
+
+}
diff --git a/branches/sca-java-0.99/samples/old/bigbank/account/src/main/java/bigbank/account/services/stockquote/StockQuoteServiceImpl.java b/branches/sca-java-0.99/samples/old/bigbank/account/src/main/java/bigbank/account/services/stockquote/StockQuoteServiceImpl.java
new file mode 100644
index 0000000000..b0c31d4d81
--- /dev/null
+++ b/branches/sca-java-0.99/samples/old/bigbank/account/src/main/java/bigbank/account/services/stockquote/StockQuoteServiceImpl.java
@@ -0,0 +1,68 @@
+/*
+ * 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 bigbank.account.services.stockquote;
+
+import java.rmi.RemoteException;
+import java.util.Hashtable;
+import java.util.Map;
+import java.util.Random;
+
+/* Mock StockQuoteService */
+
+public class StockQuoteServiceImpl implements StockQuoteService {
+
+    static Random rn = new Random();
+
+    static Hashtable<String, StockQuote> stocks = new Hashtable<String, StockQuote>();
+
+    public synchronized Map getQuotes(String[] symbols) throws RemoteException {
+        Map<String, StockQuote> ret = new Hashtable<String, StockQuote>();
+        for (String sym : symbols) {
+            sym = sym.toUpperCase();
+            if (!ret.containsKey(sym)) {
+                StockQuote sq = stocks.get(sym);
+                if (sq == null) {
+                    sq = new StockQuote();
+                    stocks.put(sym, sq);
+                    sq.setSymbol(sym);
+                    sq.setCompanyName(sym + " INC");
+                    float val = rn.nextFloat() * 97.0F + 3.0F;
+                    sq.setStockQuote(val + "");
+                    sq.setDayHighPrice(val + "");
+                    sq.setDayLowPrice(val + "");
+                    sq.setOpenPrice(val + "");
+                } else {
+                    float diff = (rn.nextFloat() * 2.0F) - 1;
+                    float newval = new Float(sq.getStockQuote()) + diff; // auto boxing cool.
+                    sq.setStockQuote(newval + "");
+                    float dh = Math.max(newval, new Float(sq.getDayHighPrice()));
+                    sq.setDayHighPrice(dh + "");
+                    float dl = Math.min(newval, new Float(sq.getDayLowPrice()));
+                    sq.setDayLowPrice(dl + "");
+
+                }
+                ret.put(sym, sq.clone());
+            }
+
+        }
+
+        return ret;
+    }
+
+}
diff --git a/branches/sca-java-0.99/samples/old/bigbank/account/src/main/java/bigbank/account/services/stockquote/StockQuoteWebservicexServiceImpl.java b/branches/sca-java-0.99/samples/old/bigbank/account/src/main/java/bigbank/account/services/stockquote/StockQuoteWebservicexServiceImpl.java
new file mode 100644
index 0000000000..053f9d7f16
--- /dev/null
+++ b/branches/sca-java-0.99/samples/old/bigbank/account/src/main/java/bigbank/account/services/stockquote/StockQuoteWebservicexServiceImpl.java
@@ -0,0 +1,153 @@
+/*

+ * 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 bigbank.account.services.stockquote;

+

+import java.io.ByteArrayInputStream;

+import java.io.InputStream;

+import java.lang.reflect.Method;

+import java.rmi.RemoteException;

+import java.util.ArrayList;

+import java.util.Hashtable;

+import java.util.Map;

+

+import javax.xml.stream.XMLInputFactory;

+import javax.xml.stream.XMLStreamConstants;

+import javax.xml.stream.XMLStreamReader;

+

+import net.x.webservice.StockQuoteSoap;

+

+import org.osoa.sca.annotations.Reference;

+import org.osoa.sca.annotations.Scope;

+import org.osoa.sca.annotations.Service;

+

+/**

+ * This class implements the Stock quote service component.

+ */

+@Service(StockQuoteService.class)

+@Scope("COMPOSITE")

+public class StockQuoteWebservicexServiceImpl implements StockQuoteService {

+

+    @Reference

+    public StockQuoteSoap stockQuoteService = null; // Injected by the SCA container.

+

+    /**

+     * @throws RemoteException

+     * @see bigbank.account.services.stockquote.StockQuoteService#getQuotes(String[])

+     */

+    public Map getQuotes(final String[] symbols) throws RemoteException {

+        try {

+            assert null != stockQuoteService : "stockQuoteService was not set by the SCA runtime!";

+            StringBuilder sb = new StringBuilder(5 * symbols.length);

+            for (String sym : symbols) {

+                if (sb.length() != 0) {

+                    sb.append(' ');

+                }

+                sb.append(sym);

+            }

+            String stockdata = stockQuoteService.GetQuote(sb.toString());

+

+            InputStream in = new ByteArrayInputStream(stockdata.getBytes());

+            XMLInputFactory factory = XMLInputFactory.newInstance();

+            XMLStreamReader parser = factory.createXMLStreamReader(in);

+            ArrayList<StockQuote> listQuotes = new ArrayList<StockQuote>();

+            Hashtable<String, StockQuote> listQuoteHT = new Hashtable<String, StockQuote>();

+            MapStock currentStock = null;

+            StringBuilder currentText = new StringBuilder(100);

+            for (int event = parser.next(); event != XMLStreamConstants.END_DOCUMENT; event = parser.next()) {

+                String lname;

+                switch (event) {

+                case XMLStreamConstants.START_ELEMENT:

+                    if (parser.getLocalName() == "Stock") {

+

+                        currentStock = new MapStock();

+                        listQuotes.add(currentStock);

+                    }

+                    break;

+                case XMLStreamConstants.END_ELEMENT:

+                    lname = parser.getLocalName();

+                    String mname = "set" + lname;

+                    try {

+                        Method setter = MapStock.class.getMethod(mname, new Class[] { String.class });

+                        if (setter != null) {

+                            setter.invoke(currentStock, currentText.toString());

+                            if (lname.equals("Symbol")) {

+                                listQuoteHT.put(currentText.toString(), currentStock);

+

+                            }

+                        }

+                    } catch (NoSuchMethodException e) {

+

+                    }

+                    // System.err.println(parser.getLocalName() + ":" + currentText.toString());

+                    currentText.setLength(0);

+                    break;

+                case XMLStreamConstants.CHARACTERS:

+                    // System.out.print(parser.getText());

+                    currentText.append(parser.getText());

+                    break;

+                case XMLStreamConstants.CDATA:

+                    // System.out.print(parser.getText());

+                    currentText.append(parser.getText());

+                    break;

+                } // end switch

+            } // end while

+            parser.close();

+

+            return listQuoteHT;

+        } catch (Exception e) {

+            e.printStackTrace();

+            throw new RemoteException(e.getClass().getName() + e.getMessage(), e);

+        }

+    }

+

+    public static class MapStock extends StockQuote {

+

+        public void setLast(String val) {

+            super.setStockQuote(val);

+        }

+

+        public void setDate(String val) {

+        };

+

+        public void setTime(String val) {

+        };

+

+        public void setHigh(String val) {

+            super.setDayHighPrice(val);

+        }

+

+        public void setLow(String val) {

+            super.setDayLowPrice(val);

+        }

+

+        public void setOpen(String val) {

+            super.setOpenPrice(val);

+        }

+

+        public void setMktCap(String val) {

+            super.setMarketCap(val);

+        }

+

+        public void setName(String val) {

+            super.setCompanyName(val);

+        }

+

+    }

+

+}

diff --git a/branches/sca-java-0.99/samples/old/bigbank/account/src/main/resources/DasAccountConfiguration.xml b/branches/sca-java-0.99/samples/old/bigbank/account/src/main/resources/DasAccountConfiguration.xml
new file mode 100644
index 0000000000..ed1553eb40
--- /dev/null
+++ b/branches/sca-java-0.99/samples/old/bigbank/account/src/main/resources/DasAccountConfiguration.xml
@@ -0,0 +1,79 @@
+<?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 xmlns="http:///org.apache.tuscany.das.rdb/config.xsd" dataObjectModel="http://www.bigbank.com/account">

+  

+  <Table tableName="CUSTOMERS" typeName="CustomerProfileData">

+    <!-- Column name="firstName" primaryKey="true"/ -->

+    <Column columnName="FIRSTNAME"/>

+    <Column columnName="LASTNAME"/> 

+    <Column columnName="ADDRESS"/> 

+    <Column columnName="EMAIL"/>

+     <Column columnName="LOGINID"/> 

+     <Column columnName="PASSWORD"/> 

+      <Column columnName="ID"/> 

+  </Table>

+  

+  <Table tableName="ACCOUNTS" typeName="AccountSummary">

+    <!-- Column name="firstName" primaryKey="true"/ -->

+    <Column columnName="ACCOUNTNUMBER"/>

+    <Column columnName="BALANCE"/> 

+  </Table>

+

+

+

+  <Table tableName="STOCKS" typeName="StockSummary" >

+    <Column columnName="ID" propertyName="id"/>

+    <Column columnName="Symbol" propertyName="symbol"/>

+    <Column columnName="quantity" propertyName="quantity"/>

+    <Column columnName="purchasePrice" propertyName="purchasePrice"/>

+    <Column columnName="PURCHASEDATE"  propertyName="purchaseDate" converterClassName="bigbank.account.services.accountdata.AccountDataServiceDASImpl$DateConverter"/>

+  </Table>

+

+	

+  <Table tableName="ACCTLOG" typeName="AccountLogEntry">

+    <Column columnName="logSeqNo"/>

+    <Column columnName="ID"/> 

+    <Column columnName="ACCOUNTNUMBER"/>

+    <Column columnName="ACTIONTYPE"/>

+    <Column columnName="AMOUNT"/> 

+  </Table>

+

+

+

+  <Table tableName="STOCKLOG" typeName="StockLogEntry" >

+    <Column columnName="logSeqNo"/>

+    <Column columnName="ID"/>

+    <Column columnName="Symbol"/>

+    <Column columnName="quantity"/>

+    <Column columnName="actionType"/>

+    <Column columnName="purchaseLotNumber"/>

+  </Table>

+

+

+  <Command name="get account" SQL="SELECT accountNumber, accountType, balance FROM accounts where accountNumber = ?" kind="Select" />    	

+  <Command name="update balance" SQL="update ACCOUNTS set BALANCE = ? where ACCOUNTNUMBER = ?" kind="Update" />    

+

+  <Command name="all customers" SQL="select * from CUSTOMERS"  kind="Select"/>

+

+  <Command name="all stocks" SQL="select symbol, quantity, purchaseprice, purchasedate from stocks"  kind="Select"/>

+  <Command name="stockbylotSelect" SQL="select quantity  from STOCKS  WHERE purchaseLotNumber = ?"  kind="Select" />

+  <Command name="stockbylot" SQL="update STOCKS set quantity = ? WHERE purchaseLotNumber = ?"  kind="Update" />

+	

+</Config>

diff --git a/branches/sca-java-0.99/samples/old/bigbank/account/src/main/resources/wsdl/AccountService.wsdl b/branches/sca-java-0.99/samples/old/bigbank/account/src/main/resources/wsdl/AccountService.wsdl
new file mode 100644
index 0000000000..5e8ced28e0
--- /dev/null
+++ b/branches/sca-java-0.99/samples/old/bigbank/account/src/main/resources/wsdl/AccountService.wsdl
@@ -0,0 +1,467 @@
+<?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.    

+-->

+<wsdl:definitions xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/"

+	xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/"

+	xmlns:xsd="http://www.w3.org/2001/XMLSchema"

+	xmlns:account="http://www.bigbank.com/account"

+	targetNamespace="http://www.bigbank.com/account"

+	name="AccountService">

+

+	<wsdl:types>

+		<xsd:schema targetNamespace="http://www.bigbank.com/account"

+			xmlns:xsd="http://www.w3.org/2001/XMLSchema"

+			xmlns:account="http://www.bigbank.com/account"

+			

+			> <!-- xmlns:sdojava="commonj.sdo/java" sdojava:package="org.apache.tuscany.samples.bigbank.account" -->

+			

+			

+<!--	<xsd:complexType name="DataGraphRoot">	

+	 	<xsd:sequence>

+            <xsd:element name="customerProfileData" type="account:CustomerProfileData" maxOccurs="unbounded" minOccurs="0" />

+            <xsd:element name="StockSummaries" type="account:StockSummary" maxOccurs="unbounded" minOccurs="0" />

+            <xsd:element name="AccountSummaries" type="account:AccountSummary" maxOccurs="unbounded" minOccurs="0" />

+            <xsd:element name="StockLogEntries" type="account:StockLogEntry" maxOccurs="unbounded" minOccurs="0" />

+            <xsd:element name="AccountLogEntries" type="account:AccountLogEntry" maxOccurs="unbounded" minOccurs="0" />

+        </xsd:sequence>

+	</xsd:complexType>-->

+			

+

+			<xsd:element name="getAccountReport">

+				<xsd:complexType>

+					<xsd:sequence>

+						<xsd:element name="customerID"

+							type="xsd:int" />

+					</xsd:sequence>

+				</xsd:complexType>

+			</xsd:element>

+			<xsd:element name="getAccountReportResponse">

+				<xsd:complexType>

+					<xsd:sequence>

+						<xsd:element name="accountReport"

+							type="account:AccountReport" />

+					</xsd:sequence>

+				</xsd:complexType>

+			</xsd:element>

+

+			<xsd:complexType name="AccountReport">

+				<xsd:sequence>

+					<xsd:element name="accountSummaries"

+						type="account:AccountSummary" maxOccurs="unbounded" />

+					<xsd:element name="stockSummaries"

+						type="account:StockSummary" maxOccurs="unbounded" />

+						

+				</xsd:sequence>

+			</xsd:complexType>

+			<xsd:complexType name="AccountSummary">

+				<xsd:attribute name="accountNumber" type="xsd:string" />

+				<xsd:attribute name="accountType" type="xsd:string" />

+				<xsd:attribute name="balance" type="xsd:float" />

+			</xsd:complexType>

+

+			<xsd:complexType name="StockSummary">

+			    <!-- xsd:attribute name="id" type="xsd:int" / -->

+				<xsd:attribute name="purchaseLotNumber" type="xsd:int" />

+				<!-- unique id for this purchase -->

+				<xsd:attribute name="symbol" type="xsd:string" />

+				<xsd:attribute name="quantity" type="xsd:int" />

+				<xsd:attribute name="purchaseDate" type="xsd:dateTime" />

+				<xsd:attribute name="purchasePrice" type="xsd:float" />

+				<xsd:attribute name="currentPrice" type="xsd:float" />

+				<xsd:attribute name="company" type="xsd:string" />

+				<xsd:attribute name="highPrice" type="xsd:float" />

+				<xsd:attribute name="lowPrice" type="xsd:float" />

+				

+			</xsd:complexType>

+

+			<!-- Profile in data base  -->

+			<xsd:element name="getCustomerProfile">

+				<xsd:complexType>

+					<xsd:sequence>

+						<xsd:element name="loginID" type="xsd:string" />

+					</xsd:sequence>

+				</xsd:complexType>

+			</xsd:element>

+

+			<xsd:complexType name="CustomerProfileData">

+				<xsd:sequence>

+					<xsd:element name="firstName" type="xsd:string" />

+					<xsd:element name="lastName" type="xsd:string" />

+					<xsd:element name="address" type="xsd:string" />

+					<xsd:element name="email" type="xsd:string" />

+					<xsd:element name="loginID" type="xsd:string" />

+					<xsd:element name="password" type="xsd:string" />

+					<xsd:element name="id" type="xsd:int" />

+				</xsd:sequence>

+			</xsd:complexType>

+

+			<xsd:element name="getCustomerProfileResponse">

+				<xsd:complexType>

+					<xsd:sequence>

+						<xsd:element name="customerProfile"

+							type="account:CustomerProfileData" />

+					</xsd:sequence>

+				</xsd:complexType>

+			</xsd:element>

+

+			<xsd:element name="withdraw">

+				<xsd:complexType>

+					<xsd:sequence>

+						<xsd:element name="accountNumber"

+							type="xsd:string" />

+						<xsd:element name="amount" type="xsd:float" />

+					</xsd:sequence>

+				</xsd:complexType>

+			</xsd:element>

+			<xsd:element name="withdrawResponse">

+				<xsd:complexType>

+					<xsd:sequence>

+						<xsd:element name="balance" type="xsd:float" />

+					</xsd:sequence>

+				</xsd:complexType>

+			</xsd:element>

+

+			<xsd:element name="deposit">

+				<xsd:complexType>

+					<xsd:sequence>

+						<xsd:element name="accountNumber"

+							type="xsd:string" />

+						<xsd:element name="amount" type="xsd:float" />

+					</xsd:sequence>

+				</xsd:complexType>

+			</xsd:element>

+			<xsd:element name="depositResponse">

+				<xsd:complexType>

+					<xsd:sequence>

+						<xsd:element name="balance" type="xsd:float" />

+					</xsd:sequence>

+				</xsd:complexType>

+			</xsd:element>

+

+			<xsd:element name="purchaseStock">

+				<xsd:complexType>

+					<xsd:sequence>

+						<xsd:element name="id" type="xsd:int" />

+						<xsd:element name="stock" type="account:StockSummary" />

+					</xsd:sequence>

+				</xsd:complexType>

+			</xsd:element>

+

+			<xsd:element name="purchaseStockResponse">

+				<xsd:complexType>

+					<xsd:sequence>

+						<xsd:element name="purchaseSummary"

+							type="account:StockSummary" />

+					</xsd:sequence>

+				</xsd:complexType>

+			</xsd:element>

+

+

+

+			<xsd:element name="sellStock">

+				<xsd:complexType>

+					<xsd:sequence>

+						<xsd:element name="purchaseLotNumber"

+							type="xsd:int" /><!-- unique id for this purchase -->

+						<xsd:element name="quantity" type="xsd:int" />

+					</xsd:sequence>

+				</xsd:complexType>

+			</xsd:element>

+

+			<xsd:element name="createAccount">

+				<xsd:complexType>

+					<xsd:sequence>

+						<xsd:element name="customerProfile"

+							type="account:CustomerProfileData" />

+                        <xsd:element name="createSavings"

+							type="xsd:boolean" />

+                        <xsd:element name="createCheckings"

+							type="xsd:boolean" />

+					</xsd:sequence>

+				</xsd:complexType>

+			</xsd:element>	

+			<xsd:element name="createAccountResponse">

+				<xsd:complexType>

+					<xsd:sequence>

+						<xsd:element name="customerProfile"

+							type="account:CustomerProfileData" />

+					</xsd:sequence>

+				</xsd:complexType>

+				

+			</xsd:element>

+

+			<xsd:element name="getAccountLog">

+				<xsd:complexType>

+					<xsd:sequence>

+						<xsd:element name="customerID"

+							type="xsd:int" />

+					</xsd:sequence>

+				</xsd:complexType>

+			</xsd:element>

+			<xsd:element name="getAccountLogResponse">

+				<xsd:complexType>

+					<xsd:sequence>

+						<xsd:element name="accountLog"

+							type="account:AccountLog" />

+					</xsd:sequence>

+				</xsd:complexType>

+			</xsd:element>

+

+			<xsd:complexType name="AccountLog">

+				<xsd:sequence>

+					<xsd:element name="accountLogEntries"

+						type="account:AccountLogEntry" maxOccurs="unbounded" />

+					<xsd:element name="stockLogEntries"

+						type="account:StockLogEntry" maxOccurs="unbounded" />

+						

+				</xsd:sequence>

+			</xsd:complexType>

+

+			<xsd:complexType name="AccountLogEntry">

+				<xsd:attribute name="logSeqNo" type="xsd:int" />

+				<xsd:attribute name="id" type="xsd:int" />

+				<xsd:attribute name="accountNumber" type="xsd:string" />

+				<xsd:attribute name="actionType" type="xsd:string" />

+				<xsd:attribute name="amount" type="xsd:float" />

+			</xsd:complexType>

+

+			<xsd:complexType name="StockLogEntry">

+				<xsd:attribute name="logSeqNo" type="xsd:int" />

+				<xsd:attribute name="id" type="xsd:int" />

+				<xsd:attribute name="symbol" type="xsd:string" />

+				<xsd:attribute name="quantity" type="xsd:int" />

+				<xsd:attribute name="actionType" type="xsd:string" />

+				<xsd:attribute name="purchaseLotNumber" type="xsd:int" />

+			</xsd:complexType>

+

+		</xsd:schema>

+	</wsdl:types>

+	<wsdl:message name="getAccountReportRequest">

+		<wsdl:part element="account:getAccountReport"

+			name="getAccountReportRequest" />

+	</wsdl:message>

+	<wsdl:message name="getAccountReportResponse">

+		<wsdl:part element="account:getAccountReportResponse"

+			name="getAccountReportResponse" />

+	</wsdl:message>

+

+	<wsdl:message name="getCustomerProfileRequest">

+		<wsdl:part element="account:getCustomerProfile"

+			name="getCustomerProfile" />

+	</wsdl:message>

+	<wsdl:message name="getCustomerProfileResponse">

+		<wsdl:part element="account:getCustomerProfileResponse"

+			name="getCustomerProfileResponse" />

+	</wsdl:message>

+

+	<wsdl:message name="withdrawRequest">

+		<wsdl:part element="account:withdraw" name="withdrawRequest" />

+	</wsdl:message>

+

+	<wsdl:message name="withdrawResponse">

+		<wsdl:part element="account:withdrawResponse"

+			name="withdrawResponse" />

+	</wsdl:message>

+

+	<wsdl:message name="depositRequest">

+		<wsdl:part element="account:deposit" name="depositRequest" />

+	</wsdl:message>

+

+	<wsdl:message name="depositResponse">

+		<wsdl:part element="account:depositResponse"

+			name="depositResponse" />

+	</wsdl:message>

+

+	<wsdl:message name="purchaseStockRequest">

+		<wsdl:part element="account:purchaseStock"

+			name="purchaseStockRequest" />

+	</wsdl:message>

+

+	<wsdl:message name="purchaseStockResponse">

+		<wsdl:part element="account:purchaseStockResponse"

+			name="purchaseStockResponse" />

+	</wsdl:message>

+

+	<wsdl:message name="sellStockRequest">

+		<wsdl:part element="account:sellStock" name="sellStockRequest" />

+	</wsdl:message>

+	

+	<wsdl:message name="createAccountRequest">

+		<wsdl:part element="account:createAccount" name="createAccountRequest" />

+	</wsdl:message>

+

+	<wsdl:message name="createAccountResponse">

+		<wsdl:part element="account:createAccountResponse" name="createAccountResponse" />

+	</wsdl:message>

+

+	<wsdl:message name="getAccountLogRequest">

+		<wsdl:part element="account:getAccountLog"

+			name="getAccountLogRequest" />

+	</wsdl:message>

+	

+	<wsdl:message name="getAccountLogResponse">

+		<wsdl:part element="account:getAccountLogResponse"

+			name="getAccountLogResponse" />

+	</wsdl:message>

+

+	<wsdl:portType name="AccountService">

+		<wsdl:operation name="getAccountReport">

+			<wsdl:input message="account:getAccountReportRequest" />

+			<wsdl:output message="account:getAccountReportResponse" />

+		</wsdl:operation>

+

+		<wsdl:operation name="getCustomerProfile">

+			<wsdl:input message="account:getCustomerProfileRequest" />

+			<wsdl:output message="account:getCustomerProfileResponse" />

+		</wsdl:operation>

+

+		<wsdl:operation name="withdraw">

+			<wsdl:input message="account:withdrawRequest" />

+			<wsdl:output message="account:withdrawResponse" />

+		</wsdl:operation>

+

+		<wsdl:operation name="deposit">

+			<wsdl:input message="account:depositRequest" />

+			<wsdl:output message="account:depositResponse" />

+		</wsdl:operation>

+

+		<wsdl:operation name="purchaseStock">

+			<wsdl:input message="account:purchaseStockRequest" />

+			<wsdl:output message="account:purchaseStockResponse" />

+		</wsdl:operation>

+

+		<wsdl:operation name="sellStock">

+			<wsdl:input message="account:sellStockRequest" />

+			<wsdl:output message="account:purchaseStockResponse" />

+		</wsdl:operation>

+

+

+		<wsdl:operation name="createAccount">

+			<wsdl:input message="account:createAccountRequest" />

+			<wsdl:output message="account:createAccountResponse" />

+		</wsdl:operation>

+

+		<wsdl:operation name="getAccountLog">

+			<wsdl:input message="account:getAccountLogRequest" />

+			<wsdl:output message="account:getAccountLogResponse" />

+		</wsdl:operation>

+

+	</wsdl:portType>

+

+

+

+	<wsdl:binding name="AccountServiceSOAP" type="account:AccountService">

+		<soap:binding style="document"

+			transport="http://schemas.xmlsoap.org/soap/http" />

+		<wsdl:operation name="getAccountReport">

+			<soap:operation

+				soapAction="http://www.bigbank.com/account/getAccountReport" />

+			<wsdl:input>

+				<soap:body use="literal" />

+			</wsdl:input>

+			<wsdl:output>

+				<soap:body use="literal" />

+			</wsdl:output>

+		</wsdl:operation>

+		<wsdl:operation name="getCustomerProfile">

+			<soap:operation

+				soapAction="http://www.bigbank.com/account/getCustomerProfile" />

+			<wsdl:input>

+				<soap:body use="literal" />

+			</wsdl:input>

+			<wsdl:output>

+				<soap:body use="literal" />

+			</wsdl:output>

+		</wsdl:operation>

+

+		<wsdl:operation name="withdraw">

+			<soap:operation

+				soapAction="http://www.bigbank.com/account/withdraw" />

+			<wsdl:input>

+				<soap:body use="literal" />

+			</wsdl:input>

+			<wsdl:output>

+				<soap:body use="literal" />

+			</wsdl:output>

+		</wsdl:operation>

+

+		<wsdl:operation name="deposit">

+			<soap:operation

+				soapAction="http://www.bigbank.com/account/deposit" />

+			<wsdl:input>

+				<soap:body use="literal" />

+			</wsdl:input>

+			<wsdl:output>

+				<soap:body use="literal" />

+			</wsdl:output>

+		</wsdl:operation>

+

+		<wsdl:operation name="purchaseStock">

+			<soap:operation

+				soapAction="http://www.bigbank.com/account/purchaseStock" />

+			<wsdl:input>

+				<soap:body use="literal" />

+			</wsdl:input>

+			<wsdl:output>

+				<soap:body use="literal" />

+			</wsdl:output>

+		</wsdl:operation>

+

+		<wsdl:operation name="sellStock">

+			<soap:operation

+				soapAction="http://www.bigbank.com/account/sellStock" />

+			<wsdl:input>

+				<soap:body use="literal" />

+			</wsdl:input>

+			<wsdl:output>

+				<soap:body use="literal" />

+			</wsdl:output>

+		</wsdl:operation>

+

+		<wsdl:operation name="createAccount">

+			<soap:operation

+				soapAction="http://www.bigbank.com/account/createAccount" />

+			<wsdl:input>

+				<soap:body use="literal" />

+			</wsdl:input>

+			<wsdl:output>

+				<soap:body use="literal" />

+			</wsdl:output>

+		</wsdl:operation>

+

+		<wsdl:operation name="getAccountLog">

+			<soap:operation

+				soapAction="http://www.bigbank.com/account/getAccountLog" />

+			<wsdl:input>

+				<soap:body use="literal" />

+			</wsdl:input>

+			<wsdl:output>

+				<soap:body use="literal" />

+			</wsdl:output>

+		</wsdl:operation>

+

+	</wsdl:binding>

+	<wsdl:service name="AccountService">

+		<wsdl:port binding="account:AccountServiceSOAP"

+			name="AccountServiceSOAP">

+			<soap:address

+				location="http://localhost:8085/sample-bigbank-account/services/AccountService" />

+		</wsdl:port>

+	</wsdl:service>

+</wsdl:definitions>

diff --git a/branches/sca-java-0.99/samples/old/bigbank/account/src/main/resources/wsdl/stockquotes.webservicex.wsdl b/branches/sca-java-0.99/samples/old/bigbank/account/src/main/resources/wsdl/stockquotes.webservicex.wsdl
new file mode 100644
index 0000000000..16c980a30e
--- /dev/null
+++ b/branches/sca-java-0.99/samples/old/bigbank/account/src/main/resources/wsdl/stockquotes.webservicex.wsdl
@@ -0,0 +1,136 @@
+<?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.    
+-->
+<wsdl:definitions xmlns:http="http://schemas.xmlsoap.org/wsdl/http/" xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/" xmlns:s="http://www.w3.org/2001/XMLSchema" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:tns="http://www.webserviceX.NET/" xmlns:tm="http://microsoft.com/wsdl/mime/textMatching/" xmlns:mime="http://schemas.xmlsoap.org/wsdl/mime/" targetNamespace="http://www.webserviceX.NET/" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/">
+  <wsdl:types>
+    <s:schema elementFormDefault="qualified"
+       targetNamespace="http://www.webserviceX.NET/" >
+       <!--
+       xmlns:sdojava="commonj.sdo/java"
+	    sdojava:package="net.x.webservice"
+	    -->
+
+       
+       >
+      <s:element name="GetQuote">
+        <s:complexType>
+          <s:sequence>
+            <s:element minOccurs="0" maxOccurs="1" name="symbol" type="s:string"/>
+          </s:sequence>
+        </s:complexType>
+      </s:element>
+      <s:element name="GetQuoteResponse">
+        <s:complexType>
+          <s:sequence>
+            <s:element minOccurs="0" maxOccurs="1" name="GetQuoteResult" type="s:string"/>
+          </s:sequence>
+        </s:complexType>
+      </s:element> 
+      <s:element name="string" nillable="true" type="s:string"/>
+    </s:schema>
+  </wsdl:types>
+  <wsdl:message name="GetQuoteSoapIn">
+    <wsdl:part name="parameters" element="tns:GetQuote"/>
+  </wsdl:message>
+  <wsdl:message name="GetQuoteSoapOut">
+    <wsdl:part name="parameters" element="tns:GetQuoteResponse"/>
+  </wsdl:message>
+  <wsdl:message name="GetQuoteHttpGetIn">
+    <wsdl:part name="symbol" type="s:string"/>
+  </wsdl:message>
+  <wsdl:message name="GetQuoteHttpGetOut">
+    <wsdl:part name="Body" element="tns:string"/>
+  </wsdl:message>
+  <wsdl:message name="GetQuoteHttpPostIn">
+    <wsdl:part name="symbol" type="s:string"/>
+  </wsdl:message>
+  <wsdl:message name="GetQuoteHttpPostOut">
+    <wsdl:part name="Body" element="tns:string"/>
+  </wsdl:message>
+  <wsdl:portType name="StockQuoteSoap">
+    <wsdl:operation name="GetQuote">
+      <documentation xmlns="http://schemas.xmlsoap.org/wsdl/">Get Stock quote for a company Symbol</documentation>
+      <wsdl:input message="tns:GetQuoteSoapIn"/>
+      <wsdl:output message="tns:GetQuoteSoapOut"/>
+    </wsdl:operation>
+  </wsdl:portType>
+  <wsdl:portType name="StockQuoteHttpGet">
+    <wsdl:operation name="GetQuote">
+      <documentation xmlns="http://schemas.xmlsoap.org/wsdl/">Get Stock quote for a company Symbol</documentation>
+      <wsdl:input message="tns:GetQuoteHttpGetIn"/>
+      <wsdl:output message="tns:GetQuoteHttpGetOut"/>
+    </wsdl:operation>
+  </wsdl:portType>
+  <wsdl:portType name="StockQuoteHttpPost">
+    <wsdl:operation name="GetQuote">
+      <documentation xmlns="http://schemas.xmlsoap.org/wsdl/">Get Stock quote for a company Symbol</documentation>
+      <wsdl:input message="tns:GetQuoteHttpPostIn"/>
+      <wsdl:output message="tns:GetQuoteHttpPostOut"/>
+    </wsdl:operation>
+  </wsdl:portType>
+  <wsdl:binding name="StockQuoteSoap" type="tns:StockQuoteSoap">
+    <soap:binding transport="http://schemas.xmlsoap.org/soap/http" style="document"/>
+    <wsdl:operation name="GetQuote">
+      <soap:operation soapAction="http://www.webserviceX.NET/GetQuote" style="document"/>
+      <wsdl:input>
+        <soap:body use="literal"/>
+      </wsdl:input>
+      <wsdl:output>
+        <soap:body use="literal"/>
+      </wsdl:output>
+    </wsdl:operation>
+  </wsdl:binding>
+  
+  <wsdl:binding name="StockQuoteHttpGet" type="tns:StockQuoteHttpGet">
+    <http:binding verb="GET"/>
+    <wsdl:operation name="GetQuote">
+      <http:operation location="/GetQuote"/>
+      <wsdl:input>
+        <http:urlEncoded/>
+      </wsdl:input>
+      <wsdl:output>
+        <mime:mimeXml part="Body"/>
+      </wsdl:output>
+    </wsdl:operation>
+  </wsdl:binding>
+  <wsdl:binding name="StockQuoteHttpPost" type="tns:StockQuoteHttpPost">
+    <http:binding verb="POST"/>
+    <wsdl:operation name="GetQuote">
+      <http:operation location="/GetQuote"/>
+      <wsdl:input>
+        <mime:content type="application/x-www-form-urlencoded"/>
+      </wsdl:input>
+      <wsdl:output>
+        <mime:mimeXml part="Body"/>
+      </wsdl:output>
+    </wsdl:operation>
+  </wsdl:binding>
+
+  <wsdl:service name="StockQuote">
+    <wsdl:port name="StockQuoteSoap" binding="tns:StockQuoteSoap">
+      <soap:address location="http://www.webservicex.com/stockquote.asmx"/>
+    </wsdl:port>
+    <wsdl:port name="StockQuoteHttpGet" binding="tns:StockQuoteHttpGet">
+      <http:address location="http://www.webservicex.com/stockquote.asmx"/>
+    </wsdl:port>
+    <wsdl:port name="StockQuoteHttpPost" binding="tns:StockQuoteHttpPost">
+      <http:address location="http://www.webservicex.com/stockquote.asmx"/>
+    </wsdl:port>
+  </wsdl:service>
+</wsdl:definitions>
diff --git a/branches/sca-java-0.99/samples/old/bigbank/account/src/main/webapp/WEB-INF/default.scdl b/branches/sca-java-0.99/samples/old/bigbank/account/src/main/webapp/WEB-INF/default.scdl
new file mode 100644
index 0000000000..7c83a1a648
--- /dev/null
+++ b/branches/sca-java-0.99/samples/old/bigbank/account/src/main/webapp/WEB-INF/default.scdl
@@ -0,0 +1,80 @@
+<?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:wsdli="http://www.w3.org/2006/01/wsdl-instance"
+    name="bigbank.account">
+
+
+    <service name="AccountService">
+        <!-- interface.java interface="com.bigbank.account.AccountService"/-->
+        <interface.wsdl interface="http://www.bigbank.com/account#wsdl.interface(AccountService)"
+            wsdli:wsdlLocation="http://www.bigbank.com/account wsdl/AccountService.wsdl" />
+
+
+        <binding.ws endpoint="http://www.bigbank.com/account#wsdl.endpoint(AccountService/AccountServiceSOAP)"
+            conformanceURIs="http://ws-i.org/profiles/basic/1.1" location="wsdl/AccountService.wsdl" />
+
+        <reference>AccountServiceComponent</reference>
+    </service>
+
+
+    <property name="currency" type="xsd:string">USD</property>
+
+    <component name="AccountServiceComponent">
+        <implementation.java class="bigbank.account.services.account.AccountServiceImpl" />
+        <property name="currency" source="$currency" />
+        <reference name="accountDataService">AccountLoggerDataServiceComponent</reference>
+        <reference name="stockQuoteService">StockQuoteServiceComponent</reference>
+    </component>
+
+    <component name="AccountLoggerDataServiceComponent">
+        <implementation.java class="bigbank.account.services.accountlogger.AccountLoggerDataServiceImpl" />
+        <reference name="accountDataService">AccountDataServiceComponent</reference>
+        <reference name="accountLoggerService">AccountLoggerServiceComponent</reference>
+    </component>
+
+    <component name="AccountDataServiceComponent">
+        <implementation.java class="bigbank.account.services.accountdata.AccountDataServiceDASImpl" />
+    </component>
+
+    <component name="AccountLoggerServiceComponent">
+        <implementation.java class="bigbank.account.services.accountlogger.AccountLoggerServiceImpl" />
+    </component>
+
+    <!--  by default, we use the faked stock quote implemented as a POJO component -->
+    <component name="StockQuoteServiceComponent">
+        <implementation.java class="bigbank.account.services.stockquote.StockQuoteServiceImpl" />
+    </component>
+
+    <!-- Please uncomment the following to get the real stock quote -->
+    <!-- 
+        <component name="StockQuoteServiceComponent">
+        <implementation.java class="bigbank.account.services.stockquote.StockQuoteWebservicexServiceImpl" />
+        <reference name="stockQuoteService">StockQuoteWebService</reference>
+        </component>
+        
+        <reference name="StockQuoteWebService">
+        <interface.wsdl interface="http://www.webserviceX.NET/#wsdl.interface(StockQuoteSoap)"
+        wsdli:wsdlLocation="http://www.webserviceX.NET/ wsdl/stockquotes.webservicex.wsdl" />
+        <binding.ws endpoint="http://www.webserviceX.NET/#wsdl.endpoint(StockQuote/StockQuoteSoap)"
+        location="wsdl/stockquotes.webservicex.wsdl" />
+        </reference>
+    -->
+
+</composite>
\ No newline at end of file
diff --git a/branches/sca-java-0.99/samples/old/bigbank/account/src/main/webapp/WEB-INF/web.xml b/branches/sca-java-0.99/samples/old/bigbank/account/src/main/webapp/WEB-INF/web.xml
new file mode 100644
index 0000000000..509e5a052d
--- /dev/null
+++ b/branches/sca-java-0.99/samples/old/bigbank/account/src/main/webapp/WEB-INF/web.xml
@@ -0,0 +1,70 @@
+<?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.    
+-->
+
+<!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 id="WebApp_ID" version="2.4" xmlns="http://java.sun.com/xml/ns/j2ee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">
+
+  <display-name>Tuscany Bigbank Account sample</display-name>
+
+  <!-- context-param>
+     <param-name>tuscany.systemScdlPath</param-name>
+     <param-value>/META-INF/tuscany/webapp.scdl</param-value>
+  </context-param -->
+
+  <!-- context-param>
+     <param-name>tuscany.applicationScdlPath</param-name>
+     <param-value>/META-INF/sca/default.scdl</param-value>
+  </context-param -->
+
+  <context-param>
+	     <param-name>tuscany.online</param-name>
+	     <param-value>false</param-value>
+  </context-param>
+
+
+  <listener>
+     <listener-class>org.apache.tuscany.runtime.webapp.TuscanyContextListener</listener-class>
+  </listener>
+   
+  <servlet>
+     <servlet-name>TuscanyServlet</servlet-name>
+     <display-name>Tuscany Servlet</display-name>
+     <servlet-class>org.apache.tuscany.runtime.webapp.TuscanyServlet</servlet-class>
+  </servlet>
+  
+  <servlet-mapping>
+     <servlet-name>TuscanyServlet</servlet-name>
+     <url-pattern>/*</url-pattern>
+
+  </servlet-mapping>  
+    <servlet>
+        <!-- Initialize bigbank database -->
+	    <servlet-name>AccountDBInit</servlet-name>
+	    <servlet-class>bigbank.account.services.accountdb.AccountDBInit</servlet-class>
+	    <load-on-startup>2</load-on-startup>
+  </servlet>
+  <!-- servlet-mapping>
+		<servlet-name>AccountDBInit</servlet-name>
+		<url-pattern>/AccountDBInit</url-pattern>
+	</servlet-mapping -->
+ 
+
+</web-app>
diff --git a/branches/sca-java-0.99/samples/old/bigbank/account/src/test/java/bigbank/account/client/AccountClient.java b/branches/sca-java-0.99/samples/old/bigbank/account/src/test/java/bigbank/account/client/AccountClient.java
new file mode 100644
index 0000000000..28f9e762f0
--- /dev/null
+++ b/branches/sca-java-0.99/samples/old/bigbank/account/src/test/java/bigbank/account/client/AccountClient.java
@@ -0,0 +1,56 @@
+/*
+ * 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 bigbank.account.client;
+
+import java.util.Iterator;
+
+import org.osoa.sca.CompositeContext;
+import org.osoa.sca.CurrentCompositeContext;
+
+import com.bigbank.account.AccountReport;
+import com.bigbank.account.AccountService;
+import com.bigbank.account.AccountSummary;
+
+public class AccountClient {
+
+    public void start() {
+    }
+
+    public void stop() {
+    }
+
+    public static void main(String[] args) throws Exception {
+
+        CompositeContext context = CurrentCompositeContext.getContext();
+
+        AccountService accountService = context.locateService(AccountService.class, "AccountServiceComponent");
+
+        AccountReport accountReport = accountService.getAccountReport(12345);
+
+        for (Iterator i = accountReport.getAccountSummaries().iterator(); i.hasNext();) {
+            AccountSummary accountSummary = (AccountSummary) i.next();
+
+            System.out.println(accountSummary.getAccountNumber());
+            System.out.println(accountSummary.getAccountType());
+            System.out.println(accountSummary.getBalance());
+        }
+
+    }
+
+}