Internal Website Search

1-38 of 38 results

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 ... . function ("year", Integer.class, date); Expression month = cb. function (" month ", Integer.class, date

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

ObjectDB and Spring Boot - sharing a simple working example

;    @Query ( " Select p from Person p WHERE MONTH ( p . birthDate ) = : month " )      List findAllByBirthDateMonth ( int month );      List

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);  

How to develop for a server license

;for one month , then the servers will be recycled. After half a year, we need to use the license on cloud server for another month . Can the original license still be valid? gzdillon Lai Yang Yes, but you will have to run activation again. support Support

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

Recovery file does not match db file

Just rebooted my production server, which had been running fine for months . When it came up, these errors started: ObjectDB 2.3.1_03] javax.persistence.PersistenceException Recovery file '/auctionologies/java/storage.odb$' does not match db file '/auctionologies/java/storage.odb' (error 145

New Index causing troubles

(Thread.java:748) Please advice how to solve this issues. Last time it happened to us few monthes earlier

Unable to persist fields in subclass

= new SimpleObjectProperty (); //eg: (1959, Month .DECEMBER, 12); public SimplePatientTest(int mrn

Mysterious "Attempt to persist a reference to a non managed instance" error

I've been working with ObjectDB for the past several months , and it's behaved pretty much as expected. I made a few modifications to a working set of classes today, and it's started throwing exceptions at commit time. I've stripped it down to a  set of files that seem to be of trivial

ObjectDb JDK8-11 support

Currently we are using ObjectDb 2.6.1 and JDK7, but next 2 month all projects will be moved to JDK8 and JDK11. Could you confirm which stable ObjectDb versions should we use for JDK8 JDK11 There is no any information about it in latest ObjectDb documentation. Harman Alexander Golyshkin

Inverse OneToMany Mapping and EmbeddedId

;   int platformSensor;     short year;     byte month ;   ... .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.day=?4  

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

JPA Query Criteria API (JPA 2.0)

and documented starting version 2.2, which is expected to be released later this month . support Support

JPA Metamodel (JPA 2.0)

starting version 2.2, which is expected to be released later this month . support Support ObjectDB version

Service terminated silently (crashed?)...is there any way to cause a crash dump?

After running without issue, uninterrupted for seven months , our instance stopped silently.  The contents of the log are as follows: Object DB log: ObjectDB Server started on port 6138. ObjectDB Server stopped. ObjectDB Server started on port 6138. ObjectDB Server stopped. ObjectDB Server

Online Backup degrades responsiveness.

I've had an hourly job running the following for many months now and it's been fine until these 2 days: try { CoreService.getLogger(this).info("DB Backup Start..."); TypedQuery backupQuery =                 em

ObjectDB 2.2.9

Added new configuration to enable / disable auto serialization of non persistable types (now disabled by default). Added support of date methods ( YEAR , MONTH , DAY , HOUR , MINUTE , SECOND ). Added support of  bypassing no arg constructors  of entity classes . Added support of using