12 | First query takes 4+ minutes to complete. The class has data members that are basic Java types. Here is extract of the code (related ... ({ : // Indices building trees in client applications @Index(members={"startDate", "toExtension"}), @Index(members={"startDate", "fromExtension"}) }) public class |
12 | "where in" query - and the MEMBER OF operator doesn't seem to do what I want (although I may be using it incorrectly ... (since its main use is in subqueries). The following code demonstrates how to use MEMBER OF with parameter ... ( "SELECT e.name FROM MyEntity e WHERE e.name MEMBER OF :names"); query |
11 | java.lang.NullPointerException when using ORDER BY member like r.startDateTime. prolancer Emil Andonov As I was writing the previous post it occurred ... a query where the ORDER BY filed is not a member of any index. It just happens that startDateTime is not a member of any index while startDate, callDirection and mapToCli are members of (different |
11 | Strange behaviour with ORDER BY and IN by a simple member (e.g. a String) being the Entity-ID and, at the same time, filter on this member with a simple IN-clause. Filtering with IN-clause or ordering on another member (which is not ... both are done on the ID member. Assuming this simple Entity class: @Entity public class Location |
11 | possible index required for improving query performanceHi, I have the following entity class: @Entity @Table @Indices({ @Index(members={"relationshipType", "party"}), @Index(members={"relationshipType", "otherParty"}), @Index(members ... > { public static enum RelationshipType { PARENT, OWNER, ADMIN, CONTAINS, MEMBER |
9 | Error using query with MAX() function> <addDate member="addDate" memberType="java.util.Date" id="0" /> </navigations ... exp="($1.addDate!=null)" type="boolean" var="1" directVar="0" ext="1"> <member ... " directVar="0" ext="1"> <member exp="$1.addDate" type="java.util.Date" var="1 |
9 | Query over the keySet of a map field with collection parameter " + "WHERE e.map member of ?1"; TypedQuery<EntityParent> q = em.createQuery(query ... e JOIN e.map child WHERE child.value member of ?1 support Support I know this solution ... EntityParent e JOIN e.map key WHERE key member of ?1 Set<String> params = new HashSet<>(); params.add |
9 | em.flush(); em.clear(); loosing data and not persisting managed objects /> <navigations> <addDate member="addDate" memberType="java.util.Date" id ... ="0" ext="1"> <member exp="$1.addDate" type="java.util.Date" var="1" directVar ... ($1.addDate)" type="java.util.Date" var="1" directVar="0" ext="1"> <member exp |
9 | composite index not used in querywe defined a composite index for class Action: @Index(name="ssst",members={"startDate","state ... (name="ssst",members={"state","subType","type", "startDate"}) or any other order in which startDate ... . support Support the sequence of the index members is the key, thanks hgzwicker Hans-Georg Zwicker |
2 | Unexpected query token - AS artifactActivatedCalibrations WHERE ( artifactActivatedGoals MEMBER OF ?1 OR artifactActivatedAssumptions MEMBER OF ?1 OR artifactActivatedCalibrations MEMBER OF ?1 ) AND artifact MEMBER OF instanceEntryArtifactSet.artifacts Caused by: com.objectdb.o |
