Package org.exolab.castor.jdo

Examples of org.exolab.castor.jdo.OQLQuery.bind()

183
184
185
186
187
188
189
190
191
192
193
        Database db = _jdo.getDatabase();
        assertNotNull(db);
        db.begin();
        OQLQuery query = db.getOQLQuery("SELECT b FROM " + Book.class.getName()
                + " b WHERE b.title = $1");
        query.bind("Heart of Darkness");
        QueryResults result = query.execute();
       
        int count = 0;
        Book b = null;
        while (result.hasMore()) {
View Full Code Here
122
123
124
125
126
127
128
129
130
131
132
       
        // load EntityOne with Id=1 from persistent store
        db.begin();
       
        query = db.getNamedQuery(SELECT_ENTITY_ONE_BY_ID);
        query.bind(new Integer(0));
        results = query.execute();
       
        NQEntity entity = (NQEntity) results.next();

        assertNotNull(entity);
View Full Code Here
85
86
87
88
89
90
91
92
93
94
95
        // Open transaction in order to perform JDO operations
        _db.begin();
        oql = _db.getOQLQuery("SELECT t FROM "
                + NestedObject.class.getName() + " t WHERE id = $1");
        oql.bind(NestedObject.DEFAULT_ID);
        results = oql.execute();
        if (results.hasMore()) {
            t = (NestedObject) results.next();
            _db.remove(t);
            LOG.debug("Deleting object: " + t);
View Full Code Here
101
102
103
104
105
106
107
108
109
110
111
        LOG.debug("Creating new object: " + t);
        _db.create(t);
        _db.commit();
       
        _db.begin();
        oql.bind(NestedObject.DEFAULT_ID);
        results = oql.execute();
        if (results.hasMore()) {
            t = (NestedObject) results.next();
            String nv1 = t.getNested1().getValue1();
            String nv2 = t.getNested2().getNested3().getValue2();
View Full Code Here
124
125
126
127
128
129
130
131
132
133
134
        LOG.info("Testing nested fields in OQLQuery...");
        _db.begin();
        oql = _db.getOQLQuery("SELECT t FROM "
                + NestedObject.class.getName()
                + " t WHERE nested2.nested3.value2 = $1");
        oql.bind(NestedObject.DEFAULT_VALUE2);
        results = oql.execute();
        if (results.hasMore()) {
            LOG.info("OK: Nested fields persisted");
        } else {
            LOG.error("Failed to persist nested fields");
View Full Code Here
124
125
126
127
128
129
130
131
132
133
134
    private void deleteGroups() throws PersistenceException {
        _db.begin();
        OQLQuery oqlclean = _db.getOQLQuery("SELECT object FROM "
                + ManyGroupKeyGen.class.getName() + " object WHERE object.id < $1");
        oqlclean.bind(Integer.MAX_VALUE);
        QueryResults enumeration = oqlclean.execute();
        while (enumeration.hasMore()) {
            _groupA = (ManyGroupKeyGen) enumeration.next();
            _stream.println("Retrieved object: " + _groupA);
            _db.remove(_groupA);
View Full Code Here
139
140
141
142
143
144
145
146
147
148
149
   
    private void deletePersons() throws PersistenceException {
        _db.begin();
        OQLQuery oqlclean = _db.getOQLQuery("SELECT object FROM "
                + ManyPersonKeyGen.class.getName() + " object WHERE object.id < $1");
        oqlclean.bind(Integer.MAX_VALUE);
        QueryResults enumeration = oqlclean.execute();
        while (enumeration.hasMore()) {
            _person1 = (ManyPersonKeyGen) enumeration.next();
            _stream.println("Retrieved object: " + _person1);
            _db.remove(_person1);
View Full Code Here
25
26
27
28
29
30
31
32
33
34
35
        Database db = _jdo.getDatabase();
        db.begin();
       
        OQLQuery query = db.getOQLQuery("SELECT entity FROM "
                + Entity.class.getName() + " entity WHERE id = $1");
        query.bind(new Integer(1));
        QueryResults results = query.execute();
       
        Entity entity = (Entity) results.next();

        assertNotNull(entity);
View Full Code Here
275
276
277
278
279
280
281
282
283
284
285
        Database db = _category.getDatabase();
        db.begin();
       
        OQLQuery query = db.getOQLQuery("SELECT entity FROM "
                + AutostoreMainMany.class.getName() + " entity WHERE id = $1");
        query.bind(new Integer(1));
        QueryResults results = query.execute();
       
        AutostoreMainMany entity = (AutostoreMainMany) results.next();

        assertNotNull(entity);
View Full Code Here
110
111
112
113
114
115
116
117
118
119
120
        BigDecimal borderLine = new BigDecimal(10.0);
        BigDecimal reducedRate = new BigDecimal(0.8);
        String s = "SELECT e FROM " + Employee.class.getName() + " e "
                 + "WHERE e.hourlyRate >= $1";
        OQLQuery qry = db.getOQLQuery(s);
        qry.bind(borderLine);
        QueryResults rst = qry.execute();
        while (rst.hasMore()) {
            Employee overPriced = (Employee) rst.next();
            overPriced.getHourlyRate().multiply(reducedRate);
        }
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.