【异常】使用Phoenix api操作hbase 报错java.lang.ClassNotFoundException: org.apache.phoenix.jdbc.PhoenixDriver

我不是女神ヾ 2024-03-22 12:31 34阅读 0赞

## 一、报错内容 ##

想要实现基于Springboot+Phoenix+Mybatis来调用Hbase的数据，我得到了如下的异常。

java.lang.ClassNotFoundException: org.apache.phoenix.jdbc.PhoenixDriver
    	at java.base/jdk.internal.loader.BuiltinClassLoader.loadClass(BuiltinClassLoader.java:581) ~[na:na]
    	at java.base/jdk.internal.loader.ClassLoaders$AppClassLoader.loadClass(ClassLoaders.java:178) ~[na:na]
    	at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:521) ~[na:na]
    	at java.base/java.lang.Class.forName0(Native Method) ~[na:na]
    	at java.base/java.lang.Class.forName(Class.java:315) ~[na:na]
    	at com.alibaba.druid.util.JdbcUtils.createDriver(JdbcUtils.java:623) ~[druid-1.1.21.jar:1.1.21]
    	at com.alibaba.druid.pool.DruidDataSource.init(DruidDataSource.java:897) ~[druid-1.1.21.jar:1.1.21]
    	at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1376) ~[druid-1.1.21.jar:1.1.21]
    	at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1372) ~[druid-1.1.21.jar:1.1.21]
    	at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:109) ~[druid-1.1.21.jar:1.1.21]
    	at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111) ~[spring-jdbc-4.3.13.RELEASE.jar:4.3.13.RELEASE]
    	at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77) ~[spring-jdbc-4.3.13.RELEASE.jar:4.3.13.RELEASE]
    	at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:80) ~[mybatis-spring-2.0.2.jar:2.0.2]
    	at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:67) ~[mybatis-spring-2.0.2.jar:2.0.2]
    	at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:336) ~[mybatis-3.5.2.jar:3.5.2]
    	at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:85) ~[mybatis-3.5.2.jar:3.5.2]
    	at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62) ~[mybatis-3.5.2.jar:3.5.2]

![在这里插入图片描述][1f0e8a5595f94c8098df1b247c7ca5f3.png]  
![在这里插入图片描述][97ec53dd1494423292c8680602af7b4f.png]

## 二、报错说明 ##

缺少相关的PhoenixDriver驱动导致的错误

## 三、报错解决 ##

> 找到对应的版本的Hbase  
> ![在这里插入图片描述][f6d45d1302b44a179ab47933721a11c8.png]

### 3.1 在pom文件添加依赖（Maven项目） ###

如果是maven项目的话，在pom文件添加对应版本的依赖即可

<dependency>
        <groupId>org.apache.phoenix</groupId>
        <artifactId>phoenix-core</artifactId>
        <version>5.0.0-HBase-2.0</version>
    </dependency>
    
    <dependency>
        <groupId>org.apache.hadoop</groupId>
        <artifactId>hadoop-common</artifactId>
        <version>3.1.3</version>
    </dependency>
    
    <dependency>
        <groupId>com.google.guava</groupId>
        <artifactId>guava</artifactId>
        <version>27.0-jre</version>
    </dependency>

### 3.2 下载对应的 驱动 jar包放到项目lib下（非Maven项目） ###

不是maven项目的话，下载对应的 驱动 jar包放到项目lib下即可，和MySQL类似。

[1f0e8a5595f94c8098df1b247c7ca5f3.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/22/270496badde04c1cb1ef8aa210a2f8f4.png
[97ec53dd1494423292c8680602af7b4f.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/22/f265cfbea9554a7bbbb74922fc51585d.png
[f6d45d1302b44a179ab47933721a11c8.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/22/caa9ae067707411ca2e8c0b29a705637.png