RE: Transactions

From: Michael Schuldt (m..scensys.de)
Date: Fri Jan 17 2003 - 07:01:36 EST

  • Next message: Dirk Olmes: "RE: Transactions"

    Hi Andrus,

    yes, I'm using MySQL ver 4.0.4. They say that it does support transactions.
    Is this realy true? Maybe you can give me a hint.

    Michael

    > -----Original Message-----
    > From: Andrus Adamchik [mailto:andru..bjectstyle.org]
    > Sent: Wednesday, January 15, 2003 4:24 PM
    > To: m..scensys.de
    > Cc: cayenne-use..bjectstyle.org
    > Subject: Re: Transactions
    >
    >
    > Hi Michael,
    >
    > Cayenne does use transactions. "commitChanges" is wrapped in a
    > transaction.
    >
    > So why didn't it work for you? I wonder if the database was at fault. Are
    > you using MySQL by any chance, or any other database that does not really
    > support transactions?
    >
    > Andrus
    >
    > > Hallo,
    > >
    > > I was of the opinion, that cayenne uses transactions. But I found the
    > > following problem.
    > >
    > > - I'm creating 3 objects for one DataContext using
    > > createAndRegisterObject. - I'm filling the objects, even the
    > > relationships
    > > - At the end, I'm using commitChanges of the DataContext.
    > >
    > > For testing I caused a problem on one table. I just deleted a column to
    > > see, if there is no data at all written to the database as suspected.
    > > But there was data written to the 2 correct tables but no in the
    > > corrupted one.
    > >
    > > So this seems to me, that there was no transaction used.
    > >
    > > Who can tell?
    > >
    > >
    > > Michael
    >
    >
    >



    This archive was generated by hypermail 2.0.0 : Fri Jan 17 2003 - 07:00:06 EST