ObjectDB ObjectDB

Internal Website Search

1-10 of 37 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

ObjectDB and Spring Boot - sharing a simple working example

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

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

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

Database access error , Doctor hanging on trying to repair, production shutdown at our biggest customer

transaction in which it was modified). Is it possible that you had this corruption for 2 months ... that you had this corruption for 2 months, but it was found only now? > for sure this is possible hgzwicker Hans-Georg Zwicker

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

boolean field flips after schema update (in class) of another field

, but now in field. Object DB version was upgraded maybe two times in the last months in the field ... months and not more. Also in production. Can it still be this issue? itsme Martin Petzold We also do not

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