ObjectDB Database Search
1-27 of 27 resultsDate and Time in JPQL and Criteria Queries , MONTH , DAY , HOUR , MINUTE , and SECOND parts from a date or time value. For example: YEAR({d '2011-12-31'}) returns 2011 . MONTH ({d '2011-12-31'}) returns 12 . DAY({d '2011-12-31'}) returns 31 . HOUR ... ); Expression month = cb. function (" month ", Integer.class, date); Expression day = cb. function ("day | |
JPA Criteria Query Date/Time Extraction Jakarta Persistence criteria queries use the following interfaces and enums to extract temporal components like year, month , or hour from date and time values. TemporalField # Base interface ... (such as java.time.LocalDate , and java.sql.Date ), including YEAR , MONTH , DAY , DAY_OF_WEEK | |
TemporalType injection with Calendar using JPA=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 =5,AM_PM=1,HOUR=7 ... ,minimalDaysInFirstWeek=4,ERA=1,YEAR=2011, MONTH =4,WEEK_OF_YEAR=22,WEEK_OF_ MONTH =5,DAY_OF_ MONTH =30,DAY_OF_YEAR=150 | |
Getting sales quantity per country with a query, an idea anyone?, only including valid orders (ord.getPaidTimeD()) and for a given month back in time. The resulting Object list ... ; to.add(Calendar. MONTH , monthBack + 1); to.set(to.get(Calendar.YEAR), to.get(Calendar. MONTH ), 1); if (to.after(now | |
Group by date / time. Each entity has it's own field that holds java.lang.Date. There is no function like YEAR(), MONTH ... WHERE YEAR(record_date) = 2009 GROUP BY YEAR(record_date), MONTH (record_date) or maybe ... support these expressions (as an extension to JPA) - support of date/time methods ( YEAR , MONTH | |
Grouping by date() (from documentation): YEAR({d '2011-12-31'}) is evaluated to 2011. MONTH ({d '2011-12-31 ... 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 | |
General Performance Issues Illustrated with a Specific Method) { setAge(period.getYears() + " years and " + period.getMonths() + " months ."); } else { setAge(period.getMonths() + " months and " + period.getDays() + " days."); } period = new Period(dob, date | |
Date field Index is corrupted due to time change(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 ... . 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 | |
Wrong data stored in time only fields(Calendar.YEAR, 1970); calendar.set(Calendar. MONTH , Calendar.JANUARY); calendar.set(Calendar.DAY_OF_ MONTH , 1);   | |
mapping file is not being loaded this project for a few months , I have been able to (finally) return and attempt to address this issue | |
Possible cause for "Enhancement of type ... is old and cannot be used" sample for you demonstrating the problem some months ago as an issue report at: BUG: objectdb-2.6.6_07 | |
ObjectDB Manual this month . support Support A first version of the manual in PDF format is ready now and attached | |
LEFT JOIN FETCH over empty embedded collection returns no results First of all, thank you for promptly implementing JOIN FETCH over nested paths in response to my inquiry a few months ago. However, I have run into one problem: if an embedded collection is empty, but I attempt to LEFT JOIN FETCH all the members of a collection within a (non-existent) member | |
JRebel integration feature.' The JRebel technology is helping to save me months of development time per year, and it helps avoid | |
ObjectDB version 2.3 has been released regarding the Explorer - will have high priority in the next months . Anyone who is interested may use | |
java.sql.Date equals comparison not working with CriteriaAPI, 2014); cal.set(Calendar. MONTH , Calendar.JULY);   | |
Licensing i need them every month for 2 days to deal with very high loads. How would i license | |
java.time.* I get errors when trying to persist anything in java.time.* For example LocalDate, Month , Period. Will these be supported sometime in the future? scoobyrooster Jason Java 8 date and tome is not supported yet, except by serialization (which is not recommended and disabled by default | |
How to have a distribuited GWT application with ObjectDB and Spring? to understand and we don't have time to waste because in a month we have to finish this project. Thank | |
index - data rewrite This was done few months ago and we just moved on. As far i remember the data records in the table | |
Inverse OneToMany Mapping and EmbeddedId month ; byte day; byte hour; } Query: select ps.platform.id, ps.sensor.id, v.id.year, v.id. month , v.id.day, v.id.hour, v.value from PlatformSensor ps, Value v where ps.sensor.name like ?1 and v.id.platformSensor=ps.id and v.id.year=?2 and v.id. month =?3 and v.id | |
Database access error , Doctor hanging on trying to repair, production shutdown at our biggest customer that you had this corruption for 2 months , but it was found only now? we are probably not able ... which it was modified). Is it possible that you had this corruption for 2 months , but it was found only now? for sure this is possible hgzwicker Hans-Georg Zwicker | |
boolean field flips after schema update (in class) of another field environment, but now in field. Object DB version was upgraded maybe two times in the last months in ... during the last months and not more. Also in production. Can it still be this issue? itsme Martin | |
database corrupt we have a major shutdown problem at a 450 employees company just using our system to completely manage the production. we have the following state of the system: - Doctor around 2 monthes ago - run our application from the 20200429, suddenly entries as it can be seen from #2559 appear | |
Enhancing a class causes it to not save changes. out how ObjectDB is holding on to the old classes, as they have not existed for months .  | |
Internal error an IoT device. It has to be able to run for months if not years without maintenance. I hope |