Package org.apache.tuscany.das.rdb

Examples of org.apache.tuscany.das.rdb.Command.execute()

106
107
108
109
110
111
112
113
114
115
116
        Command insert = das.createCommand("insert into CUSTOMER (ID, LASTNAME, ADDRESS) values (?, ?, ?)");
        String key = "10";
        insert.setParameter(1, key);
        insert.setParameter(2, "CUST10");
        insert.setParameter(3, "ADDR10");
        insert.execute();
       
        // Verify insert
        Command select = das.createCommand("Select ID, LASTNAME from CUSTOMER where ID = ?");
        select.setParameter(1, key);
        DataObject root = select.executeQuery();
View Full Code Here
127
128
129
130
131
132
133
134
135
136
137
        Command insert = das.createCommand("insert into CUSTOMER (ID, LASTNAME, ADDRESS) values (?, ?, ?)");
        String key = "10";
        insert.setParameter(1, key);
        insert.setParameter(2, "CUST10");
        insert.setParameter(3, "ADDR10");
        insert.execute();
        try{
          Integer retkey = new Integer(insert.getGeneratedKey());
          fail("Should not be able to retrieve key "+retkey);
        }catch(RuntimeException e){
          //e.printStackTrace();
View Full Code Here
154
155
156
157
158
159
160
161
162
163
164
        Command insert = das.createCommand("insert into CUSTOMER (ID, LASTNAME, ADDRESS) values (?, ?, ?)");
        String key = "10";
        insert.setParameter(1, key);
        insert.setParameter(2, "CUST10");
        insert.setParameter(3, "ADDR10");
        insert.execute();
       
        // Verify insert
        Command select = das.createCommand("Select ID, LASTNAME from CUSTOMER where ID = ?");
        select.setParameter(1, key);
        DataObject root = select.executeQuery();
View Full Code Here
46
47
48
49
50
51
52
53
54
55
56
        Command select = das.createCommand("Select * from CUSTOMER where ID = 1");
        DataObject root = select.executeQuery();

        // Explicitly update the DB to force a collision
        Command update = das.createCommand("update CUSTOMER set LASTNAME = 'Smith' where ID = 1");
        update.execute();
       
        DataObject customer = root.getDataObject("CUSTOMER[1]");

        // Modify customer
        customer.set("LASTNAME", "Pavick");
View Full Code Here
78
79
80
81
82
83
84
85
86
87
88
        book.setInt("QUANTITY", 2);

        // Explicitly change OCC column in database to force collision
        Command update = das.getCommand("update book 1");
        update.setParameter(1, new Integer(100));
        update.execute();

        // Try to apply changes and catch the expected An update collision occurred
        try {
            das.applyChanges(root);
            fail("An OCCException should be thrown");
View Full Code Here
72
73
74
75
76
77
78
79
80
81
82
        // 19:29:52.636')";
        String sql = "insert into conmgt.serverstatus (managedserverid, timestamp) "
                + "values (316405209, '2005-11-23 19:29:52.636')";
        DAS das = DAS.FACTORY.createDAS(getConnection());
        Command insert = das.createCommand(sql);
        insert.execute();

        // Verify
        Command select = das.createCommand("Select * from conmgt.serverstatus where statusid = 1");
        DataObject root = select.executeQuery();
               
View Full Code Here
55
56
57
58
59
60
61
62
63
64
65
        DataObject customer = root.getDataObject("CUSTOMER[1]");
        // Verify
        assertEquals(1, customer.getInt("ID"));

        Command update = das.createCommand("update CUSTOMER set LASTNAME = 'modified' where ID = 1");
        update.execute();

        customer.setString("ADDRESS", "main street");

        das.applyChanges(root);
View Full Code Here
117
118
119
120
121
122
123
124
125
126
127
        assertFalse(root.get("CUSTOMER[1]/LASTNAME").equals("Pavick"));
        int id = root.getInt("CUSTOMER[1]/ID");

        Command update = das.getCommand("update customer");
        update.setParameter(1, new Integer(id));
        update.execute();

        // Verify update - reuse select command
        root = read.executeQuery();
        assertEquals("Pavick", root.get("CUSTOMER[1]/LASTNAME"));
View Full Code Here
128
129
130
131
132
133
134
135
136
137
138
    }

    public void testInsert() throws Exception {
        DAS das = DAS.FACTORY.createDAS(getConnection());
        Command insert = das.createCommand("insert into CUSTOMER values (10, 'Williams', '5528 Wells Fargo Dr')");
        insert.execute();

        // Verify
        Command select = das.createCommand("Select * from CUSTOMER where ID = 10");
        DataObject root = select.executeQuery();
        assertEquals(1, root.getList("CUSTOMER").size());
View Full Code Here
144
145
146
147
148
149
150
151
152
153
154
        DAS das = DAS.FACTORY.createDAS(getConnection());
        Command insert = das.createCommand("insert into CUSTOMER values (?, ?, ?)");
        insert.setParameter(1, new Integer(10));
        insert.setParameter(2, "Williams");
        insert.setParameter(3, "5528 Wells Fargo Dr");
        insert.execute();

        // Verify
        Command select = das.createCommand("Select * from CUSTOMER where ID = 10");
        DataObject root = select.executeQuery();
        assertEquals(1, root.getList("CUSTOMER").size());
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.