Web App with SQLite Database disconnection

[DerkJ]

[quote=349853:@Aurelian Negrea]Hi Derk,
Session.[/quote]

Ok, that should be good

[Greg_O_Lone]

@349774:@Aurelian Negrea

Thanks for the above advices as well, i was thinking to redirect as well to other page, as for the maintenance page, once is on and the timer fires they cannot use the app anymore it shows a static page with maintenance mode same as the database not supported, and there i put code as well to close db but still, works only on mac properly and closes the db but on windows never.

If this maintenance page is in your app, it will continue to start sessions as that’s the only way to display a page. I suggest that in maintenance mode you add some code to app.HandleURL to redirect users away from the app when Request.Path = “” to prevent sessions from being started.

@349774:@Aurelian Negrea

Well most of the places i have just view only so i always use the recordset to fetch data , but whenever i update or add something i always commit, but it seems that the funny part happens on Windows, due to the restrictions i`m obliged to use Windows 7 so i guess there is an issue there as well, but on mac works flawlessly on windows always that wall grows and never closes, so it is strange for me as well.

What is the directory path of the database file (where the WAL file is being written)?

[Aurelian_N]

[quote=349914:@Greg O’Lone]If this maintenance page is in your app, it will continue to start sessions as that’s the only way to display a page. I suggest that in maintenance mode you add some code to app.HandleURL to redirect users away from the app when Request.Path = “” to prevent sessions from being started.

What is the directory path of the database file (where the WAL file is being written)?[/quote]

Will try to do that .

For the database is under SpecialFolder.ApplicationSupport.Databases so on windows will be under \\Users\\UserName\\AppData\\Roaming\\Databases\\database.db

I did that because other locations might create issues.

[Greg_O_Lone]

[quote=349918:@Aurelian Negrea]For the database is under SpecialFolder.ApplicationSupport.Databases so on windows will be under \Users\UserName\AppData\Roaming\Databases\database.db

I did that because other locations might create issues.[/quote]
Good. Just wanted to be sure. When setting up the database connection, you might also want to check Folderitem.IsWritable just to make sure that the file is in fact writable by the current user, because from what you’ve said it sounds like it might not be.