About JOIN

issue

JDOQL Subqueries (JDO 2.1)

Subqueries (or nested queries) have been added to the JDOQL (JDO Query Language) in version 2.1 of JDO. This is currently the main feature that of JDO 2.0-2.1-2.2 that is still missing in ObjectDB 2. JDO Feature Version: Priority: Low Status: Active Replies: 0 Type:  JDO Feature ...

 
forum_thread

Null enums and IS (NOT) NULL: NullPointerException

Hello. I'm getting NullPointerException when adding %enum field% IS (NOT) NULL or == (!=) NULL in WHERE clause. The same exception using CriteriaQuery. #1 2014-05-01 23:25 Hello. I'm getting NullPointerException when adding %enum field% IS (NOT) NULL or == (!=) NULL in WHE ...

 
issue

Compare two schemas or odb files

For example, if we make a backup of our database it would be helpful to have the possibility to compare the backup schema (odb file) with the current version in the database and as result we should get the difference between the two schemas. It would also be sufficient, if we can compare object graphs stored in the db with old graphs from backup db. Feature Request Version: Priority: Normal Status: Active Replies: 0 Type:  Feature Request ...

 
forum_thread

adding tutorial videos to youtube

Hello , it will be good for you to add video tutorials for objectdb and explorer on youtube. #1 2013-02-02 22:45 Hello , it will be good for you to add video tutorials for objectdb and explorer on youtube. ...

 
manual

WHERE clause (JPQL / Criteria API)

Explains how to use the WHERE clause in a JPQL query.... languages: SELECT c , l FROM Country c JOIN c . languages l WHERE c . population > :p AND l IN ...

 
issue

Support for roles/groups in ObjectDB

ObjectDB should incorporate roles/group in ObjectDB config file? I see no support for this. I would like to place several users under a given group or role, but I see no way of doing this as no such element is present  in the config file. Maybe under the $default, or any particular user, there could be a role/group element which would categorise the user further. This would help in authentication.   Thanks Feature Request Version: 2.3.3 Priority: Normal Status: Active Replies: 0 Type:  Feature Request ...

 
api-jpa

JoinTable.joinColumns

(Optional) The foreign key columns of the join table which reference the primary table of the entity owning the association.(Annotation Element of javax.persistence.JoinTable)

 
api-jpa

MapKeyJoinColumns.value

(Required) The map key join columns that are used to map to the entity that is the map key.(Annotation Element of javax.persistence.MapKeyJoinColumns)

 
issue

@FetchGroup in JPA similar to JDO

I was checking what's new in different JPA implementation on the market and found quite interesting two features. First of those features is described in this ticket. It's similar to FetchGroup from JDO. It works like this. First you specify attributes to fetch from database: Feature Request Version: Priority: Normal Status: Active Replies: 0 Type:  Feature Request ...

 
issue

Allow removal of entity class from ObjectDB & Explorer

Hi. It would be very useful to be able to delete an entire entity class from ObjectDB, but especially from Explorer. This is very useful for everyone, but also for clients that don't own a license, thus they're limited to 10 entities / db. During the life time of a software, many changes appear to its data structure. When an entity class becomes unnecessary, we should be able to remove it, thus to get space for another one. Feature Request Version: 2.5.2 Priority: High Status: Active Replies: 0 Type:  Feature Request ...