java.sql.SQLException: 不支持的字符集 (在类路径中添加 orai18n.jar): ZHS16GBK

java.sql.SQLException: 不支持的字符集 (在类路径中添加 orai18n.jar): ZHS16GBK

问题描述

在使用 Mybatis 操作 Oracle 数据库时，报以下错误：

 

 

 

1

2021-05-09 22:13:49.747 ERROR 7664 --- [nio-8081-exec-1] o.a.c.c.C.[.[.[/].[dispatcherServlet]    : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.apache.ibatis.exceptions.PersistenceException: 

2

### Error querying database.  Cause: org.apache.ibatis.executor.result.ResultMapException: Error attempting to get column 'username' from result set.  Cause: java.sql.SQLException: 不支持的字符集 (在类路径中添加 orai18n.jar): ZHS16GBK

3

### The error may exist in com/llm/mapper/oracleMapper/UserOracleMapper.java (best guess)

4

### The error may involve com.llm.mapper.oracleMapper.UserOracleMapper.findAll

5

### The error occurred while handling results

6

### SQL: SELECT * FROM "USER"

7

### Cause: org.apache.ibatis.executor.result.ResultMapException: Error attempting to get column 'username' from result set.  Cause: java.sql.SQLException: 不支持的字符集 (在类路径中添加 orai18n.jar): ZHS16GBK] with root cause

8

​

9

java.sql.SQLException: 不支持的字符集 (在类路径中添加 orai18n.jar): ZHS16GBK

10

at oracle.sql.CharacterSetUnknown.failCharsetUnknown(CharacterSetFactoryThin.java:233) ~[ojdbc8-19.8.0.0.jar:19.8.0.0.0]

11

at oracle.sql.CharacterSetUnknown.convert(CharacterSetFactoryThin.java:194) ~[ojdbc8-19.8.0.0.jar:19.8.0.0.0]

12

...

 

 

 

解决方法

maven 仓库，引入orai18n.jar

地址：https://mvnrepository.com/artifact/cn.easyproject/orai18n/12.1.0.2.0

 

 

 

1

<!-- https://mvnrepository.com/artifact/cn.easyproject/orai18n -->

2

<dependency>

3

    <groupId>cn.easyproject</groupId>

4

    <artifactId>orai18n</artifactId>

5

    <version>12.1.0.2.0</version>

6

</dependency>