Home » Search

About HOUR

1-10 of 49Refresh
Manual
106

Date and Time in JPQL and Criteria Queries

such functions as an extension. ObjectDB supports 6 functions for extracting the YEAR, MONTH, DAY, HOUR ... '}) is evaluated to 12. DAY({d '2011-12-31'}) is evaluated to 31. HOUR({t '23:59:00'}) is evaluated to 23 ... hour = cb.function("hour", Integer.class, time); Expression minute = cb.function
Forum
34

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) - I run
Forum
5

Grouping by date()

to 12. DAY({d '2011-12-31'}) is evaluated to 31. HOUR({t '23:59:00'}) is evaluated to 23. MINUTE({t ... ) - Extracts the date part (year, month, day) as a Date instance. TIME(ts) - Extracts the time part (hour ... screenshot. You are right, Calendar.HOUR was used in resetting the time part instead of Calendar.HOUR
Forum
5

TemporalType injection with Calendar using JPA

,DAY_OF_WEEK_IN_MONTH=5,AM_PM=1,HOUR=7,HOUR_OF_DAY=19,MINUTE=14,SECOND=43,MILLISECOND=31,ZONE_OFFSET ... _OF_MONTH=5,DAY_OF_MONTH=30,DAY_OF_YEAR=150,DAY_OF_WEEK=2,DAY_OF_WEEK_IN_MONTH=5,AM_PM=1,HOUR=7,HOUR ... ,DAY_OF_WEEK_IN_MONTH=5,AM_PM=1,HOUR=7,HOUR_OF_DAY=19,MINUTE=14,SECOND=43,MILLISECOND=31,ZONE_OFFSET=0
Forum
4

Occasionally slow requests in load testing

run today and I've changed it to 256mb. Now the database file is resized approximately every hour ... size, to avoid resizing. The initial size was set to 4.5GB. It was running great for 6 hours ... fine for 6 hours and then slowing down. It is of course always possible there is something wrong
Forum
4

query on calendar class

query=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 tried ... should use HOUR(c.start) instead of HOUR({t c.start}).Correct query look like (it resolve my trouble
Forum
3

Date field Index is corrupted due to time change

one hour back and moved from CEST to CET time. We store time data as part of the object, but we do not ... ) ... 17 more   It will be beneficial to us to know if time change, in particular back one hour ... the system time zone to B (we used Australia/Brisbane which is 1 hour back from Australia/Sydney
Issue
3

stress test -> com.objectdb.o.InternalException: null

to appear after some minutes or half an hour, or even an hour, depending on the load. Another point ... out of memory in ~20 minutes. With a heap of 512 MB, in around 240 min (4 hours). Both cases were tested ... to take a screenshot of the 20 minutes experiment in jVisualVM, but I took for the 4 hours
Result
3

ObjectDB version 2.3.6

Version 2.3.6 Improved performance of collection and map size evaluation in queries. Fixed a critical bug in page caching (issues #610, #621, #625). Fixed a bug in optimization of non ASCII string indexes. Fixed the new query HOUR function to return hours as 0 to 23 (using 24-hour clock). Fixed
Forum
3

Join performance in Objectdb

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 Now, after 2 hours, it is still running. Maybe I used ... execution time of hours. Since you didn't provide a test case (as requested in the posting instructions