Internal Website Search

51-100 of 108 results

zip file or JAR manifest missing

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

General Performance Issues Illustrated with a Specific Method

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

Query over the keySet of a map field with collection parameter

, 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

Order in WHERE Clause affects behaviour on DATE/DATETIME columns

"); 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

Get multiple entities by Id

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

Calendar in Criteria Querys

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

Sorting problem

;icQuery = em.createQuery(q, Branch.class);     icQuery. setParameter (1, "br.id ... ;   query. setParameter ("query", "SELECT b FROM Branch b"); This is because parameters

Not able to update records

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

possible index required for improving query performance

=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

Getting sales quantity per country with a query, an idea anyone?

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

Criteria Query results in a NoResultException instead of returning object

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

Object as parameter results in exception

().createQuery(c);   q. setParameter (idParam, primaryKey);   q. setParameter (companyParam

Eager Fetch is not stable for collection or map types?

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

how to query by properties of onetomany relations? (Error 990)

the following code fails em.createQuery("select f from Foo f where f.bars.name = ?1", Foo.class). setParameter (1, barName) stacktrace: [ObjectDB 2.2.4] Unexpected exception (Error 990)   ... ");         query. setParameter ("name", "aaa");    

"where in" query

;      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

Navigation through Path to evaluate collection

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

Catching exceptions from client-server mode online backup

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

DB Files permissions

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

Bulk update of embedded entities in linked list

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

Embedded List

). setParameter (1, strSupPart); strSupPart is the part I am looking for in my Embedded List

Online backup problem

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

query on calendar class

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

ORDER BY problem, when String starts with language specific character

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

Join query problem with new statetment

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

Cast exception?

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

Query can't see recently persisted object

); query. setParameter ("oid", oid); if ("-62e6083d:1612795a01c:-6e65".equals(oid)) { logger.debug

Performance in SELECT statement

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

IN expression in a Criteria Query

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

TYPE Expression

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

Visibility of changes in Transaction is not visible to a JPA QL Query

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

com.objectdb.o.InternalException: Unexpected internal exception

); List pList = em.createNamedQuery("getPersonByName",Person.class). setParameter ("userName", name

Cannot save or update entity on Spring App

. setParameter (s, map.get(s)); boolean que = q.executeUpdate() 0; em.getTransaction().commit(); em.clear(); em

java.lang.UnsupportedOperationException

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

Help with 'not like/lower' query

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

Finding an object by its datetime

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

Memory leak with OutOfMemoryError exception

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

Like fails if both underscore and percent are used

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

createQuery method error

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

user defined backup target

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

java 8 LocalDateTime is not working in 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

NullPointer on query

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

Online Backup degrades responsiveness.

. 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

NPE on em.createQuery(query).getResultList()

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

type in http://www.objectdb.com/java/jpa/query/criteria serParameter -> setParamether

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

Blocked by find

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

NullpointerException at a normal select

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

InternalException when using MEMBER OF on a large list in a query

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

Using SELECT BETWEEN with LocalDate

I am trying to query all entities whose date is between today and today + X days. The date inside the entity is a LocalDate . To do so I created the following query: .createQuery( "SELECT e FROM Element e WHERE e. date between CURRENT_DATE and :date " , Element. class ) . setParameter ( "date

Feature Request: Subclassed PersistenceException for Type Not Found in DB Schema

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

Wrong type on SUM function

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