Sanjeet,

For the Driver class name, based on Amazon’s documentation [1], you should use:
com.amazon.redshift.jdbc.Driver

You will need to provide the driver, also, and include the full path name in 
the Driver path property. JDBC Drivers are not included with NiFi due to both 
the fact that it would take up a lot of space, and the fact that there are 
typically licensing issues that prevent us from bundling them.

I’m not sure how your 1.12 is configured, but it doesn’t make sense that it 
would work without both of these properties properly configured.

[1] 
https://docs.aws.amazon.com/redshift/latest/mgmt/jdbc20-register-driver-class.html


On Jun 7, 2022, at 12:48 PM, sanjeet rath 
<rath.sanj...@gmail.com<mailto:rath.sanj...@gmail.com>> wrote:

Hi ,

I am seeing one different behaviour of dbcpconnectionpool service in 1.16.1 
version of nifi.

I am passing the Database driver class name  : Jdbc.redshift.RedshiftDriver
And DB connection URL. I am passing the required name & pwd and other things.
Driver path i am not passing anything.

With these values I am seeing no error in 1.12.1  version of nofi , however in 
1.16.1 i am seeing “Driver class jdbc.redshift.redshift.redshift not found.” 
Screenshot is attached for your reference.

Could you please let me know this behaviour is due to some change in 1.16.1 as 
the same controller with the same config 1.12.1 no issue .

Also please let me know how to solve this issue.

Thanks & Regards
Sanjeet




Reply via email to