ObjectDB Database Search

query = em. createQuery ("SELECT c FROM Country c", Country.class); List results = query. getResultList (); Because the results are managed entities they have all the support that JPA provides ... for deletion , and so on. Query results are not limited to entities. You can use almost any valid JPQL

of the first collection, the result of the overall query is an empty set. To use the example from ... include the full nested fetch, it fails, returning an empty result list: SELECT c FROM C c LEFT JOIN ... of the query).   The following query returned results : SELECT c FROM C c LEFT JOIN FETCH c.bList.aList

. The issue is that, I'm getting repeated results of the owning entity of an '@ElementCollection ... ($1.name) LIKE :p1) AND (($1.conditionOne=:p2))) Got: 1 results - correct   ... .branches.branch=:p2) OR ($1.conditionOne=:p3)))) Only expected one result , but got: 2  

annotation.  Is there anything I can look for that might result in this exception? sjzlondon Steve Zara

does result in a transaction rollback as expected.   However, this same method

Unexpected COUNT Results

getSingleResult . Result range (setFirstResult, setMaxResults) The setFirstResult and setMaxResults methods let you define a result window, which is a portion of a large query result list. The setFirstResult method specifies the starting point of the result window by defining how many results to skip from

) is not part of any iterated pair and is therefore excluded from the query results . INNER JOIN ... performance problems. For example, consider the following query execution and result iteration: TypedQuery query = em. createQuery ("SELECT c FROM Country c", Country.class); List results = query

can improve performance by reducing file fragmentation that can result from frequent resize operations ... sync= "false" results in much faster database writes, but sync="true" is safer for production ... for the two query cache mechanisms that ObjectDB manages: The results attribute specifies the size

is NULL and the other is FALSE , the result is FALSE because one FALSE operand is sufficient to make the expression false. If one operand is NULL and the other is TRUE or NULL , the result is NULL ... and the other is TRUE , the result is TRUE because one TRUE operand is sufficient to make the expression true

must also be flushed before execution of any query whose result set would be affected by unflushed modifications ... ( ConnectionFunction function ) Call the given function and return its result using the database connection ... result Returns: the new query instance. Throws: IllegalArgumentException - if a query has not

interfaces is structured as follows: Selection # Base interface for result items └─ Expression # Base ... ;to allow using expression as query results . A boolean expression used to define restrictions in

resulting from mechanical transformation or translation of a Source form, including but not limited ... , incidental, or consequential damages of any character arising as a result of this License or

this case, the employees field is populated with the results of the following query: SELECT e FROM ... results by specifying the key field with the @MapKey annotation: @Entity public class Department

and recording files and attempts to apply all the recorded operations. The resulting database file ... and applies all operations up to transaction 1000, the resulting file is named 1000.odb .

instances of the following interface: Represents a named query, including its name, result type, and hints. Retrieve it by result type from EntityManagerFactory.getNamedQueries , and use it to get a TypedQuery instance via EntityManager.createQuery .

out of, or related to, use of the Software. 6. The Customer may not disclose the  results of any

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 that navigate to persistent string fields. As the results of predefined JPQL string manipulation functions

the results of predefined JPQL functions that return the current date and time. Current date and time

. ObjectDB also uses indexes for sorting results and for projection: SELECT MIN(p.x) FROM Point p WHERE p.x

. This includes configuration information such as max results , hints, flush mode, lock mode, result set ... without throwing an exception, the result of the function is returned. If the given function throws ... and the result of the function is returned. If the function does throw an exception, the transaction is rolled

getSingleResult() Retrieve a single result from the next result set. The provider will call execute on the query if needed. A REF_CURSOR result set, if any, is retrieved in the order the REF_CURSOR parameter was registered with the query. Returns: the result or null if the next item is not a result set. Throws

getSingleResultOrNull() Retrieve a single result from the next result set. The provider will call execute on the query if needed. A REF_CURSOR result set, if any, is retrieved in the order the REF_CURSOR parameter was registered with the query. Returns: the result or null if the next item is not a result set or

connection to compute a result . The connection is usually a JDBC connection. See Also: ConnectionConsumer ... Instance Methods T apply ( C connection ) Compute a result using the given connection. Parameters: connection - the connection to use Returns: the result . Throws: Exception - if a problem occurs calling

the SELECT clause of a SQL query to an entity result . If this annotation is used, the SQL statement ... columns to related entities. The results obtained when insufficient data is available are undefined ... The class of the result . Since: Jakarta Persistence (JPA) 1.0 LockModeType lockMode The lock mode obtained

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.AbstractQuery Class getResultType() Return the result type of the query or subquery. If a result type was specified as an argument ... the createTupleQuery method, the result type is Tuple . Otherwise, the result type is Object . Returns: result type. Since: Jakarta Persistence (JPA) 1.0

