About query

171-180 of 200Refresh
Issue
13

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

Hello, we get when executing a query with MEMBER OF on a large list the following InternalException ... ) (... more see attached Image) Our query looks like this: String recordClassName = CoverageRecordImpl.class.getName(); String propertyClassName = propertyClass.getName(); String query = "SELECT DISTINCT property.uid
Forum
12

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
12

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
12

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
12

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
12

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
12

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
12

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
12

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
Manual
12

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