About Date

forum_thread

@Transient

Hello, I have a persistent class which looks something like this: @Entity public class Test { private String string; private Date date; @Transient private boolean test; // getters/setters } When I persist the class the transient 'boolean test' is stored in the database, maybe I am doing it wrong but I expect... private String string ; private Date date ;   @ Transient private boolean test ; ...

 
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

@Convert is not supported?

Does objectdb jpa implementation support @Convert annotation? (convertion of property before persistance and vice versa)   for example @Convert(converter = MyConverter.class) private Date date;   I've wrote a test on this, and seems that my Converters methods are not executed at all (like annotation doesent exist) ... converter = MyConverter. class ) private Date date ;   I've wrote a test on this, and seems that ...

 
forum_thread

Calendar in Criteria Querys

Hi, i am having troubles creating criteria querys for Calendar objects. As far as I can see CriteriaBuilder has no methods for checking if one Calendar is bevor or after another. Javas Calendar Class got such methods, but i dont know how to use those in my query. ... JPA supports 3 temporal types: java.sql.Date - representing date with no time. java.sql.Time - representing time with no ...

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

setResultClass(cls)

Specify the type of object in which to return each element of the result of invoking execute or one of its siblings.(Method of javax.jdo.Query)

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

 
forum_thread

Is there an administration tool with which I could create extra indexes?

Hello, I have composite index, and it was working fine, but now I need to add more features to the software and I need to throw more indexes in there. I wanted to know what's the best way to do this. 1. Have some admin tool CREATE INDEX..... ON a.b or 2. add more @Index to the object entities. in case of #2, would ObjectDB auto-reindex all existing data? ... class. Open the database with the up to date class in the classpath in order to update the schema. Run ... be skipped if you run the Doctor (step 3) with your up to date classes in the classpath. ObjectDB Support ...