About SELECT

191-200 of 200Refresh
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
JPA Doc
2

javax.persistence.SqlResultSetMapping

javax.persistence Annotation SqlResultSetMapping Target: Classes Specifies the mapping of the result of a native SQL query. Example: Query q = em.createNativeQuery( "SELECT o.id AS order_id, " + "o.quantity AS order_quantity, " + "o.item AS order_item
Forum
2

em.flush(); em.clear(); loosing data and not persisting managed objects

="SELECT MAX($1.addDate) FROM Notes $1 WHERE $1.addDate IS NOT NULL" args="null" transactionId="-1" /> [2011-05-05 22:28:02 #133 query.tokenizer]