Hello Simon, thank you for help. The windows application is written in C# and uses the sqlite.systemData.dll.
What does the timeout mean in detail for sqlite ? Is this time (in your example 5 minutes) for each SQL query which is executed? 2016-01-14 14:25 GMT+01:00 Simon Slavin <slavins at bigfraud.org>: > > On 14 Jan 2016, at 10:57am, Werner Kleiner <sqlitetester at gmail.com> wrote: > > > I have written a small Wep application with PHP (PDO Apache,). This web > app > > uses a sqlite db3 database. Also there is a Windows application which > uses > > the same database file. > > Now we heard one time that there war a problem and in a log file we saw > the > > error code > > "Database is locked" > > My question now is: > > Could this be a problem when Apache or PHP uses same database and also a > > windows application? > > Yes. In both applications you should set a timeout. The way it is done > in Windows depends on the language but for PHP PDO use you should set > PDO::ATTR_TIMEOUT using > > <http://php.net/manual/en/pdo.setattribute.php> > > Example code: > > $dbConnection->setAttribute(PDO:: ATTR_TIMEOUT, 5*60); // five minutes > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
