| From: | Barry Lind <barry(at)xythos(dot)com> |
|---|---|
| To: | Jon Swinth <jswinth(at)atomicpc(dot)com> |
| Cc: | Dave Cramer <Dave(at)micro-automation(dot)net>, Joe Shevland <jshevland(at)j-elite(dot)com>, "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org> |
| Subject: | Re: "No Results were returned by the query" exception |
| Date: | 2002-06-07 04:22:42 |
| Message-ID: | 3D003512.7060607@xythos.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
Jon,
Jon Swinth wrote:
> The code actually calls a select
> from currval() first and then on exception calls nextval() to see what the sequence is currently at.
The description here sounds like you are doing something you cannot do
in Postgres. If you get an exception/error in postgres you cannot just
catch the exception and continue processing. Any error in postgres will
abort the transaction, you must first do an explicit rollback() before
you can continue issuing additional sql statements. So when you say
'and then on excpetion calls ...' it sounds to me like you are trapping
an exception and trying to do additional work.
thanks,
--Barry
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Meester | 2002-06-07 08:39:59 | Re: Newbie question - Applet works only in appletviewer |
| Previous Message | Dave Cramer | 2002-06-07 02:25:21 | Re: "No Results were returned by the query" exception |