About named queries

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

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 ...

 
issue

Index Rebuilder

When a new index is added to an existing entity classes that already has instances in the database, it cannot be used in queries, because it starts empty and it is not synchronized with the existing primary data. The Index Rebuilder tool will enable rebuilding indexes, synchronizing their data to the primary data. As a workaround, you can currently use the ObjectDB Doctor to build a new database file, in which such new indexes will be enabled.... has instances in the database, it cannot be used in queries, because it starts empty and unsynchronized with the existing primary ...

 
forum_thread

ObjectDB version 2.1 has been released

Version 2.1 has been released: ... ( issue #31 ). Fixed a bug in distinct queries (duplicates due to bad optimization). Fixed a bug 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 ...

 
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

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 ...

 
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

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

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 ...