I suggest that you put a breakpoint on the call to start transaction and see
if it isn't somehow being called in a way that you are not expecting. It
should not do what you are saying that it does. If you do find that it is
being called please examine the callstack and see what it is that is
originating it.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Gordon Hamm" <vds@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, August 01, 2001 3:15 PM
Subject: Re: [IBO] Confused about rollbacks etc..


> Im doing a startTransaction... Then if something happens, Im calling a
> rollback.
>
> The next time I call my routing, it again calls a starttransaction. I get
an
> exception that says that a transaction is already being used (or something
> like that)
> I found that by simply doing a commit after my rollback, it works perfect
> now. BTW, this is after calling a stored procedure, using a TIB_cursor ..
>
>
> Gordon Hamm
>
> ----- Original Message -----
> From: "Jason Wharton" <jwharton@...>
> To: <IBObjects@yahoogroups.com>
> Sent: Wednesday, August 01, 2001 2:34 PM
> Subject: Re: [IBO] Confused about rollbacks etc..
>
>
> > Why are you making that observation?
> > Are you watching the sql trace monitor?
> > Are you aware of the CommitAction setting of the datasets? They can
cause
> a
> > new transaction handle to be acquired from the server if they are
> > repositioning a cursor after a commit.
> >
> > Jason Wharton
> > CPS - Mesa AZ
> > http://www.ibobjects.com
> >
> >
> > ----- Original Message -----
> > From: "Gordon Hamm" <vds@...>
> > To: <IBObjects@yahoogroups.com>
> > Sent: Wednesday, August 01, 2001 11:19 AM
> > Subject: [IBO] Confused about rollbacks etc..
> >
> >
> > > Hi,
> > > It seems that you must call a commit after a call to rollback or the
> > > transaction is not canceled. Is that true?
> > > Im not sure why you would need to commit data if you rolled it back?
Can
> > you
> > > explain?
> > >
> > > Gordon Hamm
> >
> >
> >
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> >
> >
>
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>