I am having this same problem -- executing a delete statement through the
ODBC driver that affects 0 rows throws an SQLException in Java -- is there a
workaround.
Thanks.
Michael
"Nick Texidor" <nick.texidor@webbods.com.au> wrote in message
news:200403190036.17909.nick.texidor@webbods.com.au...
> Hi, I'm hoping that someone can help me out with a small problem.
>
> I have just moved a website over from a MS Access database to a Postgres
one.
> The site is written in ColdFusion. Most of the SQL commands worked fine,
> with the only changes being the boolean fields, which were bit under
Access.
>
> Anyway.. my problem is this. I have a function that deletes pages in my
> content system. This function fires off several ColdFusion queries, to
> delete records from various tables. There may, or may not, be records in
> these tables that need to be deleted.
>
> The problem is this... if there are records to be deleted, everything runs
> fine and dandy.. however, of there are no records to be deleted, the
browser
> spits up a "Data Access Error" error page. All it says is "Unknown Data
> Access Error". I have played around enough to figure that it is when
there
> are no rows deleted that the error appears. This has always worked when
the
> database used was Access. I'm tried pasting the code directly into the
SQL
> window in phpPgAdmin, and the same code qorked, without returning an
error,
> where no records existed to be deleted.
>
> So I'm figuring that the error is lieing in the ODBC driver. I have been
> through all the settings, but couldn't make it work. Am I missing
> something, or is this a genuine bug? Are there any other odbc drivers I
can
> try? I can code SELECT queries all around the deletes to see if there is
> anything to delete, but this seems like a bit of overkill for something
that
> should really work.
>
> I'm running postgres on a windows NT machine, using the cygwin setup.
> Everything else seems great, just this problem.
>
> Any help would be greatly appreciated.
>
> Thanks
>
> Nick
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>