Problem with Entity update with jpa/hibernate

Question

I have this entity class, called "Pagina" and I want to update the entry in the database based on the changes made to the entity. This isn't working. I get no errors, but the db is not changed.

@Entity
@Table(name = "PAGINA")
@NamedQueries({@NamedQuery(name = "Pagina.findAll", query = "SELECT p FROM Pagina p"), 
@NamedQuery(name = "Pagina.findHashByURL", query= "SELECT p.chash FROM Pagina p WHERE p.url = :url"),
@NamedQuery(name = "Pagina.findTimestampByURL", query= "SELECT p.timestamp FROM Pagina p WHERE p.url = :url"),
@NamedQuery(name = "Pagina.findByUrl", query = "SELECT p FROM Pagina p WHERE p.url = :url"),
@NamedQuery(name = "Pagina.findByProfondita", query = "SELECT p FROM Pagina p WHERE p.profondita = :profondita"),
@NamedQuery(name = "Pagina.findByIntervallo", query = "SELECT p FROM Pagina p WHERE p.intervallo = :intervallo"),
@NamedQuery(name = "Pagina.findByTimestamp", query = "SELECT p FROM Pagina p WHERE p.timestamp = :timestamp"), 
@NamedQuery(name="Pagina.findAllURL", query="SELECT p.url FROM Pagina p"),
@NamedQuery(name="Pagina.findDelayByURL", query="SELECT p.intervallo FROM Pagina p WHERE p.url = :url"),
@NamedQuery(name = "Pagina.findByUpdated", query = "SELECT p FROM Pagina p WHERE p.updated = :updated")})
public class Pagina implements Serializable, Delayed{
    private static final long serialVersionUID = 1L;
    @Id
    @Basic(optional = false)
    @Column(name = "URL")
    private String url;
    @Column(name = "PROFONDITA")
    private Integer profondita;
    @Column(name = "INTERVALLO")
    private Integer intervallo;
    @Lob
    @Column(name = "CHASH")
    private String chash;
    @Column(name = "TIMESTAMP")
    private Integer timestamp;
    @Column(name = "UPDATED")
    private Boolean updated;


[cut]

In another class I retrieve the objects stored in the database (mysql) using a methods defined in a class that contains methods that work on the entity. This method use the query "findAll". The method's code is the following:

public List<Pagina> findAll(){
EntityManagerFactory emf = javax.persistence.Persistence.createEntityManagerFactory("CrawlerPU");
        EntityManager em = emf.createEntityManager();  
List o = (List) em.createNamedQuery("Pagina.findAll").getResultList();
        return o;
    }

I'm using this method as you can see in the code:

 PaginaMethods p = new PaginaMethods();

        List<Pagina> l = p.findAll();
   while (it.hasNext()) {
            Pagina s = (Pagina) it.next();
            s.setUpdated(Boolean.TRUE);

If I watch the db, nothing has changed after this operations. My persistence.xml has the entry " " Can you help me? I don't know how to solve this... I can change things if needed.

i have the same problem with you, can i know how you solved your problem please. thank you — Youcef LAIDANI
– Youcef LAIDANI, Commented Oct 22, 2016 at 17:32

Aaron Digulla · Accepted Answer · 2009-08-25 15:29:05Z

8

Think of Hibernate as a big cache that can use a DB as a "store" where it puts things that don't fit into the cache anymore. Hibernate will not flush everything to the DB as you change it, it will wait. Chances are that you might change more than a single field in an object.

So you need to flush the session (em.flush()), or you must run a query, or you must commit the current transaction (not an easy option when using Spring).

answered Aug 25, 2009 at 15:29

Aaron Digulla

330k111 gold badges626 silver badges840 bronze badges

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

1 Comment

Michael Wiles Over a year ago

hibernate tries to limit the amount of times it sends stuff to the database - it employs transparent persistence.

Rob H · Accepted Answer · 2009-08-25 15:28:45Z

0

Changes are not flushed to the database immediately when you set the value of a property. It happens at the time the transaction is committed (or earlier in some cases). Try committing the transaction and then check the database.

answered Aug 25, 2009 at 15:28

Rob H

15.1k8 gold badges45 silver badges46 bronze badges

Collectives™ on Stack Overflow

Problem with Entity update with jpa/hibernate

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related