1

How can a use primary key in hibernate from a Postgres sequence? I need the primary be autogenerated, and them how i can get the sequence value for use in Hibernate

this is my code

Mapped class

import java.io.Serializable;
import java.util.Date;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.SequenceGenerator;
import javax.persistence.Table;
import javax.persistence.Temporal;

@Entity
@Table(name="ensaio")
public class Ensaio implements Serializable {

  @Id
  @GeneratedValue(strategy=GenerationType.SEQUENCE, generator="ensaio_seq")
  @SequenceGenerator(name="ensaio_seq", sequenceName="ensaio_seq")
  @Column(name="ensaio_id")
  private long id;
  private String nome;
  @Column(nullable=false)
  private String modelo;
  private String site;
  @Temporal(javax.persistence.TemporalType.DATE)
  private Date datadoensaio;
  private int qtdeFotos;
  private String fotografo;

  getter and setters...
}

My DAO:

import java.util.List;
import model.Ensaio;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import util.hibernate.HibernateUtil;

public class HEnsaioDAO {

  private Session session;
  private SessionFactory sessionFactory = HibernateUtil.getSessionFactory();

  public HEnsaioDAO() {
    session = sessionFactory.openSession();
  }

  public List<Ensaio> findAll(){
    Query query = session.createQuery("from Ensaio");
    return query.list();
  }

  public void insertEnsaio(Ensaio ensaio){
    session.save(ensaio);
  }

  //testing insertion
  public static void main(String[] args) {
    Ensaio e = new Ensaio();
    e.setModelo("Roberta Maria");
    e.setSite("dsestudio");
    e.setFotografo("Jose Sobrero");
    e.setNome("Dama das camelias");

    HEnsaioDAO dao = new HEnsaioDAO();

    dao.insertEnsaio(e);


    List<Ensaio> list = dao.findAll();
    for (Ensaio ensaio : list) {
      System.out.println(ensaio.getModelo());
      System.out.println(ensaio.getNome());
      System.out.println(ensaio.getFotografo());
    }
  }

}

Nothing happens in database (Postgres 8.3). What wrong? Thanks

1
  • the problem was solved using hibernate.hbm2ddl.auto property as update Commented Mar 31, 2011 at 1:00

1 Answer 1

3

You define a generator of type sequence for your id.

Hibernate will handle the id assignation for you.

More info on ids and generators can be found here

Sign up to request clarification or add additional context in comments.

1 Comment

@ulima69 what doesn't work? what is the obtained result? what is the expected result? help me help you :)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.