About GROUP BY

forum_thread

Soft Reference Object Cache Recommendation

(Trying again.  Last post, ~50 minutes to compose, failed, possibly due to an attachment upload size limit being exceeded before the post attempt.  =(  ) ... when JVM full GC happens, which I think should be possible by configuring ObjectDB to use soft references and correct use of my JdoBlob2 ... I imagine might stand for something like "Page Access Group element". So, I eventually derive at the conclusion that a lot of ...

 
forum_thread

JDO sequences from ORM file

I want to use sequences in JDO without using annotations. Normally this is done with a package-X.orm file, where X is a value passed to the PersistenceManagerFactory as the value of property "mapping". I'm encouraged to see that the JDO zip that comes with ObjectDB includes the DTD/XSD for this type of file, though I can't see a mention of it in the manual. ... = "JdoTypes$ClassWithFetchGroup" > <fetch-group name = "fg1" post-load = "false" > ... Thanks. I have got this working, by a combination of moving the sequence from ORM to JDO file, specifying the ...

 
forum_thread

On ensuring ID available after persist

This reports on a possible solution to a common problem: I was trialling ObjectDB on an existing, functioning, large JavaEE/JPA web application, which until now had used EclipseLink+MySQL and then Oracle+MySQL. On trying it out on ObjectDB I hit a problem with my very extensive entity wiring code, which relies on an "external" entity object having a non-null id after it has been passed to EntityManager.persist, thus: ... that ObjectDB doesn't assign ID during persist by default (when using the AUTO strategy or not specifying strategy) is ... TABLE  strategies, which support allocating a group of IDs in advance in one round trip (see the allocationSize ...

 
forum_thread

Dirty checking

Hi, wondering if anyone knows the best way to detect which objects have been changed in the database. ie: which objects, and which collections of objects, have been dirtied.     ... that this view tx itself doesn't alter the database, by rolling it back after I've generated the views. Your caching ... may depend on whether the client is an administrator, or a group leader, etc. Now that table is a projection/lens/reactive-query over ...

 
issue

Database access error , Doctor hanging on trying to repair, production shutdown at our biggest customer

we have a database shutdown, logs are showing: [2017-07-10 21:07:23 #1 store] Database 'F:\Hummingbird\Objectdb\db\coreSystemDb.odb' is opened by 11028@wzbhb101 [2017-07-10 21:07:23 #2 server] Server on port 3333 has started by 11028@wzbhb101 [2017-07-14 07:08:38 #3 store] SectionClassifier: SectionClassifier{2->merger[2699]-missing:1} [2017-07-14 07:09:08 #4 store] SectionClassifier: SectionClassifier{2->merger[2699]-missing:1} ... is opened by 11028@wzbhb101 [2017-07-10 21:07:23 #2 server] Server on port 3333 has started by 11028@wzbhb101 [2017-07-14 07:08:38 #3 store] SectionClassifier: ... Sections with Errors -------------------------- Group #1: Page#7880349 5:194359909 0/2 0+1954/2699 ... ...

 
manual

FROM clause (JPQL / Criteria API)

Explains how to use the FROM clause and JOIN expressions in a JPA/JPQL query.... instances of specific types at the WHERE clause level by using a type expression . For example, in the following query, ... EMPTY, END, ENTRY, ESCAPE, EXISTS, FALSE, FETCH,FROM, GROUP, HAVING, IN, INDEX, INNER, IS, JOIN, KEY, LEADING, LEFT, LENGTH, ...

 
api-jdo

detachCopy(pc)

Detach the specified instance from the PersistenceManager.(Method of javax.jdo.PersistenceManager)

 
api-jdo

addSubquery(sub, variableDeclaration, candidateCollectionExpression, parameters)

Add a subquery to this query.(Method of javax.jdo.Query)

 
forum_thread

Help: After upgrading from 2.2.8_02 to 2.2.8_04, can't perform LIKE query

Hi,   During the upgrade from 2.2.8_02 (not sure if it was build 03/04 as I skipped 03) - my LIKE queries have stopped working. As an example output: ... 2.2.8_04] Unexpected exception (Error 990) Generated by Java HotSpot(TM) 64-Bit Server VM 1.6.0_26 (on Mac OS X 10.6.8). Please ... Avoid overflow of published source code examples by breaking long lines . You may mark in paragraph code words ...

 
api-jpa

JPA 2 Annotations

Reference (JavaDoc) of all the JPA 2 annotations, including @Entity, @Embeddable, @NamedQuery, @GeneratedValue, etc.... These ORM annotations are silently ignored by ObjectDB. ...