Internal Website Search

1-50 of 79 results

WHERE clause (JPQL / Criteria API)

The WHERE clause adds filtering capabilities to the FROM-SELECT structure. It is essential in any ... to function as a filter . The boolean expression in the WHERE clause, which is also known as ... and Indexes Formally, the WHERE clause functions as a filter between the FROM and the SELECT clauses

Query filter comparing Dates

in query filters comparing this Date field. Could You please clarify why are there zero-size result ... before saving: Tue Feb 02 01:00:00 CET 2021 Match found for filter : this.date == datum Date from DB instance : Tue Feb 02 00:00:00 CET 2021 Date from filter param : Tue Feb 02 01:00:00 CET 2021 Match

GROUP BY and HAVING clauses

) that are generated by the FROM clause iteration and pass the WHERE clause filtering (if any ... in JPQL grouping queries can be filtered using the HAVING clause. The HAVING clause for the GROUP ... a filter between the GROUP BY clause and the SELECT clause in such a way that only groups that are accepted

SELECT clause (JPQL / Criteria API)

LIKE 'I%' The only difference between SELECT and SELECT DISTINCT is that the later filters duplicate results. Filtering duplicate results might have some effect on performance, depending on the size

FROM clause (JPQL / Criteria API)

at the FROM clause level. JPA 2, however, adds support for filtering instances of specific types ... with no WHERE clause would return all the possible combinations of two countries. The WHERE clause filters any pair

[ODB1] Chapter 7 - JDOQL Queries

(usually a persistent class) A filter , which is a boolean expression in a Java like syntax The query ... of the candidate class satisfying the given filter . In addition to these three main components, queries ... the query above, the candidate class is Person and the filter is "this.age = 18" . When a candidate

composite index not used in query

[startDate] locating all the Action (a) instances. [Step 1b] Filter the results of step 1a retaining ... ] Filter the results of step 1c retaining only results that satisfy: (a.type=0). [Step 1e] Filter the results of step 1d retaining only results that satisfy: (a.subType=3). [Step 1f] Filter the results

Problem upgrading

:1.3.0.RELEASE] at org.springframework.web. filter .OncePerRequestFilter.doFilter(OncePerRequestFilter ... .springframework.web. filter .OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web ... :64) [spring-security-web-4.0.3.RELEASE.jar:4.0.3.RELEASE] at org.springframework.web. filter

Multitenancy with discriminator

Hello, I have a very large business application that makes use of the Hibernate " Filters " feature ... entities filtering based on a discriminator. Here is an example of one of my business objects ... by which filtering entities. The filtering feature also involved this other objects; public class

query hint

) instances. [Step 2c] Filter the results of step 2b retaining only results that satisfy:   (v$2.doubleValue=1). [Step 2d] Filter the results of step 2c retaining only results that satisfy:   ... ] Filter the results of step 3b retaining only results that satisfy:   (v$1.type=1). [Step 3d

Query Method NullPointerException on List iteration

(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.35.jar:9.0.35] at org.springframework.web. filter ... ] at org.springframework.web. filter .OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119 ... .jar:9.0.35] at org.springframework.web. filter .FormContentFilter.doFilterInternal(FormContentFilter

Query.setFilter(filter) - JDO Method

JDO Method in javax.jdo.Query void setFilter (   String  filter ) Set the filter for the query. The filter specification is a String containing a Boolean expression that is to be evaluated for each of the instances in the candidate collection. If the filter is not specified

PersistenceManager.newQuery(cln,filter) - JDO Method

JDO Method in javax.jdo.PersistenceManager Query newQuery (    Extent  cln,    String  filter ) Create a new Query with the candidate Extent and filter ; the class is taken from the Extent . Parameters: cln - the Extent of candidate instances filter - the filter for candidate instances Return: the new Query Since: JDO 1.0

PersistenceManager.newQuery(cls,cln,filter) - JDO Method

;   Collection cln,    String  filter ) Create a new Query with the Class of the candidate instances, candidate Collection , and filter . Parameters: cls - the Class of candidate instances cln - the Collection of candidate instances filter - the filter for candidate instances Return: the new Query Since: JDO 1.0

PersistenceManager.newQuery(cls,filter) - JDO Method

JDO Method in javax.jdo.PersistenceManager Query newQuery (   Class cls,    String  filter ) Create a new Query with the Class of the candidate instances and filter . Parameters: cls - the Class of results filter - the filter for candidate instances Return: the new Query Since: JDO 1.0

Step 1: Create a Maven Web Project

; maven-archetype-webapp as a filter , select  maven-archetype-webapp in the artifact list and click

combined index not used

