ObjectDB Database Search

1-50 of 200 results

Date and Time in JPQL and Criteria Queries

the results of predefined JPQL functions that return the current date and time. Current date and time ... when the query is executed: CURRENT _ DATE : Returns the current date as a java.sql. Date instance. CURRENT _TIME ... for building date and time expressions that represent the current date or time: // Create current date

JPA Criteria Query Date/Time Extraction

temporal components like year, month, or hour from date and time values. TemporalField # Base interface ├─ LocalDateField # Enum for Date fields ├─ LocalTimeField # Enum for Time fields └─ LocalDateTimeField # Enum for DateTime fields Date and Time components To extract a date or time component in

jakarta.persistence.TypedQuery.setParameter(Parameter,Date,TemporalType)

;  Parameter param ,    Date value ,    TemporalType temporalType ) Bind an instance of Date to a Parameter object. Parameters: temporalType - temporal type param - parameter ... should use the date /time types defined in java.time . Since: Jakarta Persistence (JPA) 1.0

jakarta.persistence.TypedQuery.setParameter(String,Date,TemporalType)

;  String name ,    Date value ,    TemporalType temporalType ) Bind an instance of Date to a named parameter. Parameters: name - parameter name temporalType - temporal type ... is of incorrect type. Deprecated: Newly-written code should use the date /time types defined in java.time . Since: Jakarta Persistence (JPA) 1.0

jakarta.persistence.TypedQuery.setParameter(int,Date,TemporalType)

;  int position ,    Date value ,    TemporalType temporalType ) Bind an instance of Date to a positional parameter. Parameters: position - position temporalType - temporal ... is of incorrect type. Deprecated: Newly-written code should use the date /time types defined in java.time . Since: Jakarta Persistence (JPA) 1.0

jakarta.persistence.StoredProcedureQuery.setParameter(int,Date,TemporalType)

setParameter (    int position ,    Date value ,    TemporalType temporalType ) Bind an instance of java.util. Date to a positional parameter. Parameters: position ... if the value argument is of incorrect type. Deprecated: Newly-written code should use the date /time

jakarta.persistence.StoredProcedureQuery.setParameter(Parameter,Date,TemporalType)

setParameter (    Parameter param ,    Date value ,    TemporalType temporalType ) Bind an instance of Date to a Parameter object. Parameters: temporalType - temporal ... : Newly-written code should use the date /time types defined in java.time . Since: Jakarta Persistence (JPA) 1.0

jakarta.persistence.StoredProcedureQuery.setParameter(String,Date,TemporalType)

setParameter (    String name ,    Date value ,    TemporalType temporalType ) Bind an instance of java.util. Date to a named parameter. Parameters: name - parameter name ... if the value argument is of incorrect type. Deprecated: Newly-written code should use the date /time types

jakarta.persistence.Query.setParameter(int,Date,TemporalType)

; int position ,    Date value ,    TemporalType temporalType ) Bind an instance of Date to a positional parameter. Parameters: position - position temporalType - temporal type value ... type. Deprecated: Newly-written code should use the date /time types defined in java.time . Since: Jakarta Persistence (JPA) 1.0

jakarta.persistence.Query.setParameter(String,Date,TemporalType)

; String name ,    Date value ,    TemporalType temporalType ) Bind an instance of Date to a named parameter. Parameters: name - parameter name temporalType - temporal type value ... . Deprecated: Newly-written code should use the date /time types defined in java.time . Since: Jakarta Persistence (JPA) 1.0

jakarta.persistence.Query.setParameter(Parameter,Date,TemporalType)

; Parameter param ,    Date value ,    TemporalType temporalType ) Bind an instance of Date to a Parameter object. Parameters: temporalType - temporal type param - parameter object ... the date /time types defined in java.time . Since: Jakarta Persistence (JPA) 2.0

jakarta.persistence.TemporalType.DATE

Jakarta Persistence (JPA) Enum Constant in jakarta.persistence.TemporalType DATE Map as java.sql. Date Since: Jakarta Persistence (JPA) 1.0

jakarta.persistence.criteria.LocalDateTimeField.DATE

Jakarta Persistence (JPA) Field in jakarta.persistence.criteria.LocalDateTimeField DATE The date part of a datetime. Since: Jakarta Persistence (JPA) 1.0

Number of current connections

Is there any way to find out the number of current connections to the DB server? natmaclin Natalia Levine Currently not. You may subscribe to this feature request and update it according to your needs. support Support

Is there an API to get the current version of ObjectDB that's being used?

