UCCX JDBC URL connection to multiple SQL URL

[Zdravko Nozharov]

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.

[Graham Old]

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

 

Graham

[Zdravko Nozharov]

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?

[Graham Old]

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

[Zdravko Nozharov]

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.

[dlcharville]

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

Thanks,

Dan