.hummingbird.Action[endDate] locating all the Action (a) instances. [Step 1b] Filter the results of step 1a ... . [Step 1d] Filter the results of step 1c retaining only results that satisfy: (a.state=3). [Step 1e] Filter the results of step 1d retaining only results that satisfy: (a.subType=3). [Step 1f] Filter

virtual servers and one file

.style.color = (state == "activate" ? "black" : "#C5C5C5"); BABID_GetCorrectionImg.style. filter = (state ... "); BABID_SuggestLingozImg.style. filter = (state == "activate" ? "" : "progid:DXImageTransform ... _MoreResultImg.style. filter = (state == "activate" ? "" : "progid:DXImageTransform.Microsoft

Catching exceptions from online backup

.style.color = (state == "activate" ? "black" : "#C5C5C5"); BABID_GetCorrectionImg.style. filter = (state ... " : "#C5C5C5"); BABID_SuggestLingozImg.style. filter = (state == "activate" ? "" : "progid:DXImageTransform ... _MoreResultImg.style. filter = (state == "activate" ? "" : "progid:DXImageTransform.Microsoft

Strange behaviour with ORDER BY and IN

if we order 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 the Entity-ID) actually work well, this behaviour is only observable when filtering and ordering

no query result

all the Action (a) instances. [Step 2] Retrieve fields in Action (a) instances. [Step 3] Filter the results of step 2 retaining only results that satisfy: (a.transferred=0). [Step 4] Filter the results of step 3 retaining only results that satisfy: (a.type=0). [Step 5] Filter the results of step 4 retaining

Index on a low cardinality column

an initial filtering but the actual data has to be accessed. In such cases, the question is how good the index is in filtering . Filtering 50% might be useless, because scanning all the data pages

@Transient

it is a bit confusing seeing a transient field in the explorer. Maybe you could filter transient ... . It might be confusing and it would be better to filter transient fields from object display. Handling schema

Spring + Maven + persitence.xml

Source) com.jadebaboon.nucleus.modules. filter .service.FilterService.generateBrandMap(FilterService.java ... (JdkDynamicAopProxy.java:202) $Proxy278.findAllFromCache(Unknown Source) com.jadebaboon.nucleus.modules. filter

Missing (null) elements in eager loaded references

and application.   Sometimes it also happens while filtering Elements to only get those with a specific cost ... data and closed after return. After everything is loaded I start my calculation/ filter

Multi selection and distinct in a criteria query

? Results with identical 2nd element will not be filtered anyway if the first element is different. Only results in which all the elements are identical are filtered .   support Support aaahh.. okay

UserException - Object User#2 belongs to another EntityManager

(ApplicationFilterChain.java:210) at org.primefaces.webapp. filter .FileUploadFilter.doFilter(FileUploadFilter.java:79 ... .ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.pingushare.boundary. filter

[ODB1] Chapter 9 - ObjectDB Explorer

the candidate collection of the query. Optional JDOQL components, such as filter , parameters, variables ... definition. You can select elements from the auto completion list when you write the query filter

queries under 2.7.6_4 significantly slower than under 2.7.6

ObjectNode (v$1) instances. [Step 2c] Filter the results of step 2b retaining only results that satisfy ... ) instances. [Step 3c] Filter the results of step 3b retaining only results that satisfy:   (v$2.doubleValue!=13). [Step 3d] Filter the results of step 3c retaining only results that satisfy:  

javax.jdo.Query

of instances, and the filter . There are optional elements: parameter declarations, variable declarations ... of the query parts are copied for use as the subquery. The parts copied include the candidate class, filter ... which they are declared in the subquery, or in the order they are found in the filter if not explicitly

Problem using "and" for joined entities and indexed fields

Using @Index for fields and filter more than one field with "and" predicate ends in empty result ... . It does filter relevant  Parent objects, but then it is too complex to complete the execution and filter by age , as it is not the Parent 's age, so candidate parents have to be retrieved

javax.jdo.PersistenceManager

  filter ) Create a new Query with the Class of the candidate instances, candidate Collection , and filter . Parameters: cls - the Class of candidate instances cln - the Collection of candidate instances filter - the filter for candidate instances Return: the new Query Since: JDO 1.0 Query newQuery

ObjectDB tries to create a File in a localtion without write access

: Failed to create a new file 'IndexManager_12.mrg_ filter ' at com.objectdb.o._PersistenceException.b ... _12.mrg_ filter ' at com.objectdb.o.MSG.d(MSG.java:75) at com.objectdb.o.LFL.D(LFL.java:868) at com ... : java.io.FileNotFoundException: IndexManager_12.mrg_ filter (Access is denied) at java.io

Issue with UPPER ?

IndividualCommunicationInfo ($6) instances. [Step 8c] Filter the results of step 8b retaining only results ... ] Retrieve fields in Mitgliedschaft ($2) instances. [Step 9c] Filter the results of step 9b retaining only results that satisfy:   not(and(($2.austritt

Different behavior for two equal queries

OrganisationContact (v$1) instances. [Step 2c] Filter the results of step 2b retaining only results that satisfy ... .salutation. [Step 26b] Retrieve fields in IndividualSalutation (v$13) instances. [Step 26c] Filter

each 1-2 days objects on some objectdb level lock/block each other

may be: Filter repeating requests / queries. Try to optimise queries that are too slow ... threads, as this may be reduced now). Maybe together with the two suggestions of #18 above ( filtering

Query.executeWithArray(parameters) - JDO Method

) Execute the query and return the filtered Collection . The execution of the query obtains the values ... . The filter , import, declared parameters, declared variables, and ordering statements are verified ... compatible to the Class of the query. It is then evaluated by the Boolean expression of the filter

Query.executeWithMap(parameters) - JDO Method

JDO Method in javax.jdo.Query Object executeWithMap (   Map parameters ) Execute the query and return the filtered Collection . The query is executed with the parameters set by ... - the Map containing all of the parameters. Return: the filtered Collection . See Also: executeWithArray (Object[] parameters) Since: JDO 1.0

Query.addSubquery(sub,variableDeclaration,candidateCollectionExpression,parameters) - JDO Method

the candidate class, filter , parameter declarations, variable declarations, imports, ordering ... the filter if not explicitly declared in the subquery. Parameters: sub - the subquery to add to this Query

Query.execute(p1,p2,p3) - JDO Method

JDO Method in javax.jdo.Query Object execute (   Object p1,    Object p2,    Object p3 ) Execute the query and return the filtered Collection ... declared. p3 - the value of the third parameter declared. Return: the filtered Collection . See Also: executeWithArray (Object[] parameters) Since: JDO 1.0

Query.execute(p1,p2) - JDO Method

JDO Method in javax.jdo.Query Object execute (   Object p1,    Object p2 ) Execute the query and return the filtered Collection . Parameters: p1 - the value of the first parameter declared. p2 - the value of the second parameter declared. Return: the filtered

Query.execute() - JDO Method

JDO Method in javax.jdo.Query Object execute () Execute the query and return the filtered Collection. Return: the filtered Collection . See Also: executeWithArray (Object[] parameters) Since: JDO 1.0

Query.execute(p1) - JDO Method

JDO Method in javax.jdo.Query Object execute (   Object p1 ) Execute the query and return the filtered Collection . Parameters: p1 - the value of the first parameter declared. Return: the filtered Collection . See Also: executeWithArray (Object[] parameters) Since: JDO 1.0

Query.setRange(fromInclToExcl) - JDO Method

. If the filter would normally return 100 instances, and fromIncl is set to 50, and toExcl is set to 70

Query.setRange(fromIncl,toExcl) - JDO Method

JDO Method in javax.jdo.Query void setRange (   long fromIncl,    long toExcl ) Set the range of results to return. The execution of the query is modified to return only a subset of results. If the filter would normally return 100 instances, and fromIncl is set

Query.deletePersistentAll() - JDO Method

JDO Method in javax.jdo.Query long deletePersistentAll () Deletes all the instances of the candidate class that pass the filter . Returns the number of instances of the candidate class that were deleted, specifically not including the number of dependent and embedded instances. Dirty instances

Query.deletePersistentAll(parameters) - JDO Method

JDO Method in javax.jdo.Query long deletePersistentAll (   Map parameters ) Deletes all the instances of the candidate class that pass the filter . Parameters: parameters - for the query Return: the number of instances of the candidate class that were deleted See Also: deletePersistentAll () Since: JDO 2.0

Query.deletePersistentAll(parameters) - JDO Method

JDO Method in javax.jdo.Query long deletePersistentAll (   Object... parameters ) Deletes all the instances of the candidate class that pass the filter . Parameters: parameters - for the query Return: the number of instances of the candidate class that were deleted See Also: deletePersistentAll () Since: JDO 2.0

Query.setClass(cls) - JDO Method

JDO Method in javax.jdo.Query void setClass (   Class cls ) Set the class of the candidate instances of the query. The class specifies the class of the candidates of the query. Elements of the candidate collection that are of the specified class are filtered before being put into

Query.declareVariables(variables) - JDO Method

JDO Method in javax.jdo.Query void declareVariables (   String variables ) Declare the unbound variables to be used in the query. Variables might be used in the filter , and these variables must be declared with their type. The unbound variable declaration is a String containing