--- In firebird-php@yahoogroups.com, Lester Caine <lester@...> wrote:

>
> tomsee7 wrote:
> > I'm running a php windows service and it opens a connection, selects records, does some stuff, the closes the connection until it runs again later.
> >
> > The first run all's good but subsequent times no records are visible even though different fb client tools (ibexpert& flamerobin) can see the new records.
> >
> > Points to note:
> > 1. The ZendX_Db_Adapter_Firebird appears to use the php_interbase extension.
> > 2. Tried changing _beginTransaction() key line:
> > ibase_trans(IBASE_DEFAULT, $this->_connection) to
> > ibase_trans( IBASE_WRITE|IBASE_COMMITTED|IBASE_WAIT, $this->_connection) but no difference.
>
> If you restart apache/php are the records then visible?
> I've never used ZendX_Db_Adapter_Firebird but on other abstraction layers that
> pool connections, the connection/transaction can be left open so that subsequent
> use of the connection still sees the old transaction view. Not sure how ZendX
> handles that, but it is most likely what is happening.
>
> --
> Lester Caine - G8HFL
> -----------------------------
> Contact - http://lsces.co.uk/wiki/?page=contact
> L.S.Caine Electronic Services - http://lsces.co.uk
> EnquirySolve - http://enquirysolve.com/
> Model Engineers Digital Workshop - http://medw.co.uk//
> Firebird - http://www.firebirdsql.org/index.php
>

Just FYI Lester the app is a Command Line Interface (CLI) app here (although there is web interface to it too).