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

        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.setFetchOffset(2);
        List artists = runProcedureSelect(q);


        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.setColumnNamesCapitalization(CapsStrategy.LOWER);
        q.addParameter("aName", "An Artist");
        List<DataRow> artists = runProcedureSelect(q);


        ProcedureQuery q1 = new ProcedureQuery(SELECT_STORED_PROCEDURE);


        q1.setColumnNamesCapitalization(CapsStrategy.UPPER);

View Full Code Here

        List<DataRow> artists = runProcedureSelect(q);


        ProcedureQuery q1 = new ProcedureQuery(SELECT_STORED_PROCEDURE);


        q1.setColumnNamesCapitalization(CapsStrategy.UPPER);
        q1.addParameter("aName", "An Artist");
        List<DataRow> artists1 = runProcedureSelect(q1);


        assertTrue(artists.get(0).containsKey("date_of_birth"));
        assertFalse(artists.get(0).containsKey("DATE_OF_BIRTH"));

View Full Code Here

        if (!getAccessStackAdapter().supportsStoredProcedures()) {
            return;
        }


        ProcedureQuery q = new ProcedureQuery(OUT_STORED_PROCEDURE);
        q.addParameter("in_param", new Integer(20));


        List rows = runProcedureSelect(q);


        assertEquals(1, rows.size());
        Object row = rows.get(0);

View Full Code Here


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


        ProcedureQuery q = new ProcedureQuery(SELECT_STORED_PROCEDURE, Artist.class);
        q.addParameter("aName", "An Artist");


        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 = ctxt.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

        // test ProcedureQuery with Procedure as root
        Procedure proc = ctxt.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

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.