如何为c3p0设置getConnection()超时?
|
昨天,AWS的RDS下降了,我们的数据库也下降了。
发生这种情况时,C3P0会尝试建立数据库连接并挂起。我显然希望我的应用程序在这些情况下返回错误页面,而不仅仅是永远等待响应。
代码如下所示:
ComboPooledDataSource db = new ComboPooledDataSource();
...
Connection conn = db.getConnection();
如何设置从c3p0的连接池获取连接的超时时间?
我以为checkoutTimeout()就可以了-但事实并非如此。它是“当池用尽时,调用getConnection()的客户端将等待签入或获取连接的毫秒数。”由于池未用尽(只是不可用),因此这不适用。
我还认为setAcquireRetryAttempts和setAcquireIncrement可以工作-但是它们不起作用,因为连接不会失败,只是不会响应。
当我拉整个堆栈时,它停滞在这里:
SocketInputStream.socketRead0(FileDescriptor, byte[], int, int, int) line: not available [native method]
SocketInputStream.read(byte[], int, int) line: 129
ReadAheadInputStream.fill(int) line: 113
ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(byte[], int, int) line: 160
ReadAheadInputStream.read(byte[], int, int) line: 188
MysqlIO.readFully(InputStream, byte[], int, int) line: 2428
MysqlIO.reuseAndReadPacket(Buffer, int) line: 2882
MysqlIO.reuseAndReadPacket(Buffer) line: 2871
MysqlIO.checkErrorPacket(int) line: 3414
MysqlIO.sendCommand(int, String, Buffer, boolean, String) line: 1936
MysqlIO.sqlQueryDirect(StatementImpl, String, String, Buffer, int, int, int, boolean, String, Field[]) line: 2060
JDBC4Connection(ConnectionImpl).execSQL(StatementImpl, String, int, Buffer, int, int, boolean, String, Field[], boolean) line: 2542
JDBC4PreparedStatement(PreparedStatement).executeInternal(int, Buffer, boolean, boolean, Field[], boolean) line: 1734
JDBC4PreparedStatement(PreparedStatement).executeQuery() line: 1885
NewProxyPreparedStatement.executeQuery() line: 76
C3P0PooledConnectionPoolManager.initializeAutomaticTestTable(String, DbAuth) line: 799
C3P0PooledConnectionPoolManager.createPooledConnectionPool(DbAuth) line: 696
C3P0PooledConnectionPoolManager.getPool(DbAuth) line: 257
C3P0PooledConnectionPoolManager.getPool() line: 271
ComboPooledDataSource(AbstractPoolBackedDataSource).getNumThreadsAwaitingCheckoutDefaultUser() line: 203
NativeMethodAccessorImpl.invoke0(Method, Object, Object[]) line: not available [native method]
NativeMethodAccessorImpl.invoke(Object, Object[]) line: 39
DelegatingMethodAccessorImpl.invoke(Object, Object[]) line: 25
Method.invoke(Object, Object...) line: 597
BeansUtils.extractAccessiblePropertiesToMap(Map, Object, Collection) line: 359
BeansUtils.appendPropNamesAndValues(StringBuffer, Object, Collection) line: 324
ComboPooledDataSource.toString() line: 539
ComboPooledDataSource(AbstractPoolBackedDataSource).getPoolManager() line: 462
ComboPooledDataSource(AbstractPoolBackedDataSource).getConnection() line: 128
当我用Google搜索“ socketRead0超时”和“ socketRead0挂起”时,我看到了很多问题,但没有真正的解决方案。
有什么办法可以在这里强制超时吗?
谢谢!
没有找到相关结果
已邀请:
2 个回复
邵酮
犀耽澄协吻