About in

forum_thread

Database is locked when in use

I am oberving that when i reading anything from odbfiles, i am not allowed to copy and paste the odb files in the file system but the same i was able to do it in object db 1.0. We supprt export functionality and if i am not allowed to copy it in objectdb 2.x, then its a problem for us :-( Do you have any settings or other way to handle this? ... odbfiles, i am not allowed to copy and paste the odb files in the file system but the same i was able to do it in object db 1.0. We supprt export functionality and if i am not ...

 
forum_thread

explorer locks local database in readonly mode

hi, my current use case is: execute unit test, verify results in explorer. my problem, i have to close the explorer before every run, and open it again after the tests are done. this slows down the whole process. i opened the database in readonly mode, but the file will be locked by the explorer process. do you think it's worth to improved this? if yes, isseu #39 (refresh) will be useful too. thanks ... use case is: execute unit test, verify results in explorer. my problem, i have to close the explorer before every run, ... down the whole process. i opened the database in readonly mode, but the file will be locked by the explorer process. ...

 
forum_thread

Project runs in Eclipse but not when exported to runnable jar

I have a simple project that performs some stability calculations and displays a scale drawing of a model glider. I decided to use objectdb as a way to persist the values for later retrieval. The project works perfectly well when run from eclipse but nothing opens when I export to a runnable jar and execute that. No windows open, there are no eror dialogs etc. Commenting out all the code related to object db resolves the issue and the project runs, so I'm fairly sure it is something I've done relating to objectdb. ... and objectdb.jar are included in the build path, and are present in the compiled file, as is the test GliderCalcs.odb file created by running ... this is a hobby project, please excuse any travesties in my code. Many thanks in advance, Mark ...

 
forum_thread

Using aliases in WHERE clause

Hi, I'm trying to run query : SELECT DISTINCT ppi.inquiries AS i FROM ProjectPartInfo ppi WHERE i.status IS NOT NULL Unfortunately, 'i' alias doesn't work in WHERE clause : Query Execution Error ===================== Unexpected query token 'i' SELECT DISTINCT ppi.inquiries AS i FROM ProjectPartInfo ppi WHERE  ==> i <== .status IS NOT NULL   ... Unfortunately, 'i' alias doesn't work in WHERE clause : Query Execution Error ===================== Unexpected ... When i change 'i' to 'ppi.inquiries' in my WHERE statement, query runs correctly : SELECT DISTINCT ...

 
forum_thread

Query to search for common elements in two separate collections.

I'm trying to work out the most efficient way to build a query that can compare two collections for identical members. Something like: "SELECT o FROM Object o WHERE o.someCollection CONTAINS MEMBER OF :someCollection" Is something like this possible in the JPA spec? ... :someCollection Is something like this possible in the JPA spec? edit ... The hash code of every stored collection should be stored in an indexed field, possibly in a new entity or embeddable class that would ...

 
forum_thread

In memory processing for ObjectDB

Hi there ! We are building a platform for trades processing where we want to keep our processing speeds very high. We like ObjectDb because its simplicity and the performance benchmarks, but to take it to next level really we wanted to check whether is there any In memory mode available for ObjectDB where recovery is possible, something like prevalyer etc. ... next level really we wanted to check whether is there any In memory mode available for ObjectDB where recovery is possible, something ... can help us here. Additionally the only cache I see in settings is query cache, is it only that query result sets are cached or I ...

 
forum_thread

Possible Bug in MEMBER OF

Hello! I maybe found another bug in version 2.3.3. I'll send you a test DB via support ticket. Try the following query in explorer: SELECT u FROM Unit u WHERE :user MEMBER OF u.users Set user to TrackerUser#8 If i run this quey i get: Invalid operand type at.co.pjm.tracker.persistence.TrackerUser for operator MEMBER OF SELECT u FROM Unit u WHERE :user MEMBER OF u. ==> users <== In my opinion the result should be Unit#4004 ... Hello! I maybe found another bug in version 2.3.3. I'll send you a test DB via support ticket. Try the following query in explorer: SELECT u FROM Unit u WHERE :user MEMBER OF u . ...

 
forum_thread

java 8 LocalDateTime is not working in query

My entity class has a field of type java.time.LocalDateTime. I'm able to persist entities and I'm able to query without datetime field in where clause, but with datetime in where clause doesn't return anything and not exception.   ... entities and I'm able to query without datetime field in where clause, but with datetime in where clause doesn't return anything and no exception.   ...

 
forum_thread

Externalising persistence.xml properties in Glassfish?

Hi, ... Why dont you create multiple  presistance units in the persistance.xml and that way you can externalize the persistance unit ... up if you give the place holder. I know I have tried this in the application.xml  and I dont see why it wont work for the persitance ...

 
forum_thread

Password in Embedded Mode?

Is there a way to setup a database file that will be accessed in embedded mode, such that it is locked with a password.  Thereby making it impossible to use ObjectDB to access the contents of the file without providing the correct password when obtaining a connection.  In my case, I'm interested in obtaining a JPA connection:... there a way to setup a database file that will be accessed in embedded mode, such that it is locked with a password.  Thereby making ... the correct password when obtaining a connection.  In my case, I'm interested in obtaining a JPA connection: Map<String, ...