Internal Website Search

1-50 of 200 results

Numbers in JPQL and Criteria Queries

, 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

Locking in JPA

, 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

CriteriaBuilder.toLong(number) - JPA Method

JPA Method in javax.persistence.criteria.CriteriaBuilder Expression toLong (    Expression   number ) Typecast. Returns same expression object. Parameters: number - numeric expression Return: Expression<Long> Since: JPA 2.0

CriteriaBuilder.toInteger(number) - JPA Method

JPA Method in javax.persistence.criteria.CriteriaBuilder Expression toInteger (    Expression   number ) Typecast. Returns same expression object. Parameters: number - numeric expression Return: Expression<Integer> Since: JPA 2.0

CriteriaBuilder.toBigDecimal(number) - JPA Method

JPA Method in javax.persistence.criteria.CriteriaBuilder Expression toBigDecimal (    Expression   number ) Typecast. Returns same expression object. Parameters: number - numeric expression Return: Expression<BigDecimal> Since: JPA 2.0

CriteriaBuilder.toBigInteger(number) - JPA Method

JPA Method in javax.persistence.criteria.CriteriaBuilder Expression toBigInteger (    Expression   number ) Typecast. Returns same expression object. Parameters: number - numeric expression Return: Expression<BigInteger> Since: JPA 2.0

CriteriaBuilder.toDouble(number) - JPA Method

JPA Method in javax.persistence.criteria.CriteriaBuilder Expression toDouble (    Expression   number ) Typecast. Returns same expression object. Parameters: number - numeric expression Return: Expression<Double> Since: JPA 2.0

CriteriaBuilder.toFloat(number) - JPA Method

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

How to retrieve the ObjectDB version number?

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

Large (and growing) numbers of ODB-StoreHandler Threads

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? 

Listing large number of complicated objects with paging.

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

GROUP BY and HAVING clauses

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

large numbers of records

large numbers of records

order by string with numbers

order by string with numbers

Auto Generated Values

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

Database Management Settings

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

Paths and Types in JPQL and Criteria API

. 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

JPA Persistable Types

are represented internally by their ordinal numbers . Caution is required when modifying an enum ... only at the end (with new higher ordinal numbers ). Alternatively, enum values can be represented internally by ... the above example, values of the color1 and color2 fields are stored as ordinal numbers (i.e. 0, 1, 2

Query Parameters in JPA

(); } 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

JPA Entity Fields

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

Collections in JPQL and Criteria Queries

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

WHERE clause (JPQL / Criteria API)

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

Running JPA Queries

reflecting the number of Country objects in the database: TypedQuery query = em. createQuery ( "SELECT ... returns the number of objects that have been updated or deleted by the query. The Query Structure

ORDER BY clause (JPQL / Criteria API)

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

Database Explorer

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

JPA Primary Key

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

SELECT clause (JPQL / Criteria API)

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

Setting and Tuning of JPA Queries

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

Server Configuration

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

Storing JPA Entity Objects

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

ObjectDB License Agreement [ver. 2.0.4]

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

Strings in JPQL and Criteria Queries

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

FROM clause (JPQL / Criteria API)

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

Logical Operators in JPQL and Criteria API

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

ObjectDB License

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

DELETE Queries in JPA/JPQL

. On success - the executeUpdate method returns the number of objects that have been deleted by the query

Privacy Policy

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

Eclipse Public License - v 1.0

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

UPDATE SET Queries in JPA/JPQL

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

javax.persistence.criteria.CriteriaBuilder

,  Number  y) Create a predicate for testing whether the first argument is greater than or ... .0 Predicate gt ( Expression  x,  Number  y) Create a predicate for testing ... Return: less-than-or-equal predicate Since: JPA 2.0 Predicate le ( Expression  x,  Number

javax.jdo.annotations.VersionStrategy.VERSION_NUMBER

JDO Enum Constant in javax.jdo.annotations.VersionStrategy VERSION_ NUMBER Since: JDO 2.1

Step 6: Design a BIRT Report Table

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

javax.persistence.Query

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

[ODB1] Chapter 6 - Persistent Objects

object ID is returned, and its toString() returns a temporary negative number , because a database object ... .getObjectId(person); String s1 = oid.toString(); // s1 contains a temporary negative number pm.currentTransaction().commit(); String s2 = oid.toString(); // s2 contains a permanent positive number

[ODB1] Chapter 8 - ObjectDB Server

with the stop and restart commands. However, in this context, you must use the same port number ... , an ObjectDB server can manage a single database file or multiple database files of any number of users. As

[ODB1] Chapter 9 - ObjectDB Explorer

the number of objects to construct and their type. Additional information is required for specific types ... of appearance. This is especially useful when working with classes with a large number of fields

[ODB1] Chapter 3 - Persistent Classes

, Character , Integer , Long , Float , Double , Number and String . Selected classes in package java ... is stored in the database. For example, a field whose type is Number (which is an abstract class

[ODB1] Chapter 7 - JDOQL Queries

.Collection instance and managed like any ordinary Java collection. For example, the number of retrieved ... of the candidate class. This may be useful, for instance, to obtain the number of objects of a specific class

javax.jdo.spi.StateManager

- the field number currentValue - the current value of the field Return: the new value for the field ... field - the field number currentValue - the current value of the field Return: the new value ... instance field - the field number currentValue - the current value of the field Return: the new value