Examples of org.apache.cayenne.query.ProcedureQuery.addParameter()

Class org.apache.cayenne.query.ProcedureQuery

Examples of org.apache.cayenne.query.ProcedureQuery.addParameter()

org.apache.cayenne.query.ProcedureQuery.addParameter()
Adds a named parameter to the internal map of parameters. @since 1.1

        // test ProcedureQuery with Procedure as root
        Procedure proc = context.getEntityResolver().getProcedure(SELECT_STORED_PROCEDURE);
        ProcedureQuery q = new ProcedureQuery(proc);
        q.setFetchingDataRows(true);
        q.addParameter("aName", "An Artist");
        q.addParameter("paintingPrice", new Integer(3000));


        // TESTING THIS ***
        // A.ARTIST_ID, A.DATE_OF_BIRTH, A.ARTIST_NAME
        ColumnDescriptor[] columns = new ColumnDescriptor[3];

View Full Code Here


        // create an artist with painting in the database
        createArtist(1000.0);


        ProcedureQuery q = new ProcedureQuery(UPDATE_STORED_PROCEDURE);
        q.addParameter("paintingPrice", new Integer(3000));


        // since stored procedure commits its stuff, we must use an explicit
        // non-committing transaction


        Transaction t = Transaction.externalTransaction(null);

View Full Code Here


        // create an artist with painting in the database
        createArtist(1000.0);


        ProcedureQuery q = new ProcedureQuery(SELECT_STORED_PROCEDURE);
        q.addParameter("aName", "An Artist");
        q.addParameter("paintingPrice", new Integer(3000));
        List<?> artists = runProcedureSelect(q);


        // check the results
        assertNotNull("Null result from StoredProcedure.", artists);

View Full Code Here

        // create an artist with painting in the database
        createArtist(1000.0);


        ProcedureQuery q = new ProcedureQuery(SELECT_STORED_PROCEDURE);
        q.addParameter("aName", "An Artist");
        q.addParameter("paintingPrice", new Integer(3000));
        List<?> artists = runProcedureSelect(q);


        // check the results
        assertNotNull("Null result from StoredProcedure.", artists);
        assertEquals(1, artists.size());

View Full Code Here


        // create an artist with painting in the database
        createArtist(1000.0);


        ProcedureQuery q = new ProcedureQuery(SELECT_STORED_PROCEDURE);
        q.addParameter("aName", "An Artist");
        q.addParameter("paintingPrice", new Integer(3000));


        List<?> artists = runProcedureSelect(q);


        // check the results

View Full Code Here

        // create an artist with painting in the database
        createArtist(1000.0);


        ProcedureQuery q = new ProcedureQuery(SELECT_STORED_PROCEDURE);
        q.addParameter("aName", "An Artist");
        q.addParameter("paintingPrice", new Integer(3000));


        List<?> artists = runProcedureSelect(q);


        // check the results
        assertNotNull("Null result from StoredProcedure.", artists);

View Full Code Here

        // test ProcedureQuery with Procedure as root
        Procedure proc = context
                .getEntityResolver()
                .getProcedure(SELECT_STORED_PROCEDURE);
        ProcedureQuery q = new ProcedureQuery(proc);
        q.addParameter("aName", "An Artist");
        q.addParameter("paintingPrice", new Integer(3000));


        List<?> artists = runProcedureSelect(q);


        // check the results

View Full Code Here

        Procedure proc = context
                .getEntityResolver()
                .getProcedure(SELECT_STORED_PROCEDURE);
        ProcedureQuery q = new ProcedureQuery(proc);
        q.addParameter("aName", "An Artist");
        q.addParameter("paintingPrice", new Integer(3000));


        List<?> artists = runProcedureSelect(q);


        // check the results
        assertNotNull("Null result from StoredProcedure.", artists);

View Full Code Here

        createArtist(1000.0);
        createArtist(2000.0);
        createArtist(3000.0);


        ProcedureQuery q = new ProcedureQuery(SELECT_STORED_PROCEDURE);
        q.addParameter("aName", "An Artist");
        q.addParameter("paintingPrice", new Integer(3000));
        q.setFetchLimit(2);
        List<?> artists = runProcedureSelect(q);


        assertEquals(2, artists.size());

View Full Code Here

        createArtist(2000.0);
        createArtist(3000.0);


        ProcedureQuery q = new ProcedureQuery(SELECT_STORED_PROCEDURE);
        q.addParameter("aName", "An Artist");
        q.addParameter("paintingPrice", new Integer(3000));
        q.setFetchLimit(2);
        List<?> artists = runProcedureSelect(q);


        assertEquals(2, artists.size());
    }

View Full Code Here

0 1 2 3 4 5 6

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.