Examples of org.voltdb.client.Client.callProcedure()

org.voltdb.client.Client.callProcedure()
Synchronously invoke a procedure. Blocks until a result is available. A {@link ProcCallException}is thrown if the response is anything other then success. @param procName class name (not qualified by package) of the procedure to execute. @param parameters vararg list of procedure's parameter values. @return array of VoltTable results. @throws org.voltdb.client.ProcCallException @throws NoConnectionsException

                e.printStackTrace();
                fail();
            }


            // verify that the row was updated
            final VoltTable[] result = client.callProcedure("Select", "ALLOW_NULLS", pkey.get()).getResults();
            final VoltTableRow row = result[0].fetchRow(0);
            for (int i=0; i < COLS; ++i) {
                final Object obj = row.get(i+1, m_types[i]);
                assertTrue( comparisonHelper(obj, params[i+2], m_types[i]) );
            }

View Full Code Here

            params[1] = pkey.incrementAndGet();
            for (int i = 0; i < COLS; i++) {
                params[i+2] = (i == k) ? m_nullValues[i] : m_midValues[i];
                assert(params[i+2] != null);
            }
            client.callProcedure("Insert", params);
            VoltTable[] result = client.callProcedure("Select", "ALLOW_NULLS", pkey.get()).getResults();
            System.out.println(result[0]);


            try {
                client.callProcedure("Delete", "ALLOW_NULLS", pkey.get());

View Full Code Here

            for (int i = 0; i < COLS; i++) {
                params[i+2] = (i == k) ? m_nullValues[i] : m_midValues[i];
                assert(params[i+2] != null);
            }
            client.callProcedure("Insert", params);
            VoltTable[] result = client.callProcedure("Select", "ALLOW_NULLS", pkey.get()).getResults();
            System.out.println(result[0]);


            try {
                client.callProcedure("Delete", "ALLOW_NULLS", pkey.get());
            } catch (final ProcCallException e) {

View Full Code Here

            client.callProcedure("Insert", params);
            VoltTable[] result = client.callProcedure("Select", "ALLOW_NULLS", pkey.get()).getResults();
            System.out.println(result[0]);


            try {
                client.callProcedure("Delete", "ALLOW_NULLS", pkey.get());
            } catch (final ProcCallException e) {
                e.printStackTrace();
                fail();
            } catch (final NoConnectionsException e) {
                e.printStackTrace();

View Full Code Here

                e.printStackTrace();
                fail();
            }


            // verify that the row was deleted
            result = client.callProcedure("Select", "ALLOW_NULLS", pkey.get()).getResults();
            assertEquals(0, result[0].getRowCount());
        }
     }


    public void testMissingAttributeInsert_With_Defaults()

View Full Code Here

            params[i+2] = m_defaultValues[i];
            assert(params[i+2] != null);
        }


        try {
            client.callProcedure("Insert", params);
        } catch (ProcCallException e) {
            e.printStackTrace();
            fail();
        } catch (NoConnectionsException e) {
            e.printStackTrace();

View Full Code Here

        } catch (NoConnectionsException e) {
            e.printStackTrace();
            fail();
        }


        VoltTable[] result = client.callProcedure("Select", "WITH_DEFAULTS", pkey.get()).getResults();
        VoltTableRow row = result[0].fetchRow(0);
        for (int i=0; i < COLS; ++i) {
            Object obj = row.get(i+1, m_types[i]);
            assertTrue( comparisonHelper(obj, params[i+2], m_types[i]) );
        }

View Full Code Here

            params[i+2] = m_nullValues[i];
            assert(params[i+2] != null);
        }


        try {
            client.callProcedure("Insert", params);
        } catch (ProcCallException e) {
            e.printStackTrace();
            fail();
        } catch (NoConnectionsException e) {
            e.printStackTrace();

View Full Code Here

        } catch (NoConnectionsException e) {
            e.printStackTrace();
            fail();
        }


        VoltTable[] result = client.callProcedure("Select", "WITH_NULL_DEFAULTS", pkey.get()).getResults();
        VoltTableRow row = result[0].fetchRow(0);
        for (int i=0; i < COLS; ++i) {
            Object obj = row.get(i+1, m_types[i]);
            assertTrue( comparisonHelper(obj, params[i+2], m_types[i]) );
        }

View Full Code Here

            // content of the select matches the parameters passed to
            // insert


            System.out.println("testInsertMaxValues: " + k + " MAX type is " + m_types[k]);
            params[0] = "NO_NULLS";
            client.callProcedure("Insert", params);
            // verify that the row was updated
            final VoltTable[] result = client.callProcedure("Select", "NO_NULLS", pkey.get()).getResults();
            final VoltTableRow row = result[0].fetchRow(0);
            for (int i=0; i < COLS; ++i) {
                final Object obj = row.get(i+1, m_types[i]);

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

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.