ObjectDB Database Search

to it. The client program can connect to the server and query to get all the records ... [Remarks] 01 Test_Connection: connecting 02 Test_Connection: connected 03 UI: start query [ query ...   05 code= %, desc= % 06 UI: end query 07 UI: start printing result 08 code= A, desc= Good

When using the CriteriaBuilder to query , the loaded list are not refreshed according to the latest updates. But, when using the JPQL Query , the list are refreshed, and, when I querying ... on update side does not any diference. The problem is only solved when changing the query mode, from

How to convert a boolean to an int in the query ? I have five parameters of type boolean in ... , approvePhoneNumber, .... because the parameters equivalent. I want to sort them in the query by their sum ... queries . It is possible to add this to ObjectDB in future versions, but using a pre-calculated field

some years ago there was a chat around query hints http://www.objectdb.com/issue/2417 we are currently trying that with the latest version but we do not see that our hint is used this is the query ... .name = 'slots' and p4.doubleValue 0)) [[objectdb. query -plan-text=index(ctso['(TC)'-'(TC

Hello!   I'm looking for help to build query on calendar class. I need to get objects ... ; @Temporal(TemporalType.TIMESTAMP) private Calendar start; I tested: Query query =em.createQuery("SELECT c FROM Cdr c where c.start.DAY_OF_WEEK = ?1",Cdr.class); query .setParameter(1,Calendar.FRIDAY

, it is written that ObjectDB is 100% compatible with JPA. However, I have problem with this JPQL query ... .employeeEntity = e) ORDER BY e.name with Hibernate, there was no problem with this query , but ObjectDB throws exception: com.objectdb.o.UserException: Unexpected query token 'EXISTS' Second problem

Hi, We have a query that is constructed dynamically, an example is like this: SELECT DISTINCT $1 ... ')))) I've also tried running the CDI query first and passing the results into the organisation query as ... for issue http://www.objectdb.com/database/forum/350 This query in both variations takes over 3

- it should be replaced by a more descriptive error message in future versions. However, this query ... a variable that will iterate over the collection elements. This specific query should be rewritten ... sql joins :) in my last projects i have been using mongodb and such a query was possible for embedded

SELECT query that we run on the DB which contains about 320,000 records of a single type of object ... (related to the query that we run). @Entity(name="RecordingMetaData") @SequenceGenerator( name ... EntityManager runs the queries (JPQL SELECT statements) shown next.  Query We test

; } With the following query : TypedQuery query = em().createQuery( "SELECT r.party FROM Relationship r ... =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

Hi, Is it possible to write a JPA query to select objects that contain a collection of elements ... WHERE si.term ????",Page.class); I want the query to give me all Pages that match all of the search ... that are already persisted. TypedQuery query = em.createQuery( "SELECT DISTINCT si.page FROM SearchIndex si

in query filters comparing this Date field. Could You please clarify why are there zero-size result collections in the first pack of queries and non-zero size results in the second pack ? I ... (); // these queries should find 1 item assertQueryResultSize(0, pm.newQuery(ClassWithDate.class

, with object 1.x, the same query was getting executed within an seconds and now the same is taking around 40 seconds in object db 2.x I have build the query using the follwoing Query query = persistanceManager ... (this.logEntryId)"); query .declareParameters("java.util.List typeIndexes,java.util.List

Hi all,   Honestly, I'm fairly new with JPA2 Criteria queries - but as far as code effort goes, it has saved me a bit of pain. I'm writing a dynamic query builder (only 1 level deep for basic entities) - but  even though I get most queries to work, I am getting the following error

.get(..) result(s) once to not query the map again and again for each test in my query ? 2) Is there anything I could do for shortening the query string? I guess there's no such thing as a "temporary" variable for being used in the query .. I am creating the query using criteriabuilder, then I am converting

Hello, we have a question again regarding query performance. The query : SELECT v FROM Values v WHERE v.step.stepNumber = ? is very slow in comparing to the query : SELECT v FROM Values v WHERE v.stepNumber = ? Can you explain why the first query needs so much time or do you have a hint

