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

        insert.setParameter(4, STOCK_ACTION_TYPE_PURCHASE);

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

        /*

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

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

         */

    }

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

        insert.setParameter(4, STOCK_ACTION_TYPE_SELL);

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

        /*

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

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

         */

    }

        int id = root.getInt("CUSTOMER[1]/ID");

        Command update = commandGroup.getCommand("update customer");

        update.setParameterValue("ID", new Integer(id));

        // Verify update - reuse select command

        root = read.executeQuery();

        assertEquals("Pavick", root.get("CUSTOMER[1]/LASTNAME"));

        Command update = commandGroup.getCommand("update balance");

        update.setParameterValue("BALANCE", new Float(newbalance));

        update.setParameterValue("ACCOUNTNUMBER", wd.getAccountNumber());

        conn.close();

    }

    public static class MyDateConverter implements Converter {

    Command update = Command.FACTORY

        .createCommand("update BOOK set OCC = :OCC where BOOK_ID = 1");

    update.setConnection(getConnection());

    update.setParameterValue("OCC", new Integer(100));

    //Try to flush the change

    ApplyChangesCommand apply = Command.FACTORY.createApplyChangesCommand(getConfig("BooksConfig.xml"));

    apply.setConnection(getConnection());

  public void testInsert() throws Exception {

   

    Command insert = Command.FACTORY.createCommand("insert into CUSTOMER values (10, 'Williams', '5528 Wells Fargo Dr')"); 

    insert.setConnection(getConnection());

    //Verify

    Command select = Command.FACTORY.createCommand("Select * from CUSTOMER where ID = 10");

    select.setConnection(getConnection());

    DataObject root = select.executeQuery(); 

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

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

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

            insert.setConnection(getConnection());

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

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

            if (createSavings) {

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

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

            if (createSavings) {

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

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

                insert.setConnection(getConnection());

            }

            if (createCheckings) {

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

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

            if (createCheckings) {

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

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

                insert.setConnection(getConnection());

            }

            return ret;

        } catch (Exception e) {

            commandGroup.setConnection(conn);

            Command update = commandGroup.getCommand("update balance");

            update.setParameterValue("BALANCE", new Float(newbalance));

            update.setParameterValue("ACCOUNTNUMBER", account);

            conn.close();

            return newbalance;

        } catch (Exception e) {

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

        }