Eclipse Plugin Central :: View topic - Can retrieve, but not update, commit the Transaction

Eclipse Plugin Central

Hibernate Synchronizer - Can retrieve, but not update, commit the Transaction

frankiestd168 - Nov 14, 2006 - 05:46 PM
Post subject: Can retrieve, but not update, commit the Transaction

sorry for this basic question...
I tried to test the following sample code...

Code:

_RootDAO.initialize();
PersonDAO dao = new PersonDAO();
List people = dao.findAll();

Yes, I can successfully retrieve people List from MySQL table.

For save/update..

Code:

Long id = new Long(3);
Person person = dao.load(id);
person.setFirstName("Joe");
dao.update(person);

but Update/Save is not working. MySQL table is not updated.

How can I commit the update/save ?

I tried to add this code to commit,

Code:

Transaction tx = dao.beginTransaction(dao.getSession());
// the above code
tx.commit();

but it throws org.hibernate.TransactionException: Transaction not successfully started.

If I set autocommit to true in cfg.xml , then it works.
<property name="hibernate.connection.autocommit">true</property>
but i want to control in the code level..

Can anybody pls help... pls

frankiestd168 - Nov 14, 2006 - 06:39 PM
Post subject:

Code:

_RootDAO.initialize();
PersonDAO dao = new PersonDAO();
Transaction tx = dao.beginTransaction(dao.getSession());
//..
// my update code
//..
dao.commitTransaction(tx);

i also try this .. but still.. i got exception..
org.hibernate.TransactionException: Transaction not successfully started

How to start the transaction correctly?

frankiestd168 - Nov 16, 2006 - 11:28 AM
Post subject:

ok, finally I fixed it.. it works for me..

_RootDAO.initialize();
MyfirstDAO dao = new MyfirstDAO();
Myfirst newperson = new Myfirst();
Transaction tx = dao.beginTransaction(dao.getSession());

newperson.setAddress("aaa");
newperson.setName("bbb");
dao.saveOrUpdate(newperson, dao.getSession());

tx.commit();

chamarts - Nov 07, 2007 - 04:08 AM
Post subject:

Hi, I am able to save & update it but I am getting error when I query for findAll. Can anybdy help me with this ?

This is how my code is:

_RootDAO.initialize(config/hibernate-cfg.xml);
List myList = MyDAO.findAll();

and the exception is

org.hibernate.HibernateException: createCriteria is not valid without active transaction
at org.hibernate.context.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:297)
at $Proxy0.createCriteria(Unknown Source)
at com.oakton.gsti.lam.dao.base._BaseRootDAO.findAll(_BaseRootDAO.java:315)
at

chamarts - Nov 07, 2007 - 11:49 PM
Post subject:

is it not supposed to be handled by the generated code ? or do I need to supply explicitly ? then, why was it supplied in update and save ? Sad