B4J Question SQLite references failing in Server Handlers

[lip]

This is an ongoing battle.

I have a Process Global SQL object in Main:

Dim IntSQL as SQL

I initialise it once

Main.IntSQL.InitializeSQLite(Folder,Filename,True

I use it all over the place and it generally works:

Dim RS As ResultSet = Main.IntSQL.ExecQuery("SELECT * FROM TabletParameters")
...
RS.Close

But sometimes, generally in server handlers, the code hangs as soon as it gets to a reference to Main.IntSQL
It works in Debug mode - which I know is single thread - but how do I make it work on Release mode? Can I make the handler single thread?

 

[aeric]

For SQLite working in concurrent access:

[WebApp] Concurrent access to SQLite databases

SQLite databases are very easy to use as they don't require any additional software or configuration. SQLite support for concurrent access is not comparable to server based databases such as MySQL and others. However they can still be perfect for small / medium solutions, especially if there...

www.b4x.com