About not

forum_thread

IN operator syntax

Hi, what is the correct syntax for IN operator when list of literals ia used instead of parameter, e.g. SELECT FROM Info i WHERE i.status IN (1,4) ? (Suppose status is int.) I always get this exception: SELECT FROM Info i WHERE i.status IN (1 ==> , <== 4) javax.persistence.PersistenceException Unexpected query token ',' (closing ')' is missing) (error 752)   Query with only one item in list works fine: ... list literal is one of the few JPA query elements that are not supported by ObjectDB yet. You can replace the list with a ...

 
forum_thread

Exception upon index definition change

Hello, I have the following types: ... never cause the application to stop. Even the Doctor does not run anymore using this index definition. We use the latest ObjectDB version ...

 
issue

huge heap usage

we are using objectdb 2.7.2_6. At a custumer we have huge problems with the memory consumption (see the heap dump attached). The database size is pretty small (1.4 GByte). Any idea ? ... be caused by creating  EntityManager instances and not closing them. ObjectDB Support ObjectDB - ...

 
forum_thread

Getting sales quantity per country with a query, an idea anyone?

Hi, For the purpose of some charts on a dashboard for our ERP i would like to get the list of countries and the sales quantity for each of them. I am pretty sure it is somehow possible to get that directly from a more or less complex query but i failed to find it; Does any have an idea? The entity (we call it OrderData) contains fields and other entities related to an order, fields we are interrested in are  buyerCountry and orderPrice. ... The new question is not related to the subject of this thread. Please follow the posting ...

 
forum_thread

How to Use a SF with extended Persistence Context?

Hey, I have a problem to use SF with an Extended Persistence Context Regarding to Transactions. The need for an extended persistence Context emerges for the need to create queries in advance for fast execution so I need to store the queries and I need an EntityManager that doesn't get closed between calls. When I call the SF directly no problem happens but if I use SL to hold a reference to the SF I get com.objectdb.o._PersistenceException: Attempt to begin a new transaction when a transaction is active. ... it finds one it updater his date to the current date. if not, it stores a new one using the persist method of the GuestDao. ...

 
manual

Chapter 6 - Configuration

Explains how to configure and tune ObjectDB, the fast Java object database for JPA/JDO.... ... If a configuration file is not found default values are used. General Configuration ...

 
forum_thread

app.jelastic.eapps.com and objectdb

It seems that this web hosting service doesn't support objectdb and that is frustrating. Does anyone know a way around this? pls help a brother... ... to the project), so it is very unlikely that this will not be supported. ObjectDB Support ObjectDB - ...

 
forum_thread

IMK Stall with certain query

Hello, I am experiencing constant IMK Stall notifications from Java when using certain query: 2015-09-01 16:53:15.785 java[3678:5217999] IMK Stall detected, *please Report* your user scenario in <rdar://problem/16792073> - (imkxpc_deadKeyStateWithReply:) block performed very slowly (4.63 secs) i am sure it is linked with objectdb as these are thrown each time one particular query is used: ... you have many orders. Indexes on buyerId (if not the PK) and buyerName may improve performance.   ...

 
forum_thread

Pessimestic Locking doesn't release when application unexpectedly terminates.

Hi, We have several services in our app framework that we want to use a cluster singleton. Our approach to this was to use Objectdb's pessimestic locking. This seems to work, but if the owner of the current pessimestic lock abruptly quits without releasing the lock it doesn't get released.    Is there anyway the server can detect that a client (lock owner is no longer connected) and therefore release the lock ?   Thank you   Paul Newman ... A possible solution (which is currently not implemented) is to use pessimistic locking with expiration time. For ...

 
issue

[ObjectDB 2.3.7_08] Unexpected exception (Error 990)

Hello there, I've encountered InternalException from ObjectDB. Attached the stacktrace below. I would require your assistance and advise on resolving this issue. Likewise, I would provide any information that you require. Thank you. ... which is now fixed. I suppose that ObjectDB could not have known first-hand if a field is null when toString() is invoked. Thus ...