Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public Documento2 loadDocumento2ById(Long id){
- String sql = "select d.id, d.int_ano_edicao, d.int_num_romaneio, d.int_cod_lista, " +
- "bin_arquivo, id_documento from Documento2 d inner join Imagem2 i on i.id_documento = d.id " +
- "where i.id=" + id;
- Query query = this.getSession().createSQLQuery(sql).addScalar("id", Hibernate.LONG).addEntity(Documento2.class)
- .addScalar("int_ano_edicao", Hibernate.INTEGER).addScalar("int_num_romaneio",Hibernate.INTEGER)
- .addScalar("int_cod_lista", Hibernate.INTEGER).addScalar("bin_arquivo",Hibernate.BLOB)
- .addScalar("id_documento", Hibernate.LONG);
- return (Documento2) query.uniqueResult();
- }
Add Comment
Please, Sign In to add comment