Guest User

Untitled

a guest
Feb 21st, 2018
98
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.74 KB | None | 0 0
  1. public Documento2 loadDocumento2ById(Long id){
  2. String sql = "select d.id, d.int_ano_edicao, d.int_num_romaneio, d.int_cod_lista, " +
  3. "bin_arquivo, id_documento from Documento2 d inner join Imagem2 i on i.id_documento = d.id " +
  4. "where i.id=" + id;
  5.  
  6. Query query = this.getSession().createSQLQuery(sql).addScalar("id", Hibernate.LONG).addEntity(Documento2.class)
  7. .addScalar("int_ano_edicao", Hibernate.INTEGER).addScalar("int_num_romaneio",Hibernate.INTEGER)
  8. .addScalar("int_cod_lista", Hibernate.INTEGER).addScalar("bin_arquivo",Hibernate.BLOB)
  9. .addScalar("id_documento", Hibernate.LONG);
  10. return (Documento2) query.uniqueResult();
  11. }
Add Comment
Please, Sign In to add comment