Internal Website Search

1-50 of 171 results

GROUP BY and HAVING clauses

is standard and it is expected to be supported by all JPA implementations. GROUP BY with HAVING Groups in JPQL grouping queries can be filtered using the HAVING clause. The HAVING clause for the GROUP BY clause is like the WHERE clause for the FROM clause. ObjectDB supports the HAVING clause

CriteriaQuery.having(restriction) - JPA Method

JPA Method in javax.persistence.criteria.CriteriaQuery CriteriaQuery having (    Expression  restriction ) Specify a restriction over the groups of the query. Replaces the previous having restriction(s), if any. This method only overrides the return type of the corresponding

Subquery.having(restrictions) - JPA Method

JPA Method in javax.persistence.criteria.Subquery Subquery having (   Predicate... restrictions ) Specify restrictions over the groups of the subquery according the conjunction of the specified restriction predicates. Replaces the previously added having restriction(s), if any

Subquery.having(restriction) - JPA Method

JPA Method in javax.persistence.criteria.Subquery Subquery having (    Expression  restriction ) Specify a restriction over the groups of the subquery. Replaces the previous having restriction(s), if any. This method only overrides the return type of the corresponding AbstractQuery

AbstractQuery.having(restrictions) - JPA Method

JPA Method in javax.persistence.criteria.AbstractQuery AbstractQuery having (   Predicate... restrictions ) Specify restrictions over the groups of the query according the conjunction of the specified restriction predicates. Replaces the previously having added restriction(s

AbstractQuery.having(restriction) - JPA Method

JPA Method in javax.persistence.criteria.AbstractQuery AbstractQuery having (    Expression  restriction ) Specify a restriction over the groups of the query. Replaces the previous having restriction(s), if any. Parameters: restriction - a simple or compound boolean expression Return: the modified query Since: JPA 2.0

CriteriaQuery.having(restrictions) - JPA Method

JPA Method in javax.persistence.criteria.CriteriaQuery CriteriaQuery having (   Predicate... restrictions ) Specify restrictions over the groups of the query according the conjunction of the specified restriction predicates. Replaces the previously added having restriction(s

New to Product & Having An Issue

New to Product & Having An Issue

URGENCY, or in query does not report any objects on first operand having no results

URGENCY, or in query does not report any objects on first operand having no results

JPA Query Structure (JPQL / Criteria)

. Having an SQL-like syntax in JPA queries is an important advantage because SQL is a very powerful query ... ;of up to 6 clauses in the following format: SELECT ... FROM ... [WHERE ...] [GROUP BY ... [ HAVING ... , HAVING and ORDER BY are optional. The structure of JPQL DELETE and UPDATE queries is simpler: DELETE

Defining a JPA Entity Class

that is marked (annotated) as having the ability to represent objects in the database. Conceptually this is similar to serializable classes, which are marked as having the ability to be serialized. The Point

JPA Criteria API Queries

, join , fetch ). WHERE clause ( where ). GROUP BY / HAVING clauses ( groupBy , having , count , sum

FROM clause (JPQL / Criteria API)

,FROM, GROUP, HAVING , IN, INDEX, INNER, IS, JOIN, KEY, LEADING, LEFT, LENGTH, LIKE,LOCATE, LOWER, MAX

JPA Query Expressions (JPQL / Criteria)

Query expressions are the foundations on which JPQL and criteria queries are built. Every query consists of clauses - SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY, and each clause consists of JPQL / Criteria query expressions. Atomic Expressions The atomic query expressions are: JPQL

DELETE Queries in JPA/JPQL

BY, HAVING and ORDER BY clauses. A WHERE clause, which is essential for removing selected

Privacy Policy

experience and to avoid You having to re-enter your preferences every time You use the Website. Analytics

Query Parameters in JPA

is designated for setting a parameter in a Criteria API query. The reason for having nine set methods

UPDATE SET Queries in JPA/JPQL

UPDATE queries cannot include the GROUP BY, HAVING and ORDER BY clauses, but the WHERE clause

ObjectDB Object Database Features

JOIN and JOIN FETCH ). WHERE (with both JPQL and JDOQL expressions). GROUP BY (including HAVING

ORDER BY clause (JPQL / Criteria API)

.currency HAVING COUNT(c) 1 ORDER BY c.currency The ORDER BY clause in the above query orders the results by

Chapter 4 - JPA Queries (JPQL / Criteria)

BY, HAVING , ORDER BY): Then the expressions that are used for building JPQL and criteria query

javax.persistence.criteria.CriteriaQuery

if no restrictions have been specified. Return: having clause predicate Inherited from ... : the modified query Since: JPA 2.0 CriteriaQuery having ( Expression  restriction) Specify a restriction over the groups of the query. Replaces the previous having restriction(s), if any

javax.persistence.criteria.AbstractQuery

(s) over the grouping items, or null if no restrictions have been specified. Return: having clause ... more grouping expressions Return: the modified query Since: JPA 2.0 AbstractQuery having ( Expression  restriction) Specify a restriction over the groups of the query. Replaces the previous having

javax.persistence.criteria.Subquery

) over the grouping items, or null if no restrictions have been specified. Return: having clause predicate ... expressions Return: the modified subquery Since: JPA 2.0 Subquery having ( Expression  restriction) Specify a restriction over the groups of the subquery. Replaces the previous having restriction(s

IDs of Entities suddenly became UUIDs?

Hi, We're having our system with ObjectDB 2.4.5 in production since this year April and it works ... the DB are having the field "myId" as type "String" and with an UUID ... that all Databases we use are affected by this. Many of them having mixed Long and UUID String ids in

JPQL query to get entities that does not have a child entity in their child entities

;   004 From these 2 tables I have to query for Jobs having states FINISHED, CANCELED, FAILED and ACTIVE. FINISHED :   A Job having status 'Finished'. CANCELED : A Job having status '%Canceled' and not ('Finished'). FAILED :      A Job having status '%Failed

Updating Entities

having to cycle through each Employee object to update their references - so I'm going ... is about over. DragonRulerX Jared Hinze OK. Note that having a separate object context for every EntityManager ... the two EMs. The downside to this is having to collect each object that needs to have its reference updated

Index causes increased memory usage

with us with understanding what is going on behind the scenes inside object db.  When you refer to having "30 open databases", are you talking about having 30 PersistanceManagers open?  Or 30 ... to having "30 open databases", are you talking about having 30 PersistanceManagers open?  Or 30

OEM license, enhancer

with the system which was created before having the OEM license and before adding enhancer ... format is the same and it is not affected by having or not having a license. support Support

How Should I Configure objectdb.conf to Obtain 256KB Disk IO Requests and Maximize Shared PersistenceManager Entity Cache?

;to forum thread mentioned above) appropriate to achieve this goal?   CBE CBE Having larger ... (because it is stored on an Amazon EBS disk which has max performance at that size and reduces monetary fees by having ... on an Amazon EBS disk which has max performance at that size and reduces monetary fees by having fewer

Object DB vs EclipseLink/TopLink: Unloaded relationships in detached entities

manager or the entity manager factory after having detached the entity, the detached entity finds ... of all theory is to make the irreducible basic elements as simple and as few as possible without having ... simpler.”   webel Dr Darren Kelly Having remarked on the ObjectDB JavaEE tutorials

find repeated records by JPQL

(select id from TTT s group id having count(id)1) I dont know how to do this using JPQL, but I use ... in #1 contains GROUP BY / HAVING . The outer query in #1 contains the IN operator. The query in #3 ... get the point since in #3 there is no GROUP BY / HAVING . support Support

Java 9 support

are allowed without me having to know what is really required by what. You can see that my tool and approach is designed for "just me" to get true Java 9 without having to wait on third parties but at the sacrifice of having everything exposed (which is fine because I am the only one using

Is there a way to set EAGER fetch on all "ToMany" collection relationships

Given that the default seems to be FetchType.LAZY for all collections @OneToMany and @ManyToMany. Such as a configuration option. Instead of having to explicitly set fetch in annotation code in every relationship. webel Dr Darren Kelly No. There is no such configuration option, since having EAGER

Dirty checking

: @Embeddable @EntityListeners (Listener.class) So, having to go and make all @Embeddables into @Entities. and, having to manually save each one. Question: What's the best way to cascade persistence of Entities

ObjectDB Parsing taking huge processing time

factors may make  getPersistenceManagerFactory  particularly slower, such as having a configuration file with many unused activation keys or having schema with hundreds of complex types

On ensuring ID available after persist

, which relies on an "external" entity object having a non-null id after it has been passed ... ); // then do something that relies on Java variable e having e.getId() defined (like wiring

AbstractQuery.getGroupRestriction() - JPA Method

JPA Method in javax.persistence.criteria.AbstractQuery Predicate getGroupRestriction () Return the predicate that corresponds to the restriction(s) over the grouping items, or null if no restrictions have been specified. Return: having clause predicate Since: JPA 2.0

[ODB1] Chapter 8 - ObjectDB Server

configuration is loaded automatically without having to restart the server. To turn off auto reloading

Once served to JSF page via @EJB query bean, many list fields are null (but same query ok after fresh persist in @PostConstruct)

to having this fixed and to having a robust ObjectDB working on my problem, as I am greatly encouraged ... when a JSF developer having performed a query in an EJB and having returned that from a JSF backing bean

NullPointerException on initial database creation

I'm having trouble creating a simple test case that reproduces it.  At this point, I think it may be related to having a class annotated with @Startup or @ApplicationScoped that references

javax.jdo.PersistenceManager

managed by this persistence manager having the specified object states. Parameters: states - The states ... having the specified object states and being instances of the specified classes. Parameters: states ... the PersistenceManager instances more easily by having an application object associated with each PersistenceManager

Query.setGrouping(group) - JDO Method

JDO Method in javax.jdo.Query void setGrouping (   String group ) Set the grouping expressions, optionally including a " having " clause. When grouping is specified, each result ... . Parameters: group a - comma-delimited list of expressions, optionally followed by the " having " keyword and a boolean expression Since: JDO 2.0

javax.jdo.Query

a " having " clause. When grouping is specified, each result expression must either be an expression ... -delimited list of expressions, optionally followed by the " having " keyword and a boolean expression

PersistenceManager.getManagedObjects(states,classes) - JDO Method

JDO Method in javax.jdo.PersistenceManager Set getManagedObjects (   EnumSet  states,    Class... classes ) Get the objects managed by this persistence manager having the specified object states and being instances of the specified classes. Parameters: states

PersistenceManager.getManagedObjects(states) - JDO Method

JDO Method in javax.jdo.PersistenceManager Set getManagedObjects (   EnumSet  states ) Get the objects managed by this persistence manager having the specified object states. Parameters: states - The states of objects that we are interested in Return: the objects Since: JDO 2.1

PersistenceManager.getUserObject() - JDO Method

JDO Method in javax.jdo.PersistenceManager Object getUserObject () The application can manage the PersistenceManager instances more easily by having an application object associated with each PersistenceManager instance. Return: the user object associated with this PersistenceManager See Also: setUserObject Since: JDO 1.0

PersistenceManager.setUserObject(o) - JDO Method

JDO Method in javax.jdo.PersistenceManager void setUserObject (   Object o ) The application can manage the PersistenceManager instances more easily by having an application object associated with each PersistenceManager instance. Parameters: o - the user instance to be remembered

javax.jdo.spi.JDOImplHelper

only if they are authorized by the security manager. To avoid having every call go through the security

javax.jdo.listener.InstanceLifecycleListener

JDO Interface InstanceLifecycleListener All lifecycle listeners extend from this base interface. In order to minimize the impact on domain classes, instance callbacks can be defined to use a life-cycle listener pattern instead of having the domain class implement the callback interface(s). Since: JDO 2.0