Re: java.sql.SQLException: No rows for 'payment_items'

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Fri Apr 28 2006 - 09:29:31 EDT

  • Next message: Andrus Adamchik: "Re: writeProperty() no longer useful for relationships"

    On Apr 28, 2006, at 6:44 AM, Philip Copeland wrote:

    > Caused by: java.sql.SQLException: No rows for 'payment_items'
    >
    > As I say the code works fine on my machine and another developers
    > computer - its just failing on our 2 test servers. We are all using
    > MySQL and are using Cayenne 1.2B2 - although we initially saw the
    > problem in 1.2M8.

    Hi Philip,

    So I assume you can run the PK query from phpMyAdmin and/or mysql
    command line on the failing database and get a row for
    'payment_items'? I guess the only other thing that can be wrong is
    MySQL driver version - are they the same on all machine?

    Andrus

    This archive was generated by hypermail 2.0.0 : Fri Apr 28 2006 - 09:29:59 EDT