ObjectDB Database Search

1-50 of 59 results

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

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