B4J Question Database Connections Pooling and Threading

aeric

Expert
Licensed User
Longtime User
The pool is responsible for maintaining the connections.
An alternative for a connections pool is a process global SQL variable. However for it to work properly all the handlers should be single threaded handlers.
Click to expand...
Referring to the tutorial
'[Server] Building web servers with B4J'
https://www.b4x.com/android/forum/threads/server-building-web-servers-with-b4j.37172/

I am now confused with this statement. No problem to use connection pool for MySQL and set the SingleThreaded to False by default.

B4X: 
srvr.AddHandler("/hello", "HelloPage", False)

But then now if I use SQLite for the backend, should I set SingleThreaded as True?
 
Last edited:
Sort by date Sort by votes

EnriqueGonzalez

Well-Known Member
Licensed User
Longtime User
Hi aeric, the single thread is only for the server handler it has nothing to do with the database, the driver and the pooler are in charge of managing that info,
 
Upvote 0

OliverA

Expert
Licensed User
Longtime User
aeric said:
But then now if I use SQLite for the backend, should I set SingleThreaded as True?
Click to expand...
No. Just don't use pooling with SQLite. For SQLite, use the InitializeSQLite method to retrieve your SQL object. Use this single object for all your DB requests. @Erel has provided the code to ensure that only one NonQuery statement will be executed at any given time. This is how I do it in my modified jRDC2 server.

Note: you also need to enable WAL mode

Sources:
WAL mode: Thread '[WebApp] Concurrent access to SQLite databases' https://www.b4x.com/android/forum/threads/webapp-concurrent-access-to-sqlite-databases.39904/
B4J's SQL: https://github.com/AnywhereSoftware...SQL/src/anywheresoftware/b4j/objects/SQL.java
My jRDC2 mod: https://www.b4x.com/android/forum/threads/modded-jrdc2-w-sqlite-support-and-more.85578/
 
Upvote 1

aeric

Expert
Licensed User
Longtime User
So the short answer is No. I understand about pooling, just confused after I read the tutorial again.
 
Upvote 0

Jmu5667

Well-Known Member
Licensed User
Longtime User
aeric said:
So the short answer is No. I understand about pooling, just confused after I read the tutorial again.
Click to expand...
On server apps always set SingleThreaded to false as it refers to the threading method uses on the handler. Setting it to true means that the handler code will run on the main thread. There maybe use cases where it is set to true but I have not encountered this so far.
 
Upvote 0
You must log in or register to reply here.

Similar Threads

  • Question
B4J Question PoolConnection Problem : Connection has timed out
Replies
9
Views
3K
Waldemar Lima
M
  • Article
B4J Library HikariCP - High Performance Connection Pool
2
Replies
27
Views
11K
alwaysbusy
  • Locked
  • Article
B4J Library [B4X] jRDC2 - B4J implementation of RDC (Remote Database Connector)
5 6 7
Replies
138
Views
144K
Erel
  • Question
B4J Question sql.SQLException: "Too many connections" with ConnectionPool library
Replies
10
Views
7K
balarii
B
  • Article
B4J Tutorial [WebApp] Concurrent access to SQLite databases
Replies
7
Views
26K
Erel
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…