About Time

manual

Date and Time in JPQL and Criteria Queries

Shows how date and time can be used in JPQL queries. Date and time expressions may appear in JPQL queries: as date and time literals - e.g. {d '2011-12-31'} , {t '23:59:59'} . as parameters - when date and time values are assigned as arguments. as  path expressions ...

 
forum_thread

log entry date/time

It would be very useful if each entry in the log file has a date/time stamp. Thanks, Carl   ... be very useful if each entry in the log file has a date/time stamp. Thanks, Carl   ... Version 2.2.2 adds date/time stamps to the log. Thank you for your suggestion. ...

 
manual

JPA Persistable Types

Explains how JPA manages types, including entity classes, embeddable classes, primitive types, wrappers, string, date, enum, collections and maps.... Simple Java Data Types Date and Time (Temporal) Types Multi Value Types Proxy ... java.util.Calendar , java.sql.Date , java.sql.Time , java.sql.Timestamp . Date and time types are discussed ...

 
forum_thread

find() cost unreasonable time!

Hi, I make a full binary tree of 4095 node, I check the first 9 node, but the root cost 24 seconds, why? Result: ... why? Result: =========== find time @ 24.125000 getSons time @ 0.000000 1 : type : Nodes, sons : 2 child : ...

 
manual

Database Schema Evolution

Explains how ObjectDB handles automatically schema changes.... entity class. This is done automatically in memory each time the entity object is loaded. The database object is only updated to the ...

 
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: ... a 1G DB file when the application starts for the fist time. The size of the DB file does not change during the life of the system as ... are sequential, i.e. only one DB operation runs at any one time. The load never exceeds more than 5 transactions per 10 ...

 
forum_thread

Grouping by date()

Hi, For some time now we can use date and time function in queries to extract part of date time (from documentation): YEAR({d '2011-12-31'}) is evaluated to 2011. MONTH({d '2011-12-31'}) is evaluated to 12. DAY({d '2011-12-31'}) is evaluated to 31. HOUR({t '23:59:00'}) is evaluated to 23. MINUTE({t '23:59:00'}) is evaluated to 59. SECOND({t '23:59:00'}) is evaluated to 0. ... Hi, For some time now we can use date and time function in queries to extract part of date time (from documentation): ...

 
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. ... 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 ...

 
forum_thread

Possible issue with timestamps

Hi, If I query doing something like: select c from CDI c where c.creationDate > {ts '2012-03-29 11:00:00} and c.creationDate < {ts '2012-03-29 12:00:00'} the test fails. Its ONLY for 12:00:00. When I started digging I found that if I queried 00:00:00 to 00:25:00 and then did 12:00:00 to 12:25:00 I got IDENTICAL results. For some reason 12:00:00 is being treated the same as 00:00:00. All other hours seem to be fine. ... in your posts when possible). Build 2.3.7_10 fixes this time parsing issue. import static org. junit . Assert . *; ...

 
forum_thread

Compile time enhancement using build.xml of a Netbeans web application

Does anybody have a complete, working example of the adaptations required in the build.xml of a Netbeans web application project to specify ObjectDB compile time enhancement, for both single file and whole project compilation ? The ObjectDB 2.3 manual gives the following tip: ... web application project to specify ObjectDB compile time enhancement, for both single file and whole project compilation ? ... helpful. Until now I have been working with run-time enhancement using objectdb.jar as a javaagent, but I am now seem to be ...