oracle aq 超时,java - 是什么导致此JMS错误连接到OracleAQ？ - 堆栈内存溢出

最新推荐文章于 2023-08-14 11:10:21 发布

litterbug21

最新推荐文章于 2023-08-14 11:10:21 发布

阅读量261

点赞数

文章标签： oracle aq 超时

我从正在侦听OracleAQ的Java服务中收到零星的错误。

它似乎每天晚上都在发生，我不确定发生了什么。真的是数据库连接问题吗？

还是“出队失败”表明它已连接并且发生了其他事情？

以下是例外：

[2013-11-04 18:16:16,508] WARN org.springframework.jms.listener.DefaultMessageListenerContainer - Setup of JMS message listener invoker failed for destination 'MYCOMPANY_INFO_QUEUE' - trying to recover. Cause: JMS-120: Dequeue failed; nested exception is java.sql.SQLException: Io exception: Socket read timed out

oracle.jms.AQjmsException: JMS-120: Dequeue failed

at oracle.jms.AQjmsError.throwEx(AQjmsError.java:311)

at oracle.jms.AQjmsConsumer.dequeue(AQjmsConsumer.java:2234)

at oracle.jms.AQjmsConsumer.receiveFromAQ(AQjmsConsumer.java:1028)

at oracle.jms.AQjmsConsumer.receiveFromAQ(AQjmsConsumer.java:951)

at oracle.jms.AQjmsConsumer.receiveFromAQ(AQjmsConsumer.java:929)

at oracle.jms.AQjmsConsumer.receive(AQjmsConsumer.java:781)

at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.receiveMessage(AbstractPollingMessageListenerContainer.java:430)

at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.doReceiveAndExecute(AbstractPollingMessageListenerContainer.java:310)

at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.receiveAndExecute(AbstractPollingMessageListenerContainer.java:263)

at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.invokeListener(DefaultMessageListenerContainer.java:1096)

at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.executeOngoingLoop(DefaultMessageListenerContainer.java:1088)

at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.run(DefaultMessageListenerContainer.java:985)

at java.lang.Thread.run(Thread.java:662)

[Linked-exception]

java.sql.SQLException: Io exception: Socket read timed out

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)

at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:976)

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)

at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)

at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3329)

at oracle.jms.AQjmsConsumer.dequeue(AQjmsConsumer.java:1732)