Q: How to commit data with Component Services (W2k)?

I have a (big) problem.

Situation.
[Quoted] An Oracle 8i database (8.1.7) on a VAX/Open VMS machine and a Windows2000 server.
I have installed the "Oracle Component for MTS" on the Win2000 machine and now I am writing components in C++ using OCI-calls to interface with the database.

Al seems to go well. I wrote some small programms to select some data from tables but now I want to change (update/insert) data in a table.....and here [Quoted] comes the problem......after the component is called (and returns with a OK [Quoted] status) the data is not commited to the database. Only after I 'shut down' the component in component services the data is commited. This also happens after the time-out in CS has passed (it is set a 3 minutes).

When I choose the option to 'leave component running when idle" the data is [Quoted] never commited.

I do release the object with the object->release() statement and I also call [Quoted] the OraMtsSvcrel() and free the remaining handles.....

There are no errors comming from the OCI-calls.......and in fact the data is [Quoted] changed...but not commited... I tried to call the OCITransCommit() function [Quoted] but that is not allowed when using a object runing under Component Services [Quoted] (so the documentation says)

Do I do something terribly wrong ??? Please help, Roy Received on Thu Sep 20 2001 - 21:01:49 CEST