项目启动报错:oracle/sql/converter_xcharset/lx20354.glb 真实报错 ORA-28040: No matching authentication protocol

项目启动报错:

16-Mar-2022 16:37:53.084 信息 [Druid-ConnectionPool-Create-1590993442] org.apache.catalina.loader.WebappClassLoaderBase.checkStateForResourceLoading Illegal access: this web application instance has been stopped already. Could not load [oracle/sql/converter_xcharset/lx20354.glb]. The following stack trace is thrown for debugging purposes as well as to attempt to terminate the thread which caused the illegal access.
 java.lang.IllegalStateException: Illegal access: this web application instance has been stopped already. Could not load [oracle/sql/converter_xcharset/lx20354.glb]. The following stack trace is thrown for debugging purposes as well as to attempt to terminate the thread which caused the illegal access.
 at org.apache.catalina.loader.WebappClassLoaderBase.checkStateForResourceLoading(WebappClassLoaderBase.java:1305)
 at org.apache.catalina.loader.WebappClassLoaderBase.getResource(WebappClassLoaderBase.java:986)
 at java.lang.Class.getResource(Class.java:2267)
 at oracle.sql.ConverterArchive.readObj(ConverterArchive.java:395)
 at oracle.sql.converter.CharacterConverterJDBC.getInstance(CharacterConverterJDBC.java:144)
 at oracle.sql.converter.CharacterConverterFactoryJDBC.make(CharacterConverterFactoryJDBC.java:45)
 at oracle.sql.CharacterSetWithConverter.getInstance(CharacterSetWithConverter.java:97)
 at oracle.sql.CharacterSetFactoryThin.make(CharacterSetFactoryThin.java:129)
 at oracle.sql.CharacterSet.make(CharacterSet.java:514)
 at oracle.jdbc.driver.DBConversion.init(DBConversion.java:169)
 at oracle.jdbc.driver.DBConversion.<init>(DBConversion.java:120)
 at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1087)
 at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:308)
 at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:536)
 at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:228)
 at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
 at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
 at com.alibaba.druidonverterArchive.java:395)
 at oracle.sql.converter.CharacterConverterJDBC.getInstance(CharacterConverterJDBC.java:144)
 at oracle.sql.converter.CharacterConverterFactoryJDBC.make(CharacterConverterFactoryJDBC.java:45)
 at oracle.sql.CharacterSetWithConverter.getInstance(CharacterSetWithConverter.java:97)
 at oracle.sql.CharacterSetFactoryThin.make(CharacterSetFactoryThin.java:129)
 at oracle.sql.CharacterSet.make(CharacterSet.java:514)
 at oracle.jdbc.driver.DBConversion.init(DBConversion.java:169)
 at oracle.jdbc.driver.DBConversion.<init>(DBConversion.java:120)
 at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1087)
 at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:308)
 at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:536)
 at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:228)
 at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
 at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
 at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:148)
 at com.alibaba.druid.filter.stat.StatFilter.connection_connect(StatFilter.java:211)
 at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:142)
 at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1386)
 at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1440)
 at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:1934)

这是一个坑,jdbc 会不停的 创建连接 不停的出错 然后将真正的报错原因给刷上去,要么即使停止启动 要么在最后一行报错com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:1934)打断点进去 看具体报错
我点进去看 是这个样子
由此可见真实报错是ORA-28040: No matching authentication protocol
这个问题 也是个坑 很少出现在项目启动上,一般都是plsq 或者其他三方工具连接oracle时 驱动不匹配,但大概意思 就是本地驱动 和 数据库不匹配,
所以 我检查一下项目依赖包里面的ojdbc版本
版本6.0 我也不知道是高还是低,我检查了一下数据库版本

 select * from v$version

发现数据库版本是12.0 ,干脆 我就去找了个ojdbc 12.0的jar包 ,也可以自己去找对应的版本

在pom里面引入 这个jar包 ,重新启动就行了

里面是ojbc的jar包
–来自百度网盘超级会员V3的分享
hi，这是我用百度网盘分享的内容~复制这段内容打开「百度网盘」APP即可获取
链接: https://pan.baidu.com/s/1Nt2CQ-ouIbVSzIkkbgXh8Q
提取码:d1vb