ObjectDB Database Search

51-100 of 200 results

Query Parameters in JPA

with different parameter values to retrieve different results. Executing the same query multiple times with different parameter values is more efficient than using a new query string for each execution ... is a parameter that serves as a placeholder for a value . Before executing the query, you must set

Database Explorer

a persistent field, and each cell contains the value of a field for a specific object. This type ... . Editing values and references You can edit simple field values inline in the Tree and Table viewer windows. Double-click the field, press F2, or type the new value . Use the Edit Edit Multi Line String

FROM clause (JPQL / Criteria API)

that appear earlier in the FROM clause. Join variables can also be bound to a single- value path expression ... to a single- value expression are less commonly used because they can usually be replaced by ... simply skips any outer variable value (for example, a Country ) that has no matching inner variable

Database Schema Evolution

the old schema, the new field is initialized with the value of the matching old field. Fields in the new schema that do not have matching fields in the old schema are initialized with default values ... , and the new field is initialized with a default value ( 0 , false , or null ). The following type

Entity Management Settings

settings: The agent attribute (with a value of "true" or "false" ) specifies whether to load ... using reflection, which can affect performance. The possible values of the reflection attribute ... . The valid values are "weak" , "soft" , and "strong" . Modified entities are always held by strong

jakarta.persistence.criteria.CriteriaBuilder

an expression that returns the absolute value of its argument. Parameters: x - expression Returns: absolute value . Since: Jakarta Persistence (JPA) 1.0 Expression all ( Subquery subquery ) Create ... . Since: Jakarta Persistence (JPA) 1.0 CompoundSelection array ( Selection ... selections ) Create an array- valued

jakarta.persistence.StoredProcedureQuery

may be controlled in accordance with the following: The setParameter methods are used to set the values of all required IN and INOUT parameters. It is not required to set the values of stored procedure parameters for which default values have been defined by the stored procedure. When getResultList

JPA Criteria Query Expressions

, representing any typed value , calculation, or path within the query. Extends Selection   ... predicates. A navigation path to an attribute value or a referenced entity. A type-safe representation of a query parameter used for binding runtime values . Advanced expressions Additional interfaces

Literals in JPQL and Criteria Queries

Literals in JPQL, as in Java, represent constant values . JPQL supports various types of literals ... literals (for example, 'abc' ), enum literals (for example, mypackage.MyEnum.MY_ VALUE ), and entity ... times with different parameter values . Embed literals in JPQL queries only when a single, constant

JPA Relationships Annotations

of entity associations: Defines a single- valued association with one-to-one multiplicity between two entities. Defines a many- valued association with one-to-many multiplicity, representing a collection. Defines a single- valued association where multiple entities reference a single target entity

Paths and Types in JPQL and Criteria API

. However, they are more often used in JPQL path expressions that navigate to values of simple types, such as numbers, booleans, strings, and dates. Values of simple types are more useful in queries ... fields to other objects and values . For example, in the expression c.capital , c represents a Country

JPA Criteria FROM and JOIN

 variable, whose scope is all values of a specific persistent attribute. The base interface ... to both map keys and values . The parent interface of Root and Join , defining the common ... : Defines a virtual anonymous join variable,  whose scope is all values of a specific persistent

SELECT clause (JPQL / Criteria API)

