Hi Johann, I've debugged ERXSequence.java and found that following statement is causing problem:
168: con.createStatement().executeQuery(updateStatement); Since updateStatement does not return any result, it throws exception. I changed this with following which fixed the issue: 168: con.createStatement().execute(updateStatement); This needs to be fixed in Wonder. Thanks, Farrukh On Nov 22, 2012, at 9:21 PM, Johann Werner <[email protected]> wrote: > Hi Farrukh, > > what is the SQL that is getting generated? > > jw > > > Am 22.11.2012 um 18:06 schrieb Farrukh Ijaz > <[email protected]>: > >> Hi Guys, >> >> I've updated my wonder to latest. The application that was running fine all >> of a sudden seems to be broken. I'm getting following exception what getting >> a DatabaseSequence object. >> >> This is the line of the code: >> >> new ERXSequence.DatabaseSequence(editingContext(), "MyModel", >> "VisaApplicationProcessNumber"); >> >> and below is the exception. >> >> Caused by: com.webobjects.foundation.NSForwardException >> [org.postgresql.util.PSQLException] No results were returned by the >> query.:Error fetching sequence: VisaApplicationProcessNumber >> at >> er.extensions.eof.ERXSequence$DatabaseSequence.increasedMaxValue(ERXSequence.java:227) >> at er.extensions.eof.ERXSequence.nextValue(ERXSequence.java:65) >> >> ... 75 more >> Caused by: org.postgresql.util.PSQLException: No results were returned by >> the query. >> at >> org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:255) >> at >> er.extensions.eof.ERXSequence$DatabaseSequence.selectAndUpdateValue(ERXSequence.java:168) >> at >> er.extensions.eof.ERXSequence$DatabaseSequence.increasedMaxValue(ERXSequence.java:210) >> ... 80 more >> >> Here is the database query: >> >> qshield=> select * from erx_sequence_table; >> name_ | value_ >> ------------------------------+---------- >> VisaApplicationProcessNumber | 2777 >> >> Any clue? >> >> Thanks, >> >> Farrukh > >
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
