All Apps and Add-ons

Splunk DB Connect: How to enable Connection Pooling?

jpmackl
New Member

I'm using DB Connect and I noticed in the setup instructions, they have an option for "Enable Connection Pooling" - I assume this is different than Search Head Pooling? If so, how do you Enable Connection Pooling via DB Connect? In Java, we have Java Connection Pooling that does the following: The connection pooling helps to utilize and efficiently re-use the database connection in a multithreading environment. The idea is to share the database connections (limited connections) with the users (unlimited numbers) in the most efficient way. Is this automatically set in Splunk DB Connect? If not, where are the instructions for to "Enable Connection Pooling"?

http://docs.splunk.com/Documentation/DBX/1.1/DeployDBX/Installtheconnector#UI_Setup
Database Connection Handling
• Factory Type
Enable connection pooling
• Cache database and table metadata
• Preload database configuration

0 Karma
1 Solution

jcoates_splunk
Splunk Employee
Splunk Employee

Hi, thread pooling in the java bridge is automatic and sounds like what you want; that's different from the search head clustering that replaced search head pooling.

View solution in original post

0 Karma

jcoates_splunk
Splunk Employee
Splunk Employee

Hi, thread pooling in the java bridge is automatic and sounds like what you want; that's different from the search head clustering that replaced search head pooling.

0 Karma

jpmackl
New Member

I found the information after digging deep into the documentation. Thanks!

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

[Puzzles] Solve, Learn, Repeat: Character substitutions with Regular Expressions

This challenge was first posted on Slack #puzzles channelFor BORE at .conf23, we had a puzzle question which ...

Splunk Community Badges!

  Hey everyone! Ready to earn some serious bragging rights in the community? Along with our existing badges ...

[Puzzles] Solve, Learn, Repeat: Matching cron expressions

This puzzle (first published here) is based on matching timestamps to cron expressions.All the timestamps ...