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 ... + "WHERE item.sku =: key " + "OR id MEMBER OF :item.apiId.identifier " + "ORDER BY item.sku DESC" ... , key ) . setParameter ( "id" , key ) ; List<ProductData> lists = ...

 
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 ... final class MyEntity { @ Id @ GeneratedValue long id ; } } Try to change this example to ...

 
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, ... <cMark>, <iSize>, <baBody>, <id> ) <sUrl> ::= String <cMark> ::= char ... int <baBody> ::= byte [ ] <id> ::= @ ID So simple a class will fail after 155,648 insertions with ...

 
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.   ... static class MyEntity { @ Id @ GeneratedValue ( strategy = ... . AUTO ) private long id ; String myname = "Roger" ; java. sql . ... { return "MyEntity{" + "id=" + id + ", myname=" + myname + ", ...

 
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: ... ; import javax. persistence . Id ; import javax. persistence . OneToMany ;   @ ... long serialVersionUID = 1L ; @ Id @ GeneratedValue private long id ; ...

 
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. ... of the object I want to update. ObjectValue ID:=100, TYPE:=Person, REVISION:=0, isPersisted:=true, ... ... Attribute  ID:=1400, Name:=profileName, Value:=ID:=1400, PrimitiveValue:=ProfileName 99, REVISION:=0, isPersisted:=true ...

 
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: ... { @ GeneratedValue @ Id private long id ; Node parent ; int depth ;   Node ...

 
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; };   ... @ Entity class C { @ Id long id ; List<B> bList ; } ; If I have an ...

 
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. ... ; import javax. persistence . Id ; import javax. persistence . Persistence ; import ... class DateTime { private Long id ; private Long version ;   private Date ...

 
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. ... public class TestEntity { @ Id private int id ; @ Basic @ Lob private String remark ; ...