Hello,

on 11/20/2005 12:12 PM jonbouyw said the following:
> I've just tested the latest CVS version and it's working great apart
> from when running for the first time with a persistent connection.
> PHP throws up this warning:
>
> Warning: sqlite_close(): 244 is not a valid sqlite database resource
> in c:\Dev\htdocs\public\docs\metabase\metabase_sqlite.php on line 89

Maybe that is because closing persistent connections should not make any
effect. I changed the driver class to not call sqlite_close when closing
a setup to a database in persistent connection mode.


> And still I have to restart Apache to be able to delete the resultant
> file after using a persistent connection.

I think that is a consequence of keeping persistent connections. The
files are kept closed and locked.

I do not see much benefit in keeping persistent connections with SQLite
because the accesses are not even authenticated, so the reconnection
overhead should be neglectable. Anyway, this does not seem to be a
Metabase or even a PHP specific problem.

--

Regards,
Manuel Lemos

Metastorage - Data object relational mapping layer generator
http://www.metastorage.net/

PHP Classes - Free ready to use OOP components written in PHP
http://www.phpclasses.org/