projection. Projection extracts field values from entities to form the query results. The results of the previous query are returned as a list of String values : TypedQuery query = em. createQuery ( "SELECT ... only single- valued path expressions in the SELECT clause. Collection and map fields cannot be included

Strings in JPQL and Criteria Queries

String values can appear in JPQL queries in several forms: As string literals , for example, 'abc' and '' . As parameters when string values are passed as query arguments. As path expressions ... (for any c.name value ). c.name NOT LIKE '%' is always FALSE (for any c.name value ). To match a literal

JPA Metamodel Attributes

_TO_ONE , ONE_TO_MANY , ONE_TO_ONE , or MANY_TO_MANY . Singular attributes Single- valued attributes are represented by: Represents single- valued attributes. This includes basic types (primitives ... ) with "To-One" cardinality. Plural (collection) attributes Collection- valued attributes are represented by

JPA Criteria Query Date/Time Extraction

temporal components like year, month, or hour from date and time values . TemporalField # Base interface ... a criteria query specify  the enum value that represents that component as the first argument of  ...  types, represented by the following enums. Defines the component types of Date values

JPA Shared (L2) Entity Cache

value . Persistence Unit Settings You can also enable or disable the shared cache by using a persistence ... to one of the following values : NONE : The cache is disabled. ENABLE_SELECTIVE : The cache is disabled ... : Handled differently by JPA providers. In ObjectDB, this value is equivalent

Chapter 6 - Configuration

, where $objectdb represents the ObjectDB home directory. ObjectDB home ( $objectdb ) The value of $objectdb ... subdirectory. However, moving objectdb.jar changes the value of $objectdb . For example, in a web application ... " ... If a configuration file is not found, default values are used. General configuration considerations

jakarta.persistence.TypedQuery

query. PersistenceException - if the query execution exceeds the query timeout value set ... execution exceeds the query timeout value set and only the statement is rolled back. Since: Jakarta ... and associated values that are in effect for the query instance. Inherited from Query Returns: query

jakarta.persistence.Query

value set and the transaction is rolled back. TransactionRequiredException ... - if the statement execution exceeds the query timeout value set and only the statement is rolled ... () Get the properties and hints and associated values that are in effect for the query instance

jakarta.persistence.criteria.MapJoin

: - the source type of the join - the type of the target Map value - the type of the target Map key Super ... Persistence (JPA) 1.0 Predicate equalTo ( Expression value ) Create a predicate to test whether the expression is equal to the argument. Inherited from Expression Parameters: value - expression to be tested

jakarta.persistence.criteria.PluralJoin

Persistence (JPA) 3.2 Predicate equalTo ( Expression value ) Create a predicate to test whether the expression is equal to the argument. Inherited from Expression Parameters: value - expression ... Predicate equalTo ( Object value ) Create a predicate to test whether the expression is equal

jakarta.persistence.criteria.Root

of the given basic type. Since: Jakarta Persistence (JPA) 3.2 Predicate equalTo ( Expression value ... Parameters: value - expression to be tested against Returns: predicate testing for equality. Since: Jakarta Persistence (JPA) 3.2 Predicate equalTo ( Object value ) Create a predicate to test

jakarta.persistence.criteria.SetJoin

Persistence (JPA) 3.2 Predicate equalTo ( Expression value ) Create a predicate to test whether the expression is equal to the argument. Inherited from Expression Parameters: value - expression to be tested ... equalTo ( Object value ) Create a predicate to test whether the expression is equal to the argument

jakarta.persistence.criteria.CollectionJoin

type. Since: Jakarta Persistence (JPA) 3.2 Predicate equalTo ( Expression value ) Create ... : value - expression to be tested against Returns: predicate testing for equality. Since: Jakarta Persistence (JPA) 3.2 Predicate equalTo ( Object value ) Create a predicate to test whether the expression

jakarta.persistence.criteria.ListJoin

Persistence (JPA) 3.2 Predicate equalTo ( Expression value ) Create a predicate to test whether the expression is equal to the argument. Inherited from Expression Parameters: value - expression ... equalTo ( Object value ) Create a predicate to test whether the expression is equal to the argument

jakarta.persistence.criteria.From

) 3.2 Predicate equalTo ( Expression value ) Create a predicate to test whether the expression is equal to the argument. Inherited from Expression Parameters: value - expression to be tested ... ( Object value ) Create a predicate to test whether the expression is equal to the argument. Inherited from

jakarta.persistence.criteria.Join

of the given basic type. Since: Jakarta Persistence (JPA) 3.2 Predicate equalTo ( Expression value ) Create ... Parameters: value - expression to be tested against Returns: predicate testing for equality. Since: Jakarta Persistence (JPA) 3.2 Predicate equalTo ( Object value ) Create a predicate to test

Schema Update

. The value of the name attribute must be unqualified (without a package name) because the package is already specified in the parent element. The value of the new-name attribute can be either qualified or unqualified. If it is unqualified, ObjectDB uses the new-name value from the parent element as

Logical Operators in JPQL and Criteria API

FALSE FALSE FALSE NULL NULL FALSE NULL NULL represents an unknown value . Therefore, if one operand ... TRUE NULL NULL NULL represents an unknown value . Therefore, if one operand is NULL ... FALSE NULL FALSE TRUE NULL If the operand is NULL , which represents an unknown value , the result

Server User List

addresses in a comma-separated list and use a hyphen (-) to specify a range. For example, a value ... - 192.18.194.255 and from 127.0.0.1 . The admin attribute, with a value of true or false , specifies ... . A username value of "$default" defines a virtual master user. Other user definitions automatically

jakarta.persistence.metamodel.IdentifiableType

CollectionAttribute getCollection ( String name , Class elementType ) Return the Collection- valued attribute ... the Collection- valued attribute of the managed type that corresponds to the specified name. Inherited from ... the Collection- valued attribute declared by the managed type that corresponds to the specified name

jakarta.persistence.metamodel.EntityType

CollectionAttribute getCollection ( String name , Class elementType ) Return the Collection- valued ... ) Return the Collection- valued attribute of the managed type that corresponds to the specified name ... elementType ) Return the Collection- valued attribute declared by the managed type that corresponds

jakarta.persistence.metamodel.ManagedType

