About @Id

forum_thread

Navigation through Path to evaluate collection

Hello, I need to evaluate a field ("identifier") which is situated in a collection, within an entity. As stated in the documentation it is not possible to navigate there with the dot operator since its a collection. Is it there a way to evaluate this field? Here is the query, the entity and the related embeddable class. Thanks #1 2016-09-04 09:17 Hello, I need to evaluate a field ("identifier") which is situated in a collection, within an entity. As ...

 
forum_thread

find() delay

Hi, I tried objectdb in following steps: 1, for 1 to 30 {trans.begin(); create typeC o; em.persist(o); trans.commit();} 2, for 1 to 30 {p = em.find(typeC.class, i); print(p)} So simple a test, there is no result in one go; I have to disable step 1 and run again, then Step 2 output the expected results. I tried em.flush(), em.clear(), etc.. that do not work. Any idea? TIA #1 2011-05-23 09:54 Hi, I tried objectdb in following steps: 1, for 1 to 30 {trans.begin(); create typeC o; em.persist(o); tr ...

 
forum_thread

Database size is much larger than expected (x2)

I store images into objectdb. The schema is : <URI>::=(<sUrl>, <cMark>, <iSize>, <baBody>, <id>) <sUrl>::=String <cMark>::=char <iSize>::=int <baBody>::=byte[] <id>::=@ID So simple a class will fail after 155,648 insertions with -Xmx1432m, #1 2011-08-18 02:10 I store images into objectdb. The schema is : <URI> ::= ( <sUrl>, <cMark&g ...

 
forum_thread

java.sql.Time field off by 30 minutes

Hihi, I'm wondering if this is a bug. I have a simple entity with java.sql.Time field. On writing and readback, the field is found to be 30 minutes off. It is observed on objectdb explorer as well. Timestamp works perfectly fine. Ps. dont think its a UTC issue. My system is set at far off UTC+30min time.   #1 2012-03-07 01:28 Hihi, I'm wondering if this is a bug. I have a simple entity with java.sql.Time field. On wri ...

 
forum_thread

Error 613 - i cant put a list<Athlete> into a Squad object

hey guys Im a swiss student and my english is not that good and ive never posted in your forum, so thats why im sorry if im doing any mistakes, but i have big trouble, because ive to get this straight till end of week. i uploaded also all classes but if u see the problem in the main problem field the classes are copied after the problem description. the structure: #1 2011-04-04 17:38 hey guys Im a swiss student and my english is not that good and ive never posted in your forum, so thats ...

 
forum_thread

Database Inconsistency or corruption

Hi, since a week I have been trying to find a solution to a strange problem. We are using ObjectDB 2.6.8_02 im embedded mode. The problem is that data gets lost when updating an entity. 1-) Background Consider Three entities: ObjectValue, Attribute and Value. ObjectValue has a one to many relationship to Attribute and Attribute has a one to one relationship to Value. #1 2016-06-27 11:16 Hi, since a week I have been trying to find a solution to a strange problem. We are using ObjectD ...

 
forum_thread

multiple LEFT JOINs do not work as expected

Hi, We have a hierarchical data set of organisations in the database, where each organisation stores a reference to it parent organisation. I'm trying to find all organisations 2 levels under a root organisation, e.g. where organisation.parentOrg is the root or organisation.parentOrg.parentOrg is the root. The query also contains a number of other predicates and it is built dynamically using Criteria API. It could be looking for other number of levels, 2 is just an example. The test query looks like this: #1 2011-12-16 05:41 Hi, We have a hierarchical data set of organisations in the database, where each organisation stores a re ...

 
forum_thread

LEFT JOIN FETCH over empty embedded collection returns no results

First of all, thank you for promptly implementing JOIN FETCH over nested paths in response to my inquiry a few months ago. However, I have run into one problem: if an embedded collection is empty, but I attempt to LEFT JOIN FETCH all the members of a collection within a (non-existent) member of the first collection, the result of the overall query is an empty set. To use the example from my original post: @Embeddable class A { String val; };   #1 2013-05-23 11:06 First of all, thank you for promptly implementing JOIN FETCH over nested paths in response to my inquiry a few mo ...

 
forum_thread

Wrong data stored in time only fields

This may be related to the fix for the problem described in this thread: Wrong data stored in date only fields. The object and its date and time fields are the same as in the referenced thread. Except we are using ObjectDB 2.6.4_08, the system time zone is set to EST and both the OS and JVM are using the 2015g time zone data. #1 2015-12-19 01:17 This may be related to the fix for the problem described in this thread: Wrong data stored in date only fields ...

 
forum_thread

Error using query with MAX() function

I have a class that is persisting a Entity that holds remarks and a time. Then when I query for the latest remark I get a internal error when the remark is larger than 1966 chars. Here is a test class and entity that reproduces the problem on my system. #1 2011-04-24 04:51 I have a class that is persisting a Entity that holds remarks and a time. Then when I query for the lates ...