could not load Database Driver

[Daniel Ortega]

Hi, I have a problem with the jdbc driver, it could not load Database Driver

[Karthikeyan SankaraVadivel]

Hi Daniel, 

Thank you for contacting Syncfusion support.  

Please follow the KB article to configure Database Connection Pooling service to access JDBC data sources in Data integration platform.  

KB link - https://www.syncfusion.com/kb/7678/how-to-create-dbcpconnectionpool-in-syncfusion-data-integration-platform  

By following the steps mentioned steps in the KB article, you can connect with the data source in your processors.  

Please let us know if you need further assistance on this.  

Regards, 

Karthikeyan S 

[Daniel Ortega]

I followed the steps of the kb article, but it gives me an error. please see attached image

Attachment
Attachment: error_7ecf0a2a.zip

[Karthikeyan SankaraVadivel]

Hi Daniel, 

We are unable to reproduce the issue at our end.  

Could you please share the following details to look in to the issue further.  

• Data source – Which you are looking to connect with Data Integration Platform(e.g. , Oracle,SQLserver,MYSQL) .
• Database Driver class name .
• Database Driver Jar , which you have used.
• Data Integration Platform logs from the following location “ <Installed Drive>\Syncfusion\Data Integration\<versionNumber>\SDK\NIFI\logs\”

In addition to that, Please consider the following case while creating DBCPConnectionPool.  

• Remove whitespaces in the connection string if any.
• Make sure that proper Drive class name is provided.
• Ensure that proper JDBC jar is loaded. If you are using Data integration platform v1.1.0.60,  Please use the jar which is compatible with Java7.
• Refer the driver(jar) location in the given format <drive>:\<directory>\<yourjdbc>.jar

Please let us know if you need further assistance.  

 

Regards, 

Karthikeyan S  

[Daniel Ortega]

Hi 

I Can solve it 

thanks very much for your help

[Karthikeyan SankaraVadivel]

Hi Daniel,   

Thank you for contacting Syncfusion Support.     

Please get back to us if you need further assistance. We will happy to assist you.    

Regards,  

Karthikeyan S