English 中文(简体)
oracle. ucp. jdbc. PoolData 源工具与 oracle.jdbc. ReadTimeout 不取消查询
原标题:oracle.ucp.jdbc.PoolDataSourceFactory and oracle.jdbc.ReadTimeout doesn t cancel the query

我有一个比 oracle.jdbc.ReadTimeout 指定的值更长的查询。 它与 SQL 可回收例外失败, 完全有效。 除了该查询无法取消, 甲骨文一直在研究它。 试图抓住这个例外并取消语句失败, 因为语句已经关闭 。

最佳回答

这是愚蠢的。 查询超时应该设置为 < a href=" http://docs. oracle. com/javase/ 1. 4.2/docs/ api/ java/ sql/ statement. html#setQueryTimeout% 28int% 29" rel=“ nofollow” > statement. setQueryTimeout () , 然后查询会被正确取消 。 基本上设置的QueryTimeout 应该总是低于 oracle.jdbc. ReadTimeout, 所有人都会高兴的 。

问题回答

暂无回答




相关问题
Spring Properties File

Hi have this j2ee web application developed using spring framework. I have a problem with rendering mnessages in nihongo characters from the properties file. I tried converting the file to ascii using ...

Logging a global ID in multiple components

I have a system which contains multiple applications connected together using JMS and Spring Integration. Messages get sent along a chain of applications. [App A] -> [App B] -> [App C] We set a ...

Java Library Size

If I m given two Java Libraries in Jar format, 1 having no bells and whistles, and the other having lots of them that will mostly go unused.... my question is: How will the larger, mostly unused ...

How to get the Array Class for a given Class in Java?

I have a Class variable that holds a certain type and I need to get a variable that holds the corresponding array class. The best I could come up with is this: Class arrayOfFooClass = java.lang....

SQLite , Derby vs file system

I m working on a Java desktop application that reads and writes from/to different files. I think a better solution would be to replace the file system by a SQLite database. How hard is it to migrate ...

热门标签