Support Questions
Find answers, ask questions, and share your expertise

Dynamically create JDBC connection

Dynamically create JDBC connection

New Contributor

I would like to know if it's possible to dynamically generate a JDBC connection. Our use case is that we have a SQL server that contains a database that acts as multi-tenant configuration. It contains all the database names and connection string info for all tenants. Instead of having to create a DBCPConnectionPool controller service for each one of these, is there a way to dynamically generate a connection to query across all tenant connections?

Don't have an account?