Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to commit data with Component Services (W2k)?

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

From: Roy <something_at_something.here>
Date: Fri, 21 Sep 2001 10:00:47 +0200
Message-ID: <9oes30$sdi$1@news1.xs4all.nl>


Aaaaaaaaaaah....stupid me.......found it.... The component had the flag 'Transaction support : not supported' ..... after I changed this flag to 'Required' all worked as it should :-)

The TRANSACTION_REQUIRED parameter in the IDL-file also does the trick :-)

Roy

"Roy van der Pijl" <nospam_at_xs4all.nl> wrote in message news:9odef0$arq$1_at_news1.xs4all.nl...
> Hi,
>
> I have a (big) problem.
>
> Situation.
> 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
> comes the problem......after the component is called (and returns with a
OK
> 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
> never commited.
>
> I do release the object with the object->release() statement and I also
call
> the OraMtsSvcrel() and free the remaining handles.....
>
> There are no errors comming from the OCI-calls.......and in fact the data
is
> changed...but not commited... I tried to call the OCITransCommit()
function
> but that is not allowed when using a object runing under Component
Services
> (so the documentation says)
>
> Do I do something terribly wrong ??? Please help,
> Roy
>
>
>
>
Received on Fri Sep 21 2001 - 03:00:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US