About @Query

forum_thread

how to query by properties of onetomany relations? (Error 990)

the following code fails em.createQuery("select f from Foo f where f.bars.name = ?1", Foo.class).setParameter(1, barName) stacktrace: #1 2011-05-10 21:39 the following code fails em. createQuery ( "select f from Foo f where f.bars.name = ?1" , Foo. ...

 
forum_thread

Query results are not up to date for entities, not primitives

When using the CriteriaBuilder to query, the retrieved list are not refreshed according to the latest updates. But, when using the JPQL Query, the list are refreshed. What is the problem? #1 2014-09-27 17:42 When using the CriteriaBuilder to query, the loaded list are not refreshed according to the latest updates. B ...

 
release

2.4.5

Release date: 2012-12-13 Download (5.41 MB) Binary:  objectdb-2.4.5.zip You should start by following a  tutorial or reading the manual ...

 
forum_thread

Query vs Extent for retrieving data

I'm running into a problem where data that is retrieved via a Query comes out null, but when I retrieve it using an Extent everything is present. We have a very simple class: public class PositionReportManagerBean implements InstanceCallbacks { private int maxReports; private List<PositionReportBean> reports; } I have a test file with 5 instances of PositionReportManagerBean, each with maxReports set to 10 and 5 PositionReportBeans in reports. I can verify with the ObjectDB explorer that all of the data is there. If I call #1 2011-12-13 23:17 I'm running into a problem where data that is retrieved via a Query comes out null, but when I retrieve it us ...

 
forum_thread

Join query problem with new statetment

Hi, I'm trying to implement some reporting logic in my application and got nasty exception when using query with join. The query code is: #1 2011-07-04 19:40 Hi, I'm trying to implement some reporting logic in my application and got nasty exception when using ...

 
issue

Once served to JSF page via @EJB query bean, many list fields are null (but same query ok after fresh persist in @PostConstruct)

I have marked this as CRITICAL because although there probably is no database integrity problem, the inability to robustly query relationship fields in a web application renders the ObjectDB system seemingly useless. objectdb-2.2.5_10 NetbeansIDE6.9.1 Glassfish3.01 client-server mode. odb file written to db-files/greendesk/greendesk.odb (see persistence.xml), copy of odb output attached. Bug Version: 2.2.5 Priority: Normal Status: Closed Replies: 19 Type:  Bug ...

 
release

2.4.3

Release date: 2012-08-26 Download (5.4 MB) Binary:  objectdb-2.4.3.zip You should start by following a  tutorial or reading the manual ...

 
release

2.4.2

Release date: 2012-07-22 Download (5.4 MB) Binary:  objectdb-2.4.2.zip You should start by following a  tutorial or reading the manual ...

 
release

2.4.1

Release date: 2012-06-16 Download (5.4 MB) Binary:  objectdb-2.4.1.zip You should start by following a  tutorial or reading the manual ...

 
release

2.4.4

Release date: 2012-10-13 Download (5.4 MB) Binary:  objectdb-2.4.4.zip You should start by following a  tutorial or reading the manual ...