Обсуждение: SQLGetDiagRec, sqlstate returned?

Поиск
Список
Период
Сортировка

SQLGetDiagRec, sqlstate returned?

От
"Heiser, Doris"
Дата:

Hi,

 

I have some problems with sqlstates returned from SQLGetDiagRec with psqlodbc. We use PostgreSQL with psqlodbc on Linux systems.

 

We do at least some checks on sqlstates returned from PostgreSQL within our application to implement some specific error reactions.

 

This worked fine with psqlodbc 08.01.0200 and PostgreSQL 8.1.9. We used to get a specific sqlstate and error message, e.g. “22021”, “invalid byte sequence for encoding…”.

 

Now we changed to psqlodbc 08.02.0500 and PostgreSQL 8.2.5. In the very same error situation we still see the error message as before. The sqlstate obtained with SQLGetDiagRec however seems to be always “HY000” (general error) in more or less any error situation.

 

I still see the sqlstate within PostgreSQL error log, so I guess the “HY000” is coming from the odbc driver. Can someone give me some help with this problem? Are we missing something in our application or is this normal behavior of the current driver version?

 

Thanks in advance and best regards,

Doris Heiser

 

 

 

 

 

 

 

Re: SQLGetDiagRec, sqlstate returned?

От
Hiroshi Inoue
Дата:
Heiser, Doris wrote:
> Hi,
>
> I have some problems with sqlstates returned from SQLGetDiagRec with
> psqlodbc. We use PostgreSQL with psqlodbc on Linux systems.
>
> We do at least some checks on sqlstates returned from PostgreSQL within
> our application to implement some specific error reactions.
>
> This worked fine with psqlodbc 08.01.0200 and PostgreSQL 8.1.9. We used
> to get a specific sqlstate and error message, e.g. “22021”, “invalid
> byte sequence for encoding…”.
>
> Now we changed to psqlodbc 08.02.0500 and PostgreSQL 8.2.5. In the very
> same error situation we still see the error message as before. The
> sqlstate obtained with SQLGetDiagRec however seems to be always “HY000”
> (general error) in more or less any error situation.

I can see "22021" "invalid byte sequence ..." error message in a test
  case.

Could you send me directly the Mylog message ?

regards,
Hiroshi Inoue