Question

ssh + oracle的java项目,频繁的请求查询数据库会报错

- com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@14143ad -- 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). Last acquisition attempt exception: java.sql.SQLException: Io 异常: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=186646784)(ERR=12519)(ERROR_STACK=(ERROR=(CODE=12519)(EMFI=4)))) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at com.mchange.v2.async.ThreadPerTaskAsynchronousRunner$TaskThread.run(ThreadPerTaskAsynchronousRunner.java:255)

报完这个错后数据库就断掉了。项目也进不去了

Answer 1

Oracle没搞过。
从你报的错误来看，连接池在申请新的连接的时候，被拒绝连接了。
建议你看一下你Oracle的最大连接数是多少。你这里的设置，不要大于Oracle的最大连接数了。

追问

如何修改最大连接数啊。oracle 设置

追答

都说了啊，我没搞过Oracle