About SELECT

191-200 of 200Refresh
Forum
2

JBOSS AS7 7.1.1 - Entity not persisted and createNamedQuery fire exception

",          query="select g from guest.Guest g order by g.name" ) } ) @Stateless @TransactionManagement ... );   TypedQuery query = this.em.createQuery( "select g from guest.Guest g order by g.name ... ="select g from guest.Guest g order by g.name" ) } ) ... // NamedQuery does not work // TypedQuery
Forum
2

Join performance in Objectdb

SELECT count(e) FROM Meta e, ImageNet i, Page p WHERE e.idImage=i.id AND e.idPage=p.id; So simple ... instead of direct references. A more JPA conventional variant of your query would be: SELECT count(e ... .createQuery(             "SELECT COUNT(a) FROM A a, B b, C c " +             "WHERE a.bId = b.id
JPA Doc
2

ColumnResult.name

Annotation Element javax.persistence.ColumnResult String name (Required) The name of a column in the SELECT clause of a SQL query Since: JPA 1.0
JPA Doc
2

createNamedQuery(name, resultClass)

Method javax.persistence.EntityManager TypedQuery createNamedQuery(   String name,   Class resultClass ) Create an instance of TypedQuery for executing a Java Persistence query language named query. The select list of the query must contain only a single item, which must be assignable
JPA Doc
2

createQuery(qlString, resultClass)

Method javax.persistence.EntityManager TypedQuery createQuery(   String qlString,   Class resultClass ) Create an instance of TypedQuery for executing a Java Persistence query language statement. The select list of the query must contain only a single item, which must be assignable
JPA Doc
2

EntityResult.discriminatorColumn

Annotation Element javax.persistence.EntityResult String discriminatorColumn Specifies the column name (or alias) of the column in the SELECT list that is used to determine the type of the entity instance. Default value: "" Since: JPA 1.0
JPA Doc
2

EntityResult.fields

Annotation Element javax.persistence.EntityResult FieldResult[] fields Maps the columns specified in the SELECT list of the query to the properties or fields of the entity class. Default value: {} Since: JPA 1.0
Forum
2

Error using query with MAX() function

"); Expression me = cb.max(c); CriteriaQuery s = q.select(me); Predicate predicate = cb ... to debug. [2011-05-02 21:10:36 #150 query.manager] SELECT" code="132" postion="0:6" />
JPA Doc
2

executeUpdate()

Method javax.persistence.Query int executeUpdate() Execute an update or delete statement. Returns: the number of entities updated or deleted Throws: IllegalStateException - if called for a Java Persistence query language SELECT statement or for a criteria query TransactionRequiredException
JPA Doc
2

FieldResult.column

Annotation Element javax.persistence.FieldResult String column Name of the column in the SELECT clause - i.e., column aliases, if applicable. Since: JPA 1.0