About query

181-190 of 200Refresh
Forum
9

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
9

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
9

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
9

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
Issue
9

unclear syntax for update query

. Query Update Action Set transferred = 0 where a.objectsInCharge.nodePath like "/(PR)W4455NS01%" and a.objectsInCharge.nodePath like "%MARAS%" results in Query Execution Error ===================== Unexpected query token 'a' Update Action Set transferred = 0