About between

manual

FROM clause (JPQL / Criteria API)

Explains how to use the FROM clause and JOIN expressions in a JPA/JPQL query.... words: ABS, ALL, AND, ANY, AS, ASC, AVG, BETWEEN, BIT_LENGTH, BOTH, BY, CASE, CHAR_LENGTH, CHARACTER_LENGTH, CLASS, ...

 
forum_thread

problem with lazy loading - unittest project attached

hi, i'm still testing objectdb together with spring-data-jpa. i made a test which should simulate 4 requests 1. save entity 2. read an existing entity, add onetomany relation 3. read an existing entity, add another onetomany relation 4. read entity, get relations. i have the feeling this is not the optional way to test this, because of the differnt transaction behavior. the test is not transactional, but the spring repository methods are. ... object becomes detached. Since the relationship between Foo And Bar is lazy - it is unavailable in a detached Foo ...

 
release

2.4.7

... than 2GB. Fixed a bug in running queries between flush and commit. Fixed a deadlock ( issue #62 ). ...

 
forum_thread

query on calendar class

Hello!   I'm looking for help to build query on calendar class. I need to get objects where Calendar.DAY_OF_WEEK is FRIDAY or any other. My class: @Entity public class Cdr {     private static final long serialVersionUID = 1L;        @Id @GeneratedValue     private long serialID;     private String A;     @Temporal(TemporalType.TIMESTAMP) private Calendar start; I tested: ... createQuery ( "select c from Cdr c where c.start between {ts '2044-12-01 00:00:00'} and {ts '2044-12-01 01:00:00'}" , Cdr ...

 
release

2.4.6

... than 2GB. Fixed a bug in running queries between flush and commit. Fixed a deadlock ( issue #62 ). ...

 
forum_thread

Date field Index is corrupted due to time change

Hi, can you shed some light on why we cannot delete data from the attached DB file. A delete attempt with DB explorer results in the following exception: ... with no time). ObjectDB converts pure date values between local time and UTC more than once during transaction commit, and on ... to the BTree leaf pages) and the change of the offset is between these write operations, i.e. different levels of the BTree hold ...

 
forum_thread

JDO sequences from ORM file

I want to use sequences in JDO without using annotations. Normally this is done with a package-X.orm file, where X is a value passed to the PersistenceManagerFactory as the value of property "mapping". I'm encouraged to see that the JDO zip that comes with ObjectDB includes the DTD/XSD for this type of file, though I can't see a mention of it in the manual. ... to use the fully qualified name to prevent clashes between sequences of the same name in different packages. It's certainly ...

 
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 ... to maintain the inverse fields, then is there a conflict between manual and auto relations? Suppose the Employee and the address are all ...

 
release

2.4.5

... than 2GB. Fixed a bug in running queries between flush and commit. Fixed a deadlock ( issue #62 ). ...

 
forum_thread

Optimization Question

One of our uses for your ObjectDB software is in maintaining the current state of a large number of data objects called tracks. These tracks change very frequently over time (every 10-15 seconds is not unreasonable), but they are also very large complex data structures so it's extremely difficult to identify exactly what fields have changed from one update to the next. Currently the following sequence executes when a track update comes in: - If it’s a new track simply add it to the database.... of data is incorrect.  I could do some synchronization between the threads to ensure only one is transacting the database at any given ...