JDBC Connection - Driver class not correct when testing connection

Identity Security Cloud (ISC) ISC Discussion and Questions
,
1

Hi all,

I am trying to setup a JDBC connection to an Azure SQL server.
I have configured the Account query and test query, not the group query.
I have uploaded the driver and restarted the VA cluster, but when I test the connection I get the following error:
Error occurred before establishing the connection with Server. java.lang.ClassNotFoundException : test configuration

This reads to me as if the system is not taking the driver class configuration.

I later also tried to configure the group query, thinking it might be some issue with the connection test if there is no group, yet same result.

Any help would be appreciated.

1 Like
2

@ioosterlinck please check if jar file is there under this folder

image
image913×120 32 KB

1 Like
3

Thank you for your reply.
Even though I uploaded the jar via the UI (multiple times) it did not arrive on the VA’s.
I am also wondering how this would work, since every source requires the JAR to be uploaded, and this appears to be a rather specific folder…

4

hey Istvan, restart the ccg into you VA. that should solve it . If not reset the whole VA, look for upodates.

1 Like
5

Hi Ivan,
Thanks for your suggestion.
We have done just that, but no luck, still the same error.
Also, no updates are available for the VA.

6

Try to remove the JDBC file , save the conector , then upload it again.

1 Like
7

Follow this steps
Here is that text converted to a markdown numbered list:

  1. change the va cluster
  2. delete the jar
  3. save the config
  4. reboot your older va
  5. change the cluster again
  6. add the jar file save it
  7. try and check if the file is there

Thanks

1 Like
8

Hi all,
Thanks for your suggestions.
It turns out that finally there was an issue with the jar. After re-uploading and restarting the VA it got resolved.

9

thts awesome! glad to help