JDK1.6连接Oracle12C
应用环境:Jboss4.2+JDK1.6.27+Oracle12C
应用启动后报错如下:
2023-06-16 11:37:48,422 INFO [STDOUT] 2023-06-16 11:37:48,422 [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0] WARN - com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@769652dd -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30).
2023-06-16 11:37:48,423 INFO [STDOUT] 11:37:48.423****** 发生了异常 ******
获取失败: Connections could not be acquired from the underlying database!
2023-06-16 11:37:48,424 INFO [STDOUT] ************
2023-06-16 11:37:48,425 ERROR [STDERR] java.sql.SQLException: Connections could not be acquired from the underlying database!
##查了很多资料
- 1.连接串配置写法问题。
2.复制ojdbc6.jar到…\jboss\server\default\lib和JRE\lib目录下 均无效。
最后,修改oracle数据库的sqlnet.ora文件,增加两行配置后问题解决,注意需要重启监听:lsnrctl reload
SQLNET.ALLOWED_LOGON_VERSION_SERVER=8
SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8