About ORDER BY

forum_thread

License Activation Change and Checking Activation

Hello! How does ObjectDB determine the machine ID? Yesterday I activated our license on my development laptop and today I tried to persist more than 1M objects. ObjectDB told me that it cant't do that because of the evaluation restrictions. Now I activated it again on the same machine and got a different activation code. With this code it works. The only difference I can think of is that my WiFi was disabled yesterday and today it's not. ... Avoid overflow of published source code examples by breaking long lines . You may mark in paragraph code words ... names) with the code style (can be applied by ctrl + D). Long stack traces (> 50 lines) and complex ...

 
forum_thread

How to use JOIN FETCH?

The ObjectDB manual (http://www.objectdb.com/java/jpa/query/jpql/from) gives an example of using JOIN FETCH to avoid excessive round trips to the database: ... is normal for JOIN FETCH and you can remove duplication by using SELECT DISTINCT . ObjectDB Support ... Avoid overflow of published source code examples by breaking long lines . You may mark in paragraph code words ...

 
forum_thread

@AttributeOverrides , and postgresql + own TYPE

Hello,  first of all i want to thank for this is site. I'm begginer in Java and also in JPA and this site is very helpful for me. Now What is my problem. Unfortunately  i have to work with postgresql + JPA + eclipselink, because is my school project. Database is final and i can't do any changes even if i wanted to. In structure of DB  is this. -- -- Name: address; Type: TYPE; Schema: artio; Owner: facman --   ... Avoid overflow of published source code examples by breaking long lines . You may mark in paragraph code words ... names) with the code style (can be applied by ctrl + D). Long stack traces (> 50 lines) and complex ...

 
issue

Page #9 entry 0 (key 'bjjl') has 75 extra bytes / Unexpected last index ID: -119 (expected -116)

Please check the attached database file. When running the Doctor, I get   Global Value Errors ------------------- [1] Unexpected last index ID: -119 (expected -116) Page Content Errors ------------------- [1] Page #9 entry 0 has unexpected object format [2] Page #9 entry 0 (key 'bjjl') has 75 extra bytes   Both errors are not fixable. When creating a new db file with the Doctor, this file yields the same errors. Please advise.  ... [1] BTree #5122(5122):5713873 Referenced by:   - odbbug.Person(2):'guest'   ... Avoid overflow of published source code examples by breaking long lines . You may mark in paragraph code words ...

 
forum_thread

TemporalType injection with Calendar using JPA

I have ObjectDB  JPA  comsummed by a RESTful web service deployed on Tomcat. I am using an embedded object as a primary key, which has time fields which I have annotated with TemporalType.TIMESTAMP When I use a java.util.Date as a field on this object there is no problem. However, if I use a java.util.Calendar it encounters an exception.   Calendar is what I need.  Is there something obvious here that I am failing to see?   ... I have ObjectDB  JPA  comsummed by a RESTful web service deployed on Tomcat. I am using an embedded ... java.lang.Thread.run(Thread.java:619) Caused by: com.objectdb.o.UserException: Unexpected argument ... 43 more Caused by: com.objectdb.o.InternalException at com.objectdb.o.VUT.e(VUT.java:220) at ...

 
issue

NullPointer on query

I'm getting a null pointer when running the following code: TypedQuery<ObjectDbMessagePayload> query = em.createQuery("SELECT m FROM ObjectDbMessagePayload m WHERE m.id = :id", ObjectDbMessagePayload.class); query.setParameter("id", msg.getId()); List<ObjectDbMessagePayload> loaded = query.getResultList(); Stack trace follows: ... Source) at java.lang.Thread.run(Thread.java:662) Caused by: com.objectdb.o.InternalException: Unexpected internal exception at ... Source) ... 4 more Caused by: java.lang.NullPointerException at com.objectdb.o.OBI.t(OBI.java:377) at ... is too heavy to send as an example (6hrs runtime backed up by a large grid...). My attempts to recreate the issue in a cutdown version of ...

 
issue

Exception on the recovery of a database

I've also had this similar exception on the recovery of a database: ... Avoid overflow of published source code examples by breaking long lines . You may mark in paragraph code words ... names) with the code style (can be applied by ctrl + D). Long stack traces (> 50 lines) and complex ...

 
forum_thread

Wrong data stored in date only fileds

Hi, the following query returns records with startDate of 24/10/2015 before records with startDate of 25/10/2015: SELECT r from RecordingMetaData AS r ORDER BY r.startDate DESC, r.startTime DESC, r.channelNumber DESC If we place the same data in an SQL database and run the following query we get the records in the expected order, i.e. records with startDate of 25/10/2015 before records with startDate 24/10/2015: ... Enhanced classes have __odbHidden methods added by the Enhancer. There is a change in this build, following this forum thread ... Avoid overflow of published source code examples by breaking long lines . You may mark in paragraph code words ...

 
issue

InternalException

  ... 2.4.2] Unexpected exception (Error 990) Generated by Java HotSpot(TM) Client VM 1.6.0_25 (on Linux 2.6.32.12). Please report this ... Avoid overflow of published source code examples by breaking long lines . You may mark in paragraph code words ...

 
forum_thread

Help with JPA2 Criteria and conditional operator grouping

Hi,   I'm getting a little trouble performing a query as per the way I had it set up on eclipselink. Essentially, the query I'm trying to generate is: SELECT $1 FROM Company $1 WHERE (($1.companyId=:p1) AND ($1.conditionOne=true)) AND (($1.conditionTwo=false) OR ($1.conditionThree=false))   From the JPA2 criteria: ... Avoid overflow of published source code examples by breaking long lines . You may mark in paragraph code words ... names) with the code style (can be applied by ctrl + D). Long stack traces (> 50 lines) and complex ...