About WHERE

forum_thread

Composite indexes

Hi, I read your manual about defining Indexes for JPA Entities (http://www.objectdb.com/java/jpa/entity/index), but I still have some problems understanding how and when should I use them.   Let's start with some example then. Assume we have an entity that represents an interior design image, called Inspiration : ... index should be a field that is most commonly used in WHERE clauses or maybe the filed that is used in ORDER clause for query that ... to this : SELECT i FROM Inspiration i WHERE i . room = "bedroom" AND 4 MEMBER OF i . ...

 
api-jpa

javax.persistence.criteria.From

Represents a bound type, usually an entity that appears in the from clause, but may also be an embeddable belonging to an entity in the from clause.(Interface of JPA)

 
issue

Issue with TYPE expression in Criteria API

Find attached project using latest 2.3.4_03 odb still causes:   ... SELECT $1 FROM com.test.virtual.model.MyCustomer $1 WHERE TYPE($1)=class com.test.model.Customer Exception in thread "main" ... cq. select ( e ) ; cq. where ( cb. equal ( e. type ( ) , cb. literal ...

 
issue

Weird issue with variable naming

hi, ... $1. We're also adding a custom function expression in where clause though however as said, cannot replicate it in a demo, however ... ( "name" ) ) ;   cq. where ( cb. equal ( join2. get ( "name" ) , ...

 
api-jpa

javax.persistence.criteria.PluralJoin

The PluralJoin interface defines functionality that is common to joins to all collection types.(Interface of JPA)

 
issue

JPQL support for Maps (JPA 2.0)

JPQL 2.0 introduces the ability define FROM variables for map keys and values. Currently ObjectDB supports FROM variables for collection elements and FROM variables for map keys and values are expected to be supported in future versions. ... Query : "SELECT s FROM Session s JOIN s.data d WHERE VALUE(d) = :value" Object : public class Session ... SELECT s FROM Session s JOIN s . DATA d WHERE d = :value ObjectDB Support ObjectDB ...

 
forum_thread

ObjectDb Supports Clustering of Servers?

Hi,     I am new to ObjectDb. we have a scenario where we deploy the same application in more than one linux (Jobss) servers. In this case user request can go to any server depends on the availability of the servers (This is for load balancing ). As of now we are using Oracle + Hibernate + JPA , as Oracle is shared data there was no problem. ... I am new to ObjectDb. we have a scenario where we deploy the same application in more than one linux (Jobss) servers. ... when i retrieve objects from my local DB it was too fast where as it is taking so much time to connect Linux Object DB. So I ...

 
api-jpa

javax.persistence.criteria.Join

A join to an entity, embeddable, or basic type.(Interface of JPA)

 
issue

Issues with JDO Casting & Full Qualified Names

hi! See this query and the comments about failures. This is really urgent for us because as you've stated, this is the only workaround for now to proper casting AND map KEY access though it isn't working correctly either.. ... HERE query = "SELECT COUNT(e) FROM MyEntity e WHERE ((com.test.F328.EmbeddedB)e.embeddeds.get('test2')).superB = '123'" ; ... "SELECT COUNT(e) FROM MyEntity e " + "WHERE ((com.test.EmbeddedB)e.embeddeds.get('test2')).superB = '123' " ; ...

 
forum_thread

Problem with Criteria Querys

Hi, i am having problems running following code...   ... parameter ( Double. class ) ; q. where ( cb. and ( cb. gt ( d. get ( ... = d. get ( "lon" ) ; q. where ( cb. and ( cb. gt ( lon, ...