From: Ken J. Wright <ken@ori-ind.com>
To: Byron Nikolaidis <byronn@solipsys.com>
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: catching posting exceptions
Date: Mon, 16 Aug 1999 13:05:56 -0700
Message-ID: <3.0.32.19990816130552.00a39980@ren.cncware.com> (raw)
At 10:10 07/30/1999 -0400, you wrote:
>
>
>"Ken J. Wright" wrote:
>
>> Attached are the logs pertaining to the posting error. Hopefully they will
>> shed some light. At the end of sql.log there is a SQLDisconnect. This is
>> the point in the program at which the dataset state goes to InActive. I can
>> not as of yet, determine where the SQLDisconnect is originating.
>>
>> Byron, could you please have a look for a possible driver problem?
>>
>
>I don't see anything. It looks like it is working correctly. The driver is
>returning an error from sqlexecute. Shouldn't the application handle that?
>
Byron,
The driver is returning a SQLSTATE of "08S01" (communication link failure)
for any hstmt type error. The error in this case was from attempting to
duplicate a unique key. My application never had the chance to judge the
error, as the api (OCBDExpress) has a hard coded block that terminates the
connection if the SQLSTATE is a "08xxx". This is where my problem stems
from. I believe that both the api & the driver are not correct. The MS ODBC
reference states that the SQLSTATE is not required by the driver and should
not be trusted by an app. This is where I believe ODBCExpress is wrong.
However, 08S01 indicates a rather fatal connection type of error. This is
where I believe the driver is wrong. A failed sql statement does not
constitute a connection failure. The closest error I can find that would
work is HY000 (general error). Comments?
Ken
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: ken@ori-ind.com, byronn@solipsys.com
Subject: Re: catching posting exceptions
In-Reply-To: <3.0.32.19990816130552.00a39980@ren.cncware.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox