cancel
Showing results for 
Search instead for 
Did you mean: 
cancel

UCCX JDBC URL connection to multiple SQL URL

Zdravko Nozharov
Beginner
Beginner

Hello,
I have UCCX 11.6 and 2 SQLs in mirroring. Is it possible to connect UCCX to both SQL URLs? If 1st SQL is unreachable, UCCX should connect to the 2nd one.

5 REPLIES 5

Graham Old
Rising star
Rising star

Yes, create two data sources one pointing to each SQL server

In your script do an "DB Read" pointing to the first data source.

In the Connection Not Available add a second "DB Read" pointing to the second data source

Untitled.png 

Graham

Hello,

Yes but I have to change a lots steps in script. According to Microsoft JDBC support SQL mirroring but I can't define both SQL hosts in one JDBC connection string. Is some limitation of UCCX or just my mistake in connection string?

Don't forget that CCX 11.6 only officially supports JDBC version 1.2.5

I believe you need JDBC version 2 or later for the database mirroring to work.

I have not tried the JDBC mirroring but I know the above solution works.

I would be interested to know if you can get the JDBC mirroring to work.

Graham

Where I can find version 2.0 driver for UCCX? In SourceForge the newest version is 1.3.1 from 2013. I tried with version downloaded from Microsoft site but UCCX didn't like it.

Zdravko - I'm in the same situation, did you ever find a solution?

 

Thanks,

Dan

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: