About YEAR

manual

Date and Time in JPQL and Criteria Queries

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

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

 
forum_thread

ObjectDB future

Hi, For how long ObjectDB will exist and will be actively maintained? Will it still be there in 10 years? In 20 years? Thanks, Anton. #1 2016-06-01 11:53 Hi, For how long ObjectDB will exist and will be actively maintained? Will it still be there in 10 years? ...

 
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. ... to extract part of date time (from documentation): YEAR({d '2011-12-31'}) is evaluated to 2011. MONTH({d ... For few queries I was concatenating 'date' from year()-month()-day() calls, but this method is quite error prone and final ...

 
forum_thread

Failed to read the value of field using reflection (error 363)

I have encountered this error from one of the many servers hosting my application. Other servers didn't encounter errors of this kind and running without problems. My system provider said that nearly all of the servers are VM-based including this one which encountered this error. It is the 'youngest' server in deployment. I can get more information as you require. As the application developer, I am perplexed as I have use JPA and ObjectDB for years now. I could use your assistance in overcoming this problem. Thank you. ----- #1 2014-02-07 02:28 I have encountered this error from one of the many servers hosting my application. Other servers didn't encou ...

 
forum_thread

Should I use ObjectDB and JDO?

My application is not meeting required performance because JavaDB appears to be my bottleneck.  I require a faster DB.  Surveying the Internet lead me to believe that ObjectDB might be just what I am looking for (to achieve MUCH faster database access).  But, I have a few concerns.   #1 2016-07-09 15:19 My application is not meeting required performance because JavaDB appears to be my bottleneck.  I require a ...

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

 
manual

[ODB1] Chapter 7 - JDOQL Queries

Explains how to use JDOQL, the Java/JDO Query Language.... a Date instance representing the first day of the year 2000. The query is declared with a parameter date of type Date , ... older than at least one of their children by more than 25 year. But because of the ! operator, eventually, the result collection ...

 
issue

ObjectDB 2 JDO Manual

The new ObjectDB Manual describes how to use ObjectDB 2 with JPA. An additional manual that focuses on using ObjectDB 2 with JDO can help JDO users. But since writing a new manual and then maintaining two similar manuals, one for JPA and the other for JDO requires sufficient effort, this will be done only if there is sufficient demand.  ... in a university course on database technology. Last year we used odb104fe, and I was happy to see the updated web page and the ...

 
forum_thread

Great product - needs better marketing - more popularity

Hi, ObjectDB! While you have a very nice product, which I recommend everywhere I go, it is quite difficult to explain to my customers what is it and why we should use it, and things like that, because it's quite unknown.  It's a great product, therefore I'm building the 3rd product based on ObjectDB since the beginning of this year, but I think it would be much better if your db was more popular. ... 3rd product based on ObjectDB since the beginning of this year, but I think it would be much better if your db was more popular. ...