ObjectDB Database Search

Hi, I'm trying to create reporting query that will return entities grouped by year / mont / day ... WHERE YEAR(record_date) = 2009 GROUP BY YEAR(record_date), MONTH(record_date) or maybe something like this: SELECT COUNT(id) FROM stats WHERE YEAR(record_date) = 2009 GROUP BY DATE_FORMAT(record_date

Hello! In a query like SELECT parent, children FROM Parent parent LEFT JOIN p.children children GROUP BY parent  maybe it would be good if it will return a list of Object[ 2 ], where the second object is a list of children of a parent. Because creating a query to get a list of parents

Hi,   AFter the upgrade from 2 . 2 .8_02 (not sure if it was build 03/04 as I skipped 03 ... =false) OR ($1.conditionThree=false)))) Exception in thread "main" [ObjectDB 2 . 2 .8_04] Unexpected ... The criteria query AND/OR fix in 2 . 2 .8_04 caused this new problem. Please try build  2 . 2 .8_05

Hello, How can I incorporate roles/ group in ObjectDB config file? I see no support for this. For example, I would like to place several users under a given group or role, but I see no way of doing this as no such element is present  in the config file. Is it possible to have this? st.clair

Jakarta Persistence (JPA) Annotation Type jakarta.persistence.SequenceGenerators Implemented Interfaces: Annotation Target: Type, Method, Field, Package Used to group SequenceGenerator annotations. See Also: SequenceGenerator Since: Jakarta Persistence (JPA) 2 . 2 Annotation Elements

Jakarta Persistence (JPA) Annotation Type jakarta.persistence.TableGenerators Implemented Interfaces: Annotation Target: Type, Method, Field, Package Used to group TableGenerator annotations. See Also: TableGenerator Since: Jakarta Persistence (JPA) 2 . 2 Annotation Elements TableGenerator[] value

groups JoinColumn annotations for the same relationship. Each JoinColumn annotation must explicit ... Persistence (JPA) 2 .1 Additional JDK methods inherited from java.lang.annotation.Annotation java.lang

Jakarta Persistence (JPA) Annotation Type jakarta.persistence.NamedEntityGraphs Implemented Interfaces: Annotation Target: Type Used to group NamedEntityGraph annotations. See Also: NamedEntityGraph Since: Jakarta Persistence (JPA) 2 .1 Annotation Elements NamedEntityGraph[] value Since: Jakarta

" + "WHERE o.cid = c.id " + " GROUP BY c.id, c.name", "CustomerDetailsResult"); @SqlResultSetMapping( name ... NamedNativeQuery ColumnResult Since: Jakarta Persistence (JPA) 2 .1 Annotation Elements Class

Jakarta Persistence (JPA) Annotation Type jakarta.persistence.Converts Implemented Interfaces: Annotation Target: Method, Field, Type Used to group Convert annotations. Multiple converters must not be applied to the same basic attribute. See Also: Convert Since: Jakarta Persistence (JPA) 2 .1

Jakarta Persistence (JPA) Annotation Type jakarta.persistence.PrimaryKeyJoinColumns Implemented Interfaces: Annotation Target: Type, Method, Field Groups PrimaryKeyJoinColumn annotations. It is used ... _DEFAULT) Since: Jakarta Persistence (JPA) 2 .1 Additional JDK methods inherited from java.lang

groupBy (    List grouping ) Specify the expressions that are used to form groups over the query results. Replaces the previous specified grouping expressions, if any. If no grouping expressions are specified, any previously added grouping expressions are simply removed. Parameters: grouping

;  Expression ... grouping ) Specify the expressions that are used to form groups over the subquery results. Replaces the previous specified grouping expressions, if any. If no grouping expressions are specified, any previously added grouping expressions are simply removed. This method

groupBy (    Expression ... grouping ) Specify the expressions that are used to form groups over the query results. Replaces the previous specified grouping expressions, if any. If no grouping expressions are specified, any previously added grouping expressions are simply removed. Parameters

;  List grouping ) Specify the expressions that are used to form groups over the subquery results. Replaces the previous specified grouping expressions, if any. If no grouping expressions are specified, any previously added grouping expressions are simply removed. This method only overrides

groupBy (    Expression ... grouping ) Specify the expressions that are used to form groups over the query results. Replaces the previous specified grouping expressions, if any. If no grouping expressions are specified, any previously added grouping expressions are simply removed. This method

