I isolated the problem by programming directly on the Oracle API. It seams that a connection that was involved in an aborted transaction (a "transaction required" component) cannot be used in a non-transactional ("transaction supported") call (same user/pwd/server combination).
It's easy to...
Marco,
I tried some other error handling mechanism in TOracleSession. According to the Oracle documentation there is a function OraMTSOCIErrGet that retrieves the last OCI errr in case an MTS function (like OraMTSSvcGet) fails. So I imported this function and changed TOracleSession.MTSCall:
if...
Hi Marco,
Ewart left the company several years ago. I could not find his report you mentioned. Do you have a direct url?
Any suggestions on how to analyze or isolate the problem?
Pim-Jan
It is reproducable with one active transaction. In one case multiple connections (one database, multiple users and datasets) are involved, in another case one connection is involved and one other resource manager (no database). The transaction is always aborted due to a functional error...
We recently upgraded our com+ application from DOA 4.0.3 on an Oracle 8 client to DOA 4.0.7.1. First using the Oracle 8.1.7 client, and now using an Oracle 10.2.0.1.0 client.
Our application ran just fine on the Oracle 8 client but on the Oracle 10 client, we ran into errors in the...
Thanks, I could have read it in the version history notes.
I will ask my manager to purchase a new license. Is this the 4.0.9 version or the promised and upcoming 4.1 version?
Pim-Jan
A very simple com+ test application with DOA 4.0.3 cannot connect to an Oracle 10g server using an Oracle 10g client. The exception says "Initialization error, SQL*Net not property installed, OracleHomeKey: SOFTWARE\ORACLE, OracleHomeDir: ". I read the source code but cannot figure it out that...
It is during the installation of the application in COM+. I don't think it is possible to debug that. For now it is probably best to remove the Oracle Monitor.
Pim-Jan Veenendaal
Dexia Bank Nederland
We bought and downloaded the latest version this week so that should not be the problem.
Should the monitor be installed or running when the COM+ application is installed?
Pim-Jan Veenendaal
Dexia Bank Nederland
We have created a COM+ application with DOA and I tried to install it on my Windows 2000 Server machine. However, the Component Services freezes with 100% CPU usage.
I found out that the OracleMonitor unit is included in one of our units. When I excluded installation works fine.
The Oracle...