@OneToMany(targetEntity = Player.class, mappedBy = "team", fetch = FetchType.EAGER) @Fetch(FetchMode.SELECT) @Loader(namedQuery = "loadByTeam") public Set<Player> getPlayers() { return players; }
collection.setLoaderName( loader.namedQuery() );
persistentClass.setLoaderName( loader.namedQuery() );
persistentClass.setLoaderName( loader.namedQuery() );
@Entity(name = "Person") @Loader(namedQuery = "invalid_sql") @NamedQuery( name = "invalid_sql",
collection.setLoaderName( loader.namedQuery() );
@Entity(name = "CardWithCustomSQL") @Persister( impl = SingleTableEntityPersister.class ) @Loader(namedQuery = "find_foo_by_id") @NamedNativeQuery( name = "find_foo_by_id", query = "SELECT id, name FROM {h-schema}FOO WHERE id = ?", resultClass = CustomEntity.class ) @SQLInsert(sql = "INSERT INTO {h-schema}FOO (name, id) VALUES (?, ?)") @SQLDelete(sql = "DELETE FROM {h-schema}FOO WHERE id = ?", check = ResultCheckStyle.COUNT) @SQLUpdate(sql = "UPDATE {h-schema}FOO SET name = ? WHERE id = ? ") public static class CustomEntity { @Id public Integer id; private String name; }
persistentClass.setLoaderName( loader.namedQuery() );
@Loader(namedQuery = "find_valid_person") @NamedNativeQueries({ @NamedNativeQuery(
persistentClass.setLoaderName( loader.namedQuery() );
@SQLDelete( sql="DELETE CHAOS WHERE id = ?") @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 {
collection.setLoaderName( loader.namedQuery() );
@SQLDelete( sql = "UPDATE person SET valid = false WHERE id = ? ") @Loader(namedQuery = "find_valid_person") @NamedNativeQueries({ @NamedNativeQuery( @SQLDeleteAll( sql = "UPDATE person_phones SET valid = false WHERE person_id = ?") @Loader(namedQuery = "find_valid_phones") private List<String> phones = new ArrayList<>();
collection.setLoaderName( loader.namedQuery() );
sql = "UPDATE person SET valid = false WHERE id = ? " @Loader(namedQuery = "find_valid_person") @NamedNativeQueries({ @NamedNativeQuery(
collection.setLoaderName( loader.namedQuery() );
@Loader(namedQuery = "find_valid_person") @NamedNativeQueries({ @NamedNativeQuery(
persistentClass.setLoaderName( loader.namedQuery() );
@Entity(name = "Tag") @Table(name = "tag") @SQLDelete(sql = "UPDATE tag " + "SET deleted = true " + "WHERE id = ?") @Loader(namedQuery = "findTagById") @NamedQuery(name = "findTagById", query = "select t " + "from Tag t " + "where " + " t.id = ?1 and " + " t.deleted = false") @Where(clause = "deleted = false") public static class Tag extends BaseEntity { @Id private String id; public String getId() { return id; } public void setId(String id) { this.id = id; } }
@Entity(name = "Tag") @Table(name = "tag") @SQLDelete(sql = "UPDATE tag " + "SET deleted = true " + "WHERE id = ? and version = ?") @Loader(namedQuery = "findTagById") @NamedQuery(name = "findTagById", query = "SELECT t " + "FROM Tag t " + "WHERE " + " t.id = ?1 AND " + " t.deleted = false") @Where(clause = "deleted = false") public static class Tag extends BaseEntity { @Id private String id; @Version private int version; public String getId() { return id; } public void setId(String id) { this.id = id; } }