# JDBC Integration Issue with SailPoint Class

**URL:** <https://developer.sailpoint.com/discuss/t/jdbc-integration-issue-with-sailpoint-class/70227>\
**Category:** SHF Discussion and Questions\
**Tags:** sailpoint-identity-security\
**Created:** [June 29, 2024, 7:29am UTC](https://developer.sailpoint.com/discuss/t/jdbc-integration-issue-with-sailpoint-class/70227 "2024-06-29T07:29:45Z")\
**Posts on this page:** 14\
**Page:** 1

<div class="post-metadata">

**Author:** ![Karthikeyan\_U](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/karthikeyan_u/32/23649_2.png) [@Karthikeyan\_U](https://developer.sailpoint.com/discuss/u/Karthikeyan_U)\
**Post date:** [June 29, 2024, 7:29am UTC](https://developer.sailpoint.com/discuss/t/jdbc-integration-issue-with-sailpoint-class/70227/1 "2024-06-29T07:29:45Z")

</div>

Hi all,

I was trying to on-board a JDBC application and I got the weird issue saying that JDBC class itself not found, has anyone come across this issue?

```auto
"exception":{"stacktrace":"java.lang.RuntimeException: sailpoint.tools.GeneralException: Couldn't load connector class: sailpoint.connector.JDBCConnector
	at com.sailpoint.utilities.ExceptionUtil.wrapChecked(ExceptionUtil.java:114)
	at com.sailpoint.ccg.cloud.container.Container.getConnector(Container.java:195)
	at com.sailpoint.ccg.cloud.container.Container.testConnection(Container.java:324)
	at com.sailpoint.ccg.cloud.container.ContainerIntegration.ping(ContainerIntegration.java:73)
	at com.sailpoint.ccg.handler.TestConnectionHandler.invoke(TestConnectionHandler.java:29)
	at sailpoint.gateway.accessiq.CcgPipelineMessageHandler.handleMessage_aroundBody0(CcgPipelineMessageHandler.java:47)
	at sailpoint.gateway.accessiq.CcgPipelineMessageHandler$AjcClosure1.run(CcgPipelineMessageHandler.java:1)
	at org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:167)
	at com.sailpoint.tracing.otel.TracedAspect.lambda$traceExecution$0(TracedAspect.java:34)
	at com.sailpoint.tracing.otel.GlobalTracer.trace(GlobalTracer.java:157)
	at com.sailpoint.tracing.otel.GlobalTracer.trace(GlobalTracer.java:136)
	at com.sailpoint.tracing.otel.GlobalTracer.trace(GlobalTracer.java:124)
	at com.sailpoint.tracing.otel.TracedAspect.traceExecution(TracedAspect.java:36)
	at sailpoint.gateway.accessiq.CcgPipelineMessageHandler.handleMessage(CcgPipelineMessageHandler.java:36)
	at com.sailpoint.pipeline.server.PipelineServer$InboundQueueListener$MessageHandler.run(PipelineServer.java:369)
	at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
	at java.base/java.lang.Thread.run(Thread.java:829)
Caused by: sailpoint.tools.GeneralException: Couldn't load connector class: sailpoint.connector.JDBCConnector
	at sailpoint.connector.ConnectorFactory.createConnector(ConnectorFactory.java:179)
	at sailpoint.connector.ConnectorFactory.getConnector(ConnectorFactory.java:99)
	at sailpoint.connector.ConnectorFactory.getConnector(ConnectorFactory.java:47)
	at com.sailpoint.ccg.cloud.container.Container.lambda$getConnector$0(Container.java:195)
	at com.sailpoint.utilities.ExceptionUtil.wrapChecked(ExceptionUtil.java:110)
	... 19 more`Preformatted text`

```

---

<div class="post-metadata">

**Author:** ![KRM7](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/krm7/32/2685_2.png) [@KRM7](https://developer.sailpoint.com/discuss/u/KRM7)\
**Post date:** [June 29, 2024, 8:22am UTC](https://developer.sailpoint.com/discuss/t/jdbc-integration-issue-with-sailpoint-class/70227/2 "2024-06-29T08:22:31Z")

</div>

I believe you have already uploaded the relevant JAR files for the DB you are connecting to, if not upload them. If already uploaded, check the type and versions.

Thanks  
Krish

---

<div class="post-metadata">

**Author:** ![Karthikeyan\_U](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/karthikeyan_u/32/23649_2.png) [@Karthikeyan\_U](https://developer.sailpoint.com/discuss/u/Karthikeyan_U)\
**Post date:** [June 30, 2024, 4:25pm UTC](https://developer.sailpoint.com/discuss/t/jdbc-integration-issue-with-sailpoint-class/70227/3 "2024-06-30T16:25:09Z")

</div>

Yes I did, but still I am seeing the same problem

---

<div class="post-metadata">

**Author:** ![varshini303](https://avatars.discourse-cdn.com/v4/letter/v/9d8465/32.png) [@varshini303](https://developer.sailpoint.com/discuss/u/varshini303)\
**Post date:** [July 1, 2024, 4:33am UTC](https://developer.sailpoint.com/discuss/t/jdbc-integration-issue-with-sailpoint-class/70227/4 "2024-07-01T04:33:54Z")

</div>

Hi @Karthikeyan_U

Please check for any updates in VA and can you restart it?

> [@Couldn't load connector class: sailpoint.connector.ADLDAPConnector](https://developer.sailpoint.com/discuss/t/couldnt-load-connector-class-sailpoint-connector-adldapconnector/13387/4):
>
> Try running the commands: sudo update\_engine\_client -check\_for\_update sudo reboot

Thanks!

---

<div class="post-metadata">

**Author:** ![Karthikeyan\_U](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/karthikeyan_u/32/23649_2.png) [@Karthikeyan\_U](https://developer.sailpoint.com/discuss/u/Karthikeyan_U)\
**Post date:** [July 30, 2024, 2:17pm UTC](https://developer.sailpoint.com/discuss/t/jdbc-integration-issue-with-sailpoint-class/70227/5 "2024-07-30T14:17:40Z")

</div>

Hi Varshini,

The problem is still not resolved, even after multiple update and restart. One main thing I notice is that the ccg version are not getting updated.

 ![undefined](https://global.discourse-cdn.com/sailpoint/original/2X/3/37dcc7d00c75c89b2959d6eda7d50149603a0529.png)

Not sure is it something issue with my VA.

Thanks,  
Karthi

---

<div class="post-metadata">

**Author:** ![hranjan3](https://avatars.discourse-cdn.com/v4/letter/h/ecb155/32.png) [@hranjan3](https://developer.sailpoint.com/discuss/u/hranjan3)\
**Post date:** [July 30, 2024, 3:10pm UTC](https://developer.sailpoint.com/discuss/t/jdbc-integration-issue-with-sailpoint-class/70227/6 "2024-07-30T15:10:13Z")

</div>

Could you please post here version of your db and the jar file version you are using.

---

<div class="post-metadata">

**Author:** ![Karthikeyan\_U](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/karthikeyan_u/32/23649_2.png) [@Karthikeyan\_U](https://developer.sailpoint.com/discuss/u/Karthikeyan_U)\
**Post date:** [July 30, 2024, 3:14pm UTC](https://developer.sailpoint.com/discuss/t/jdbc-integration-issue-with-sailpoint-class/70227/7 "2024-07-30T15:14:27Z")

</div>

DB Version:

 ![undefined](https://global.discourse-cdn.com/sailpoint/original/2X/1/1aa92c8790d1fd6867d60672eb29d953c9c1b6df.png)

JAR Version: mssql-jdbc-12.6.1.jre8.jar

But still I am wondering , you have any clue why the ccg version is not getting updated?

---

<div class="post-metadata">

**Author:** ![agutschow](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/agutschow/32/8543_2.png) [@agutschow](https://developer.sailpoint.com/discuss/u/agutschow)\
**Post date:** [July 30, 2024, 4:31pm UTC](https://developer.sailpoint.com/discuss/t/jdbc-integration-issue-with-sailpoint-class/70227/8 "2024-07-30T16:31:01Z")

</div>

@Karthikeyan_U

If your ccg version is not updated, I am wondering whether if it is actually downloading your jdbc jar files at all.

Can you try running `sudo docker ps -a` and `sudo systemctl status ccg`?

Can you check your ccg\_start.log, charon.log, and the va\_agent.log to see if there are any errors about the startup or connectivity with ISC?

Do you just have one VA or multiple VAs in this cluster? Are any of them up to date?

Alicia

---

<div class="post-metadata">

**Author:** ![Karthikeyan\_U](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/karthikeyan_u/32/23649_2.png) [@Karthikeyan\_U](https://developer.sailpoint.com/discuss/u/Karthikeyan_U)\
**Post date:** [July 30, 2024, 7:04pm UTC](https://developer.sailpoint.com/discuss/t/jdbc-integration-issue-with-sailpoint-class/70227/9 "2024-07-30T19:04:08Z")

</div>

> [@agutschow](#):
>
> sudo systemctl status ccg

Hi @agutschow ,

This is what I see after running those commands,

 ![image](https://global.discourse-cdn.com/sailpoint/original/2X/8/87babe4be7d61315433ed4b476e024cbbc4cd698.png)  
 ![image](https://global.discourse-cdn.com/sailpoint/original/2X/f/f0ff420fcacd361788160fae65e5a0bff3e9115e.png)

va\_agent log says connection to ISC is successful

 ![image](https://global.discourse-cdn.com/sailpoint/original/2X/5/5d86af636356bd955c0f32a436cdf5ff90bf5052.jpeg)

Regards,  
Karthi

---

<div class="post-metadata">

**Author:** ![Karthikeyan\_U](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/karthikeyan_u/32/23649_2.png) [@Karthikeyan\_U](https://developer.sailpoint.com/discuss/u/Karthikeyan_U)\
**Post date:** [July 30, 2024, 7:20pm UTC](https://developer.sailpoint.com/discuss/t/jdbc-integration-issue-with-sailpoint-class/70227/10 "2024-07-30T19:20:27Z")

</div>

Additionally when I ran the stunt script there are four test cases are failing  
Uploading: Stunt-Script-Log.txt…

Additionally I have modified the config.yaml file POD value for the VA connection as per the below post  
[https://developer.sailpoint.com/discuss/t/ambassadors-va-configuration-not-working/68070/29](https://developer.sailpoint.com/discuss/t/ambassadors-va-configuration-not-working/68070/29)

---

<div class="post-metadata">

**Author:** ![agutschow](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/agutschow/32/8543_2.png) [@agutschow](https://developer.sailpoint.com/discuss/u/agutschow)\
**Post date:** [July 30, 2024, 8:36pm UTC](https://developer.sailpoint.com/discuss/t/jdbc-integration-issue-with-sailpoint-class/70227/11 "2024-07-30T20:36:30Z")

</div>

@Karthikeyan_U

Can you try uploading your stunt results again?

Can you try running

```auto
sudo docker exec ls -al /opt/sailpoint/ccg/lib/custom

```

Do you have any other sources attached to this VA?

Thanks,

Alicia

---

<div class="post-metadata">

**Author:** ![Karthikeyan\_U](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/karthikeyan_u/32/23649_2.png) [@Karthikeyan\_U](https://developer.sailpoint.com/discuss/u/Karthikeyan_U)\
**Post date:** [July 31, 2024, 11:43am UTC](https://developer.sailpoint.com/discuss/t/jdbc-integration-issue-with-sailpoint-class/70227/12 "2024-07-31T11:43:13Z")

</div>

> [@agutschow](#):
>
> ```auto
> sudo docker exec ls -al /opt/sailpoint/ccg/lib/custom
> 
> ```

Hi @agutschow ,  
This command is not working since it requires the root access. Added the stunt log.

[Stunt-Script-Log.txt](https://developer.sailpoint.com/discuss/uploads/short-url/so2jzL1FWN5YjyHPpQt13qbEjVL.txt) (13.7 KB)

Thanks,  
Karthi

---

<div class="post-metadata">

**Author:** ![Karthikeyan\_U](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/karthikeyan_u/32/23649_2.png) [@Karthikeyan\_U](https://developer.sailpoint.com/discuss/u/Karthikeyan_U)\
**Post date:** [July 31, 2024, 11:45am UTC](https://developer.sailpoint.com/discuss/t/jdbc-integration-issue-with-sailpoint-class/70227/13 "2024-07-31T11:45:49Z")

</div>

Hi all,

Thanks for all the valuable suggestions.  
I was able to fix the issue by downloading the new vm(Ambassador one) from the developer portal and configured the VA without modifying the POD in the config.yaml file. Now I see the successful connection for AD and JDBC source.

Thanks,  
Karthi

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/sailpoint/original/2X/f/f2136700ed5e3703e0b85e02f6be799dacca7735.png) [@system](https://developer.sailpoint.com/discuss/u/system)\
**Post date:** [September 29, 2024, 11:46am UTC](https://developer.sailpoint.com/discuss/t/jdbc-integration-issue-with-sailpoint-class/70227/14 "2024-09-29T11:46:32Z")

</div>

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