ObjectDB Database Search
1-50 of 59 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 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 | |
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 | |
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 | |
Searching lists within objects.handlers. filter .FilterTest.doCustomQuery(FilterTest.java:165) at sun.reflect | |
Native ObjectDB Support for EnumSet ? Greetings ObjectDB team, Are embedded EnumSet objects faster to query than normal classes ? Does JPA/JDO offer native support to filter persistent objects by an EnumSet field's multi values ? For example: WHERE o.es == ES.A | ES.B | ES.C Thank you ! geekox86 Mohannad AlAwad Embedded enum | |
objectdb-2.6.9_02 (with "objectdb.temp.no-enhancement-crc-check") vs. generic classes with interfaces: detailed investigation build filters bridge methods, eliminating this duplication. The other bug is when using reflection | |
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 | |
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 | |
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 :   | |
ObjectDB 2.7.6 references ( issue #2302 ). Added support of filtering mapped-by (inverse) relationship results using |