[unixODBC-support] Errors with integration between Oracle and PostgreSQL

Raul Orduna rorduna at tracasa.es
Tue Apr 7 12:56:02 BST 2009

I was working with Oracle support because we can't use the database link from Oracle (DG4ODBC) to PostgreSQL through OWB (Oracle Warehouse Builder).


I test the Database link from SQLplus and runs properly. I only detect problems with text data of the system tables of postgreSQL (schema pg_catalog). Other tables and numeric values seem correct.


When we use Oracle Warehouse Builder this tool makes some "standard" queries: "dual" table, "all_users" table, etc, in order to show the tables for read data. These queries don't run because the tool report that tables don't exist. 


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[1].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.


The referenced files are attached (logs of the same test for all_users in both logfiles, and two connections, the correct one from sqlplus, and the error one from OWB).


Any idea??


Raúl Orduna

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.unixodbc.org/pipermail/unixodbc-support/attachments/20090407/1877cc41/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: allusers.zip
Type: application/x-zip-compressed
Size: 5265 bytes
Desc: allusers.zip
URL: <http://mailman.unixodbc.org/pipermail/unixodbc-support/attachments/20090407/1877cc41/attachment.bin>

More information about the unixODBC-support mailing list