Guys, Just tracked this down - its very subtle - and I think qualifies as a bug in Cayenne. The problem is that the select for the AutoPKSupport is not using A fully qualified table name - the query is "SELECT NEXT_ID FROM AUTO_PK_SUPPORT WHERE etc". I belive it should be "SELECT NEXT_ID FROM DBSCHEMA.AUTO_PK_SUPPORT WHERE etc". I had a couple of different schemas - but was using 1 common user to connect. In most cases this was Ok because the table names are qualified - except for the Atop_support table.
To fix my problem I'm adding separate users for each schema. Thanks Phil -----Original Message----- From: Andrus Adamchik [mailto:[EMAIL PROTECTED] Sent: Friday, 28 April 2006 11:30 PM To: [email protected] Subject: Re: java.sql.SQLException: No rows for 'payment_items' 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
