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

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Tue Apr 03 2007 - 13:43:56 EDT

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

    Ok, moving ahead - another thing to check... Try a DBCP connection
    pool instead of default Cayenne pool.

    http://cayenne.apache.org/doc20/dbcpdatasourcefactory.html

    Also could you do a "kill -QUIT" on the stuck instance to get the
    thread dump and see where exactly it is stuck.

    Andrus

    On Apr 3, 2007, at 1:15 PM, jerome moliere wrote:

    > 2007/4/3, Andrus Adamchik <andru..bjectstyle.org>:
    >>
    >> One more shot in the dark. I've seen Sybase standard driver behave
    >> unpredictably (I won't have access to Sybase until the end of the
    >> week to try it). Can you run the same test with jTDS driver?
    >
    >
    >
    > yes that's done.... same results
    > Thanks for your help
    > Cheers
    > jerome
    >
    > http://jtds.sourceforge.net/
    >>
    >> Andrus
    >>
    >>
    >> On Apr 3, 2007, at 12:35 PM, jerome moliere wrote:
    >> > 2007/4/3, Andrus Adamchik <andru..bjectstyle.org>:
    >> >>
    >> >> While I've never seen hung transactions in my apps, there were
    >> other
    >> >> users [1] who are seeing some strangeness. So let's try to
    >> figure out
    >> >> what's going on.
    >> >>
    >> >> 1. What DataSource are you using - Cayenne-provided or some other
    >> >> (e.g. container-provided). Either should work of course, but this
    >> >> information should help in debugging.
    >> >
    >> >
    >> > cayenne provided one...
    >> >
    >> > 2. Are you using container-managed transactions? If you are, you
    >> have
    >> >> to check "container-managed transactions" [2], and ensure that
    >> >> whatever transaction mechanism is used (i.e. explicit J2EE
    >> >> UserTransactions), you commit them explicitly.
    >> >
    >> >
    >> > no CMT.... these samples are made in a very simple context, STAND
    >> > ALONE
    >> > applications
    >> > no J2EE stuff here...
    >> >
    >> >
    >> > --
    >> > 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 - 13:44:34 EDT