About WHERE

api-jdo

Key.mappedBy

Name of a member in the value class where this key is stored.(Annotation Element of javax.jdo.annotations.Key)

 
forum_thread

String Contains Query Result - Possible?

Hi, I have a managed database for an Entity, "Program", filled with String fields, "description", that are effectively unique sub-strings of a system generated description. Example: System: For Series Sales usage: 6014-Private Individual Swim Lessons  10-Pack Database: 6014-Private Individual Swim Lessons  10-Pack I would like to know if it is possible to have a query return the "Program" object using the System Description? I've considered doing something similar to... ... similar to... SELECT FROM Program WHERE description LIKE " [something] " ...but, this ... use JPQL Locate : SELECT FROM Program WHERE LOCATE ( " [something] " , description ) > ...

 
forum_thread

Eclipse - Maven - Dependencies not getting automatically reflected

I have installed Java 1.7 Eclipse Juno From Eclipse Market place have installed - Maven Integration for Eclipse WTP (a.k.a m2e-wtp), m2e-apt, Spring IDE, The Spring Tool Suite™ (STS) Have defined M2_HOME as directory where Maven is installed. PATH updated as %M2_HOME%/bin I am working on Windows XP. ... (STS) Have defined M2_HOME as directory where Maven is installed. PATH updated as %M2_HOME%/bin I am ... required jars. I am working on my home computer where I don't have any proxies and has set following in local m2 ...

 
api-jpa

get(attributeName)

Create a path corresponding to the referenced attribute.(Method of javax.persistence.criteria.Path)

 
api-jdo

Value.mappedBy

Name of a member in the key class where this value is stored.(Annotation Element of javax.jdo.annotations.Value)

 
api-jpa

javax.persistence.criteria.Path

Represents a simple or compound attribute path from a bound type or collection, and is a "primitive" expression.(Interface of JPA)

 
forum_thread

Query fails with numerical values > 2^31

Hi ! I'm trying to execute the following query (from Java-code, also tried ObjectDB Explorer) delete from DataRecord p where p.TimeOfDeletion < 4147483648 This fails with "invalid numerical literal". The field p.TimeOfDeletion is of type long. As far as I know, the maximum value greater than 2^31 (Oracle: "The long data type is a 64-bit two's complement integer.") ... Explorer) DELETE FROM DataRecord p WHERE p . TimeOfDeletion < 4147483648 This fails with ... "Thread-2" [ObjectDB 2.5.6_05] DELETE FROM DataRecord c WHERE c.TimeOfDeletion > ==> 1410521635503 ...

 
forum_thread

JPA CriteriaQuery -- Iterate Expression<List<Object>>

Hi, I am new to  JPA and in particular the CriteriaQuery API. I have a simple CriteriaQuery where I pattern match a simple search String against field entires in a Person entity... i.e. the searchString is always decorated with %searchString%.  The Person object can contain many Record objects. I would like to update my query below to include a similar 'like' pattern match for each applicable field (String) of each element of the List of Records (see pseudo code).  ... the CriteriaQuery API. I have a simple CriteriaQuery where I pattern match a simple search String against field entires in a Person ... ( "status" ) ;   criteriaQuery. where ( builder. or ( builder. like ( ...

 
issue

javax.servlet.ServletException: Annotated methods must follow the JavaBeans naming convention. __odbHidden_getPropertyName

NB: the following issue only happens with ObjectDB, it does not happen with EclipseLink.  Glassfish3.0.1 objectdb-2.2.5_10 JavaEE6 web app The error reports as: javax.servlet.ServletException: Annotated methods must follow the JavaBeans naming convention. __odbHidden_getWidthPxSideBarLeft Where getWidthPxSideBarLeft() is an annotated getter of an entity ViewConfiguration: ... convention. __odbHidden_getWidthPxSideBarLeft Where getWidthPxSideBarLeft() is an annotated getter of an entity ... Where ViewConfigurationManager is a @SessionScoped @ManagedBean backing bean ...

 
forum_thread

Pessimistic Lock Timeouts setting

Hi,   I realise that JPA2 doesn't necessarily define a standard API way for Lock Timeouts. However, there is a standardised query 'hint' that can be setup to make the underlying DB lock a record for a specific time. The hint property is: "javax.persistence.lock.timeout" ... I have a situation where multiple threads can hit a shared counter (which is used to track ... impact all threads.   My situation is where many clients from 1 company are accessing the same counter when bulk ...