ERXSequence.DatabaseSequence error

Subject: ERXSequence.DatabaseSequence error
From: Farrukh Ijaz <email@hidden>
Date: Thu, 22 Nov 2012 20:06:09 +0300

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@hidden)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden

Follow-Ups:
- Re: ERXSequence.DatabaseSequence error
  - From: Johann Werner <email@hidden>

Prev by Date: Re: wrong redirect
Next by Date: Re: ERXSequence.DatabaseSequence error
Previous by thread: Re: wrong redirect
Next by thread: Re: ERXSequence.DatabaseSequence error
Index(es):
- Date
- Thread