ObjectDB Database Search

, which is always a positive number or zero. For example: ABS(-5) is evaluated to 5 ABS(10.7) is evaluated ... of the same type. The MOD Function The MOD function calculates the remainder of the division of one number by ... (path, param); // 2 expressions Expression sum2 = cb. sum (path, 1000); // expression + number

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression power (    Expression x ,    Number y ) Create an expression that returns the first argument raised to the power of its second argument. Parameters: x - base y - exponent Returns

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Predicate gt (    Expression x ,    Number y ) Create a predicate for testing whether the first argument is greater than the second. Parameters: x - expression y - value Returns: greater-than predicate. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Predicate le (    Expression x ,    Number y ) Create a predicate for testing whether the first argument is less than or equal to the second. Parameters: x - expression y - value Returns

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Predicate ge (    Expression x ,    Number y ) Create a predicate for testing whether the first argument is greater than or equal to the second. Parameters: x - expression y - value Returns

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Predicate lt (    Expression x ,    Number y ) Create a predicate for testing whether the first argument is less than the second. Parameters: x - expression y - value Returns: less-than predicate. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression quot (    Expression x ,    Number y ) Create an expression that returns the quotient of its arguments. Parameters: x - expression y - value Returns: quotient. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression quot (    Number x ,    Expression y ) Create an expression that returns the quotient of its arguments. Parameters: x - value y - expression Returns: quotient. Since: Jakarta Persistence (JPA) 1.0

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

, which is the best (JPA) method to get the version number ?   Peter       pezifromvienna Peter

I'm not sure yet if this is a bug, however the number of OBD-StoreHandler threads seems to be growing over time.  The database JVM now has about ~500 active threads total, most of them titled OBD-StoreHandler.  What causes the creation of new OBD-StoreHandler threads? 

( setMaxResults ). Does that number affect? You may try running the query with a lazy fetch hint (as done by

large numbers of records

order by string with numbers

, if they happen, are detected earlier. Optimistic Locking ObjectDB maintains a version number for every entity ... time) is 1. In every transaction in which an entity object is modified its version number is automatically increased by one. Version numbers are managed internally but can be exposed by defining

of SQL: COUNT - returns a long value representing the number of elements. SUM - returns the sum ... (numeric, strings, dates). The following query counts for every letter the number of countries with names that start with that letter and the number of different currencies that are used by these countries

number generator for every database. This number generator is used to generate automatic object IDs ... number generator is also used to generate numeric values for primary key fields annotated by ... ; : } During a commit the AUTO strategy uses the global number generator to generate a primary key

for caching pages of the database file. The max-threads attribute specifies the maximum number ... is reached - new requests are pending until previous requests are completed. The optimal number is usually larger than the number of available CPU cores, but not too large, to avoid thread competition

. But more often they are used in JPQL path expressions that navigate to values of simple types ( number , boolean ... and functions (e.g. for strings and for numbers ), they can be compared by all six comparison operators ... types ( number , boolean, string, date). For a path expression to be valid the user defined persistable

their ordinal numbers . Caution is required when modifying an enum type that is already in use in an existing database. New enum fields can be added safely only at the end (with new higher ordinal numbers ... , values of the color1 and color2 fields are stored as ordinal numbers (i.e. 0, 1, 2) while values

(); } The form of ordinal parameters is a question mark (?) followed by a positive int number . Apart from ... (of type ParameterExpression or its super interface Parameter ) rather than by names or numbers ... such methods, 9 of which are overridden in TypedQuery . That large number of methods is not typical

eagerly when the entity object is first accessed. Version Field ObjectDB maintains a version number ... for the first time) is 1. For every transaction in which an entity object is modified its version number

if the collection is empty and TRUE otherwise. SIZE The SIZE(collection) function returns the number ... to the number of languages in that collection. [NOT] MEMBER [OF] The [NOT] MEMBER OF operator checks

the WHERE clause are passed through to the SELECT. In multi-variable queries the number of tuples for iteration ... takes a variable number of arguments of Predicate type and uses an AND conjunction as

