Question
How many database connections are created simultaneously when using Scriptura ?
Answer
Tracking
The default pool size is 30, but there is a configuration option in the tracking session alias that can overrule this default value: com.id.scriptura.tracking.configuration.session.impl.jdbc.pooledconnection.connections.max
Event Flow
Event Flow uses Tracking as DB back-end, so it uses the same settings.
User Store (Store/Retrieve/Delete pages)
1 connection per step, which is released when the step's flow instance has ended, however nothing is done when the flow instance ends abnormally.
Forms store
The default pool size is 10, but there is a configuration option that can overrule the default: /config/server/htmlforms/administrator/store/connection-pool-size
Flow Store
The default pool size is 10, but there is a configuration option that can overrule the default: /config/server/documentflow/database/connection-pool-size
Messages DB
The default pool size is 10, but there is a configuration option that can overrule the default: /config/server/messagehandler/database/connection-pool-size
Custom server applications
Custom steps and applications may also use connections to the database.