I really need an answer : Could we / Should we manage our hibernate Transaction in ZK

answered 2009-03-06 15:35:28 +0800

terrytornado
9393 ● 3 ● 7 ● 16
http://www.oxitec.de/

updated 2009-03-06 15:41:38 +0800

Hi Steve,

i use zk with spring + hibernate in the backend. At time against a PostgreSQL.

The backend is a separate Eclipse project and have nothing todo with zk.
So at time i don't know what your problem is. I mean you should not mix
you database layer with zkoss.
-----------------------------------------------------------------

We have a helperclass and additionally all the transaction stuff is done by
spring by a aop configuration. So i have nothing more todo with the transaction.

It's to big to posted all here. So send me your email address at sge(at)forsthaus(dot)de.
I will send you my backend test package. So you can look at the code yourself. Please write
here for the others if you found a solution .

Whises
Stephan

PS: help to prevent the global warming by writing cool software.

answered 2009-03-06 16:00:10 +0800

terrytornado
9393 ● 3 ● 7 ● 16
http://www.oxitec.de/

OK Steve,

i don't use a special zkClass for hibernate. So i have no idea what goes wrong.

Can you explain with some code how is the workflow for a typically access in your webApp.

Stephan

answered 2009-03-06 19:41:43 +0800

terrytornado
9393 ● 3 ● 7 ● 16
http://www.oxitec.de/

updated 2009-03-06 20:00:11 +0800

hmmm Steve,

your code

public class HeuresEffectueesRowRenderer implements RowRenderer {
            public void render ( Row row, Object data ){
               //if i access repondant then i can't save-update a new HeuresEffectuees.
               new Label(((HeuresEffectuees)data).getRepondant().getNom()).setParent(row);
               new Label(((HeuresEffectuees)data).getNbHeuresEffectuees().toString()).setParent(row);               
               new Label("").setParent(row);
            }
         }

It's exactly what i have written above what happens to the structure of your relation!
Let have a look on this thread. Ups, i see this was an other user. But okay let's go on.

      new Label(((HeuresEffectuees)data).getRepondant().getNom()).setParent(row);
      
      HeuresEffectuees (bean/getter/setter)
         private long id
         private string dummy
         private Set Repondant
         ...

                Repondant (bean/getter/setter)
                   private long id
                   private String nom
                   ...

I cannot see what your input is, when you are storing the objects. Please do a log/SysOut from the objects before storing. If you are shure that the second (related Repondant) object is in the database when you save the mainly object() HeuresEffectuees?

OK, what i mean is i have at no time try out what happens when you want to saveAndUpdate() a new Object with a new Object in relation. I.e. new HeuresEffectuees() and new Repondant() at the same time.
In my logic it must be sure that the second (related) object is already in DB or if not, it must be safed before the main object.
You can see this if you fill a Database with several related tables with a demo-data-script.

Apart from this, you must at every time use the tx.commit/tx.rollback.

i'm longing to know if both (main Object and relation object are new to the database).

Stephan

PS: no event have control over my CRUD data. And that's good.

answered 2009-03-07 00:44:22 +0800

terrytornado
9393 ● 3 ● 7 ● 16
http://www.oxitec.de/

updated 2009-03-07 01:04:46 +0800

Hi Steve,

Firstly, equal what others said. It's an absolutly MUST DO to wrap all database access to a transaction.

It's the old banking sample. Take 100$ from one account and book it to an other account and unplugg the power of the booking machine (computer) in the middle of the transaction process!! On your account there is -100$ and your friend have nothing added on his account. Where are the other 100$ ?????

Therefore we need a transaction. ALL is done correct or nothing should be. It means ALL what is booking till now is ROLLEDBACK when their was a failure.

So it's better to do it for all. So you burn it in you brain. :-)

  try
    save/delete
    commit
  catch
    e
    rollback
  -

You said you have no zk-Hibernate stuff calls.

From what came org.zkoss.zkplus.hibernate.OpenSessionInViewListener.cleanup ???
So i don't know if you work with some special classes for zk. In my case i have nothing special. My backend hibernate stuff is/must absolutly free from zkoss et vice versa. It's a seperate layer !!!!

Because i'm pull Lists<Customer> or objects Customer. Or i send it back saveOrUpdate/delete(customer).

I mean you have somewhere refering some special zkClasses (org.zkoss.zkplus.hibernate.OpenSessionInViewListener).
Have a look in you web/zk.xml's

For what you need these classes?

As i said before, i don't know what you are will doing in your code and what is your workflow for this and what you have imported for this.
When you call direct a DAO methode where comes the zkoss stuff in the errormessage ???????

Comes these messages from working with some binding classes?
I have no Binding Features!!! For what!! I'm absolutly against the zscript stuff in a zuml-file. It forces to mix View and Logic with this feature. There is no change for a nearly MCV pattern. ZK is a absolutly great framework!! You have with it the chance to do all what you need in one language. Java!!

Steve, have a look over your project. Kill step by step all what you don't know for what it is.

All will be good :-) :-)

whishes
Stephan

PS 1: Try to delete the update=NO Insert=no tags in your mapping file. For what is that???
As i understand you. You do it very correct self in your DAO methodes.
PS 2: Have a look. Is there standing autocommit=yes ?

answered 2009-03-07 23:29:37 +0800

terrytornado
9393 ● 3 ● 7 ● 16
http://www.oxitec.de/

updated 2009-03-07 23:31:20 +0800

Hi Steve,

OK. It seems that this is a helper class for something.

I take a short look in it. I hope you does it too.

Yes, this class handles the transaction/commit/rollback for you.
So you don't need tx.begin/commit/rollback in your code when you use this class.

Stephan