ObjectDB Database Search

= em.createQuery(queryStr) . setParameter ("identityObjectName", obj.getName()) .getSingleResult ... val = em.createQuery(queryStr) . setParameter ("identityObjectName", "demo") .getSingleResult();  

;      query. setParameter ("names", Arrays.asList("a", "c"));    ... FROM Prez p WHERE p.id MEMBER OF :ids", Prez.class); prezs. setParameter ("ids", Arrays.asList(1,3

i where i.taskid=?1 and i.itemname = ?2"; Query q2 = em.createQuery(sQ2); q2. setParameter (1, iTask); q2. setParameter (2, sName); ItemList item = null; try { item = (ItemList)q2.getSingleResult

. setParameter ("cachedKey", Integer.toString(which)); try { return q.getSingleResult(); } catch ... .co.his.experiment8.model.noIdQuery.NoIdQuerySingleton.uniqueMapItem"); q. setParameter ("cachedKey

);     List result = query. setParameter ("id", id).getResultList();     ... .class); List result = query. setParameter ("id", id).getResultList(); if(result.size() 0) { Game g

;    . setParameter (p, Calendar.getInstance()).getResultList();     ... had to be specified as a  Timestamp : results = em.createQuery(query)     . setParameter (p

=RelationshipType."+type.toString(), BaseObject.class); query. setParameter ("otherParty_id", otherParty); query. setParameter ("pclass", partyClass); We have noticed that this query slows down in a linear way

WHERE e.id IN :id");         query1. setParameter ("id",idsToRequest ... ;     query2. setParameter ("id",idsToRequest);       

, sessionID));   int updateCount = query. setParameter ("value", userCredential.getRegisteredEmailD ... )); int updateCount = query. setParameter ("value", userCredential.getRegisteredEmailD()).executeUpdate

TrackerUser t WHERE t.username = :uname");         q. setParameter ("uname ... t WHERE LOWER(t.unitID) = LOWER(:uname)");         q. setParameter

. setParameter ("fromD", from.getTime());         q2. setParameter ("toD

;      . setParameter ("key", key)        . setParameter ("id", key)        ;     

"); q. setParameter ("query", "%myQuery%"); I would get an  IllegalArgumentException: Parameter ... ().createQuery("SELECT m FROM MyClass m WHERE m.myText LIKE :query OR m.myDate LIKE :query"); q. setParameter

;                   . setParameter ("value", 100.0)                     . setParameter ("uid", 12345)    

.createQuery("objectdb backup", Thread.class); backupQuery. setParameter ("target", getBackupDirectory()); backupQuery. setParameter ("name", backupSubdir); thamal Tomas Hamal ObjectDB creates files using

); backupQuery. setParameter ("target", "relative-path"); backupQuery. setParameter ("name", backupSubdir); In case

, EntityParent.class); q. setParameter (1, values); List result = q.getResultList(); @Entity public ... WHERE key member of ?1 Set params = new HashSet ( ) ; params . add ( "c2" ) ; q . setParameter ( 1 , params

= (String) m.getKey(); if (m.getValue() instanceof Date) { Date pVal = (Date) m.getValue(); qry. setParameter (pPara, pVal, TemporalType.DATE); } else { Object pVal = (Object) m.getValue(); qry. setParameter

instanceof Date) { qry. setParameter (paramName, (Date) paramValue, TemporalType.DATE); } else { qry. setParameter (paramName, paramValue); } } List resultList; try { resultList = qry.getResultList(); } catch

", License.class); query. setParameter (1, id); int changes = query.executeUpdate

.getNormName()");         query. setParameter ("names", Arrays.asList

backup");     query. setParameter ("dummy", "dummy");     

. setParameter (stringProp, "test");             List resultList

;InspirationsPerSupplierResult.class); inspirationQuery. setParameter (1, sup); Nothing special here. 

