@NamedNativeQuery(name = "Subscription.findAllSubscriptionSummaries", // query = "select product_name as productName, count(user_id) as subscriptions from subscription group by product_name order by productName", // resultSetMapping = "subscriptionSummary"), @NamedNativeQuery(name = "Subscription.findAllSubscriptionProjections", // query = "select product_name as product, count(user_id) as usageCount from subscription group by product_name order by product") })
@Table(name = "destination_entity") @NamedNativeQueries({ @NamedNativeQuery(name = "DestinationEntity.insertSelect", query = "insert into destination_entity(id, from_id, fullNameFrom) " + " select fe.id, fe.id, fe.name||fe.lastName from from_entity fe where fe.id in (:ids)"), @NamedNativeQuery(name = "DestinationEntity.insert", query = "insert into destination_entity(id, from_id, fullNameFrom) " + "values (:generatedId, :fromId, :fullName)"), @NamedNativeQuery(name = "DestinationEntity.update", query = "update destination_entity set from_id=:idFrom, fullNameFrom=:fullName" + " where id in (:ids)"), @NamedNativeQuery(name = "DestinationEntity.delete", query = "delete from destination_entity where id in (:ids)"), @NamedNativeQuery(name = "DestinationEntity.selectIds", query = "select id, from_id, fullNameFrom from destination_entity where id in (:ids) order by id") }) public class DestinationEntity {
/** * @author Emmanuel Bernard */ @Entity @Table(name = "matchtable", schema = "matchschema") @SecondaryTable(name = "extendedMatch") @Inheritance(strategy = InheritanceType.TABLE_PER_CLASS) @NamedQueries({ @NamedQuery(name = "matchbyid", query = "select m from Match m where m.id = :id"), @NamedQuery(name = "getAllMatches2", query = "select m from Match m") }) @NamedNativeQueries({ @NamedNativeQuery(name = "matchbyid", query = "select m from Match m where m.id = :id", resultSetMapping = "matchrs"), @NamedNativeQuery(name = "getAllMatches2", query = "select m from Match m", resultSetMapping = "matchrs") }) public class Match extends Competition { public String competitor1Point; @Version public Integer version; public SocialSecurityNumber playerASSN; }
@Table(name = "domainadmin") @IdClass(DomainAdminId.class) @NamedNativeQuery(name = "DomainAdmin.testQuery", query = "select * from domainadmin da where da.domain_name = 'org'", resultClass = org.hibernate.test.annotations.idclass.DomainAdmin.class)
@Entity(name = "Game") @NamedQueries(@NamedQuery(name = "NamedQuery", query = "select g from Game g where title = ?1")) @NamedNativeQueries(@NamedNativeQuery(name = "NamedNativeQuery", query = "select * from Game g where title = ?")) public static class Game { private Long id;
@Entity @Table(name = "BOT_NUMVALUE") @NamedNativeQueries({ @NamedNativeQuery(name = "NumValue.getSomeValues", query = "{ ? = call f_test_return_cursor() }", resultClass = NumValue.class, hints = { @QueryHint(name = "org.hibernate.callable", value = "true") })
entities = @EntityResult(entityClass = org.hibernate.test.annotations.query.SpaceShip.class)) @NamedNativeQueries({ @NamedNativeQuery(name = "implicitSample", query = "select * from SpaceShip", resultSetMapping = "implicit"), @NamedNativeQuery(name = "compositekey", query = "select name, model, speed, lname as lastn, fname as firstn, length, width, length * width as surface, length * width *10 as volume from SpaceShip", resultSetMapping = "compositekey")
@NamedNativeQuery( name = "find_person_name", query = @NamedNativeQuery( name = "find_person_name_and_nickName", query = @NamedNativeQuery( name = "find_person_name_and_nickName_dto", query = @NamedNativeQuery( name = "find_person_by_name", query = @NamedNativeQuery( name = "find_person_with_phones_by_name", query =
@NamedNativeQuery( name = "find_valid_person", query = "SELECT id, name " +
@SQLDeleteAll( sql="DELETE CHAOS") @Loader(namedQuery = "chaos") @NamedNativeQuery(name="chaos", query="select id, chaos_size, name, lower( nick_name ) as nick_name from CHAOS where id= ?", resultClass = Chaos.class) public class Chaos { @Id
@Loader(namedQuery = "find_valid_person") @NamedNativeQueries({ @NamedNativeQuery( name = "find_valid_person", query = "SELECT id, name " + resultClass = Person.class ), @NamedNativeQuery( name = "find_valid_phones", query = "SELECT person_id, phones " +
@NamedNativeQuery( name = "find_person_by_bitset", query =
@NamedNativeQuery( name = "find_valid_person", query = "SELECT id, name " +
@NamedNativeQuery( name = "find_valid_person", query = "SELECT " +
@NamedNativeQuery(name = "all.dictionaries", query = "select id, name, editor, disc as \"type\" from Dictionary", resultSetMapping = "dictionary")
@NamedNativeQuery( name = "nativeItem1", query = "select name as itemname, descr as itemdescription from Item", resultSetMapping = "getItem" ), @NamedNativeQuery( name = "nativeItem2", query = "select * from Item",
@NamedNativeQuery(name = "find_all_spaceships", query = "SELECT " +
@NamedQuery(name = "test.named.queries1", query = "Select t1 from TestEntity t1 where t1.field = :field"), @NamedQuery(name = "test.named.queries2", query = "Select t2 from TestEntity t2 where t2.field = :field") }) @NamedNativeQuery(name = "test.native.query", query = "Select native from TestEntity native where native.field = :field") @NamedNativeQueries({ @NamedNativeQuery(name = "test.native.query1", query = "Select native1 from TestEntity native1 where native1.field = :field"), @NamedNativeQuery(name = "test.native.query2", query = "Select native2 from TestEntity native2 where native2.field = :field") }) public class EntitySample
@NamedQuery(name = "updateStudent", query = "update Student s set s.lastName = :lastName, s.lastUpdated = :lastUpdated where s.rollNumber in (select max(a.rollNumber) from Student a)") }) @NamedNativeQuery(resultClass = StudentDomain.class, name = "updateStudentNativeQuery", query = "update Student s set s.lastName = :lastName, lastUpdated = :lastUpdated where s.rollNumber in (select max(a.rollNumber) from Student a)") @SequenceGenerator(name = "student_sequence", initialValue = 1004, allocationSize = 1) public class StudentDomain {
@NamedQuery(name = "findByPublication", query = "Select b from Book b where b.publication = ?1"), @NamedQuery(name = "findAllBooks", query = "Select b from Book b") }) @NamedNativeQueries(value = { @NamedNativeQuery(name = "findAllBooksNative", query = "select * from " + "\"BOOK\"") }) @IndexCollection(columns = {@Index(name = "publication"), @Index(name = "author")}) @XmlRootElement