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,
