About @Query

forum_thread

Entity has be persistended,but query not fetched?

I create a new entity T newT and persistend it,then I create a query "select t from T t" to fetch all T entities.But  then the newT is not contain in the query result. Why? #1 2011-04-24 01:51 I create a new entity T newT and persistend it,then I create a query "select t from T t" to fetch all T entities. ...

 
api-jdo

addSubquery(sub, variableDeclaration, candidateCollectionExpression, parameters)

Add a subquery to this query.(Method of javax.jdo.Query)

 
release

2.3.1

Release date: 2011-10-02 Download (5.48 MB) Binary:  objectdb-2.3.1.zip You should start by following a  tutorial or reading the manual ...

 
release

2.3.2

Release date: 2011-10-25 Download (5.48 MB) Binary:  objectdb-2.3.2.zip You should start by following a  tutorial or reading the manual ...

 
api-jpa

getSingleResult()

Execute a SELECT query that returns a single untyped result.(Method of javax.persistence.Query)

 
api-jdo

javax.jdo.annotations.Query

Annotation for a named query.(Annotation of JDO)

 
forum_thread

Help with JPA2 Criteria and conditional operator grouping

Hi,   I'm getting a little trouble performing a query as per the way I had it set up on eclipselink. Essentially, the query I'm trying to generate is: SELECT $1 FROM Company $1 WHERE (($1.companyId=:p1) AND ($1.conditionOne=true)) AND (($1.conditionTwo=false) OR ($1.conditionThree=false))   From the JPA2 criteria: #1 2011-07-13 13:51 Hi,   I'm getting a little trouble performing a query as per the way I had it set up on eclipsel ...

 
forum_thread

How to convert a boolean to an int in the query?

How to convert a boolean to an int in the query? I have five parameters of type boolean in the entity object - approveEmail, approvePhoneNumper, ... I can not sort them ORDER BY approveEmail, approvePhoneNumper, .... because the parameters equivalent. I want to sort them in the query by their sum ORDER BY (approveEmail + approvePhoneNumper + ... ) But I get an exception com.objectdb.o._PersistenceException: Invalid operand type boolean for operator + #1 2013-08-27 12:52 How to convert a boolean to an int in the query? I have five parameters of type boolean in the entity object ...

 
forum_thread

slow performance for a complex query

Hi, We have a query that is constructed dynamically, an example is like this: SELECT DISTINCT $1 FROM CDI $1, Organisation $2, Organisation $3 WHERE ((UPPER($1.cdiId) LIKE 'THREAD14%') AND ((($1.parentOrgId='news') OR (($1.parentOrgId=$2.organisationId) AND ($2.parentOrgId='news'))) OR ((($1.parentOrgId=$3.organisationId) AND ($3.parentOrgId=$2.organisationId)) AND ($2.parentOrgId='news')))) I've also tried running the CDI query first and passing the results into the organisation query as follows: #1 2012-02-16 09:16 Hi, We have a query that is constructed dynamically, an example is like this: SELECT DISTINC ...

 
issue

Error 990 when querying a class with persistence-capable-superclass

[ObjectDB 2.4.7_07] Unexpected exception (Error 990) Generated by Java HotSpot(TM) Server VM 1.7.0_10 (on Linux 3.2.0-39-generic-pae). Please report this error on http://www.objectdb.com/database/issue/new com.objectdb.o.InternalException: null com.objectdb.o.InternalException at com.objectdb.o.InternalException.f(InternalException.java:236) at com.objectdb.o.STA.K(STA.java:339) at com.objectdb.o.ENT.D(ENT.java:533) at com.objectdb.o.ENT.M(ENT.java:681) at com.objectdb.o.LDR.F(LDR.java:589) at com.objectdb.o.LDR.E(LDR.java:466) Bug Version: 2.5.4 Priority: Normal Status: Active Replies: 8 Type:  Bug ...