Is there an API to get the current version of ObjectDB that's being used? This would be very handy to have, because it is somewhat difficult to know what version of the ObjectDB you are currently using since the objectdb.jar filename remains the same for all versions (which is not a bad thing by

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 ... ; List dates = new ArrayList ();         calendar.set(1980, 2, 1

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

JPA Persistable Types

`, ` Date `, and math types. Multi-value types: Collections, maps, and arrays. Miscellaneous types: Enum ... .util. Date , java.util.Calendar , java.sql. Date , java.sql.Time , java.sql.Timestamp, java.time ... .OffsetDateTime , java.time.Instant. Date and time types are discussed in more detail in the next section. Date

Date field Index is corrupted due to time change

the bug, which affects indexes on pure Date fields (i.e. date with no time). ObjectDB converts pure date values between local time and UTC more than once during transaction commit, and on clock ... that records are being added to the DB at the time of the time change. However, what values in the date

How to add minutes to a Date with JPA2

than the current date . My idea is as follows: Calendar currentTime = Calendar.getInstance(); Date currenteDate ... ); //minutes to be added I must now sum to the dateCapture the delayMinute and verify that the current date ... ); How to do!! faber Faber Wouldn't it be more simple to subtract the delay from the current date and send

java.sql.Date equals comparison not working with CriteriaAPI

Hello, Using ODB 2.4.5 and the Criteria API, doing a simple equals comparison with java.sql. Date ... = ...; Root root = ...; java.sql. Date myDate = ...; Predicate predicate = builder.equal(root ... : We can currently not update the ODB version as this is a production system. Note also that doing

Query Parameters in JPA

instead of three is that JPA also provides three separate methods for setting Date parameters and three for setting Calendar parameters. Date and Calendar parameter values require special methods to specify whether they represent a date , a time, or a combination of date and time, as explained in

ObjectDB Object Database Features

and annotations. Zero administration. Documentation Compressive, up to date , searchable online  ... types (Boolean, Byte, Short, Character, Integer, Long, Float, Double). java.lang.String Date types : java.util. Date , java.sql. Date , java.sql.Time and java.sql.Timestamp. Math types : java.lang

Literals in JPQL and Criteria Queries

) are case-sensitive, so 'abc' and 'ABC' are not equivalent. Date and time literals JPQL follows the SQL and JDBC syntax for date and time literals: Date : {d 'yyyy-mm-dd'} . For example: {d '2019-12-31 ... ); // String literals: Expression empty = cb. literal (""); Expression jpa = cb. literal ("JPA"); // Date

FROM clause (JPQL / Criteria API)

_LENGTH, BOTH, BY, CASE, CHAR_LENGTH, CHARACTER_LENGTH, CLASS, COALESCE, CONCAT, COUNT, CURRENT _ DATE , CURRENT _TIME, CURRENT _TIMESTAMP,DELETE, DESC, DISTINCT, ELSE, EMPTY, END, ENTRY, ESCAPE, EXISTS, FALSE ... only over the neighbors collection for the current c1 . In this case, propagating the WHERE constraint to the FROM

Paths and Types in JPQL and Criteria API

numbers, booleans, strings, and dates . Values of simple types are more useful in queries ... to collections, maps, or values of simple types (such as numbers, booleans, strings, and dates ). For a path ... through a null reference. In JPQL, the current FROM variable (or FROM tuple, when there are multiple

GROUP BY and HAVING clauses

might not be supported by other JPA implementations. Currently , only identification variables and path ... a double . MIN : Returns the minimum of comparable values, such as numbers, strings, and dates . MAX : Returns the maximum of comparable values, such as numbers, strings, and dates . For each starting letter

JPA Attributes Annotations

used to specify the storage format for enumerated types. Temporal mapping Map legacy date ... ): Specifies the database SQL type for a persistent field or property of type java.util. Date or java.util.Calendar . Specifies the database SQL type for a map key of type java.util. Date or java.util.Calendar

Database Schema Evolution

, it is automatically converted to an instance of the up-to- date entity class. This conversion ... to the new type (for example, a change from int to Date ), the fields are not considered matching ... () if necessary). From String to numeric types, including enum types (when applicable). From any date /time type

Retrieving JPA Entities

the field from cascaded retrieval. (ObjectDB currently does not distinguish between these two annotations ... or @ManyToMany annotation enables cascaded retrieval for the field. (ObjectDB currently does not ... that the application is working with the most up-to- date version of an entity, in case it was changed

General Settings and Logging

is disabled. Every day, a new log file is generated with the name odb .log , where represents the date . A new log file is also generated when the current log file exceeds the maximum size specified by the max ... for a specific ObjectDB subsystem. The names of the subsystem loggers are currently undocumented

Index Definition

( name ="u2") Date indexedField5; // unique } The @Unique annotation defines a unique index ... .util. Date , java.sql. Date , java.sql.Time , java.sql.Timestamp Any enum type A reference

JPA Primary Key

.lang.String . java.util. Date , java.sql. Date , java.sql.Time , and java.sql.Timestamp , java.time ... ; : } @Embeddable public class EventId { int sensorId; Date time; } Because entities are ordered in

Online Backup

subdirectory is created in the backup root directory. The subdirectory's name reflects the current date and time (for example, 201912312359 ). The backup database file is then created in this new

jakarta.persistence.criteria.CriteriaBuilder

(JPA) 1.0 Expression currentDate () Create expression to return current date . Returns: expression for current date . Since: Jakarta Persistence (JPA) 1.0 Expression currentTime () Create expression ... (JPA) 1.0 Expression localDate () Create expression to return current local date . Returns: expression

JPA Query Expressions (JPQL / Criteria)

on the following pages: Literals and dates ( literal , nullLiteral , currentDate , …) Paths, navigation ... ) String expressions ( like , length , locate , lower , upper , concat , substring , …) Date and time

JPA Optimistic and Pessimistic Locking

after the current transaction retrieved it, so the current transaction is attempting to modify a stale version ... that another user (using another EntityManager ) has modified the object since the current transaction ... (from another EntityManager instance) currently holds a PESSIMISTIC_WRITE lock on that database object

jakarta.persistence.TypedQuery

properties and hints. Since: Jakarta Persistence (JPA) 2.0 LockModeType getLockMode () Get the current ... to a parameter of the query. Deprecated: Newly-written code should use the date /time types defined in java.time . Since: Jakarta Persistence (JPA) 1.0 TypedQuery setParameter ( Parameter param , Date value

jakarta.persistence.Query

() Get the current lock mode for the query. Returns null if a lock mode has not been set on the query ... . Deprecated: Newly-written code should use the date /time types defined in java.time . Since: Jakarta Persistence (JPA) 2.0 Query setParameter ( Parameter param , Date value , TemporalType temporalType

jakarta.persistence.StoredProcedureQuery

() Get the current lock mode for the query. Returns null if a lock mode has not been set on the query ... . Deprecated: Newly-written code should use the date /time types defined in java.time . Since: Jakarta Persistence (JPA) 1.0 StoredProcedureQuery setParameter ( Parameter param , Date value

Database Explorer

line as follows: $ java -jar explorer.jar If explorer.jar is not in the current directory ... the current database connection, use the File Close command. Viewing database content Viewer windows ... switches the current viewer to focus on that object. Executing queries The Query window on the left lets

Apache License, Version 2.0, January 2004

to You under this License for that Work shall terminate as of the date such litigation is filed. 4. Redistribution

Schema Update

, the instructions should usually be on the client side, where the up-to- date classes are located. The following

JPA Metamodel Types

, Strings, or Dates ) that do not contain persistent attributes of their own. An enumeration

Step 2: Entity Class and Persistence Unit

.Serializable; import java.sql. Date ; import javax.persistence.Entity; import javax.persistence ... String name; private Date signingDate; // Constructors: public Guest() { } public Guest(String name) { this.name = name; this.signingDate = new Date (System.currentTimeMillis()); } // String Representation

Step 2: Entity Class and Persistence Unit

.Serializable; import java.sql. Date ; import javax.persistence.Entity; import javax.persistence.GeneratedValue ... name; private Date signingDate; // Constructors: public Guest() { } public Guest(String name) { this.name = name; this.signingDate = new Date (System.currentTimeMillis()); } // String Representation

Step 2: Entity Class and Persistence Unit

java.io.Serializable; import java.sql. Date ; import javax.persistence.Entity; import javax.persistence ... ; private String name; private Date signingDate; // Constructors: public Guest() { } public Guest(String name) { this.name = name; this.signingDate = new Date (System.currentTimeMillis()); } // String

Step 2: Entity Class and Persistence Unit

.Serializable; import java.sql. Date ; import javax.persistence.Entity; import javax.persistence ... name; private Date signingDate; // Constructors: public Guest() { } public Guest(String name) { this.name = name; this.signingDate = new Date (System.currentTimeMillis()); } // String Representation

Step 2: Define a JPA Entity Class

.Serializable; import java.sql. Date ; import javax.persistence.Entity; import javax.persistence ... String name; private Date signingDate; // Constructors: public Guest() { } public Guest(String name) { this.name = name; this.signingDate = new Date (System.currentTimeMillis()); } // String Representation

Step 2: Define a JPA Entity Class

code: package guest; import java.io.Serializable; import java.sql. Date ; import javax.persistence.Entity ... @GeneratedValue Long id; private String name; private Date signingDate; // Constructors: public Guest() { } public Guest(String name) { this.name = name; this.signingDate = new Date