Internal Website Search
1-50 of 200 resultsDate and Time in JPQL and Criteria Queries JPQL current date and time functions. Current Date and Time JPA defines special JPQL expressions that are evaluated to the date and time on the database server when the query is executed: CURRENT _ DATE - is evaluated to the current date (a java.sql. Date instance). CURRENT _TIME - is evaluated | |
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 ... . 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 and Time | |
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 | |
Grouping by date() Hi, For some time now we can use date and time function in queries to extract part of date time ... have to group by date (). For few queries I was concatenating ' date ' from year()-month()-day() calls ... to add one more method to above list - date () - that will return only date from java.util. Date | |
Problem with 'where' and date() Hi, Today I was playing with some date -range queries in explorer and found a small problem. When you try to use queries like this: SELECT o from TestObject o where o. date :someDate where o. date is java.util. Date , 'where' doesn't work as it should. Results are not filtered by date | |
GWT RPC is throwing serialization exception when I have object db date value Caused by: com.google.gwt.user.client.rpc.SerializationException: Type 'objectdb.java.util. Date ... ; kpanda ganesh gothai The objectdb.java.util. Date class is a subclass of java.util. Date ... this is not sufficient for GWT because Date is a special data type. You may have a similar | |
javax.persistence.TemporalType.DATE JPA Enum Constant in javax.persistence.TemporalType DATE Map as java.sql. Date Since: JPA 1.0 | |
Query Parameters in JPA rather than just 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 | |
Literals in JPQL and Criteria Queries literals (e.g. 077 , 077L ), a feature that is not currently supported by all JPA implementations. String ... ' and 'ABC' are not equivalent. Date and Time Literals JPQL follows the syntax of SQL and JDBC for date literals: Date - {d 'yyyy-mm-dd'} - for example: {d '2019-12-31'} Time - {t 'hh:mm:ss | |
ObjectDB Object Database Features using XML and annotations. Zero administration. Documentation Compressive, up to date , searchable ... .String Date types : java.util. Date , java.sql. Date , java.sql.Time and java.sql.Timestamp. Math types ... (Boolean, Byte, Short, Character, Integer, Long, Float and Double). java.lang.String Dates : java | |
Database Explorer it from the command line as follows: java -jar explorer.jar If explorer.jar is not in the current ... menu command to close a currently open database connection. Viewing Database Content Viewer ... , a bookmark in the [Database] tabbed window or an object in a currently open Table or Tree window | |
Database Schema Evolution of an old schema is loaded into memory it is automatically converted into an instance of the up to date ... from int to Date ) the fields are not considered as matching and the new field is initialized ... (when applicable). From any date type to any date type. From any collection or array type to any | |
FROM clause (JPQL / Criteria API), 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, FETCH | |
Retrieving JPA Entity Objects FetchType . LAZY in either @OneToOne or @ManyToOne annotations ( currently ObjectDB does not distinguish ... annotations ( currently ObjectDB does not distinguish between the two) enables cascading retrieval ... fields of an entity object can be accessed freely, regardless of the current fetch policy, as long as | |
Paths and Types in JPQL and Criteria API, string, date ). Simple type values are more useful in queries. They have special operators ... types (number, boolean, string, date ). For a path expression to be valid the user defined persistable ... reference. In JPQL, the current FROM variable (or FROM tuple when there are multiple variables | |
GROUP BY and HAVING clauses. Only identification variables and path expressions are currently supported in the GROUP BY clause by all the JPA ... of comparable values (numeric, strings, dates ). MAX - returns the maximum of comparable values (numeric, strings, dates ). The following query counts for every letter the number of countries with names | |
Index Definition; // unique @Unique ( name ="u2") Date indexedField5; // unique } @Unique represents a unique index ... .BigInteger , java.math.BigDecimal. java.lang.String. java.util. Date , java.sql. Date , java.sql.Time | |
JPA Primary Key.lang.String. java.util. Date , java.sql. Date , java.sql.Time , java.sql.Timestamp. Any enum type ... EventId id; : } @Embeddable Class EventId { int sensorId; Date time; } Because entity objects | |
Online Backup that reflects the current date and time (e.g. 201912312359 ) is created under the backup root | |
General Settings and Logging (where represents the date ). A new log file is also generated when the log file exceeds the maximum size ... of the subsystem loggers are currently undocumented and can change at any time without notice | |
Comparison in JPQL and Criteria API , comparing the content rather than the identity. Date values can be compared by using any comparison operator. Equality operators (=, , == , != ) on date values in queries follow the logic of equals | |
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 located on the client side where the up to date classes are located | |
JPA Annotations for Fields The way a field of a persistable class is managed by JPA can be set by the following annotations: Additional annotations (and enum) are designated for enum fields: Other additional annotations (and enum) are designated for date and calendar fields: Chapter 2 of the ObjectDB manual explains how to use all the above annotations. | |
JPA Query Expressions (JPQL / Criteria) expressions are provided as follows: Literals and Dates ( literal , nullLiteral , currentDate | |
Privacy Policy device identifiers, browser type, browser version, the time and date of Your visit, the pages | |
Eclipse Public License - v 1.0 of the date such litigation is filed. All Recipient's rights under this Agreement shall terminate | |
JPA Criteria API Queries expressions are provided in the following page sections: Literals and Dates ( literal | |
ORDER BY clause (JPQL / Criteria API) whose type is comparable (i.e. numbers, strings and date values) and is derived from the SELECT | |
Locking in JPA (using another EntityManager ) since it was retrieved by the current updater. Optimistic locking ... another EntityManager instance) currently holds a PESSIMISTIC_WRITE lock on that database object. A PESSIMISTIC_WRITE lock request fails if another user currently holds either a PESSIMISTIC_WRITE lock or | |
Sequence.current() - JDO Method JDO Method in javax.jdo.datastore.Sequence Object current () Returns the current sequence value object if it is available. It is intended to return a sequence value object previously used. If the current sequence value is not available, throw JDODataStoreException. Return: the current value Since: JDO 2.0 | |
[ODB1] Chapter 7 - JDOQL Queries), but use the equals( ... ) method for system types ( String , Date , ArrayList , ...). String instances can be compared using all six comparison operators. Date instances can be compared using ... : Calendar calendar = Calendar.getInstance(); calendar.clear(); calendar.set(2000, 0, 1); Date date | |
javax.jdo.annotations.VersionStrategy.DATE_TIME JDO Enum Constant in javax.jdo.annotations.VersionStrategy DATE _TIME Since: JDO 2.1 | |
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 | |
[ODB1] Chapter 4 - JDO Metadata and Integer ), types defined in java.math (e.g. BigInteger ), and java.util. Date . Collections, arrays ... . Wrapper objects, strings, dates , collections and arrays are embedded by default. To use them as non ... default, so a collection of strings or dates is fully embedded by default. Specifying embedded-element | |
[ODB1] Chapter 6 - Persistent Objects in memory is up to date . If true is specified and the object in database is different, the cached ... and section 4.4 ). Therefore, by default, String and Date fields, as well as collection fields (such as ... persistent object of the current transaction, and not yet stored in the database. JDOHelper | |
[ODB1] Chapter 3 - Persistent Classes.util : Date , Locale , HashSet , TreeSet , ArrayList , LinkedList , Vector , HashMap , TreeMap ... it is automatically converted into an instance of the new up-to- date persistent class. The conversion ... automatically to the new type. If casting is illegal (for example from int to Date ) the field | |
[ODB1] Chapter 2 - A Quick Tour. Predefined Java types like ArrayList , String and Date can be stored in the database only as fields | |
[ODB1] Chapter 9 - ObjectDB Explorer the content of that object. Select an object in a currently open table or browser viewer to explore ... Selection" command switches the current viewer to focus on the selected object. A double click ... all the changes of the current transaction only to the new database file. This command is available |