Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Two DBCPConnectionPool for SQLServer in different ProcessorGroups one never stops Enabling

Highlighted

Two DBCPConnectionPool for SQLServer in different ProcessorGroups one never stops Enabling

New Contributor

I Have two separate processor groups access two separate database on the same SQLServer instance.

92897-settings.png

I have created two DBCPConnectionPool with the only real difference being the Database name in the SQLServer connection string.

One works the other when trying to enable stays enabling all the time.

I am sure this relates to something can only be used once but I am unsure.

Help appreciated.

Lee

92898-enabling.png

1 REPLY 1

Re: Two DBCPConnectionPool for SQLServer in different ProcessorGroups one never stops Enabling

New Contributor

I am now researching

DBCPConnectionPoolLookup 1.7.1

but I can find no help on this at all.

How does one use it? I want to have DBCPService defined and then Use

DBCPConnectionPoolLookup 1.7.1 with variable database.name to call to allow execution of sql.

It seems can't have two DBCPConnectionPools with same ODBC driver