SQL 2000和i-net Opta 2000 JDBC的READ_UNCOMMITTED问题 [英] READ_UNCOMMITTED problem with SQL 2000 and i-net Opta 2000 JDBC

问题描述

我将JDBC连接设置为READ UNCOMMITED有问题。


setTransactionIsolation（Connection.TRANSACTION_REA D_UNCOMMITTED）


这会导致很多表格上的阻塞

并且更新或插入无法正常工作。


有没有人有想知道我在这里缺少什么？


我问过i-net支持他们建议在上面的函数之后调用

setAutoCommit（false） />
并且它没有工作。

也建议impltrans = true，我在SQL上更改了该选项
导致更多阻塞。 br />

提前感谢任何信息。

Hi,
I have a problem to set a JDBC connection as READ UNCOMMITED.

setTransactionIsolation(Connection.TRANSACTION_REA D_UNCOMMITTED)

This is causing lots of blocking on tables
and update or insert doesn''t work properly.

Does anyone have any idea what I''m missing here?

I asked i-net support and they suggested to call
setAutoCommit(false) after the above function
and it didn''t work.
also suggested impltrans = true, and I changed that option on SQL
and it caused more blocking.

Thanks in advance for any info.

推荐答案

neo写道：

neo wrote:

我将JDBC连接设置为READ UNCOMMITED有问题。

setTransactionIsolation（Connection.TRANSACTION_REA D_UNCOMMITTED）

这导致很多表格上的阻止
有谁知道我在这里缺少什么？

我问过i-net支持他们建议在上面的函数之后调用
setAutoCommit（false）并且它没有工作。
也建议impltrans = true，我在SQL上改变了这个选项
它导致更多阻塞。

提前感谢任何信息。

Hi,
I have a problem to set a JDBC connection as READ UNCOMMITED.

setTransactionIsolation(Connection.TRANSACTION_REA D_UNCOMMITTED)

This is causing lots of blocking on tables
and update or insert doesn''t work properly.

Does anyone have any idea what I''m missing here?

I asked i-net support and they suggested to call
setAutoCommit(false) after the above function
and it didn''t work.
also suggested impltrans = true, and I changed that option on SQL
and it caused more blocking.

Thanks in advance for any info.

你为什么要让任何人或任何东西读到一个不受欢迎的人/>
交易？如果没有提交......它就不存在。

-

Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http：// www。 outreach.washington.edu/e...oa/aoa_crs.asp
da **** **@x.washington.edu

（将''x''替换为''u''来回复）

Why are you letting anyone, or any thing, read an uncommited
transaction? If it is not committed ... it doesn''t exist.
--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
da******@x.washington.edu
(replace ''x'' with a ''u'' to reply)

Daniel Morgan< da ****** @ x.washington.edu>在消息新闻中写道：< 1069122434.507152@yasure> ...

Daniel Morgan <da******@x.washington.edu> wrote in message news:<1069122434.507152@yasure>...

neo写道：

neo wrote:

我有一个问题要设置一个JDBC连接为READ UNCOMMITED。

setTransactionIsolation（Connection.TRANSACTION_REA D_UNCOMMITTED）

这导致表格上的大量阻塞
并且更新或插入不起作用正确。

有谁知道我在这里缺少什么？

我问过i-net支持他们建议打电话给
setAutoCommit（false）在上面的功能之后它并没有用。
也建议impltrans = true，我在SQL上改变了这个选项
并且它导致了更多的阻塞。
提前感谢您提供任何信息。

Hi,
I have a problem to set a JDBC connection as READ UNCOMMITED.

setTransactionIsolation(Connection.TRANSACTION_REA D_UNCOMMITTED)

This is causing lots of blocking on tables
and update or insert doesn''t work properly.

Does anyone have any idea what I''m missing here?

I asked i-net support and they suggested to call
setAutoCommit(false) after the above function
and it didn''t work.
also suggested impltrans = true, and I changed that option on SQL
and it caused more blocking.

Thanks in advance for any info.

为什么让任何人或任何东西阅读未经审查的交易？如果没有提交......它就不存在。

Why are you letting anyone, or any thing, read an uncommited
transaction? If it is not committed ... it doesn''t exist.

这个函数设置脏读启用。

所以尽管如此有这个连接阻塞，

，仍然可以读取数据。这就是我想要的。

This function sets dirty-read enable.
So even though there is blocking,
with this connection, data can still be read. That''s what I want.

Daniel Morgan <哒****** @ x.washington.edu>写在消息新闻：1069122434.507152@yasure ...

"Daniel Morgan" <da******@x.washington.edu> wrote in message news:1069122434.507152@yasure...

neo写道：

neo wrote:

我有一个问题，设置JDBC连接为READ UNCOMMITED。

setTransactionIsolation（Connection.TRANSACTION_REA D_UNCOMMITTED）

这会导致表格上的大量阻塞
并且更新或插入无法正常工作。

有没有人知道我在这里缺少什么？

我问过i-net支持他们建议在上面之后调用
setAutoCommit（false）功能
它没有用。
也建议impltrans = true，我在SQL上更改了这个选项
它引起了更多阻塞。

谢谢提前获取任何信息。

Hi,
I have a problem to set a JDBC connection as READ UNCOMMITED.

setTransactionIsolation(Connection.TRANSACTION_REA D_UNCOMMITTED)

This is causing lots of blocking on tables
and update or insert doesn''t work properly.

Does anyone have any idea what I''m missing here?

I asked i-net support and they suggested to call
setAutoCommit(false) after the above function
and it didn''t work.
also suggested impltrans = true, and I changed that option on SQL
and it caused more blocking.

Thanks in advance for any info.

为什么让任何人或任何事物都阅读未经审查的交易？如果它没有提交......它就不存在了。

Why are you letting anyone, or any thing, read an uncommited
transaction? If it is not committed ... it doesn''t exist.

啊..这是一个典型的oracleisque响应。当READ_UNCOMMITTED完全合理时，有些情况下会有

。

例如如果您正在运行过去数据的报告（如上周的报告）

，在运行时保证是只读的报告。为什么要关心COMMITTED数据呢？一个简单的脏读

读取将有效地完成工作，但效率更高。


Oracle的MVRC听起来很棒，但除非它提供了一个选项

在没必要的情况下绕过它，这是一种矫枉过正。


rk-

ah.. this is a typical oracleisque response. Well there are
some circumstances when READ_UNCOMMITTED makes perfect sense.
For e.g. if u r running report on past data (like last week''s report)
which is guaranteed to be read-only at the time of running
the report. why bother about COMMITTED data? a simple dirty
read will do the job as effectively, but more efficiently.

Oracle''s MVRC sounds great, but unless it gives an option
to bypass when it is unnecessary, it is an overkill.

rk-

这篇关于SQL 2000和i-net Opta 2000 JDBC的READ_UNCOMMITTED问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！