How does StreamBase determine the connection count
Article ID: KB0076101
Updated On:
| Products | Versions |
|---|---|
| TIBCO Streaming | - |
Description
I am seeing 9 connections from my StreamBase application into Sybase. Is this normal? How does StreamBase determine the connection count?
Issue/Introduction
How does StreamBase determine the connection count
Resolution
By default, a StreamBase application makes 1 connection for each JDBC query operator that interacts with that data-source. If you turn on jdbc-share-connections in the data-source definition in the sbd.sbconf file, then each JDBC query operator connected to that data-source uses the same connection, dropping the connection count back to one.
Be aware that turning on concurrency and parallelism that affects any JDBC query operator increases the number of connections observed by the number of additional threads.
Be aware that turning on concurrency and parallelism that affects any JDBC query operator increases the number of connections observed by the number of additional threads.
Feedback
Yes
No
Powered by
