Re: commitChanges() doesn't imply commit in db ?

From: jerome moliere (jerome.molier..mail.com)
Date: Tue Apr 03 2007 - 12:03:39 EDT

  • Next message: Andrus Adamchik: "Re: commitChanges() doesn't imply commit in db ?"

    Thanks for your reply michael,
    i was wondering about my code ....

    2007/4/3, Michael Gentry <blacknex..mail.com>:
    >
    > Hmm, this is interesting. I've noticed transactions uncommitted against
    > our
    > Sybase DB, too. I've usually attributed this to a problem with the Sybase
    > connection getting stale or something else going awry inside the database
    > because our process (and the connection to the DB) is long-running (a web
    > application that is hardly ever restarted) and the problem only occurs
    > after
    > it has been running for a while and a restart of the application clears
    > the
    > problem up (fetching data from the DB still works in our case,
    > though). It
    > sounds like yours isn't that long-term of a connection, though. Now I'm
    > wondering if there is a problem with the Sybase driver or something inside
    > Cayenne. Is there any chance you can make a repeatable test case? Our
    > experience with the issue has been very intermittent and not reproducible
    > and Cayenne was always logging the proper SQL.

    in fact it's very simple, i'll try to make a small drawing of my test:

      App1 = thread querying a table all 10 seconds
                   after the first query -> send a message on a tibco queue

    App 2 = wait for notification on the tibco queue
    get the item (id passed into the message) then update this record (one
    field)
    send a message for notifying about field update via tibco
    App 3 = wait for the notification and displays the new value (once again
    query on db)

    SO at this point app1 runs but with bad results after the first query
    App2 seems to work but does'nt commit
    App3 is never notified...

    I'll try to package a small test case using openjms ?
    It's very disappointing because Sybase is the database choice from my
    customers (like in many financial companies)...

    Cheers
    jerome

    Thanks,
    >
    > /dev/mrg
    >
    >
    > On 4/3/07, jerome moliere <jerome.molier..mail.com> wrote:
    > >
    > > Hi all,
    > >
    > > I'm doing a proof of concepts of several tricky usage from orm , one of
    > > the
    > > 2 implementations is Cayenne...
    > > I've one scenario where 3 process (stand-alone Java applications) use
    > the
    > > same table on db and communicate via Tibco rendez vous...
    > > It works fine with Hibernate, but I 've got several problems with
    > > cayenne...
    > > latest one is while updating one object in one of these applications,
    > > invoking commitChanges() on my context, nothing happens..
    > > the query logger shows me a trans begin, the right update query but this
    > > transaction is never committed
    > > strange isn't it ?
    > > This is the output (excerpt )from my process trying to update one
    > entity:
    > >
    > > [java] INFO QueryLogger - +++ Connecting: SUCCESS.
    > > [java] INFO QueryLogger - --- transaction started.
    > > [java] INFO DbAdapterFactoryChain - DB name: Adaptive Server
    > > Enterprise
    > > [java] INFO QueryLogger - Detected and installed adapter:
    > > org.apache.cayenne.dba.sybase.SybaseAdapter
    > > [java] INFO QueryLogger - SELECT t0.AggregationCurrency,
    > > t0.AllowFixing, t0.FixingAskSpread, t0.FixingBidSpread, t0.IsIslamic,
    > > t0.IsLocal, t0.OISRoundingConv, t0.Currencies_Id FROM
    > dbo.CurrenciesLocTt0
    > > WHERE t0.Currencies_Id = ? [bind: 105] - prepared in 37 ms.
    > > [java] INFO QueryLogger - === returned 1 row. - took 71 ms.
    > > [java] INFO QueryLogger - +++ transaction committed.
    > > [java] INFO CayenneCurrencyDAOImpl - before update isIslamicChar
    > set
    > > to = Y
    > > [java] INFO CayenneCurrencyDAOImpl - after update this filed is
    > now
    > > set to = N
    > > [java] INFO QueryLogger - --- will run 1 query.
    > > [java] INFO QueryLogger - --- transaction started.
    > > [java] INFO QueryLogger - UPDATE dbo.CurrenciesLocT SET IsIslamic
    > =
    > > ?
    > > WHERE Currencies_Id = ?
    > > [java] INFO QueryLogger - [bind: 'N', 105]
    > >
    > >
    > > druid shows me that the tranaction is never committed, like one of the
    > > other
    > > applications lauching as a daemon a query on this table (does not show
    > any
    > > update because there are not..)
    > >
    > > Any clue ?
    > > cheers
    > > jerome
    > >
    > > --
    > > Jerome Moliere - Mentor/J
    > > http://romjethoughts.blogspot.com/
    > > auteur Eyrolles
    > >
    > 

    -- 
Jerome Moliere - Mentor/J
http://romjethoughts.blogspot.com/
auteur Eyrolles

    This archive was generated by hypermail 2.0.0 : Tue Apr 03 2007 - 12:04:38 EDT