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

JPA Method in jakarta.persistence.criteria.CriteriaBuilder Expression toLong (    Expression   number ) Typecast. Returns same expression object. Parameters: number - numeric expression Return: {@literal Expression } Since: JPA 2.0

JPA Method in jakarta.persistence.criteria.CriteriaBuilder Expression toInteger (    Expression   number ) Typecast. Returns same expression object. Parameters: number - numeric expression Return: {@literal Expression } Since: JPA 2.0

JPA Method in jakarta.persistence.criteria.CriteriaBuilder Expression toBigDecimal (    Expression   number ) Typecast. Returns same expression object. Parameters: number - numeric expression Return: {@literal Expression } Since: JPA 2.0

JPA Method in jakarta.persistence.criteria.CriteriaBuilder Expression toBigInteger (    Expression   number ) Typecast. Returns same expression object. Parameters: number - numeric expression Return: {@literal Expression } Since: JPA 2.0

JPA Method in jakarta.persistence.criteria.CriteriaBuilder Expression toDouble (    Expression   number ) Typecast. Returns same expression object. Parameters: number - numeric expression Return: {@literal Expression } Since: JPA 2.0

JPA Method in jakarta.persistence.criteria.CriteriaBuilder Expression toFloat (    Expression   number ) Typecast. Returns same expression object. Parameters: number - numeric expression Return: {@literal Expression } Since: JPA 2.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

- 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

an expression that returns the exponential of its argument, that is, Euler's number e raised ...  x,  Number  y) Create a predicate for testing whether the first argument is greater ... Since: JPA 2.0 Predicate gt ( Expression  x,  Number  y) Create a predicate for testing

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

part of a datetime. Since: JPA 3.2 DAY The calendar day of the month, numbered from 1. Since: JPA 3.2 HOUR The hour of the day in 24-hour time, numbered from 0 to 23. Since: JPA 3.2 MINUTE The minute of the hour, numbered from 0 to 59. Since: JPA 3.2 MONTH The calendar month of the year, numbered from 1

. Public Methods int executeUpdate () Execute an update or delete statement. Return: the number ... getMaxResults () The maximum number of results the query object was set to retrieve. Returns Integer if setMaxResults was not applied to the query object. Return: maximum number of results Since: JPA 2

() Execute an update or delete statement. Return: the number of entities updated or deleted Throws ... Since: JPA 2.0 int getMaxResults () The maximum number of results the query object was set to retrieve. Returns Integer if setMaxResults was not applied to the query object. Return: maximum number

() The maximum number of results the query object was set to retrieve. Returns Integer if setMaxResults was not applied to the query object. Return: maximum number of results Inherited from: Query Since: JPA 2.0 ... of the first result to retrieve. Parameters: startPosition - position of the first result, numbered from

, numbered from 1. Since: JPA 3.2 MONTH The calendar month of the year, numbered from 1. Since: JPA 3.2 QUARTER The calendar quarter, numbered from 1 to 4. Since: JPA 3.2 WEEK The ISO-8601 week number . Since: JPA 3.2 YEAR The calendar year. Since: JPA 3.2

time, numbered from 0 to 23. Since: JPA 3.2 MINUTE The minute of the hour, numbered from 0 to 59. Since: JPA 3.2 SECOND The second of the minute, numbered from 0 to 59, including a fractional part representing fractions of a second Since: JPA 3.2

JPA Annotation Attribute in jakarta.persistence.Column int secondPrecision default -1 (Optional) The number of decimal digits to use for storing fractional seconds in a SQL time or timestamp column ... seconds should not be stored in a time column, or that the maximum number of digits supported by

JPA Method in jakarta.persistence.Query int getMaxResults () The maximum number of results the query object was set to retrieve. Returns Integer if setMaxResults was not applied to the query object. Return: maximum number of results Since: JPA 2.0