About execute

forum_thread

Issue with alias

Hi, This query works and correctly casts and selects my entity into the tuplet: SELECT $1, ((com.lexware.vereinsverwaltung.abrechnung.api.model.mitglied.MitgliedDebitorenKontoFragment)$1.qubletFRAGMENTMAP.get('com.lexware.vereinsverwaltung.abrechnung.api.model.mitglied.MitgliedDebitorenKontoFragment')) AS DEB FROM com.lexware.vereinsverwaltung.verein.mitglied.Mitglied $1 WHERE DEB.debitor=true however, trying to access "DEB" in the where clause causes an "unexpected token" error? Alex #1 2012-01-17 04:30 Hi, This query works and correctly casts and selects my entity into the tuplet: SELECT $1 , ...

 
manual

GROUP BY and HAVING clauses

Explains how to use the GROUP BY and HAVING clauses in a JPA/JPQL query. The GROUP BY clause enables grouping of query results. A JPQL query with a GROUP BY clause returns properties of generated groups instead of individual objects and fields. The position of a GROUP BY clause in the query execution order is afte ...

 
forum_thread

String representation of a query

Hi, Is it possible to get a JPQL string having a Query object instance? JpaQuery class doesn't have any method like "getQueryString" or "getDatabaseQuery", maybe it's going to be added in near future? It would be very helpfull to have something similiar to Hibernate etc : findAllBooks.unwrap(org.hibernate.Query.class).getQueryString() I would like to measure time of query execution and log that information with JPQL string and parameters map to find and optimize the most ineffective cases. #1 2012-12-18 10:29 Hi, Is it possible to get a JPQL string having a Query object instance? JpaQuery class doesn't have a ...

 
forum_thread

JPA-Query does not lead to any result

Hi, we have a database with a Entitiy inside which we want to fetch with a query. Normally that works without a problem, but in case of this database that query does not have any results. Can anyome help us what the problem is? SELECT FROM UserModelData usr WHERE usr.userName = 'admin' Attached are two databases, one where the query has a result and one where the query does not has any results. #1 2013-08-23 11:06 Hi, we have a database with a Entitiy inside which we want to fetch with a query. Normally that works wit ...

 
forum_thread

ID format in objectdb 2.x for JDOHelper.getObjectId

Hi, I am trying to upgrade the objectdb from 1.x to 2.x. I installed and configured as per object db tuotrial. I am just wondering, in objectdb 1.x, when i am tring to get the object id for a persistable object, i am getting an integer as a result e.g Object obj = JDOHelper.getObjectId(logTestRunImpl) used to return suppose 1 obj.toString() = 1 but the same code when i am trying to execute for the same object in object db 2.x, i am getting ... = 1 but the same code when i am trying to execute for the same object in object db 2.x, i am getting Object obj = ...

 
api-jdo

checkConsistency()

Validates the PersistenceManager cache with the datastore.(Method of javax.jdo.PersistenceManager)

 
api-jdo

jdoPostAttach(attached)

This method is called during the execution of javax.jdo.PersistenceManager.makePersistent on the persistent instance after the copy is made.(Method of javax.jdo.listener.AttachCallback)

 
forum_thread

Is there a function of "drop table" or "delete from table"?

Besides the em.remove() one by one, is there a function of "drop table" or "delete from table"? TIA ... 21:10 You can execute a DELETE query: em. createQuery ( "DELETE FROM ...

 
forum_thread

Cache configuration of database file pages, query programs, query results

Are there some possibilities to configure following caches in order to keep cache data for only some important entity types and for the entire life cycle of the EntityManagerFactory. Cache of database file pages. Cache of query programs. Cache of query execution results. #1 2016-06-22 08:04 Are there some possibilities to configure following caches in order to keep cache data for only some important en ...

 
forum_thread

Failed to write the value of field using reflection (error 363) on LAZY fetch

Hi There I am using ObjectDB 2.6.3. I get the following Exception when I try to read my entities with a query where I have set to use LAZY initalization. It fails when it tries to set a 1:n member (e.g. a Modell has several Artikels) . When I remove the LAZY hint on the query execution it works. Any hints why this can happen? The Mapping of class Modell and its member: #1 2015-12-18 17:42 Hi There I am using ObjectDB 2.6.3. I get the following Exception when I try to read my entities with a query whe ...