About SELECT

191-200 of 200Refresh
JPA Doc
2

getSingleResult()

Method javax.persistence.TypedQuery X getSingleResult() Execute a SELECT query that returns a single result. Returns: the result Throws: NoResultException - if there is no result NonUniqueResultException - if more than one result IllegalStateException - if called for a Java Persistence query
Forum
2

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 ... should be rewritten as follows: select f from Foo f join f.bars b where b.name = ?1 More details ... (             "select count(f) from Foo f where f.bars.name = :name");         query.setParameter("name", "aaa
JPA Doc
2

javax.persistence.TupleElement

javax.persistence Interface TupleElement Subinterfaces: CollectionJoin, CompoundSelection, Case, Coalesce, In, SimpleCase, Expression, From, Join, ListJoin, MapJoin, ParameterExpression, Path, PluralJoin, Predicate, Root, Selection, SetJoin, Subquery The TupleElement interface defines an element
Forum
2

Possible issue with timestamps

Hi, If I query doing something like: select c from CDI c where c.creationDate > {ts '2012-03-29 11 ... . All other hours seem to be fine. Thankfully if I do: select c from CDI c where c.creationDate > :startDate and c ... ().commit();              TypedQuery query = em.createQuery("SELECT count(c) FROM CDI c", Long
Forum
2

query on calendar class

=em.createQuery("SELECT c FROM Cdr c where c.start.DAY_OF_WEEK = ?1",Cdr.class); query.setParameter ... .createQuery("SELECT c FROM Cdr c where c.start > {t '23:00:00'}", Cdr.class); But it throws: Exception in thread "AWT-EventQueue-0" [ObjectDB 2.5.6_02] SELECT c FROM Cdr c where c.answered
JDO Doc
2

Query.SQL

to the PersistenceManager.newQuery(String,Object) method should be a String containing a SQL SELECT statement. Since: JDO 2.0
JPA Doc
2

setLockMode(lockMode)

Method javax.persistence.Query Query setLockMode(   LockModeType lockMode ) Set the lock mode type to be used for the query execution. Parameters: lockMode - lock mode Returns: the same query instance Throws: IllegalStateException - if the query is found not to be a Java Persistence query language SELECT query or a Criteria API query Since: JPA 2.0
JPA Doc
2

setLockMode(lockMode)

query language SELECT query or a Criteria API query Since: JPA 2.0
JPA Doc
2

javax.persistence.NamedQuery

="findAllCustomersWithName", query="SELECT c FROM Customer c WHERE c.name LIKE :custName
JDO Doc
2

javax.jdo.Query

should be a String containing a SQL SELECT statement. Since: JDO 2.0   void addExtension(String key