Re: Using Cursors in PHP

On Fri, 8 Aug 2003, Rod Taylor wrote:

> > I don't think so.  Basically, PHP is supposed to reset the connection if 
> > it's persistant, and if it isn't persistant, then it's always a new 
> > connection, which means a cursor shouldn't survive. 
> > 
> > But I'm NOT familiar with "WITH HOLD" right now, so someone else who knows 
> > that better may have a more definitive answer.
> 
> Yup.. This is where you setup a little Java to deal with persistent
> database elements like this and hook into it via PHP.  It's a little
> nasty at the moment (though functional) but is supposedly greatly
> improved in PHP 5.
> 
> http://ca2.php.net/manual/en/ref.java.php

Java providing connection pooling for PHP.  Sweet!