CollectionAttribute getCollection ( String name , Class elementType ) Return the Collection- valued attribute ... Persistence (JPA) 1.0 CollectionAttribute getCollection ( String name ) Return the Collection- valued ... the Collection- valued attribute declared by the managed type that corresponds to the specified name

jakarta.persistence.metamodel.EmbeddableType

elementType ) Return the Collection- valued attribute of the managed type that corresponds ... CollectionAttribute getCollection ( String name ) Return the Collection- valued attribute of the managed type ... getDeclaredCollection ( String name , Class elementType ) Return the Collection- valued attribute declared by

jakarta.persistence.metamodel.MappedSuperclassType

CollectionAttribute getCollection ( String name , Class elementType ) Return the Collection- valued ... the Collection- valued attribute of the managed type that corresponds to the specified name. Inherited ... ) Return the Collection- valued attribute declared by the managed type that corresponds to the specified

Database Management Settings

file when it needs more space. Small values for initial and resize save space. Larger values ... . The page attribute specifies the size of a page in a database file. The default value of 2 KB

SQL Queries Annotations

the results of native SQL queries to entities or scalar values using these annotations: Defines how the result set of a native query maps to entities, scalar values , or constructor results. Groups ... entity class. Maps a specific SQL column to an entity field or property within an @EntityResult . Maps a result set column directly to a scalar value .

JPA Criteria Query Selection and Results

;the result as an array of objects or as individual values by index, alias string or TupleElement . Represents a single selection in a compound selection and can be used to obtain the values ... and CriteriaBuilder.desc . Determines the precedence of null values during sorting, such as placing them first or

ObjectDB Object Database Features

and values are indexable. Nested paths inside embedded objects are indexable. Indices are also used for fast ... . Auto Value Generation Modes (for primary Key fields) Database IDs - automatic allocation of global ... . Application IDs - primary key values are set explicitly by the application. Query Support ObjectDB

jakarta.persistence.criteria.CriteriaBuilder.In

type. Since: Jakarta Persistence (JPA) 3.2 Predicate equalTo ( Expression value ) Create a predicate to test whether the expression is equal to the argument. Inherited from Expression Parameters: value ... Persistence (JPA) 3.2 Predicate equalTo ( Object value ) Create a predicate to test whether the expression

jakarta.persistence.criteria.CriteriaBuilder.Coalesce

that returns null if all its arguments evaluate to null, and the value of its first non-null argument ... Persistence (JPA) 3.2 Predicate equalTo ( Expression value ) Create a predicate to test whether the expression is equal to the argument. Inherited from Expression Parameters: value - expression to be tested

jakarta.persistence.criteria.Path

( Expression value ) Create a predicate to test whether the expression is equal to the argument. Inherited from Expression Parameters: value - expression to be tested against Returns: predicate testing for equality. Since: Jakarta Persistence (JPA) 3.2 Predicate equalTo ( Object value ) Create a predicate

Setting and Tuning of JPA Queries

the FlushModeType enum, which has two values : AUTO - Flushes changes before query execution ... .persistence.query.timeout", value ="7000")}) For a specific query execution, use the setHint method before

[ODB1] Chapter 8 - ObjectDB Server

. For instance, a value of 30 (as specified above) indicates a check every 30 seconds. If a change ... off auto reloading specify a value of "0" for the reload attribute. In this case the server ... the configuration above, there is no point to specifying different values for the max and user-max attributes

[ODB1] Chapter 7 - JDOQL Queries

if the field exists but its type cannot be compared with an int value , a JDOUserException is thrown ... more generic. Parameter values are provided when the query is executed so that the same query can be executed with different parameter values . The 'this' Keyword During query evaluation, each object in

[ODB1] Chapter 9 - ObjectDB Explorer

, every column represents a persistent field, and the content of a cell is the value of a single field in ... is represented by a tree node, and the values of its persistent fields are represents by child nodes. The main ... . Similarly, renaming a selected persistent field in the Explorer is useful in order to avoid losing values

Step 4: Add a Controller Class

public class GuestController { @Autowired private GuestDao guestDao; @RequestMapping( value ="/guest ... attribute (whose name is "guestDao" and its value is guestDao ). The next step is  adding

[ODB1] Chapter 3 - Persistent Classes

) Of course, persistent fields should not hold non persistent values at runtime when the object ... value . Similarly, a field whose type is one of the persistent collection interfaces ( Collection , Set ... a method or by getting its value as an argument to a method, on the other hand, does not make the class

[ODB1] Chapter 6 - Persistent Objects

that calling toString() on the same object ID before and after commit() returns different values ... string values between web pages is easier than passing real object ID instances. In this case ... , but also a Class instance. ObjectDB ignores the first argument. Therefore, a null value can also be specified