() Return true if the first result corresponds to a result set, and false if it is an update count or if there are no results other than through INOUT and OUT parameters, if any. Returns: true if first result corresponds to result set. Throws: PersistenceException - if the query execution exceeds

hasMoreResults() Return true if the next result corresponds to a result set, and false if it is an update count or if there are no results other than through INOUT and OUT parameters, if any. Returns: true if next result corresponds to result set. Throws: PersistenceException - if the query execution exceeds

() Retrieve the list of results from the next result set. The provider will call execute on the query if needed. A REF_CURSOR result set, if any, is retrieved in the order the REF_CURSOR parameter was registered with the query. Returns: a list of the results or null is the next item is not a result set

distinct (    boolean distinct ) Specify whether duplicate query results are eliminated. A true ... . If distinct has not been specified, duplicate results must be retained. Parameters: distinct - boolean value specifying whether duplicate results must be eliminated from the query result or

(    boolean distinct ) Specify whether duplicate query results are eliminated. A true value ... has not been specified, duplicate results must be retained. This method only overrides the return ... whether duplicate results must be eliminated from the subquery result or whether they must be retained

a SELECT query that returns a single result . Returns: the result , of type X . Throws ... back. NonUniqueResultException - if more than one result . QueryTimeoutException - if the query execution exceeds the query ... fails and the transaction is rolled back. NoResultException - if there is no result

() Execute a SELECT query that returns a single untyped result . Returns: the result , of type X , or null if there is no result . Throws: IllegalStateException - if called for a Jakarta Persistence query ... and only the statement is rolled back. NonUniqueResultException - if more than one result . QueryTimeoutException

Jakarta Persistence (JPA) Method in jakarta.persistence.StoredProcedureQuery int getUpdateCount() Return the update count or -1 if there is no pending result or if the next result is not an update count. Returns: update count or -1 if there is no pending result or if the next result is not

Jakarta Persistence (JPA) Method in jakarta.persistence.StoredProcedureQuery int executeUpdate() Return the update count of -1 if there is no pending result or if the first result is not an update ... if there is no pending result or if the next result is not an update count.. Throws: PersistenceException

, and the database locking failure results in transaction-level rollback, the provider must throw ... . When the lock cannot be obtained, and the database locking failure results in only statement-level

the name of a column in the SELECT list — i.e., column alias, if applicable. Scalar result types can be included in the query result by specifying this annotation in the metadata. Example: Query q = em

;  Class type ) Get the value of the element at the specified position in the result tuple. The first position is 0. Parameters: i - position in result tuple type - type of the tuple element Returns: value of the tuple element. Throws: IllegalArgumentException - if i exceeds length of result

) Get the value of the element at the specified position in the result tuple. The first position is 0. Parameters: i - position in result tuple Returns: value of the tuple element. Throws: IllegalArgumentException - if i exceeds length of result tuple. Since: Jakarta Persistence (JPA) 1.0

() Execute a SELECT query and return the query result as a typed Stream . By default, this method delegates ... to provide additional capabilities. Returns: a stream of the results , each of type X , or an empty stream if there are no results . Throws: IllegalStateException - if called for a Jakarta Persistence query

Jakarta Persistence (JPA) Method in jakarta.persistence.TypedQuery List getResultList() Execute a SELECT query and return the query results as a typed List . Returns: a list of the results , each of type X , or an empty list if there are no results . Throws: IllegalStateException - if called

through an INOUT or OUT parameter. For portability, all results corresponding to result sets and update counts ... Returns: the result that is passed back through the parameter. Throws: IllegalArgumentException

through an INOUT or OUT parameter. For portability, all results corresponding to result sets and update ... of the parameter as registered or specified in metadata Returns: the result that is passed

which is the union of the given queries, without elimination of duplicate results . Returns: a new criteria query which returns the union of the results of the given queries. Since: Jakarta Persistence (JPA) 3.2

which is the intersection of the given queries, without elimination of duplicate results . Returns: a new criteria query which returns the intersection of the results of the given queries. Since: Jakarta Persistence (JPA) 3.2

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.AbstractQuery boolean isDistinct() Return whether duplicate query results must be eliminated or retained. Returns: boolean indicating whether duplicate query results must be eliminated. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder CriteriaQuery createQuery (    Class resultClass ) Create a CriteriaQuery object with the given result type. Parameters: resultClass - type of the query result Returns: criteria query object. Since: Jakarta Persistence (JPA) 1.0

, you may download and run the result application as a Maven project: JPA Web App - Maven Project (6KB

)); // Prepare the result view (guest.jsp): return new ModelAndView("guest.jsp", "guestDao", guestDao

;if you prefer, you may download and run the result application as a Maven project: Java EE JPA Web