ObjectDB Database Search
1-50 of 63 resultsQuery 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 | |
WHERE clause (JPQL / Criteria API) The WHERE clause adds filtering capabilities to the SELECT-FROM statement. It is essential ... to the SELECT clause to be collected as query results, the WHERE clause acts as a filter . The boolean ... and collected as query results. WHERE predicate and indexes Formally, the WHERE clause functions as a filter | |
GROUP BY and HAVING clauses and pass the WHERE clause filter are grouped before being passed to the SELECT clause. GROUP BY as ... with HAVING The HAVING clause filters the groups that result from a GROUP BY clause. The HAVING clause ... clause acts as a filter between the GROUP BY and SELECT clauses. Only groups that satisfy the HAVING | |
SELECT clause (JPQL / Criteria API) SELECT and SELECT DISTINCT is that the latter filters duplicate results. Filtering duplicate | |
FROM clause (JPQL / Criteria API). The WHERE clause filters any pair of countries that do not share a border, returning only neighboring | |
Query Parameters in JPA filters the query results to Country objects whose name field is equal to :name . The :name identifier | |
ORDER BY clause (JPQL / Criteria API) produces objects for examination, and the WHERE clause filters them. Then, the SELECT clause builds | |
Multiple inputs not supported on WHERE ?; at com.vlkan.hrrs.servlet.HrrsFilter.doFilter(HrrsFilter.java:115) ~[hrrs-servlet- filter ... ) ~[tomcat-embed-core-9.0.83.jar:9.0.83] at org.springframework.web. filter ... ) ~[main/:na] at org.springframework.web. filter .OncePerRequestFilter.doFilter | |
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 | |
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 | |
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 | |
Like fails if both underscore and percent are used StringHolder holder WHERE holder.content LIKE : filter "; Query query = em.createQuery(queryString, StringHolder.class); query.setParameter(" filter ", "_oo%"); List results = query.getResultList | |
InternalError on multiple AND and JOIN Query filtered resources, i.e. build is platform dependent! [INFO] Copying 0 resource [INFO] [compiler:compile ... -testResources}] [WARNING] Using platform encoding (UTF-8 actually) to copy filtered resources, i.e. build | |
Query with FETCH JOIN returns multiple results instead of one. You should be able to filter duplicates with DISTINCT: SELECT DISTINCT d FROM Demand d JOIN FETCH d.services ... spec clearly mentions that duplicates are not filtered unless DISTINCT is used, but many JPA | |
Use on GIS possible? fields such as bounding boxes or center points with indexes for efficient spatial filtering ... and coarse filtering directly within ObjectDB today. support Support You can also checkout for hilbert | |
@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 | |
Problem with queries on lists with reverse mapping = query7.getResultList(); assertEquals(1, q7results.size()); It looks like the result is not filtered | |
@ElementCollection query returning extra result per element in collection of (company,branch) should return the same company with different branches that match the filter | |
Composite indexes for a picture that fulfils some filter criteria, I use queries similar to this : SELECT i FROM | |
Spring Data JPA.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina. filters | |
Problem with 'where' and date() Hi, Today I was playing with some date-range queries in explorer and found a small problem. When you try to use queries like this: SELECT o from TestObject o where o.date :someDate where o.date is java.util.Date, 'where' doesn't work as it should. Results are not filtered by date | |
Error 990... and then new version? is back! But with an updated version this time! Here is updated (and filtered | |
PersistenceException UserException: Failed to validate persistence.xml(ApplicationFilterChain.java:210) at org.primefaces.webapp. filter .FileUploadFilter.doFilter(FileUploadFilter | |
TYPE Expression) when trying to get a result list. leaving it out removes the error, other filters like string equals | |
slow performance for a complex query and filter the organisations manually. However if I do that, I cannot support pagination | |
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:   | |
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 | |
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 | |
Calling List.removeIf makes object dirty even if nothing is removed, Predicate filter ) { Objects.requireNonNull(collection); Objects.requireNonNull( filter ); boolean removed = false; final Iterator it = collection.iterator(); while (it.hasNext()) { if ( filter .test | |
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 | |
Query on primary key is slow when using 'IN'.productVariantOid='1344763'). [Step 3] Merge the results of steps 1, 2 using OR. [Step 4] Filter the results ... declare HashSet parameters for the searched values, and set the query filter to: param | |
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 | |
InvalidClassException(ApplicationFilterChain.java:208) at com.spiffymap.mvp.server.servlet. filter .ErrorCatcher.doFilter | |
Bug when using SIZE in combination with date lower parameter since no tags get filtered by the query. Thanks in advance Markus doppelrittberger Markus Ritter yes, I | |
InternalException when querying indexed field using a list that contains duplicates filter like this is used: ":ids.contains(originalId)" originalId is an indexed String field | |
huge heap usage Zwicker You can see the number of open connections by filtering by PMImpl :   |