and there are performances issues. I am doing small queries and they take much longer than I expect, i.e.: Get the total ... query needs 4 to 5 minutes to return a result. I have been adviced to use indexes ... transient LogEntryImpl logEntryImpl; ... And I use such query : Query query = pm.newQuery(MessageImpl

of one of these entities. If I execute that query I get an exception;   Caused by: com.objectdb.o ... the query on objdbTest.Item package objdbTest; import .... @Entity @NamedQueries({ @NamedQuery(name = "objdbTest.Singleton.getItem", query = "SELECT o FROM Item o WHERE o.cachedKey = :cachedKey

Hi, i am having troubles creating criteria querys for Calendar objects. As far as I ... Class got such methods, but i dont know how to use those in my query . suez Tobias JPA supports 3 ... and may have some limitations. Anyway, the following example demonstrates criteria queries with Calendar

I create a new entity T newT and persistend it,then I create a query "select t from T t" to fetch all T entities.But  then the newT is not contain in the query result. Why? code order: query .setFlushMode(FlushModeType.AUTO); query .getResultList();   maozf maozf The following example

()])); return em.createQuery(criteria).getSingleResult(); which evaluates to the query : SELECT $1 FROM ... .RuntimeException: com.objectdb.o._NoResultException: No matching results for a unique query at org.jboss.seam ... ._NoResultException: No matching results for a unique query at com.objectdb.o.JPE.g(JPE.java:100

Hi, I have a query similar to this one: select person.name, person.surname, ... ... from Entity e ... , and there is only on Entity in the database. Execution of this query (running with ObjectDB) takes about 10-12 seconds. If i remove ANY 5 left joins, query execution time drops to about 50

Hi, Is is possible in any way to get string representation of a query right before execution, after setting parameters? Of course it's easy to print out query string when we build it by ... implementation. What exactly do you suggest? The query string with parameter values embedded, replacing

Dear ObjectDB, Can someone give me a tip, to make the aggregated query work. I am filling a tableview with a normal query "SELECT p From Recept p, with no problem. But when I trying to fill a tableview with an aggregated query : "SELECT SUM(getValue()) AS value ,getUnit() AS unit,getName() AS name

Hello, i'm new to ObjectDB and want to create a query which sums up the product categories ... : categoryId categoryName   Expected query outcome: SupplierName Category1_Count Category2_Count ... to do this with a query method: select s.supplierName, s.countCategory("category1") as Category1, s.countCategory

understand that making a query just on entity.id.field1 is efficient. Of course, making a query ... is: what about making a query just on entity.id.field2? I suppose it will not be an efficient query ... can be part of user defined indexed. Accordingly queries on field1 (and on both fields) will be fast

is the producer from DB (based on a query ) and I would like to speed it up. I have tried using several entity ... - i.e. each query in a thread is running simultaneously - but it looks sometimes the " query threads ... what it is - but my guess it is coming from some ObjectDB low level I/O settings? Any help on how to speed up query by

;the objectdb server can run out of memory and stop if a query deals with too many objects. This isn't ... of Java heap space in any scenario. Regarding a query that returns too many objects, consider limiting the number of result objects . If you must support very large query result sets, check the temp

i'm curious as to how the explorer is able to execute queries when its obviously not aware ... to execute somewhat generalized queries and i won't know what classes are in the object model ahead ... need the classes for running ordinary queries . However, if you use user defined methods in queries

Hi we have a problem with queries , database is returning wrong results. These are the queries we run from ObjectDB explorer. Query 1 - SELECT MAX(e.generisaniID) FROM AktImpl e – returns string (from field e.brojAkta) although field generisaniID is of type long. Query 2 - select e.idRecord, e

of a query : so far we are not optimizing the order of conditions in the where clauses of our queries . Would it make sense to have indexed fields first and then the others, or is that something that the query compiler/optimizer is doing automatically? For example, Entity TestObject has fields id

Hello, I am experiencing constant IMK Stall notifications from Java when using certain query ... with objectdb as these are thrown each time one particular query is used: String param = "%"+begining+"%"; CriteriaBuilder cb = DataBase.em.getCriteriaBuilder(); CriteriaQuery query = cb.createQuery

Is there a way in the Explorer to associate JPQL queries with query result windows?  I would really like to be able to open multiple query / result tabbed panes and be able to save out my queries , similar to what you can do in Benthic Golden or Toad in the SQL world. Alternatively

sets is undefined. The hints element may be used to specify query properties and hints. Properties ... recognized by a provider must be ignored. All parameters of a named stored procedure query ... StoredProcedureParameter Since: Jakarta Persistence (JPA) 2.1 Public Instance Methods QueryHint[] hints () Query

indicating deep query plan checks and an overall significant performance loss in all queries ... since version 2.7.6 that could possibly effect query execution. Could you please explain or post some of these logs that show deep query plan checks (and are new in 2.7.6_04)? In addition

); } } } We have about 200M instances of this entity. The following query finishes instantly: SELECT FROM ... = '1344770') Query plan 1/2 description ============================ [Step 1] Scan type eu.extech ... equalities to IN, the query suddenly takes 2.5 minutes: SELECT FROM ProductVariantStoreData d WHERE d

