About HOUR

manual

Date and Time in JPQL and Criteria Queries

Shows how date and time can be used in JPQL queries.... for extracting the YEAR , MONTH , DAY , HOUR , MINUTE and SECOND . For example: ... is evaluated to 31 . HOUR({t '23:59:00'}) is evaluated to 23 . ... See JavaDoc Reference Page... <Integer> hour = cb. function function(name, type, args) ...

 
forum_thread

RT Java application recording into 100DB run OOM after a few hours.

Hi, I am running a java application that records data from 100 feeds into 100 different database - this is done is one thread. It works fine several hours - and suddenly i got an out of memory issue (I checked there is no leak in java - I cleared the entity manager every 10 new entity). 1/ I use the default objectDb.conf (i mean i dont use any - so it must be using the default somewhere). 2/ Using Netbeans, I profiled the application and I noticed that there is one thread (ODB FileWriter) running for each open DB. #1 2015-01-02 20:11 Hi, I am running a java application that records data from 100 feeds into 100 different database - this i ...

 
issue

Negative snapshot user count exception

I found the following stack trace in my log files; it's cropped up a number of times: Bug Version: 2.5.2 Priority: Normal Status: Active Replies: 8 Type:  Bug ...

 
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. ... DAY({d '2011-12-31'}) is evaluated to 31. HOUR({t '23:59:00'}) is evaluated to 23. MINUTE({t ... instance. TIME(ts) - Extracts the time part (hour, minute, second, millisecond) as a Date instance. Please ...

 
forum_thread

Join performance in Objectdb

select count(e) from Meta e, ImageNet i, Page p where e.idImage=i.id and e.idPage=p.id; So simple a command cause me half an hour and is running now! Each table has about 160K records. What formula can predict the time for such counting? TIA ... = p . id; So simple a command cause me half an hour and is running now! Each table has about 160K records. What formula can ...

 
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: ... = em . createQuery ( "SELECT c FROM Cdr c where HOUR({ts c.start}) >= 23" , Cdr . class ) ;   Query query = em . createQuery ( "SELECT c FROM Cdr c where HOUR({t c.start}) >= 23" , Cdr . class ) ; Maybe i ...

 
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?   #1 2011-05-30 17:15 I have ObjectDB  JPA  comsummed by a RESTful web service deployed on Tomcat. I am using an embe ...

 
forum_thread

Occasionally slow requests in load testing

We are running load testing against objectdb version 2.3.7_18. The performance is generally OK, however there are quite a few "spikes" in the performance where we are getting a lot of very slow response times from the DB, around 10 - 15 seconds. Looking at the DB server process with AppDynamics we can see that most of the requests get stuck in one of 2 places: com.objectdb.o.PGC:w: line number 232 com.objectdb.o.LFL:U: line number 1068 Please see the attached callgraph examples for full stack trace examples. ... Now the database file is resized approximately every hour. Each time at the same time we see these slow response incidents. The ...

 
release

2.3.7

... ASCII string indexes. Fixed the new query HOUR function to return hours as 0 to 23 (using 24-hour clock). Fixed a regression bug in the default fetch policy. ...

 
release

2.3.6

... ASCII string indexes. Fixed the new query HOUR function to return hours as 0 to 23 (using 24-hour clock). Fixed a regression bug in the default fetch policy. ...