About DISTINCT

release

2.2.0

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

 
release

2.2.3

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

 
forum_thread

Updating Entities

Hello, I'm currently writing a program using JavaFX and ObjectDB and I'm encountering a problem with Entities not sending their updates to each other. I have two Entities in question at the moment: Employee and Paygrade. ... - objects within two separate EntityManagers are in fact distinct objects and not one and the same even if persisted from a single ... Problem: I have 2 EntityManagers that contain a distinct Entity each: Employee and Paygrade. Paygrade must remain unique and in ...

 
forum_thread

Query in JPA2 with LEFT JOIN on INNER JOIN

select a.description, a.id, p1.description, p2.description,p3.description from action a left join action_profile ap1 on ap1.id_action=a.id inner join profile p1 on  ap1.id_profile=p1.id  and p1.name='?' left join action_profile ap2 on ap2.id_action=a.id inner join profile p2 on  ap2.id_profile=p2.id  and p2.name='?' where a.id =?;   Thanks   ... = 9 while my query is SELECT DISTINCT ( a . description ) , a . id , ap1 . ...

 
release

2.2.2

... 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 ...

 
release

2.2.1

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

 
manual

FROM clause (JPQL / Criteria API)

Explains how to use the FROM clause and JOIN expressions in a JPA/JPQL query.... CURRENT_TIME, CURRENT_TIMESTAMP,DELETE, DESC, DISTINCT, ELSE, EMPTY, END, ENTRY, ESCAPE, EXISTS, FALSE, FETCH,FROM, GROUP, ...

 
issue

Issue with UPPER ?

Hi, Assuming those queries which are all the same except the UPPER calls: ... duplicates. The second query with a small change, COUNT(distinct $1) , returns 100. ObjectDB Support ...

 
issue

Once served to JSF page via @EJB query bean, many list fields are null (but same query ok after fresh persist in @PostConstruct)

I have marked this as CRITICAL because although there probably is no database integrity problem, the inability to robustly query relationship fields in a web application renders the ObjectDB system seemingly useless. objectdb-2.2.5_10 NetbeansIDE6.9.1 Glassfish3.01 client-server mode. odb file written to db-files/greendesk/greendesk.odb (see persistence.xml), copy of odb output attached. Bug Version: 2.2.5 Priority: Normal Status: Closed Replies: 19 Type:  Bug ...