for executing a Jakarta Persistence query language named query . The select list of the query must contain ... . Parameters: name - the name of a query defined in metadata resultClass - the type of the query result Returns: the new query instance. Throws: IllegalArgumentException - if a query has not been defined

Hello, we get when executing a query with MEMBER OF on a large list the following ... .o.PBI.q(PBI.jave:97) at com.objectdb.o.OBI.Vp(OBI.java:244) (... more see attached Image) Our query ... propertyClassName = propertyClass.getName(); String query = "SELECT DISTINCT property.uid FROM

make a query for only one field, it takes 0-3 milliseconds: SELECT p FROM RackPlanogram p WHERE p.rackOID = "826268" Query plan 1/2 description ============================ [Step 1] Scan index eu.extech ... '*:notNull]) /   However, when I make a query for two fields, ObjectDB does a scan

Hello! Attached you find a full stacktrace. The query was: SELECT COUNT(t) FROM Position t ... for the fields in the query . Log of the query execution using DEBUG logging level. support Support Hello ... the query below it will crash with the exception in crash.txt. select p from Position p where p.unit

file as it goes. It then loops through the data from the file and queries for the entity id based ... this should be sufficient as I only create/read one item of data at a time and am only querying for the id. After about 300 queries the test throws an out of memory exception so I assume the query data is being held

ObjectDB 2.8.7.b08 Our entities are not enhanced and we execute a query "select max(uid) from ... exception after execution of the query : Caused by: com.objectdb.o.UserException: Unexpected query token ... : Unexpected query token 'uid'. If the entities are enhanced then the query works without exception. btc

Hi, I've got two equal queries though they behave differently: SELECT FROM com.quasado.foundation ... Here're also the execution plans from the explorer if that helps: First query (which works): Query Plan ... and prepare final results. Second query (which fails): Query Plan Description

I'm getting a null pointer when running the following code: TypedQuery query = em.createQuery("SELECT m FROM ObjectDbMessagePayload m WHERE m.id = :id", ObjectDbMessagePayload.class); query .setParameter("id", msg.getId()); List loaded = query .getResultList(); Stack trace follows: rbccm.felix

OF item.labels But when I search for an item that have two specific labels, the following query ... .labels Is it a bug or JPQL query is wrong? Best regards, Pablo. Pablo Berra Pablo Berra This seems to be the result of how JPQL queries are converted into SQL like syntax before executing. MEMBER

When using JQL-Update Queries it is basically not working without calling entityManager.clear ... - Query and fetching Entities afterwards from database. Expected result: Getting changed Entities from ... using UPDATE- Query , calling entityManger.clear() and fetching Entities afterwards from database

I'm getting the ClassCastException below when querying objects. As yet I haven't been able to track down the exact circumstance in which it occurs - saving and querying objects works fine ... (Unknown Source) at rbccm.felix.gridservice.admin.dao.SimpleWorkflowInstanceDao. query (Unknown Source

.java:143 is the last line of the following: Query query = pm.newQuery(); query .setResult("count(this)"); query .setClass(myClass); return (Long) query .execute(); All queries (eg ones with parameters ... , and the cause is unknown. It happens during cleanup of query execution in a finally block. Maybe

(). Afterwards the entity can be load again by query although the resulted entity have an attribute ... . Apparently the query was directed to the wrong snapshot. Are you sure that this bug exists in 2.7.4 ... a particular transaction. When changes are flushed, a snapshot is generated, and further queries in

able to query without datetime field in where clause, but with datetime in where clause doesn't ... ().getEntityManger(); Query query = em.createQuery(     "SELECT t FROM Test t WHERE t.date BETWEEN :startDate AND :endDate ORDER BY t.date"); query .setParameter("startDate", LocalDateTime