Package org.apache.tuscany.das.rdb

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

174
175
176
177
178
179
180
181
182
183
184
      assertEquals(0, customers.size());

      //delete - cfg command with no param
      Command deleteNoParam = das.getCommand("deleteCustomerNoParam");
      deleteNoParam.setParameter("ID", new Integer(7));
      deleteNoParam.execute();
      select.setParameter("ID", new Integer(7));
      root = select.executeQuery();
      customers = root.getList("CUSTOMER");
      assertEquals(0, customers.size());     
    }
View Full Code Here
210
211
212
213
214
215
216
217
218
219
220
    //setup is over, now set values in params and execute
    Command insert = das.getCommand("insertCustomer");
    insert.setParameter("ID", new Integer(6));
    insert.setParameter("LASTNAME", "Anthony");
    insert.setParameter("ADDRESS", "IND");
    insert.execute();
   
    Command select = das.createCommand("select * from CUSTOMER where ID = ?");
      select.setParameter("ID", new Integer(6));
      DataObject root = select.executeQuery();
      List customers = root.getList("CUSTOMER");
View Full Code Here
232
233
234
235
236
237
238
239
240
241
242
      Command insertAdhoc = das.createCommand("insert into CUSTOMER values (?, ?, ?)");
      insertAdhoc.setParameter("ID", new Integer(6));
      insertAdhoc.setParameter("LASTNAME", "MyLastName");
      insertAdhoc.setParameter("ADDRESS", "MyLastAddress");
      assertEquals("MyLastAddress", insertAdhoc.getParameter("ADDRESS"));
      insertAdhoc.execute();
     
      Command select = das.createCommand("select * from CUSTOMER where ID = ?");
      select.setParameter("ID", new Integer(6));
      DataObject root = select.executeQuery();
      List customers = root.getList("CUSTOMER");
View Full Code Here
51
52
53
54
55
56
57
58
59
60
61
     
      //insert same image
      Command insert = das.createCommand("INSERT INTO DOCUMENTS_IMAGES (ID, PIC) VALUES (?,?)");
      insert.setParameter(1, new Integer(101));
      insert.setParameter(2, imgArray);
      insert.execute();
     
      //Select again
      Command readNew = das.createCommand("SELECT PIC FROM DOCUMENTS_IMAGES WHERE id = 101");
      root = readNew.executeQuery();
      result = root.getList("DOCUMENTS_IMAGES");
View Full Code Here
128
129
130
131
132
133
134
135
136
137
138
    // Simplest possible SP write
    public void testDelete() throws Exception {
        DAS das = DAS.FACTORY.createDAS(getConnection());
        Command delete = das.createCommand("{call DELETECUSTOMER(?)}");
        delete.setParameter(1, new Integer(1));
        delete.execute();

        // Verify DELETE
        Command select = das.createCommand("Select * from CUSTOMER where ID = 1");
        DataObject root = select.executeQuery();
        assertTrue(root.getList("CUSTOMER").isEmpty());
View Full Code Here
109
110
111
112
113
114
115
116
117
118
119
        DAS das = DAS.FACTORY.createDAS(getConnection());
        Command insert = das.createCommand(sql);
        insert.setParameter(1, new Integer(316405209));
        insert.setParameter(2, "2005-11-23 19:29:52.636");
        insert.execute();

        // Verify
        Command select = das.createCommand("Select * from conmgt.SERVERSTATUS");
        DataObject root = select.executeQuery();
        assertEquals(1, root.getList("SERVERSTATUS").size());
View Full Code Here
154
155
156
157
158
159
160
161
162
163
164
        DAS das = DAS.FACTORY.createDAS(getConnection());
        Command insert = das.createCommand("insert into CUSTOMER values (?, ?, ?)");
        insert.setParameter(1, new Integer(10));
        insert.setParameter(2, null);
        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
175
176
177
178
179
180
181
182
183
184
185
        insert.setParameter(1, new Integer(10));
        // insert.setParameterValue("LASTNAME", null);
        insert.setParameter(3, "5528 Wells Fargo Dr");

        try {
            insert.execute();
            fail();
        } catch (RuntimeException e) {
            // Expected since "LASTNAME" parameter not set
        }
    }
View Full Code Here
191
192
193
194
195
196
197
198
199
200
201
        DAS das = DAS.FACTORY.createDAS(getConnection());
        Command insert = das.createCommand("insert into CUSTOMER values (?, ?, ?)");
        insert.setParameter(1, new Integer(10));
        insert.setParameter(2, "");
        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
239
240
241
242
243
244
245
246
247
248
249
        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, null);
        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.