Home » Search

About query

171-180 of 200Refresh
Issue
11

ClassCastException thrown when running count query

Hello! Attached you find a full stacktrace. The query was: SELECT COUNT(t) FROM Position t ... the query. Log of the query execution using DEBUG logging level. Hello again! I had the same issue ... for you to reproduce the crash. If you open the attached db with the explorer and run the query below it will crash
Forum
11

JPA query of a Set of terms

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 terms ... that are already persisted. TypedQuery query = em.createQuery( "SELECT DISTINCT si.page FROM SearchIndex si
Issue
10

Large query parameter - out of memory

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
Forum
10

Optimization of Map Queries

.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
Forum
10

Performance issues on aggregate query

we are using this aggregate query to collect some data: select p3.doubleValue,c1.classIdentifier,c1 ... valid;   No the problem is the following: when we query objects that have no objects linked into the relationship ObjectNode.childNodes the query takes around 1 second. when we query objects
Forum
10

Query becomes slower on moving from ObjectDB 1.x to ObjectDB 2.x

, 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
Forum
10

Speed of queries that return many objects

Hi, I have a DB of 146MB - with 1_000_000 elements. Loading the contents (objectDB query in java ... - according to blackMagicTest app for mac) - so I was expecting the query to take less than one sec (146 ... ();             TypedQuery query = em.createQuery("SELECT a FROM BenchEnt a", BenchEnt.class
Manual
10

JPA Persistable Types

are represented in queries by entity names. By default, the entity name is the unqualified name ... . their instances cannot be shared by different entity objects and they cannot be queried directly ... and retrieval is faster). It simplifies queries on dates and ranges of dates. When an entity is stored
Manual
10

JPA Primary Key

useful when using queries that return large result sets. As an example, consider a real time ... that queries that retrieve all the events of a specified sensor in a specified period are common and return thousands of Event objects. In that case the following primary key can significantly improve query run
Manual
10

Locking in JPA

); In addition, the hint can be set for a specific retrieval operation or query. Releasing ... ); A lock mode can also be set for a query in order to lock all the query result objects. When a retrieval