About in

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 + ... How to convert a boolean to an int in the query? I have five parameters of type boolean in the entity object - approveEmail, approvePhoneNumber, ... I can not ...

 
forum_thread

How to package orm.xml when using EJB in WAR?

Hi, I have database utility classes in one project, the id's use sequences declared in an orm.xml file for example: ... Hi, I have database utility classes in one project, the id's use sequences declared in an orm.xml file for example: < entity class = ... both persistence.xml and orm.xml are located in src/main/resources/META-INF and Maven correctly copies META-INF and all ...

 
forum_thread

explorer locks local database in readonly mode

hi, my current use case is: execute unit test, verify results in explorer. my problem, i have to close the explorer before every run, and open it again after the tests are done. this slows down the whole process. i opened the database in readonly mode, but the file will be locked by the explorer process. do you think it's worth to improved this? if yes, isseu #39 (refresh) will be useful too. thanks ... use case is: execute unit test, verify results in explorer. my problem, i have to close the explorer before every run, ... down the whole process. i opened the database in readonly mode, but the file will be locked by the explorer process. ...

 
forum_thread

Possible Bug in MEMBER OF

Hello! I maybe found another bug in version 2.3.3. I'll send you a test DB via support ticket. Try the following query in explorer: SELECT u FROM Unit u WHERE :user MEMBER OF u.users Set user to TrackerUser#8 If i run this quey i get: Invalid operand type at.co.pjm.tracker.persistence.TrackerUser for operator MEMBER OF SELECT u FROM Unit u WHERE :user MEMBER OF u. ==> users <== In my opinion the result should be Unit#4004 ... Hello! I maybe found another bug in version 2.3.3. I'll send you a test DB via support ticket. Try the following query in explorer: SELECT u FROM Unit u WHERE :user MEMBER OF u . ...

 
forum_thread

Database is locked when in use

I am oberving that when i reading anything from odbfiles, i am not allowed to copy and paste the odb files in the file system but the same i was able to do it in object db 1.0. We supprt export functionality and if i am not allowed to copy it in objectdb 2.x, then its a problem for us :-( Do you have any settings or other way to handle this? ... odbfiles, i am not allowed to copy and paste the odb files in the file system but the same i was able to do it in object db 1.0. We supprt export functionality and if i am not ...

 
manual

ORDER BY clause (JPQL / Criteria API)

Explains how to use the ORDER BY clause in a JPA/JPQL query.... that does not include an ORDER BY clause produces results in an undefined and non-deterministic order. This page covers the ... Grouping (GROUP BY) Order ORDER BY in Criteria Queries ORDER BY Expressions The ...

 
forum_thread

How the sort order (in queries) works for non english letters?

We are considering using ObjectDB in  project where target audience are czech speaking people (we are Czech company). How the sort order works for international (for us 'czech') letters? Does the ordering respects the national requirements? Thank you for clarification ... ... We are considering using ObjectDB in  project where target audience are czech speaking people (we are Czech ... order, which is based on the order of the characters in Unicode. In Unicode, ordinary English letters are located separated from ...

 
forum_thread

Optimistic locking: prevent version increment on entity collection attribute

Hello, I have an entity E with an attribute which is a collection of entities (one to many relationship) with an optimistic locking strategy supported by a version field. Is it possible to prevent the increment of the version of entity E when entities are added to or removed from the collection? Something like the equivalent of @OptimisticLock(excluded=true) in Hibernate? Thanks, Farid ... like the equivalent of @OptimisticLock(excluded=true) in Hibernate? Thanks, Farid ... a bidirectional relationship that is owned by the entities in the collection (i.e. the collection is defined as a mapped by) then adding ...

 
forum_thread

In memory processing for ObjectDB

Hi there ! We are building a platform for trades processing where we want to keep our processing speeds very high. We like ObjectDb because its simplicity and the performance benchmarks, but to take it to next level really we wanted to check whether is there any In memory mode available for ObjectDB where recovery is possible, something like prevalyer etc. ... next level really we wanted to check whether is there any In memory mode available for ObjectDB where recovery is possible, something ... can help us here. Additionally the only cache I see in settings is query cache, is it only that query result sets are cached or I ...

 
forum_thread

java 8 LocalDateTime is not working in query

My entity class has a field of type java.time.LocalDateTime. I'm able to persist entities and I'm able to query without datetime field in where clause, but with datetime in where clause doesn't return anything and not exception.   ... entities and I'm able to query without datetime field in where clause, but with datetime in where clause doesn't return anything and no exception.   ...