ObjectDB ObjectDB

Internal Website Search

1-10 of 38 resultsRefresh

Date and Time in JPQL and Criteria Queries

such functions as an extension. 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. MONTH({d '2011-12-31 ... ); Expression<Integer> month = cb.function("month", Integer.class, date); Expression<Integer> day = cb

TemporalType injection with Calendar using JPA

,endDayOfWeek=1,endTime=3600000,endTimeMode=2]],firstDayOfWeek=2,minimalDaysInFirstWeek=4,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 ... ]],firstDayOfWeek=2,minimalDaysInFirstWeek=4,ERA=1,YEAR=2011,MONTH=4,WEEK_OF_YEAR=22,WEEK_OF_MONTH=5,DAY_OF_MONTH

Getting sales quantity per country with a query, an idea anyone?

.getPaidTimeD()) and for a given month back in time. The resulting Object list contains the 3 SELECT ... .MONTH, monthBack + 1); to.set(to.get(Calendar.YEAR), to.get(Calendar.MONTH), 1); if (to.after(now)) {to = now;} Calendar from = (GregorianCalendar) now.clone(); from.add(Calendar.MONTH, monthBack); from

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 ... (YEAR, MONTH, DAY, HOUR, MINUTE, SECOND) was just added to ObjectDB in build 2.2.8_02. For example

Grouping by date()

(from documentation): YEAR({d '2011-12-31'}) is evaluated to 2011. MONTH({d '2011-12-31'}) is evaluated ... have to group by date(). For few queries I was concatenating 'date' from year()-month()-day() calls ... in queries: DATE(ts) - Extracts the date part (year, month, day) as a Date instance. TIME(ts

ObjectDB and Spring Boot - sharing a simple working example

Person p WHERE MONTH(p.birthDate) = :month")     List<Person> findAllByBirthDateMonth(int month

General Performance Issues Illustrated with a Specific Method

."); } else if (getAgeYears() > 0) { setAge(period.getYears() + " years and " + period.getMonths() + " months."); } else { setAge(period.getMonths() + " months and " + period.getDays

Date field Index is corrupted due to time change

);         calendar.set(Calendar.MONTH, Calendar.JANUARY);         calendar.set(Calendar.DAY_OF_MONTH, 1

java.lang.ClassCastException: CriteriaQueryImpl cannot be cast to java.util.List

Please follow the posting instructions and use a separate thread for each subject. Your new question is not related to your original topic from 4 months ago, and therefore should not be discussed in ... for each subject. Your new question is not related to your original topic from 4 months ago, and therefore should not be discussed in this thread. support Support

Unexpected Exception (Error 990) with ArrayIndexOutOfBoundsException

itself, am I right? We upgraded from JDK 1.8 to 11 a few months ago and did some upgrades ... was installed a few months ago. So it was not affected by every change I just mentioned. However 2.7

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