[unixODBC-support] Errors with integration between Oracle and PostgreSQL
rorduna at tracasa.es
Wed Apr 8 09:56:39 BST 2009
First of all, thank you again.
Your solution obtains a successful connection from Oracle Warehouse Builder. Good!!!
The next error arises when we try to select the source tables for the project. I would remember that it seems that the text fields of pg_catalog load incorrectly (even from sqlplus, for example for
select * from "pg_catalog"."pg_user"@postgres;
I send the logs of the select statement from unixODBC log and from dg4odbc log:
select * from ALL_USERS at postgres;
De: unixodbc-support-bounces at mailman.unixodbc.org [mailto:unixodbc-support-bounces at mailman.unixodbc.org] En nombre de Nick Gorham
Enviado el: martes, 07 de abril de 2009 17:02
Para: Support for the unixODBC project
Asunto: Re: [unixODBC-support] Errors with integration between Oracle and PostgreSQL
>The response of Oracle is included below:
>After researching this with several engineers on the gateways team, it was determined that your ODBC driver is returning an incorrect sqlstate of "HY000" in your dg4odbc trace (allusers_dg4odbc.log). The correct sqlstate for an "object not found" error is "42S02". This is what's architected in the ODBC spec, drivers are supposed to follow the spec and those that don't are broken. You will need to persue this with your ODBC driver vendor.
More information about the unixODBC-support