About DISTINCT

forum_thread

An InternalException occurs when gets an result list

[ObjectDB 2.6.4_04] Unexpected exception (Error 990) Generated by Java HotSpot(TM) Client VM 1.8.0_51 (on Windows 7 6.1). Please report this error on http://www.objectdb.com/database/issue/new com.objectdb.o.InternalException: java.lang.NullPointerException: null java.lang.NullPointerException at com.objectdb.o.VAR.S(VAR.java:297) at com.objectdb.o.VAR.R(VAR.java:259) at com.objectdb.o.SYR.y(SYR.java:515) at com.objectdb.o.QRC.x(QRC.java:192) at com.objectdb.o.QRM.Vm(QRM.java:272)... it is actually a simple query: select distinct m from ArchitectureImpl m with query option: ...

 
forum_thread

First query takes 4+ minutes to complete

Hi, we are evaluating ObjectDB 2.5.1_04 in embedded mode hoping to replace SQLite in our application. We observed that in our case it takes on average more than 4 minutes to complete the first SELECT query that we run on the DB which contains about 320,000 records of a single type of object. SQLite in comparison responds within few seconds on average with the same number of records. We hope to receive your recommendation on how to improve this result with this post.   Test System ... we tried a different query today: SELECT DISTINCT NEW com . arunta . base . db . DateExtensionDTO ( ... ;   String qs = "SELECT DISTINCT NEW com.arunta.base.db.DateExtensionDTO(r.startDate, r.toExtension) ...

 
release

2.2.0

... enabled ( issue #31 ). Fixed a bug in distinct queries (duplicates due to bad optimization). Fixed a ...

 
issue

Feature Request: Subclassed PersistenceException for Type Not Found in DB Schema

Hi,... String queryString = "select DISTINCT(summary.store) from AbstractClientSummary summary WHERE summary.chain ...

 
forum_thread

Why the internal error was thrown?

com.objectdb.o.InternalException at com.objectdb.o.CCH.H(CCH.java:298) at com.objectdb.o.CCH.E(CCH.java:155) at com.objectdb.o.QRM.Vo(QRM.java:226) at com.objectdb.o.MST.Vo(MST.java:988) at com.objectdb.o.WRA.Vo(WRA.java:311) at com.objectdb.o.WSM.Vo(WSM.java:115) at com.objectdb.o.QRR.g(QRR.java:247) at com.objectdb.o.QRR.f(QRR.java:153) at com.objectdb.jpa.JpaQuery.getResultList(JpaQuery.java:719) ... . getModelElementsByQuery ( "select distinct m from " + PoolImpl. class . getName ( ) + ...

 
forum_thread

InternalError on query of empty database

Hi, I have reasons for sometimes trying to query the database before anything has been created. The problem is the database throws a InternalException when that happens. Is it possible to throw something that identifies that that is the issue, say something like "MissingSchemaException", ie something that clearly shows its because no data of that type has been added? This just makes the exception catching cleaner. Thought thinking about it, it probably needs to be a JPA exception, maybe something like javax.persistence.EntityNotFoundException? ... Hi, Query I'm running is: SELECT DISTINCT $1 FROM CDI $1 JOIN $1.attributeList $2 JOIN $1.attributeList $3 WHERE ...

 
release

2.1.1

... enabled ( issue #31 ). Fixed a bug in distinct queries (duplicates due to bad optimization). Fixed a ...

 
release

2.1.0

... enabled ( issue #31 ). Fixed a bug in distinct queries (duplicates due to bad optimization). Fixed a ...

 
forum_thread

How to convert a boolean to an int in the query?

How to convert a boolean to an int in the query? I have five parameters of type boolean in the entity object - approveEmail, approvePhoneNumper, ... I can not sort them ORDER BY approveEmail, approvePhoneNumper, .... because the parameters equivalent. I want to sort them in the query by their sum ORDER BY (approveEmail + approvePhoneNumper + ... ) But I get an exception com.objectdb.o._PersistenceException: Invalid operand type boolean for operator + ... on the query for example SELECT DISTINCT m FROM Person m LEFT OUTER JOIN m . answers ...

 
forum_thread

"Problem" with cross join

At first, this is my first JPA Projekt - and the code should work with Hibernate and JPA, using the specifc DAOs. Following query string returns no result using ObjectDB - using Hibernate, or EclipseLink this query works fine. select distinct c from CI c, CIstring s where c.name like :SSTR or (c.id = s.ci.id AND s.text like :SSTR) The class CI (Confiugration Item):...private String name;@OneToMany(mappedBy="ci") private List<CIdata> content;... or EclipseLink this query works fine. select distinct c from CI c, CIstring s where c.name like :SSTR or (c.id = s.ci.id AND ...