About DAY

1-10 of 96Refresh

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 ... ); Expression month = cb.function("month", Integer.class, date); Expression day = cb

each 1-2 days objects on some objectdb level lock/block each other

each 1-2 days we have the situation that our system changes to a completely underperforming mode ... % and around 200 threads According to the subject of this thread it happens every 1-2 days. Can you confirm that it happens when the system is on load? Does it happen in a specific time of the day? any

several times a day queries take several minutes

take around 10 seconds but sometimes several times a day take around 3-10 minutes

General Settings and Logging

is empty ("") logging to file is disabled. Every day a new log file is generated with the name odb ... directory. The retain attribute specifies how many days to keep the archived log files

Privacy Policy

adverts. Such cookies are used for conversion and referral tracking and typically expire after 30 days

TemporalType injection with Calendar using JPA

.PersistenceException Unexpected argument (com.foo.bar.jpa.enity.TimePeriod[ day, java.util.GregorianCalendar ... ,ERA=1,YEAR=2011,MONTH=4,WEEK_OF_YEAR=22,WEEK_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_OF_DAY=19,MINUTE=14,SECOND=43,MILLISECOND=31,ZONE_OFFSET

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 ... have to group by date(). For few queries I was concatenating 'date' from year()-month()-day() calls ... ) - Extracts the date part (year, month, day) as a Date instance. TIME(ts) - Extracts the time part (hour

query on calendar class

where Calendar.DAY_OF_WEEK is FRIDAY or any other. My class: @Entity public class Cdr {     private static ... =em.createQuery("SELECT c FROM Cdr c where c.start.DAY_OF_WEEK = ?1",Cdr.class); query.setParameter ... .persistence.PersistenceException Navigation from 'java.util.Calendar' through 'DAY_OF_WEEK

Server out of memory exceptions

has typically been running for 3-4 days without issue. The stack trace doesn't provide much information. Could you get heap dump snapshots - after one day, two days, three days - in order to detect memory ... . As the real problem only presents itself after a few days the test is deliberately more extreme

Group by date / time

Hi, I'm trying to create reporting query that will return entities grouped by year / mont / day ... DAY() in ODB. So, how to build queries similar to something like this: SELECT COUNT(id) FROM ... these expressions (as an extension to JPA) - support of date/time methods (YEAR, MONTH, DAY, HOUR, MINUTE