About named queries

issue

Collation and String Order

ObjectDB should support selecting collation when a new database is created. The collation should affect the way strings are sorted in queries (with ORDER BY). Currently strings are always ordered by Unicode order, and a workaround that enables controlling the order is to use normalizing, as discussed in this forum thread and in this forum thread. ... The collation will affect the way strings are sorted in queries (with ORDER BY). Currently strings are always ordered by ...

 
forum_thread

dual access

Hello Exploring the product having had significant experience win Kodo/BEA/JDO1.x, yes I know dated but still works.  Is it possible to still have the SQL emitted from only the JAVA syntax?  If so is it also possible get each SQL statement before it is sent to the store?  Does objectdb only permit direct SQL coding? ... JDOQL and JPQL (the later is very similar to SQL). Queries can be logged before execution. ObjectDB ...

 
forum_thread

"Automatic" Auditing

Any ideas around how I could do "automatic" auditing of changes to objects? (An equivalent to Hibernate's Envers) Thanks. Michael. ... an entity object is old or new. Adjust your queries to use that field. In addition, you may be interested in ...

 
forum_thread

Acces the same DB with multiple users

I developed an application that needs 3 computers to acces the same odb file, unfortunately when I acces this file from any other computer than the one where I first generated the file (I'm using the server.exe) my queries result in nothing? Must something be changed to the config? Or should this work with no changes to the included config file? Thanks for the help, Marvin   ... first generated the file (I'm using the server.exe) my queries result in nothing? Must something be changed to the config? Or ...

 
forum_thread

Using multiple databases

Is it possible for an ObjectDB PersistenceManger/EntityManager to connect to more than one database at a time? Also, can objects in one database reference objects in another database (e.g. through globally unique identifiers)? #1 2011-08-25 10:11 Is it possible for an ObjectDB PersistenceManger/EntityManager to connect to more than one database at a time?&nb ...

 
forum_thread

Object explorer cannot open odb file. ObjectDB many-to-many relationship

I created a data model to test many-to-many relationship with a link table as following (full code in attachement) ... maintain both sides, but navigation may be faster since no queries will be required. This ability (of navigation in the to many direction with no queries) is not supported by ORM JPA implementations, so you will be leveraging ...

 
forum_thread

How to check if an entity exists in a Database without loading it?

Hi, I am trying to speed up some code - where i check if the entity exists in order to make a decision. In Java - It looks like this (pk - is the primary key of the entity): MyClass find = em.find(MyClass.class, pk); boolean exists = find != null; Is there a way to check the existence without loading the entity? Thanks   #1 2015-07-16 21:14 Hi, I am trying to speed up some code - where i check if an entity exists in order to make a decision. ...

 
forum_thread

Duplicate a table

Hello, I would like to know if it's possible to copy the content of a table representing one class of object to another table whithout having to use java object (no object instantiation) ? In fact, I would like to execute a native query like "select * into T0 from T1" My purpose is to backup a table before erasing the content. Thanks. #1 2015-11-12 13:57 Hello, I would like to know if it's possible to copy the content of a table representing one class of ...

 
issue

InternalException during producer/consumer scenario

Hi, I'm trying to use objectdb in a producer/consumer scenario. Producer threads put message objects into a table while consumer threads remove the objects based on age, priority, etc. There are 2 main motivations for using objectdb for this purpose rather than a queue or similar data structure: 1) The consumer can select the "next" object based on a range of potentially complex criteria. 2) The number of objects produced can be potentially exceed available memory so can be held on disk within the objectdb file. Bug Version: 2.2.0 Priority: Normal Status: Fixed Replies: 2 Type:  Bug ...

 
forum_thread

Selecting random rows

Hello is there way to get random rows? Functions line rand(), random(), newid() doesn't work ;/ for example: em.createQuery("SELECT s FROM StawkaVat s ORDER BY rand()").setMaxResults(5).getResultList(); gives exception: #1 2014-06-21 09:47 Hello is there way to get random rows? Functions like rand(), random(), newid() doesn't work ;/ for e ...