About HAVING

issue

NULL reference, how to remove

we have in our db these objects, how can we remove them (we did already a -cp Doctor):     Bug Version: 1.04 Priority: Normal Status: Active Replies: 2 Type:  Bug ...

 
forum_thread

IN expression in a Criteria Query

Hello, I am trying to migrate my Spring project from Hibernate to ObjectDB. On ObjectDB page, it is written that ObjectDB is 100% compatible with JPA. However, I have problem with this JPQL query: SELECT e FROM Employee e WHERE e.present = false AND NOT EXISTS (SELECT c FROM Computer c WHERE c.employeeEntity = e) ORDER BY e.name with Hibernate, there was no problem with this query, but ObjectDB throws exception: ... a FROM Account a GROUP BY a . code HAVING COUNT ( a ) < 2 It throws following ... a FROM Account a GROUP BY a . code HAVING COUNT ( a ) < 2 This is an invalid ...

 
forum_thread

Entity name

2. Object creation I created a class named EBResult which looks like this: @Entity(name="RESULT") public class EBResult extends Pojo implements Serializable{..... In ObjectDB-explorer (which is part of ObjectDB library) I expected to see an object named "RESULT" due to class annotation @Entity(name="RESULT"). Instead I see following: #1 2017-02-10 17:28 Hello !! I am new in JPA / ObjectDB development and I have many questions:   ...

 
forum_thread

JDO @Index in JPA?

Hi! I have a project which has all entities as JPA entities. I would like to make use of indexing, which I know that it's not available in JPA, but ObjectDB works with JDO as well. Question1: will adding JDO @Index in a JPA entity have any effect or I have to switch that entity to JDO? Question2: switching entities from JPA to JDO can happen when there is already data in the database? Or do I have to delete the previous data and start with a fresh db? Thank you. #1 2014-03-01 18:45 Hi! I have a project which has all entities as JPA entities. I would like to make use of indexing, which ...

 
forum_thread

Mismatch client-server protocol prefix

Hello! We migrated one of our legacy webservices to Spring Boot/Spring MVC. Now i have a strange problem. At first the app runs perfectly for a couple of hours. After that it stops working and I get the following exception: #1 2015-06-17 16:02 Hello! We migrated one of our legacy webservices to Spring Boot/Spring MVC. Now i have a strange prob ...

 
issue

Blocked by find

I have a container object which wraps an objectdb database. There is a "putIfAbsent(String id, Object obj)" method which is synchronized and attempts to load an object by id using the EntityManager "find" method. If nothing is returned from the db the passed object is persisted to the db. I have 5 threads which use this method. In a run today one of the threads seems to have got stuck somewhere in the find. The thread dump looks like: Bug Version: Priority: High Status: Fixed Replies: 23 Type:  Bug ...

 
forum_thread

Searching lists within objects

Hi everyone,  I've a problem with searching on lists. I'm uncertain as to what the best form is, so I've created a maven project with all the classes and a unit test showing my issue. Pretty much I want to search using cb.isMember passing an object. This however does NOT work. I'm uncertain how the database is doing its matching, but it looks to me like it matches using objectids, which means you can only match isMember if you have a database object. This does not help as I'm never going to have the real object at search time. #1 2011-07-07 00:59 Hi everyone,  I've a problem with searching on lists. I'm uncertain as to what the best form ...

 
forum_thread

Merge Issue: Attempt to reuse an existing primary key value

Hello, I have just updated my objectdb version from 2.4.6 to 2.5.5. I observed a new bug or a feature on an ordinary merge operation. This is the test case ( work in 2.4.6 version ) : 2 parents object share the same child on a ManyToMany relationship with Cascade.ALL constraint. #1 2014-06-10 08:02 Hello, I have just updated my objectdb version from 2.4.6 to 2.5.5. I observed a new bug or a fea ...

 
forum_thread

Performance in large transactions

Hello, we have a performance problem when we use a large transaction. Let's do exactly the same in several transactions the ObjectDB works much faster. In our use case, we create many new entities and between the creations we call a select query. The execution of the query becomes slower at each iteration. (In the query, we search for an item of type Entity2. However, there is only one entity.)   Pseudocode for the fast and the slow solution FAST: #1 2015-03-03 15:07 Hello, we have a performance problem when we use a large transaction. Let's do exactly the same i ...

 
forum_thread

Failed to generate dynamic type

Hi  I was trying to enhance some of my classes and I got an error :  Failed to generate dynamic type com.package.RootContainer (error 361) It seems that all dependent classes are on the classpath , so what is missing or how to recognize what is wrong with that class ?? thanks in advance b ... exception name and message, it is hard to improve error, having only message which is equal to null thank you, we will check ...