Re: small problem in 1.2B1 on Oracle 8i

From: Bryan Lewis (brya..aine.rr.com)
Date: Sat Apr 15 2006 - 14:19:26 EDT

  • Next message: Andrus Adamchik: "Re: small problem in 1.2B1 on Oracle 8i"

    Thanks.

    Just out of curiosity, what was wrong with the old code for getting the
    count?

        QueryLogger.logUpdateCount(statement.getUpdateCount());

    Andrus Adamchik wrote:

    > "-2" is a constant value defined in JDBC spec
    > (Statement.SUCCESS_NO_INFO). It is returned from the batch update
    > when the driver doesn't know how many rows where updated. The latest
    > change in the batch action enabled logging of this value as a part of
    > the total count. I just changed the logging code to output something
    > like this instead for the negative values:
    >
    > === updated ? rows
    >
    > Andrus
    >
    >
    > On Apr 14, 2006, at 9:14 PM, Mike Kienenberger wrote:
    >
    >> On 4/14/06, Bryan Lewis <brya..aine.rr.com> wrote:
    >>
    >>> I noticed this line in my log:
    >>>
    >>> [QueryLogger] === updated -2 rows.
    >>>
    >>> Note the minus sign.
    >>>
    >>> I suspected the recently modified code in BatchAction.runAsBatch() was
    >>> running into an Oracle 8i flakiness. I put a couple of println's in
    >>> that method and got this for a single-row update:
    >>
    >>
    >> I noticed the same thing. But I'm using Oracle 9i. Parts of it
    >> might even 10g now. So I think it's specific to Oracle, but not any
    >> particular version.
    >>
    >> Also, Bryan, please update your mailing list address to
    >> cayenne-use..ncubator.apache.org
    >>
    >



    This archive was generated by hypermail 2.0.0 : Sat Apr 15 2006 - 14:19:58 EDT