About date

forum_thread

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 ...

 
issue

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 ...

 
forum_thread

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. ...

 
forum_thread

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) } ...

 
api-jdo

setFilter(filter)

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

 
api-jpa

least(x)

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

 
api-jpa

greatest(x)

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

 
api-jpa

javax.persistence.MapKeyTemporal

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

 
forum_thread

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 ...

 
forum_thread

_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 ; ...