java.sql.SQLException: 不支持的字符集 (在类路径中添加 orai18n.jar): ZHS16GBK
在使用 Mybatis 操作 Oracle 数据库时,报以下错误:
2022-01-26 10:09:01.490 WARN 15184 --- [nio-8080-exec-1] o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Error: 17056, SQLState: 99999
2022-01-26 10:09:01.490 ERROR 15184 --- [nio-8080-exec-1] o.h.engine.jdbc.spi.SqlExceptionHelper : 不支持的字符集 (在类路径中添加 orai18n.jar): ZHS16GBK
2022-01-26 10:09:01.575 ERROR 15184 --- [nio-8080-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.springframework.orm.jpa.JpaSystemException: could not execute query; nested exception is org.hibernate.exception.GenericJDBCException: could not execute query] with root cause
java.sql.SQLException: 不支持的字符集 (在类路径中添加 orai18n.jar): ZHS16GBK
at oracle.sql.CharacterSetUnknown.failCharsetUnknown(CharacterSetFactoryThin.java:240) ~[ojdbc8-21.3.0.0.jar:21.3.0.0.0]
at oracle.sql.CharacterSetUnknown.convert(CharacterSetFactoryThin.java:201) ~[ojdbc8-21.3.0.0.jar:21.3.0.0.0]
at oracle.jdbc.driver.PhysicalConnection.throughDbCharset(PhysicalConnection.java:11040) ~[ojdbc8-21.3.0.0.jar:21.3.0.0.0]
................
application.properties
中添加依赖orai18n
<!-- https://mvnrepository.com/artifact/com.oracle.database.nls/orai18n -->
<dependency>
<groupId>com.oracle.database.nls</groupId>
<artifactId>orai18n</artifactId>
<version>21.1.0.0</version>
</dependency>