The driver should be on NiFi host. Are you running NiFi in clustered mode?
If yes, the driver jar has to be put in all the NiFi hosts that are part of
the cluster in the same exact path. BTW, make sure the jar has read
permissions provided to the user NiFi is running as.
On Wed, Sep 26, 2018 at 2:47 AM l vic wrote:
> I have PutSQL on host 10.10.105.214 trying to execute query on phoenix
> query server on the host 10.10.105.202 and i see the following error:
>
> Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC
> driver of class 'org.apache.phoenix.jdbc.PhoenixDriver' for connect URL
> 'jdbc:10.10.105.202:2181:/hbase-unsecure
> '
> at
> org.apache.commons.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1452)
> at
> org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1371)
> at
> org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
> at
> org.apache.nifi.dbcp.DBCPConnectionPool.getConnection(DBCPConnectionPool.java:272)
> ... 22 common frames omitted
> Caused by: java.sql.SQLException: No suitable driver
> at java.sql.DriverManager.getDriver(DriverManager.java:315)
>
> For DBCPConnectionPool ( Enabled- no problem) I have the following
> settings:
> jdbc:10.10.105.202:2181:/hbase-unsecure
> org.apache.phoenix.jdbc.PhoenixDriver
> file:usr/hdf/current/phoenix/phoenix-client.jar
> Should the driver (/usr/hdf/current/phoenix/phoenix-client.jar) be on NiFi
> or Phoenix host?
> Seems as the problem is in the driver itself ( connection string works):
> how can i get to the particular cause? Stack trace doesn't really help...
> Any idea where the problem can be?
> Thanks,
>
>
