Skip site navigation (1) Skip section navigation (2)

[ psqlodbc-Bugs-1000650 ] Error in accessing PostgreSQL via unixODBC from Oracle

From: <noreply(at)pgfoundry(dot)org>
To: noreply(at)pgfoundry(dot)org
Subject: [ psqlodbc-Bugs-1000650 ] Error in accessing PostgreSQL via unixODBC from Oracle
Date: 2006-05-23 15:12:58
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc
Bugs item #1000650, was opened at 2006-05-23 15:36
You can respond by visiting:

Category: None
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Nobody (None)
Assigned to: Nobody (None)
Summary:  Error in accessing PostgreSQL  via unixODBC from Oracle

Initial Comment:

We have an Opteron machine running Linux and Oracle We access a PostgreSQL 8.0.3 database running under Linux on an AMD Athlon via unixODBC and the postgresql ODBC driver psqlodbc 8.02.0002.

On the Opteron machine we compiled a postgresql 8.1.3 client (libraries), the unixodbc 2.2.11 framework and the psqlodbc 8.02.0002 driver. Everything was configured so that the binaries are all 32bit as the Oracle hsodbc driver demands.

Here is the error message we get when trying to acces the CRM (postgresql) database via sqlplus ( Oracle 10g ):

SQL> select count(*) from "my_table"@crm;
select count(*) from "my_table"@crm
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Generic Connectivity Using ODBC][unixODBC]ERROR:  current transaction is
aborted, commands ignored until end of transaction block;
Error while executing the query (SQL State: S1000; SQL Code: 1)
ORA-02063: preceding 3 lines from CRM

with best regards
Matthias Weiss


>Comment By: Ludek Finstrle (luf)
Date: 2006-05-23 17:12

If it's your first statement to postgresql feel free to attach mylog output. In other way there is new setting for transaction handling in psqlodbc 08.02.0002. I'm sorry I don't have it here so I wrote it only from my mind. There is new automatic rollback per transaction/per statement.




Comment By: Jonah Harris (jharris)
Date: 2006-05-23 17:05

THIS IS NOT A BUG.  It has to do with the difference in the way Oracle and PostgreSQL view transactions.  PostgreSQL aborted the current transaction due to some error in your use of it, Oracle didn't view that as an error so it doesn't know about the "aborted" state.  From Oracle, you need to perform an explicit ROLLBACK and then you can use the connection again.


You can respond by visiting:

pgsql-odbc by date

Next:From: sibel karaasmaDate: 2006-05-24 08:43:17
Subject: compiling source code!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Previous:From: noreplyDate: 2006-05-23 15:05:32
Subject: [ psqlodbc-Bugs-1000650 ] Error in accessing PostgreSQL via unixODBC from Oracle

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group