ObjectDB Database Search

Order in WHERE Clause affects behaviour on DATE/DATETIME columns

Finding an object by its datetime

        DateTime dt = null;         try {             dt = new DateTime (dtf ... ;    dt = new DateTime (dtf.parse("2015.12.09 10:59:57"), new Short((short)10), null

that are a problem         DateTime dt = null;      ... DateTime (dtf.parse("2015.10.30 18:18:14"));           ... ;       dt = new DateTime (dtf.parse("2015.12.09 21:26:19"));   

LocalDateTime dateTime = null; @Enumerated(EnumType.STRING) @JsonProperty private Level level = null ... = null; private Log(final Builder builder) { this.uuid = builder.uuid; this. dateTime = builder. dateTime ... ; } public Log(@JsonProperty("uuid") String uuid, @JsonProperty(" dateTime ") LocalDateTime dateTime

the value of a field extracted from a date, time, or datetime . Parameters: field - a temporal field type temporal - a date, time, or datetime Return: expression for the value of the extracted field ... Expression localDateTime () Create expression to return current local datetime . Return: expression

part of a datetime . Since: JPA 3.2 DAY The calendar day of the month, numbered from 1. Since: JPA 3.2 HOUR ... Since: JPA 3.2 TIME The plain part of a datetime . Since: JPA 3.2 WEEK The ISO-8601 week number. Since: JPA 3.2 YEAR The calendar year. Since: JPA 3.2

that returns the value of a field extracted from a date, time, or datetime . Parameters: field - a temporal field type temporal - a date, time, or datetime Return: expression for the value of the extracted field Since: JPA 3.2

JPA Interface TemporalField Type Parameters: - the resulting type of the extracted value - the temporal type (date, time, or datetime ) Each instance represents a type of field which can be extracted from a date, time, or datetime . See Also: LocalDateField LocalTimeField LocalDateTimeField CriteriaBuilder.extract Since: JPA 3.2

JPA Method in jakarta.persistence.criteria.CriteriaBuilder Expression localDateTime () Create expression to return current local datetime . Return: expression for current timestamp Since: JPA 2.0

JPA Static Field in jakarta.persistence.criteria.LocalDateTimeField TIME The plain part of a datetime . Since: JPA 3.2

JPA Static Field in jakarta.persistence.criteria.LocalDateTimeField DATE The plain part of a datetime . Since: JPA 3.2

Hi.   Is Java 8 new DateTime API supported natively or through Converters in the newest versions of objectdb? If not, can we expect this feature in the next releases?   Best regards and congratulations on this awesome database.  Amsterdam Amsterdam Luís de Lima Filho It is not

public class Log { @Id @GeneratedValue private long id; private LocalDateTime dateTime = null

long id;     private LocalDateTime dateTime = null;     

My entity class has a field of type java.time.LocalDateTime. I'm able to persist entities and I'm able to query without datetime field in where clause, but with datetime in where clause doesn't ... (LocalDateTime dateTime ) { return Timestamp.valueOf( dateTime ); } @Override public LocalDateTime

(fromMomentPayload.get(" dateTime "))); Query q = em.createQuery(query); if (!all) { q.setMaxResults(maxResults); q ... ; query.orderBy(cb.desc(fromMomentPayload.get(" dateTime ")));         ... .sql.Timestamp dateTime ;     } }   support Support Unfortunately, I have not

to store String, and Joda DateTime .  However the test code at this time is just storing