ObjectDB ObjectDB

Internal Website Search

1-10 of 200 resultsRefresh

Date and Time in JPQL and Criteria Queries

Date and time expressions may appear in JPQL queries: as date and time literals - e.g. {d '2011-12-31'}, {t '23:59:59'}. as parameters - when date and time values are assigned as arguments. as path expressions - in navigation to persistent date and time fields. as results of predefined JPQL current

Internal exception when updating date filed (TemporalType.DATE)

Hello! ObjectDB version 2.5.3_02. I get internal exception when commiting update Date field (javax.persistence.TemporalType.DATE). [ObjectDB 2.5.3_02] javax.persistence.RollbackException Failed ... .getTimeZone("GMT+03:00"));         List<Date> dates = new ArrayList<Date>();         calendar.set(1980, 2

Query filter comparing Dates

Hi, I am using an indexed java.util.Date field in my Entity and I came across some weird behaviour in query filters comparing this Date field. Could You please clarify why are there zero-size result ... am comparing 2 dates which should be equal because they are showing exactly same inner millisecond count. I

JPA Persistable Types

, Date and Math types. Multi value types - Collections, Maps and Arrays. Miscellaneous types: Enum ... , java.math.BigDecimal. java.lang.String. java.util.Date, java.util.Calendar, java.sql.Date, java.sql.Time, java.sql.Timestamp. Date and time types are discussed in more detail in the next paragraph. Date


Enum Constant javax.persistence.TemporalType DATE Map as java.sql.Date Since: JPA 1.0

Literals in JPQL and Criteria Queries

equivalent. Date and Time Literals JPQL follows the syntax of SQL and JDBC for date literals: Date - {d ... .literal("JPA"); // Date and Time literals: Expression<java.sql.Date> today = cb.literal(new java.sql.Date()); Expression<java.sql.Time> time = cb.literal(new java.sql.Time()); Expression

Database Schema Evolution

of an old schema is loaded into memory it is automatically converted into an instance of the up to date ... int to Date) the fields are not considered as matching and the new field is initialized ... any date type to any date type. From any collection or array type to any collection or array type, as

Query Parameters in JPA

three is that JPA additionally provides three separate methods for setting Date, parameters as well as three separate methods for setting Calendar parameters. Date and Calendar parameter values require special methods in order to specify what they represent, such as a pure date, a pure time or a combination


Enum Constant javax.jdo.annotations.VersionStrategy DATE_TIME Since: JDO 2.1

[ODB1] Chapter 7 - JDOQL Queries

for system types (String, Date, ArrayList, ...). String instances can be compared using all six comparison operators. Date instances can be compared using all six comparison operators. Numeric wrapper types ... . The only way to include objects with no literal representation in queries (as Date instances

Getting Started

ObjectDB is very easy to use. Follow the Getting Started Tutorial and the Quick Tour manual chapter and in minutes you may be able to write and run first Java programs against ObjectDB.

Prior knowledge or experience in database programming (SQL, JDBC, ORM, JPA, etc.) is not required, but some background in using the Java language is essential.

Need Help?

  1. Search ObjectDB website
  2. Read the FAQ
  3. Follow the Tutorials
  4. View or post in the forum
  5. Search or file an issue
  6. Contact support