Home » Search

About query

171-180 of 200Refresh
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
Forum
10

Help with 'not like/lower' query

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. This is using
Forum
10

possible index required for improving query performance

; } 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
Issue
10

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
10

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
9

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
9

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
9

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
9

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
9

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