ObjectDB Database Search

of a numeric argument. The result is always a positive number or zero. For example: ABS(-5) evaluates to 5 ... ); // expression + number Expression sum3 = cb. sum (1000, path); // number + expression // Subtraction ... ); // expression - number Expression diff3 = cb. diff (1000, path); // number - expression

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

the five aggregate functions of SQL: COUNT : Returns a long value that represents the number ... 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

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

. Optimistic Locking ObjectDB maintains a version number for every entity. The initial version of a new ... ;is modified, its version number is automatically incremented by one. Version numbers are managed internally ... every database object that is being updated or deleted and compares the version number of that object in

to use for caching database file pages. The max-threads attribute specifies the maximum number ... requests are queued until previous requests are completed. The optimal number is usually larger than the number of available CPU cores but not so large that it causes performance degradation from

strategies. The AUTO strategy ObjectDB maintains a global number generator for each database ... ; : } When a transaction is committed, the AUTO strategy uses the global number generator to generate ... . The allocationSize attribute specifies the number of IDs in each allocation. Some IDs in an allocation

numbers , booleans, strings, and dates. Values of simple types are more useful in queries because they have special operators and functions (for example, for strings and numbers ). They can also be compared ... to collections, maps, or values of simple types (such as numbers , booleans, strings, and dates). For a path

, enum values are represented internally by their ordinal numbers . Use caution when modifying an enum ... only at the end of the list, which gives them new, higher ordinal numbers . Alternatively, enum values ... are stored as ordinal numbers (0, 1, and 2), while values of the color3 field are stored as strings

accessed. Version Field ObjectDB maintains a version number for every entity. The initial version ... that modifies an entity, its version number is automatically incremented by one. Version fields are used

the maximum number of simultaneous connections that the server accepts. A connection request that exceeds this limit causes an exception on the client. A value of 0 indicates no limit on the number

(collection) function returns the number of elements in a specified collection. For example: SIZE(c.languages) returns the number of elements in the languages collection. [NOT] MEMBER [OF] The [NOT] MEMBER

. In multi-variable queries, the number of tuples for iteration can be very large even if the database ... . get ("population"), p)); Multiple restrictions The second where method takes a variable number of Predicate

its superinterface, Parameter ) rather than by names or numbers . For more details, see the Parameters in Criteria ... number of methods is not typical for JPA, which is generally known for its lean and simple API

always returns a single result object, which is a Long object that represents the number of Country objects in ... the number of objects that the query updated or deleted. The Query Structure section provides more details about DELETE and UPDATE queries.

number of subdirectories allowed in that directory. This count includes nested subdirectories. The files attribute specifies the maximum number of database files the directory can contain. The disk

expression whose type is comparable (for example, numbers , strings, and date values) and is derived from ... a variable number of Order arguments (or a List of Order instances) rather than Expression instances

, ObjectDB automatically sets the primary key for every new entity. The key is a sequential 64-bit number ... and can be collected by accessing a minimum number of database pages. On the other hand, such a primary

, 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

provides a shortcut method, multiselect , which takes a variable number of arguments representing

the page number (starting from 0 for the first page), the following code retrieves the results

.xml . Batch store Storing a large number of entities requires special consideration. You can use

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

- counting characters in a string The LENGTH (str) function returns the number of characters in

; that is, the number of round trips to the database is much larger than necessary. A simple solution is to use

or large Additional factory methods are available that accept a variable number of predicates

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

is active. If successful, the executeUpdate method returns the number of objects that were deleted

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

. On success, the executeUpdate() method returns the number of objects that the query modified. Selective

specifies the archive directory. The retain attribute specifies the number of days to retain archived

the Edit New Entities... command. In the dialog box, select the entity class and specify the number

, 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

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