JDBC Source configuration throws invalid configuration exception

Identity Security Cloud (ISC) ISC Discussion and Questions
1

I am trying to configure a JDBC source in IDN which is using MSSQL Driver jars. Test connection throws Invalid configuration exception.
We have detected an error from the managed system.

Error Received:

[ InvalidConfigurationException ] [ Possible suggestions ] Verify that the driver details are correct/Missing required jar. [ Error details ] Error occurred before establishing the connection with Server. java.lang.ClassNotFoundException : test configuration

Any help is highly appreciated.

2

Hello,

Have you correctly configured the driver in the account request ?
For MS SQL, we are using : com.microsoft.sqlserver.jdbc.SQLServerDriver

Hope it can help

3

Did you upload the sql JDBC jar file in your source config ?

Upload the jar file and then restart VA, it will work.

4

Thanks Alexandre. I am using the mentioned driver only.

5

Thanks Krishna. Couple of questions. Do we have to upload those jars in the VA? If yes why. The configuration page itself is asking for us to upload the jar file. If I understand what you are saying, we have to upload the jar files in two places. One through the IdN configuration page. Another place is in the VA.
Any help is highly appreciated. Thanks

6

No, you just need to upload jars through UI.

Once you upload, you just need to restart the VA cluster.

7

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.