ObjectDB Database Search
1-50 of 200 resultsDate 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 |