("SELECT o FROM Item o WHERE o.cachedKey = :cachedKey", Item.class);   q. setParameter ("cachedKey

"); q. setParameter ("container", this); q.setFlushMode(FlushModeType.AUTO); try { long l = (Long) q

A a WHERE TYPE(a)=:type");         query. setParameter ("type

", DailyEntry.class);     q. setParameter ("symbol", symbol);     List

I have the following bit of code: public List findFolderByName(String folderName) { TypedQuery byNameQuery = this.entityManager.createQuery("SELECT f FROM Entry f WHERE f.name=:name", Folder.class); return byNameQuery. setParameter ("name", folderName).getResultList(); } I would have assumed

SearchBookingByTimeStamp() { Calendar btime = Calendar.getInstance(); btime.set(2012, 10, 11, 7, 30, 00); //This time is already inserted, trying to find it /* My Query */ TypedQuery query = em.createQuery( "SELECT b FROM Booking b WHERE b.btime = :btime", Booking.class) . setParameter ("btime

;           . setParameter ("principal

(:bindVar)");         query. setParameter ("bindVar", "a");  

");         query. setParameter ("search", "");    

Hello, I am learning ObjectDB now. I create a simple Dao method as below:   public boolean isJobExist(String name) { TypedQuery query = em.createQuery( "SELECT count(j) FROM MFJob j WHERE j.jobName = :name", Long.class); return query. setParameter ("name", name).getSingleResult()0 ? true

Dear objectdb Team 1. I could not find a way, to declare the name of the backup-file (while running the database).  The only way I found is to create the folder in which objectdb will copy the database - file: Query backupQuery = em.createQuery("objectdb backup"); backupQuery. setParameter

, StringHolder.class); query. setParameter ("filter", "_oo%"); List results = query.getResultList

I'm getting a weird exception: java.lang.ClassCastException: database.entity.Player cannot be cast to database.entity.Player From just fetching a single result: TypedQuery query = em.createNamedQuery("Player.getPlayer", Player.class); Player player = query. setParameter ("id", uid).getSingleResult

("SELECT c FROM Cdr c where c.start.DAY_OF_WEEK = ?1",Cdr.class); query. setParameter (1,Calendar.FRIDAY

:state"; TypedQuery query = em.createQuery(strSelect, TestEntity.class); query. setParameter ("state

. setParameter ("id", msg.getId()); List loaded = query.getResultList(); Stack trace follows: rbccm.felix ... = :id", ObjectDbMessagePayload.class); query. setParameter ("id", msg.getId()); List loaded = query

.date BETWEEN :startDate AND :endDate ORDER BY t.date"); query. setParameter ("startDate", LocalDateTime.now()); query. setParameter ("endDate", LocalDateTime.now().plusDays(1)); above code returns empty list

. setParameter ("sleepInMillisPerMB", 500);// sleep for 500ms every 1MB That way I can test it live in prod ... .createQuery("objectdb backup", Thread.class); backupQuery. setParameter ("sleepInMillisPerMB", 500L));// sleep

MyEntity e WHERE e = :p");         query. setParameter ("p", e

.containerId = :containerId"); query. setParameter ("containerId", containerId); query.executeUpdate(); em

;       . setParameter ("list", new ArrayList(list1)).getResultList();  

When I run the following code: EntityManager em = getEm(); Customer result = null; try {     logger.debug("Ident: "+ident);     result = em.createQuery("Select c from Customer c where c.identifier=:id", Customer.class). setParameter ("id", ident).getSingleResult

.moneda"); List resultList = q. setParameter ("cuenta", this).getResultList(); The problem

type in http://www.objectdb.com/java/jpa/query/criteria serParameter - setParamether ravshansbox Ravshan Thanks. It was fixed now to setParameter . support Support

(queryString, Integer.class);         query. setParameter ("chain

. setParameter (1, scopeIDs); //scopeIDs is a Set List resultArray = q.getResultList(); Basically, the query