Web Images Videos Maps News Shopping Gmail more »
Recently Visited Groups | Help | Sign in
Google Groups Home
NBear Google Group
Home
+ new post
Pages
Files
About this group
Join this group
连接其他人数据库做插入修改操作时，出现下列异常：
Options
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
   5 messages - Collapse all  -  Translate all to Translated (View all originals)
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 
From:
To:
Cc:
Followup To:
Add Cc | Add Followup-to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers you hear
 
Lex  
View profile   Translate to Translated (View Original)
(1 user)  More options Dec 20 2006, 1:31 am
From: "Lex" <cuili...@gmail.com>
Date: Tue, 19 Dec 2006 22:31:30 -0800
Local: Wed, Dec 20 2006 1:31 am
Subject: 连接其他人数据库做插入修改操作时，出现下列异常：
Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author
"事务已被隐式或显式提交，或已终止。"

数据库在本机的时候，没有出现该问题。
但数据库与程序不在一台机器时，做数据库写操作就会出现这个问题。
所以想请教一下Teddy。


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Teddy  
View profile   Translate to Translated (View Original)
 More options Dec 20 2006, 1:36 am
From: Teddy <shijie...@gmail.com>
Date: Wed, 20 Dec 2006 14:36:30 +0800
Local: Wed, Dec 20 2006 1:36 am
Subject: Re: 连接其他人数据库做插入修改操作时，出现下列异常：
Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author

你使用的是默认的基于msdtc的事务还是基于Gateway.BeginTransaction
()的事务呢？如果是前者，建议改为后一方案试试，因为最有可能的原因还是默认的基于msdtc的事务的问题。在本机调试时，由于数据库在同一机器，msdtc 总能工作正常，跨机器时可能就会受各种原因的影响，比如防火墙等。

Teddy

On 12/20/06, Lex <cuili...@gmail.com> wrote:


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Lex  
View profile   Translate to Translated (View Original)
 More options Dec 20 2006, 9:18 pm
From: "Lex" <cuili...@gmail.com>
Date: Wed, 20 Dec 2006 18:18:44 -0800
Local: Wed, Dec 20 2006 9:18 pm
Subject: Re: 连接其他人数据库做插入修改操作时，出现下列异常：
Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author
但我并未使用事务。怎么还会有这样的提示？

    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Teddy  
View profile   Translate to Translated (View Original)
 More options Dec 20 2006, 9:23 pm
From: Teddy <shijie...@gmail.com>
Date: Thu, 21 Dec 2006 10:23:41 +0800
Local: Wed, Dec 20 2006 9:23 pm
Subject: Re: 连接其他人数据库做插入修改操作时，出现下列异常：
Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author

默认情况下，只要有些操作，nbear内部就可能使用事务，默认的事务基于msdtc。可以通过显式使用gateway.BeginTransaction
()方式的事务来完全避免msdtc方式的事务。关于msdtc导致的报你遇到的这个错误的问题的原因，可以参考一下这篇文章：
http://www.cnblogs.com/hotsoho.net/archive/2006/12/20/598620.html

Teddy

On 12/21/06, Lex <cuili...@gmail.com> wrote:


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Teddy  
View profile   Translate to Translated (View Original)
 More options Dec 20 2006, 9:23 pm
From: Teddy <shijie...@gmail.com>
Date: Thu, 21 Dec 2006 10:23:57 +0800
Local: Wed, Dec 20 2006 9:23 pm
Subject: Re: 连接其他人数据库做插入修改操作时，出现下列异常：
Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author

"只要有写操作"

On 12/21/06, Teddy <shijie...@gmail.com> wrote:


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions « Newer topic     Older topic »

Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2009 Google