, which is a Long object reflecting the number of Country objects in the database: TypedQuery query = em ... - the executeUpdate method returns the number of objects that have been updated or deleted by the query

whose type is comparable (i.e. numbers , strings and date values) and is derived from the SELECT ... method takes a variable number of  Order instances as arguments (or a list of Order

New Entity Objects...  command. In the dialog box select the entity class and specify the number ... and their order of appearance. This may be useful when working with classes with a large number of fields

is a sequential 64 bit number ( long ) that is set automatically by ObjectDB for every new entity object ... during a period of time are stored continuously and can be collected by accessing a minimum number of database

, that is, Euler's number e raised to the power of its argument. Parameters: x - expression Returns ... , Number y ) Create a predicate for testing whether the first argument is greater than or equal ... ( Expression x , Number y ) Create a predicate for testing whether the first argument is greater

- multiselect , which takes a variable number of arguments representing multiple selections, and builds a 

number ( 0 for the first page), the following expression retrieves the results for a specified page

specifies the maximum number of simultaneous connections that are accepted by the server. A request

(in persistence.xml ). Batch Store Storing a large number of entity objects requires special

by this agreement. 3. The free edition of the Software includes restrictions on the number of classes

returns the number of characters in the argument string as an int . For example: LENGTH('United

, since the referenced  Capital objects are retrieved one at a time, i.e. the number of round trips

, isLarge); // Either OECD member or large Additional factory methods are available for a variant number

a product to an unlimited number of end users. For a quote please contact ObjectDB Sales (sales

if no transaction is active. On success - the executeUpdate method returns the number of objects

picture, profile signature, company name, phone number , billing address, country,  payment

will be given a distinguishing version number . The Program (including Contributions) may always be distributed

- the executeUpdate method returns the number of objects that have been modified by the query. Selective Update

, numbered from 1. Since: Jakarta Persistence (JPA) 1.0 HOUR The hour of the day in 24-hour time, numbered from 0 to 23. Since: Jakarta Persistence (JPA) 1.0 MINUTE The minute of the hour, numbered from 0 to 59. Since: Jakarta Persistence (JPA) 1.0 MONTH The calendar month of the year, numbered from 1

statement. Inherited from Query Returns: the number of entities updated or deleted. Throws ... (JPA) 2.0 int getMaxResults () The maximum number of results the query object was set to retrieve ... . Inherited from Query Returns: maximum number of results. Since: Jakarta Persistence (JPA) 2.0

executeUpdate () Execute an update or delete statement. Returns: the number of entities updated or deleted ... int getMaxResults () The maximum number of results the query object was set to retrieve. Returns ... : maximum number of results. Since: Jakarta Persistence (JPA) 2.0 Parameter getParameter ( String name

Persistence (JPA) 2.0 int getMaxResults () The maximum number of results the query object was set ... to the query object. Inherited from Query Returns: maximum number of results. Since: Jakarta Persistence ... , numbered from 0 Returns: the same query instance. Throws: IllegalArgumentException

day of the month, numbered from 1. Since: Jakarta Persistence (JPA) 1.0 MONTH The calendar month of the year, numbered from 1. Since: Jakarta Persistence (JPA) 1.0 QUARTER The calendar quarter, numbered from 1 to 4. Since: Jakarta Persistence (JPA) 1.0 WEEK The ISO-8601 week number . Since: Jakarta

of the day in 24-hour time, numbered from 0 to 23. Since: Jakarta Persistence (JPA) 1.0 MINUTE The minute of the hour, numbered from 0 to 59. Since: Jakarta Persistence (JPA) 1.0 SECOND The second of the minute, numbered from 0 to 59, including a fractional part representing fractions of a second

field or property holds a version number or timestamp identifying the revision of the entity data ... . This field declares a version number : @Version @Column(name = "REVISION") protected int version

In this final step we will add a simple table to the report: Open the [Insert Table] dialog box by dragging a Table from the [Palette] window and dropping it on the report design (.rptdesign) layout. Set the column number to 2 , number of details to 1 , select the data set (e.g. Points by X