Package javax.jcr.query

Examples of javax.jcr.query.Query.bindValue()

504
505
506
507
508
509
510
511
512
513
514
        // secure
        Query q = qm.createQuery(
                "select text from [nt:base] where password = $p",
                Query.JCR_SQL2 + "-noLiterals");
        q.bindValue("p", vf.createValue("x"));
        q.execute();
    }

    @SuppressWarnings("deprecation")
    @Test
View Full Code Here
237
238
239
240
241
242
243
244
245
246
247
        QueryManager qm = session.getWorkspace().getQueryManager();

        // SQL-2

        Query q = qm.createQuery("select text from [nt:base] where id = $id", Query.JCR_SQL2);
        q.bindValue("id", vf.createValue("1"));
        QueryResult r = q.execute();
        RowIterator it = r.getRows();
        assertTrue(it.hasNext());
        Row row = it.nextRow();
        assertEquals("hello_world", row.getValue("text").getString());
View Full Code Here
297
298
299
300
301
302
303
304
305
306
307
        hello2.setProperty("data",  "y");
        session.save();
        ValueFactory vf = session.getValueFactory();
        QueryManager qm = session.getWorkspace().getQueryManager();
        Query q = qm.createQuery("select id from [nt:base] where data >= $data order by id", Query.JCR_SQL2);
        q.bindValue("data", vf.createValue("x"));
        for (int i = -1; i < 5; i++) {
            QueryResult r = q.execute();
            RowIterator it = r.getRows();
            assertEquals(3, r.getRows().getSize());
            assertEquals(3, r.getNodes().getSize());
View Full Code Here
349
350
351
352
353
354
355
356
357
358
359
        hello2.setProperty("data",  "y");
        session.save();
        ValueFactory vf = session.getValueFactory();
        QueryManager qm = session.getWorkspace().getQueryManager();
        Query q = qm.createQuery("select id from [nt:base] where data >= $data order by id", Query.JCR_SQL2);
        q.bindValue("data", vf.createValue("x"));
        for (int limit = 0; limit < 5; limit++) {
            q.setLimit(limit);
            for (int offset = 0; offset < 3; offset++) {
                q.setOffset(offset);
                QueryResult r = q.execute();
View Full Code Here
415
416
417
418
419
420
421
422
423
424
425
        // secure
        Query q = qm.createQuery(
                "select text from [nt:base] where password = $p",
                Query.JCR_SQL2 + "-noLiterals");
        q.bindValue("p", vf.createValue("x"));
        q.execute();
    }

    @SuppressWarnings("deprecation")
    @Test
View Full Code Here
60
61
62
63
64
65
66
67
68
69
70
        NodeIterator ni;

        // verify we can see the visible node
        q = testSession.getWorkspace().getQueryManager().createQuery(
                "select * from [nt:base] where [jcr:path]=$path", Query.JCR_SQL2);
        q.bindValue("path", vf.createValue(visible.getPath()));
        r = q.execute();
        ni = r.getNodes();
        assertTrue(ni.hasNext());
        x = ni.nextNode();
        assertTrue(x.getSession() == testSession);
View Full Code Here
70
71
72
73
74
75
76
77
78
79
80
        assertTrue(x.getSession() == testSession);

        // verify we cannot see the invisible node
        q = testSession.getWorkspace().getQueryManager().createQuery(
                "select * from [nt:base] where [jcr:path]=$path", Query.JCR_SQL2);
        q.bindValue("path", vf.createValue(invisible.getPath()));
        r = q.execute();
        assertFalse(r.getNodes().hasNext());
       
        // the superuser should see both nodes
        q = superuser.getWorkspace().getQueryManager().createQuery(
View Full Code Here
79
80
81
82
83
84
85
86
87
88
89
        // the superuser should see both nodes
        q = superuser.getWorkspace().getQueryManager().createQuery(
                "select a.* from [nt:base] as a " +
                "inner join [nt:base] as b on isdescendantnode(b, a) " +
                "where a.[jcr:path]=$path", Query.JCR_SQL2);
        q.bindValue("path", vf.createValue(visible.getPath()));
        r = q.execute();
        assertTrue(r.getNodes().hasNext());

        // but the testSession must not:
        // verify we can not deduce existence of the invisible node
View Full Code Here
90
91
92
93
94
95
96
97
98
99
100
        // using a join
        q = testSession.getWorkspace().getQueryManager().createQuery(
                "select a.* from [nt:base] as a " +
                "inner join [nt:base] as b on isdescendantnode(b, a) " +
                "where a.[jcr:path]=$path", Query.JCR_SQL2);
        q.bindValue("path", vf.createValue(visible.getPath()));
        r = q.execute();
        assertFalse(r.getNodes().hasNext());

    }
   
View Full Code Here
148
149
150
151
152
153
154
155
156
157
158
        QueryManager qm = session.getWorkspace().getQueryManager();

        // SQL-2

        Query q = qm.createQuery("select text from [nt:base] where id = $id", Query.JCR_SQL2);
        q.bindValue("id", vf.createValue("1"));
        QueryResult r = q.execute();
        RowIterator it = r.getRows();
        assertTrue(it.hasNext());
        Row row = it.nextRow();
        assertEquals("hello_world", row.getValue("text").getString());
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.