ObjectDB Database Search

1-27 of 27 results

Date 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