groupBy (    List grouping ) Specify the expressions that are used to form groups over the query results. Replaces the previous specified grouping expressions, if any. If no grouping expressions are specified, any previously added grouping expressions are simply removed. This method

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.AbstractQuery AbstractQuery having (    List restrictions ) Specify restrictions over the groups of the query according ... removed. Parameters: restrictions - a list of zero or more restriction predicates Returns: the modified query. Since: Jakarta Persistence (JPA) 3. 2

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.Subquery Subquery having (    List restrictions ) Specify restrictions over the groups of the query according ... : restrictions - a list of zero or more restriction predicates Returns: the modified query. Since: Jakarta Persistence (JPA) 3. 2

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaQuery CriteriaQuery having (    List restrictions ) Specify restrictions over the groups of the query according ... : restrictions - a list of zero or more restriction predicates Returns: the modified query. Since: Jakarta Persistence (JPA) 3. 2

we update to the latest version from 2 .7.6. Now we have the problem that we have numerous logs ... since version 2 .7.6 that could possibly effect query execution. Could you please explain or post some of these logs that show deep query plan checks (and are new in 2 .7.6_04)? In addition

to 'aly' . SUBSTRING('Italy', 3, 2 ) is evaluated to 'al' . Positions are one-based (as in SQL), not ... ); Expression l2 = cb. locate (path, "x"); Expression l3 = cb. locate (path, param, cb. literal ( 2 )); Expression l4 = cb. locate (path, "x", 2 ); // LOWER(str) and UPPER(str) Expression lower = cb. lower (path

