About in

manual

UPDATE SET Queries in JPA/JPQL

Explains how to apply server side bulk update using a JPA/JPQL query.... entity objects can be updated, as explained in chapter 2 , by: Retrieving the entity objects into an ... executed, update the content of specified entity objects in the database. Updating entity objects in the database using an ...

 
manual

Numbers in JPQL and Criteria Queries

Shows how numbers, arithmetic expressions and numeric functions and operators (MOD, ABS) can be used in JPQL queries. Numeric values may appear in JPQL queries in many forms: as  numeric literals - e.g. 123 , ... arguments. as  path expressions - in navigation to persistent numeric fields. as aggregate ...

 
forum_thread

JPA Query language support in OBjectDB / Sub query or nested Query

Hi Wanted to check with you on the exact level of support of JPA QL within the ObjectDB world. I have given a sample typed query below which fails to work with ObjectDB and it runs very well with the Hibernate/MySQL JPA. We are using Spring Data here. It looks like a problem with Sub query or nested queries where I am using IN clause like below. ... problem with Sub query or nested queries where I am using IN clause like below. @Query("SELECT product FROM Product product WHERE product.id in (SELECT msg.objectId FROM Message msg WHERE msg.contextId = ... You may have to disable pop up blocking in order to use the toolbar (e.g. in Chrome). Use ctrl + right ...

 
issue

Error reading UTF string (Serialized Objects in Explorer)

This is the message I get for attached db and this query: ... There is a problem in retrieval of the BeitragVertragArt instance (with qubletID = 371). Trying to view all the instances of this type in the explorer (by right clicking the type in the Schema tab and selecting ...

 
issue

Better support for ObjectDB in Eclipse Plugins

ObjectDB can be used in Eclipse plugin, but currently it has to be embedded in the plugin and cannot be used from other plugins in which it is not embedded. More details can be found in the following forum threads: ObjectDB eclipse plugin Eclipse plugin problem (using ObjectDB as a separate bundle) ClassCastException of same object type javax.persistence.PersistenceException ... ObjectDB can be used in Eclipse plugin, but currently it has to be embedded in the plugin and cannot be used from other plugins in which it is not ...

 
forum_thread

Join performance in Objectdb

select count(e) from Meta e, ImageNet i, Page p where e.idImage=i.id and e.idPage=p.id; So simple a command cause me half an hour and is running now! Each table has about 160K records. What formula can predict the time for such counting? TIA ... Since you didn't provide a test case (as requested in the posting instructions ) it is impossible to see what is exactly the problem. Maybe the id fields in Page and Image are not annotated with @Id or @Index . In that ...

 
api-jpa

Criteria Query Selection and Results

Reference (JavaDoc) of JPA query criteria result interfaces, including Selection, CompoundSelection, Order and Tuple. The JPA Criteria API interfaces in this group are in use for setting the SELECT and ORDER BY clauses and for representing query ... Clause Elements The content of the SELECT clause in a criteria query is represented by Selection : ...

 
forum_thread

Query in JPA2 with LEFT JOIN on INNER JOIN

select a.description, a.id, p1.description, p2.description,p3.description from action a left join action_profile ap1 on ap1.id_action=a.id inner join profile p1 on  ap1.id_profile=p1.id  and p1.name='?' left join action_profile ap2 on ap2.id_action=a.id inner join profile p2 on  ap2.id_profile=p2.id  and p2.name='?' where a.id =?;   Thanks   ... How write a query in JPA2 with LEFT JOIN on INNER JOIN? SELECT a . description , ... The syntax of using JOIN in explained on this manual page . Using ON in a  JOIN ...

 
forum_thread

JPQL IN Operator

How can I use the standard JPQL IN operator with ObjectDB? This JPQL query works fine with EclipseLink / postgres but throws an exception in objectDB: select distinct dv.creationtime from DataValue dv where dv.capabilityId.capabilityId ==> in <== :capabilities and dv.creationtime >= :earliest and dv.creationtime <= :latest order by dv.creationtime ASC [ObjectDB 2.2.9] javax.persistence.PersistenceException Unexpected query token 'in' (error 752) ... How can I use the standard JPQL IN operator with ObjectDB? This JPQL query works fine with EclipseLink / postgres but throws an exception in objectDB: SELECT DISTINCT dv . creationtime FROM ...

 
manual

[ODB1] Chapter 8 - ObjectDB Server

An ObjectDB server can manage one or more databases. Databases that are managed by a server can be accessed by multiple processes simultaneously. In addition, the server supports accessing these databases from remote machines by TCP/IP. More details about client server mode vs. embedded database mode are discussed in Section 1.2.... can be accessed by multiple processes simultaneously. In addition, the server supports accessing these databases from remote machines ... server mode vs. embedded database mode are discussed in Section 1.2 . Because the JDO API and the format of the database file are ...