About DAY

manual

Date and Time in JPQL and Criteria Queries

Shows how date and time can be used in JPQL queries.... 6 functions for extracting the YEAR , MONTH , DAY , HOUR , MINUTE and SECOND . For example: ... is evaluated to 12 . DAY({d '2011-12-31'}) is evaluated to 31 . HOUR({t ...

 
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. ... MONTH({d '2011-12-31'}) is evaluated to 12. DAY({d '2011-12-31'}) is evaluated to 31. HOUR({t ... I was concatenating 'date' from year()-month()-day() calls, but this method is quite error prone and final queries are ... DATE(ts) - Extracts the date part (year, month, day) as a Date instance. TIME(ts) - Extracts the time part ...

 
forum_thread

Group by date / time

Hi, I'm trying to create reporting query that will return entities grouped by year / mont / day. Each entity has it's own field that holds java.lang.Date. There is no function like YEAR(), MONTH() or DAY() in ODB. So, how to build queries similar to something like this: SELECT COUNT(id) FROM stats WHERE YEAR(record_date) = 2009 GROUP BY YEAR(record_date), MONTH(record_date) or maybe something like this: ... query that will return entities grouped by year / mont / day. Each entity has it's own field that holds java.lang.Date. There is no function like YEAR(), MONTH() or DAY() in ODB. So, how to build queries similar to something like this: ...

 
issue

Server out of memory exceptions

I've started to get memory exceptions on objectdb instances running as a server. The objectdb log reports this as: ... Could you get heap dump snapshots - after one day, two days, three days - in order to detect memory leakage if any. ...

 
forum_thread

Incremental online backup

Hello, Are there plans for ObjectDB to handle incremental online backups, where a backup does not create a whole new copy of the DB, but "updates" an existing backup? This behavior would make backups much faster as only a portion of the data would need to be copied. Such a feature would also allow to perform backups more often, several times a day, in order to always have a backup that's closer to the current state of the DB. Thank you ... also allow to perform backups more often, several times a day, in order to always have a backup that's closer to the current state of ... I have a database that is backed up incrementally twice a day, and one day we realize that the database has been corrupted (by which i ...

 
forum_thread

ObjectDB shuts down

Hi, we have a problem with OBjectDB shuts down every few days, sometimes every day. It always happens in the morning ie. after several hours of inactivity although we are not sure if this is the reason. Last night we maintained constant activity during the whole night (user were frequently using the application) and DB was OK. ... with OBjectDB shuts down every few days, sometimes every day. It always happens in the morning ie. after several hours of inactivity ...

 
forum_thread

Path in tomcat

Hi, If I put the .jar into /opt/Tomcat/lib/, then where the .conf should be in? And the .odb? When I debug the Eclipse web project, I export all things into a .war file. Then I use Tomcat's web deploy tool by the .war file. However, if I put objectdb into the project's /WEB-INF/, I may lost the db when I use Undeploy tool. TIA ... You can try configuration like this (it's my day to day dev environment): - create directory 'objectdb' somewhere - ...

 
forum_thread

watch out for your hosting provider migrating machines

My hosting provider recently had a very brief 'scheduled down time'. After which I was getting objectdb exceptions due to max persistent types in database (> 10). Turns out that hosting provider had migrated machines. Luckily I was able to deal with it quickly. I continue to believe that this could be improved.       #1 2012-06-01 07:31 My hosting provider recently had a very brief 'scheduled down time'. After which I was getting ob ...

 
issue

Feature Request: Subclassed PersistenceException for Type Not Found in DB Schema

Hi,... by the same ObjectDB server that are sharded based on the day.  We let ObjectdDB create the schema in each ODB file the first time ... One of the methods that returns this exception every day a before a new shard is created.     public ...

 
forum_thread

Wrong data stored in date only fileds

Hi, the following query returns records with startDate of 24/10/2015 before records with startDate of 25/10/2015: SELECT r from RecordingMetaData AS r ORDER BY r.startDate DESC, r.startTime DESC, r.channelNumber DESC If we place the same data in an SQL database and run the following query we get the records in the expected order, i.e. records with startDate of 25/10/2015 before records with startDate 24/10/2015: ... field is set to "Sat Oct 24 00:00:00 CEST 2015", i.e. one day before 25th. The other two fields are correct.   This ...