using hibernate with mysql

Question

I followed this tutorial mykong in order to use hibernate with mysql.

My problem is that when I launch the program I am getting this exception org.hibernate.TransactionException: Transaction not successfully started".

So I tried to use session.persist(Object) and session.flush() instead of session.save(Object) and session.getTransaction().commit(). Now I am not getting any exception but the object is not saved in the database. logs show the request

Hibernate: insert into stock (STOCK_CODE, STOCK_NAME) values (?, ?)

Could someone help me with this ?

            session = HibernateUtil.getSessionFactory().openSession();

        Stock stock = new Stock();

        stock.setStockCode("4715");
        stock.setStockName("GENM");

        session.persist(stock);

        session.flush();

        session.getTransaction().commit();

        session.close();

You need to commit the transaction as well. Flushing the session does not commit your data. — Ankur
– Ankur, Commented Aug 27, 2018 at 10:20
can you share where you have started the transaction and committed the transaction? — Ankur
– Ankur, Commented Aug 27, 2018 at 11:07
I added the code to my post, but as I said I followed the mykong basic tutorial. — Aymen Ragoubi
– Aymen Ragoubi, Commented Aug 27, 2018 at 11:09

Harly Hallikas · Accepted Answer · 2018-08-27 11:30:35Z

1

You're trying to commit a transaction that you haven't even started, as you're missing

session.beginTransaction();

in your code.

As per the web site above you must start a session, then start the transaction in the session, make your edits, save the edited object into session and then commit the transaction. Your flush is also causing issues, as you flush your session before even saving or committing it.

    Session session = HibernateUtil.getSessionFactory().openSession();

    session.beginTransaction();
    Stock stock = new Stock();

    stock.setStockCode("4715");
    stock.setStockName("GENM");

    session.save(stock);
    session.getTransaction().commit();

answered Aug 27, 2018 at 11:30

Harly Hallikas

6184 silver badges13 bronze badges

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

Collectives™ on Stack Overflow

using hibernate with mysql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related