ObjectDB ObjectDB

Internal Website Search

11-20 of 200 resultsRefresh

Date field Index is corrupted due to time change

this happened. support Support Apparently we found the bug, which affects indexes on pure Date fields (i.e. date with no time). ObjectDB converts pure date values between local time and UTC ... of the time change. However, what values in the date fields will cause the corruption? An example

How to add minutes to a Date with JPA2

Hi, I have to sum to a date of minutes, and check the date obtained is greater than the current ... and verify that the current date is less than dateCapure+delayMinutes, cb.greaterThan(dateCapture ... the current date and send the result as an argument for direct comparison with the date field

java.sql.Date equals comparison not working with CriteriaAPI

Hello, Using ODB 2.4.5 and the Criteria API, doing a simple equals comparison with java.sql.Date ... = ...; Root<MyEntity> root = ...; java.sql.Date myDate = ...; Predicate predicate = builder.equal ... why this might be the case? Note: We can currently not update the ODB version as this is a production system. Note

Grouping by date()

Hi, For some time now we can use date and time function in queries to extract part of date time ... have to group by date(). For few queries I was concatenating 'date' from year()-month()-day() calls ... to add one more method to above list - date() - that will return only date from java.util.Date field

Problem with 'where' and date()

Hi, Today I was playing with some date-range queries in explorer and found a small problem. When you try to use queries like this: SELECT o from TestObject o where o.date > :someDate where o.date is java.util.Date, 'where' doesn't work as it should. Results are not filtered by date

GWT RPC is throwing serialization exception when I have object db date value

Caused by: com.google.gwt.user.client.rpc.SerializationException: Type 'objectdb.java.util.Date ... The objectdb.java.util.Date class is a subclass of java.util.Date that ObjectDB uses in order ... because Date is a special data type. You may have a similar problem with collection and map fields in

Wrong data stored in date only fileds

Hi, we have an object with the following fields: private Date startDateTime; // Time stamp: start of recording in local time zone private Date startDate; // Date: date part of startDateTime private Date startTime; // Time: time part of startDateTime @Basic


Question on dates. SQL doesn't seem to store timezone with dates (oddly). So, any best practises with ODB? 1. use java.util.Date 2. Milliseconds since January 1, 1970, 00:00:00 GMT 3. other? dmoshal David Moshal When a Date instance is stored in an ObjectDB database it is converted automatically

Entity with java.util.Date column gives ClassCastException in BIRT

JPQL query to select the fields. Entity looks like this: package entity; import java.util.Date ... ="birthdate")     @Temporal(value = TemporalType.DATE)     private Date birthdate ... the birthdate      */     public Date getBirthdate() {         return birthdate

Group by date / time

. Each entity has it's own field that holds java.lang.Date. There is no function like YEAR(), MONTH() or ... stats WHERE YEAR(record_date) = 2009 GROUP BY YEAR(record_date), MONTH(record_date) or maybe something like this: SELECT COUNT(id) FROM stats WHERE YEAR(record_date) = 2009 GROUP BY DATE

Getting Started

ObjectDB is very easy to use. Follow the Getting Started Tutorial and the Quick Tour manual chapter and in minutes you may be able to write and run first Java programs against ObjectDB.

Prior knowledge or experience in database programming (SQL, JDBC, ORM, JPA, etc.) is not required, but some background in using the Java language is essential.

Need Help?

  1. Search ObjectDB website
  2. Read the FAQ
  3. Follow the Tutorials
  4. View or post in the forum
  5. Search or file an issue
  6. Contact support