About date


Composite indexes

Hi, I read your manual about defining Indexes for JPA Entities (http://www.objectdb.com/java/jpa/entity/index), but I still have some problems understanding how and when should I use them.   Let's start with some example then. Assume we have an entity that represents an interior design image, called Inspiration : ... room ; // type of the room (kitchen, bedroom etc.) Date lastModificationDate ; // date of last modification Float rating ; //users rating in scale from ...


user defined backup file

We need a way to do a (online) backup to a user defined backup-destination. Maybe in that way: backupQuery.setParameter("targetfile", new java.io.File("/User/Backup/test.objectdb")); which creates a backupfile with the name 'test.objectdb" in the directory '/User/Backup/' or ... newly created backup database-file (in a subdirectory with date and time information), then move it to the real backup directory and ... an undocumented parameter that you can use to replace the date/time pattern with your own selected sub folder name: Query ...


user defined backup target

Dear objectdb Team 1. I could not find a way, to declare the name of the backup-file (while running the database).  The only way I found is to create the folder in which objectdb will copy the database - file:   ... backup database-file to a self defined target without any Date/Time Information maybe: .. /Users/backup/mybackup.objectdb ... would be located in a sub folder whose name reflects the date and time. Additional option can be added in future versions of ObjectDB. ...


Extending model by "common entity"

Hi, I have a question about extending working model with one, common entity, that all other entities will inherit from. For example I have 2 different entities in database with some data:... private String createdBy ; private Date createdAt ; private String modifiedBy ; private Date modifiedAt ;   // (getters and setters here) } ...



Set the filter for the query.(Method of javax.jdo.Query)



Create an aggregate expression for finding the least of the values (strings, dates, etc).(Method of javax.persistence.criteria.CriteriaBuilder)



Create an aggregate expression for finding the greatest of the values (strings, dates, etc).(Method of javax.persistence.criteria.CriteriaBuilder)



This annotation must be specified for persistent map keys of type java.util.Date and java.util.Calendar.(Annotation of JPA)


Speeding up reporting queries with size() on list

Hi, I'm working on some reporting stuff in our application. One of few different reports should include activity on last modified objects. The query for now looks like this: select date(insp.lastModificationDate), insp.modifiedBy, insp.description.length(), insp.products.size(), insp.picture from Inspiration insp order by date(insp.lastModificationDate) desc insp.description is normal String field in Inspiration entity. insp.products is a list with 0 to 600 objects. Definition: ... The query for now looks like this: SELECT date ( insp . lastModificationDate ) , insp . modifiedBy , ... . picture FROM Inspiration insp ORDER BY date ( insp . lastModificationDate ) DESC ...


_PersistenceException: Type is not found on getSingleResult.

Greetings. I'm new to ObjectDB. I'm using an ObjectDB local database for a Java SE standalone application and i'm having issues querying for an object of this entity: ... @ Temporal ( TemporalType . DATE ) private Date fechaNacimiento ;   private String primerNombre ; ...