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
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.
Get Updates on the Splunk Community!

Tech Talk Recap | Mastering Threat Hunting

Mastering Threat HuntingDive into the world of threat hunting, exploring the key differences between ...

Observability for AI Applications: Troubleshooting Latency

If you’re working with proprietary company data, you’re probably going to have a locally hosted LLM or many ...

Splunk AI Assistant for SPL vs. ChatGPT: Which One is Better?

In the age of AI, every tool promises to make our lives easier. From summarizing content to writing code, ...