Package org.exolab.castor.jdo

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

251
252
253
254
255
256
257
258
259
260
261
        // Note: product uses group, so group object has to be created first, but can
        //       be persisted later
        OQLQuery productOql = db.getOQLQuery(
                "SELECT p FROM " + Product.class.getName() + " p WHERE p.id = $1");

        productOql.bind(99);
        results = productOql.execute();
        if (!results.hasMore()) {
            Product productToCreate = new Product();
            productToCreate.setId(99);
            productToCreate.setName("product99");
View Full Code Here
155
156
157
158
159
160
161
162
163
164
165
        Database db = getJDOManager(DBNAME, MAPPING).getDatabase();

        db.begin();
        query = db.getOQLQuery("SELECT entity FROM "
                + TimeStampableEntity.class.getName() + " entity WHERE id = $1");
        query.bind(TimeStampableEntity.DEFAULT_ID);
        results = query.execute();
        assertTrue(results.hasMore());
        TimeStampableEntity first = (TimeStampableEntity) results.next();
        db.commit();
View Full Code Here
177
178
179
180
181
182
183
184
185
186
187
        LOG.debug("Expired all objects from cache.");

        db.begin();
        query = db.getOQLQuery("SELECT entity FROM "
                + TimeStampableEntity.class.getName() + " entity WHERE id = $1");
        query.bind(TimeStampableEntity.DEFAULT_ID);
        results = query.execute();
        assertTrue(results.hasMore());
        TimeStampableEntity second = (TimeStampableEntity) results.next();
        db.commit();
        db.close();
View Full Code Here
141
142
143
144
145
146
147
148
149
150
151
        LOG.debug("Testing testBasicSelect4");

        _db.begin();
        String oql = "select x from " + Entity.class.getName() + " x where id=$1";
        OQLQuery query = _db.getOQLQuery(oql);
        query.bind(MIN_ID);
        tryQuery(query, 1);   
        _db.commit();
    }
   
    /*
 
View Full Code Here
155
156
157
158
159
160
161
162
163
164
165
        LOG.debug("Testing testBasicSelect5");
       
        _db.begin();
        String oql = "select x from " + Entity.class.getName() + " x where id=$1";
        OQLQuery query = _db.getOQLQuery(oql);
        query.bind(MIN_ID - 1);
        tryQuery(query, 0);   
        _db.commit();
    }
   
    /*
 
View Full Code Here
169
170
171
172
173
174
175
176
177
178
179
        LOG.debug("Testing testBasicSelect6");

        _db.begin();
        String oql = "select x from " + Entity.class.getName() + " x where $(int)1 = 1000";
        OQLQuery query = _db.getOQLQuery(oql);
        query.bind(1000);
        tryQuery(query, MAX_ID + 1 - MIN_ID);   
        _db.commit();
    }
   
    /*
 
View Full Code Here
183
184
185
186
187
188
189
190
191
192
193
        LOG.debug("Testing testBasicSelect7");

        _db.begin();
        String oql = "select x from " + Entity.class.getName() + " x where $(int)1 = 1000";
        OQLQuery query = _db.getOQLQuery(oql);
        query.bind(2000);
        tryQuery(query, 0);   
        _db.commit();
    }
   
    /*
 
View Full Code Here
197
198
199
200
201
202
203
204
205
206
207
        LOG.debug("Testing testBasicSelect8");

        _db.begin();
        String oql = "select x from " + Entity.class.getName() + " x where id>$1 and id<$2";
        OQLQuery query = _db.getOQLQuery(oql);
        query.bind(MIN_ID);
        query.bind(MAX_ID);
        tryQuery(query, MAX_ID + 1 - MIN_ID - 2);   
        _db.commit();
    }
   
View Full Code Here
198
199
200
201
202
203
204
205
206
207
208
        _db.begin();
        String oql = "select x from " + Entity.class.getName() + " x where id>$1 and id<$2";
        OQLQuery query = _db.getOQLQuery(oql);
        query.bind(MIN_ID);
        query.bind(MAX_ID);
        tryQuery(query, MAX_ID + 1 - MIN_ID - 2);   
        _db.commit();
    }
   
    /*
 
View Full Code Here
212
213
214
215
216
217
218
219
220
221
222
        LOG.debug("Testing testBasicSelect9");

        _db.begin();
        String oql = "select x from " + Entity.class.getName() + " x where id>$1 and id<$2";
        OQLQuery query = _db.getOQLQuery(oql);
        query.bind(MIN_ID);
        query.bind(MAX_ID);
        tryQuery(query, MAX_ID + 1 - MIN_ID - 2);   
        _db.commit();
    }
   
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.