11 | Date field Index is corrupted due to time change", allocationSize=1 ) @Indices({ // Indices for popular searches @Index(members={"startDate", "startTime", "channelNumber"}), @Index(members={"startDate"}), @Index(members={"startTime"}), @Index(members={"startDate", "mapToCli", "mapFromCli |
10 | 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 |
10 | 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 |
10 | 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 | 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 | Multi part paths in a composite index must have the same length(members={"tStamp.value", "instrumentId"}) public class OBN implements Serializable{ private static ... must have the same length. Therefore, the following index definition is invalid: @Entity @Index(members ... @Index(members={"tStamp.value", "instrumentId"}) public static class OBN { @Id |
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 to search for common elements in two separate collections.I'm trying to work out the most efficient way to build a query that can compare two collections for identical members. Something like: SELECT o FROM Object o WHERE o.someCollection CONTAINS MEMBER ... . This is easier and supported by JPA: SELECT o FROM MyClass o JOIN o.someCollection e WHERE e MEMBER |
9 | JPA query of a Set of terms FROM SearchIndex si WHERE si.term MEMBER OF :terms", Page.class); query.setParameter("terms ... " + "WHERE :t1 MEMBER OF p.terms AND :t2 MEMBER OF p.terms", Page.class); query.setParameter("t1", t1 |
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 |