. For example: MOD(11, 3) evaluates to 2 . MOD(8, 4) evaluates to 0 . The MOD function takes two integer ... function returns the square root of a specified argument. For example: SQRT(9) is evaluated to 3 SQRT( 2 ... (+) Expression sum1 = cb. sum (path, param); // 2 expressions Expression sum2 = cb. sum (path, 1000

ObjectDB should incorporate roles/ group in ObjectDB config file? I see no support for this. I would like to place several users under a given group or role, but I see no way of doing this as ... , there could be a role/ group element which would categorise the user further. This would help in authentication.   Thanks st.clair.clarke St Clair Clarke

the database. Fixed a bug in using LIKE in AND/OR in criteria queries . Fixed a bug in AND/OR grouping

. You are encouraged to test ObjectDB before purchasing a license. Server License ObjectDB 2 .x Server License costs £500  and includes all version 2 .x updates. A server license covers one installation ... a Server License Site License ObjectDB 2 .x Site License costs £2,500  and includes all version 2 .x

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.AbstractQuery List getGroupList() Return a list of the grouping expressions. Returns empty list if no grouping expressions have been specified. Modifications to the list do not affect the query. Returns: the list of grouping expressions. Since: Jakarta Persistence (JPA) 1.0

line: ObjectDB Enhancer [version 2 .9.4] Copyright (c) 2025, ObjectDB Software. All rights reserved ... lists the classes that have been enhanced: [ObjectDB 2 .9.4] 3 persistable types have been enhanced: test.MyEntity1 test.MyEntity2 test.MyEmbeddable 2 NON persistable types have been enhanced: Main test

. "Recipient" means anyone who receives the Program under this Agreement, including all Contributors. 2 ... such Recipient's patent(s), then such Recipient's rights granted under Section 2 (b) shall terminate as ... its Contributions) under the new version. Except as expressly stated in Sections 2 (a) and 2 (b

Exception thrown by ConnectionFunction.apply , if any. Since: Jakarta Persistence (JPA) 3. 2 void ... of entity graph Returns: entity graph. Since: Jakarta Persistence (JPA) 2 .1 EntityGraph ... graph. Since: Jakarta Persistence (JPA) 2 .1 Query createNamedQuery ( String name ) Create an instance

LEFT OUTER JOIN. Fixed GROUP BY DATE(...) - merging AM and PM into the same date.

, -127L, 0L, 07777L float : 3.14F, 0f, 1e2f, - 2 .f, 5.04e+17f double : 3.14, 0d, 1e2D, - 2 ., 5.04e+17 ... . literal (1); Expression i2 = cb. literal (Integer.ValueOf( 2 )); Expression d = cb. literal (3.4

')),(v$ 2 .classIdentifier='(TC)')))" eval="9.3923" group =" group (a.endDate,v$1.nodePath,v$3.doubleValue ... .linkedObjects join v$ 2 )))" eval="18.6359" group =" group (a.endDate,v$1.nodePath,v$3.doubleValue)" eval ... .properties.name = 'scheduledSlot') GROUP BY a.endDate, a.objectsInCharge.nodePath, a.objectsInCharge

All latest versions later 2 .4.5+ even 2 .4.5_05 doesn't work, it deployed but errors when running. But 2 .4.4 worked javax.ejb.EJBException at com.sun.ejb.containers.BaseContainer ... Luc Have you tried 2 .4.5 or 2 .4.5_03? Because 2 .4.5_03 fixes a GlassFish integration issue . support

that will be in effect during query execution. Since: Jakarta Persistence (JPA) 3. 2 CacheStoreMode ... . Since: Jakarta Persistence (JPA) 3. 2 int getFirstResult () The position of the first result the query object ... : position of the first result. Since: Jakarta Persistence (JPA) 2 .0 The Running JPA Queries article

. See Also: Query Parameter Since: Jakarta Persistence (JPA) 2 .0 Chapter 4 - JPA Queries (JPQL / Criteria ... effect during query execution. Inherited from Query Since: Jakarta Persistence (JPA) 3. 2 CacheStoreMode ... . Inherited from Query Since: Jakarta Persistence (JPA) 3. 2 int getFirstResult () The position of the first

Since: Jakarta Persistence (JPA) 2 .1 Public Instance Methods boolean execute () Return true if the first ... . 2 CacheStoreMode getCacheStoreMode () The cache storage mode that will be in effect during query execution. Inherited from Query Since: Jakarta Persistence (JPA) 3. 2 int getFirstResult () The position

attribute specifies the size of the shared level- 2 cache that is managed by the EntityManagerFactory and shared by all its EntityManager instances. To disable the level- 2 cache, specify 0 or 0mb

compatible with varags. Since: Jakarta Persistence (JPA) 2 .0 The JPA Criteria API Queries article ... more restriction predicates Returns: and predicate. Since: Jakarta Persistence (JPA) 3. 2 Expression ... . Since: Jakarta Persistence (JPA) 3. 2 Order asc ( Expression expression ) Create an ordering by

ObjectDB 2.2.2

Jakarta Persistence (JPA) Method in jakarta.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. Returns: having clause predicate. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.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

= x :     (0, 0), (1, 1), ( 2 , 2 ), ..., (999, 999) The BIRT report

: ObjectDB 2 .3.7_04 or later is required if Glassfish 3.1. 2 (or later) is used. The Tutorial Steps This tutorial consists of the following steps:

and menus might look slightly different but the code would be the same). Note: ObjectDB 2 .3.7_04 or later is required if Glassfish 3.1. 2 (or later) is used. The Tutorial Steps This tutorial consists of the following steps:

) void setCandidates(Extent pcs) void setFilter(String filter) 7. 2   Query Filter Syntax ... , 0, 0xFFFF, 07777 , ... long 2003L, -127L, 0L, 0xFFFFL, 07777L , ... float 3.14F, 0f, 1e2f, - 2 .f, 5.04e+17f , ... double 3.14, 0d, 1e2D, - 2 ., 5.04e+17 , ... char 'x', '@', '\n', '\\', '\'', '\uFFFF

of persistent types is available at section 3. 2 ). ObjectDB provides an additional storing method ... (an embedded object can only be retrieved using a reference from its containing object). 6. 2   ... of the first object in the database is always 1, the ID of the second object is 2

mode are discussed in Section 1. 2 . Because the JDO API and the format of the database file ... is listening for new connections is specified in the configuration file (as explained in section 8. 2 ... to manage the server (stop, restart and start), and to exit the application. 8. 2   Single User

. 2   javax.jdo.PersistenceManager The javax.jdo.PersistenceManager interface represents ... retries (about 2 seconds) a JDOUserException (a subclass of JDOException ) is thrown. These constants

. It has a small footprint, high performance, and a flexible architecture (1-Tier, 2 -Tier or N-Tier). 1 ... developing software without a debugger. 1. 2   ObjectDB Operating Modes ObjectDB for Java/JDO