MQSeries.net :: View topic - Which ODBC drive should I use for oracle 2 phase commit

lium · Posted: Wed Jan 22, 2014 10:06 am Post subject:

Hi, I want to implement 2 phase commit for IIB. I have both DataDirect and Oracle client installed with the IIB(message broker v9).
I have generated the oraswit.dll for both 32 bit and 64 bit.
The windows are OS 64 bit, the qmgr is 32 bit, and IIB is 64 bit. I have both oracle client 32 bit and 64bit installed locally along the message broker. The oracle server is also on the same box.

I have made a lot of progress, and from the xa_ORCL01202014.trc which is about xa trace by oralce, I did not see any error from that.

However, right now the situation is:
If I use DataDirect drive, I will get error as:

2014-01-20 01:52:59.435016 4348 DatabaseException BIP2321E: Database error: ODBC return code '-1' using ODBC driver manager ''odbc32.dll''.
The message broker encountered an error when processing a database operation. The ODBC return code was '-1'. See the following messages for information obtained from the database concerning this error.
Use the following messages to determine the cause of the error. Typical problems are an incorrect datasource or table names. Correct either the database or message broker configuration.
2014-01-20 01:52:59.435032 4348 DatabaseException BIP2322E: Database error: SQL State ''HY000''; Native Error Code '0'; Error Text ''[IBM][ODBC Oracle Wire Protocol driver]xa_open must be called before a connection is enlisted in a distributed transaction.''.
The error has the following diagnostic information: SQL State ''HY000'' SQL Native Error Code '0' SQL Error Text ''[IBM][ODBC Oracle Wire Protocol driver]xa_open must be called before a connection is enlisted in a distributed transaction.''

I am wondering if this is ODBC drive issue, so I switched to oracle client drive, which however, generated the following error:

2014-01-20 21:08:57.582156 4512 DatabaseException BIP2321E: Database error: ODBC return code '-1' using ODBC driver manager ''odbc32.dll''.
The message broker encountered an error when processing a database operation. The ODBC return code was '-1'. See the following messages for information obtained from the database concerning this error.
Use the following messages to determine the cause of the error. Typical problems are an incorrect datasource or table names. Correct either the database or message broker configuration.
2014-01-20 21:08:57.582168 4512 DatabaseException BIP2322E: Database error: SQL State ''HYC00''; Native Error Code '0'; Error Text ''[Oracle][ODBC]Optional feature not implemented.''.
The error has the following diagnostic information: SQL State ''HYC00'' SQL Native Error Code '0' SQL Error Text ''[Oracle][ODBC]Optional feature not implemented.''
This message may be accompanied by other messages describing the effect on the message broker itself. Use the reason identified in this message with the accompanying messages to determine the cause of the error. Use the mqsicvp command to test connectivity to this database.

I am wondering any tip which drive I should use?
and further any clue to solve the problem above?

Thanks