@OneToMany(targetEntity = Player.class, mappedBy = "team", fetch = FetchType.EAGER) @Fetch(FetchMode.SELECT) @Loader(namedQuery = "loadByTeam") public Set<Player> getPlayers() { return players; }
@Entity(name = "Person") @Loader(namedQuery = "invalid_sql") @NamedQuery( name = "invalid_sql",
@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; }
@Loader(namedQuery = "find_valid_person") @NamedNativeQueries({ @NamedNativeQuery(
@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 {
@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<>();
sql = "UPDATE person SET valid = false WHERE id = ? " @Loader(namedQuery = "find_valid_person") @NamedNativeQueries({ @NamedNativeQuery(
@Loader(namedQuery = "find_valid_person") @NamedNativeQueries({ @NamedNativeQuery(
@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; } }
"SET deleted = true " + "WHERE id = ?") @Loader(namedQuery = "findPostCommentById") @NamedQuery(name = "findPostCommentById", query = "select pc " +
"SET deleted = true " + "WHERE id = ?") @Loader(namedQuery = "findPostDetailsById") @NamedQuery(name = "findPostDetailsById", query = "select pd " +
"SET deleted = true " + "WHERE id = ?1") @Loader(namedQuery = "findPostById") @NamedQuery(name = "findPostById", query = "select p " +
callable = true @Loader(namedQuery = "find_valid_person") @NamedNativeQueries({ @NamedNativeQuery(