Re: Execute and PortalSuspended needs explicit transaction

--- Oliver Jowett <oliver(at)opencloud(dot)com> escreveu:
> Francisco Figueiredo Jr. wrote:
>
> > After some testing, I could send an Execute message with 2 as the manx
> > number of rows. After the second execute I get the following:
> >
> > portal "" does not exist
> > Severity: ERROR
> > Code: 34000
> >
> > I noticed that I could only get it working if I explicitly create a
> > transaction.
> >
> > I thought it could be some Sync() messages I was sending after the first
> > execute, but when I removed them, I still get the problems.
>
> If you're sending any Sync messages at all between the two Executes, it
> will indeed cause problems as Sync causes any implicitly-opened
> transaction to be closed, which will in turn invalidate any non-holdable
> portals.
>

Ok.

The strange part to me is that even after removing the sync calls, I still got
the problem :(

> Do you have a trace of all the messages sent?
>

I'm not at my devel box right now, but when I get home I will send you.

Thanks in advance, Oliver.

Regards,

Francisco Figueiredo Jr.

_______________________________________________________
Yahoo! Acesso Grátis - Instale o discador do Yahoo! agora. http://br.acesso.yahoo.com/ - Internet rápida e grátis