On Fri, Mar 21, 2014 at 4:06 PM, E. D. Epperson Jr
wrote:
> I 'stumbled' across some code that gave me a pretty good idea. Here is what
> I came up with, is this a good way of doing it? Also
> what would I use for Chaos? What is a good value for the waittimeout?
You can check sources directly.
I 'stumbled' across some code that gave me a pretty good idea. Here is
what I came up with, is this a good way of doing it? Also
what would I use for Chaos? What is a good value for the waittimeout?
Finally, I need to verify my understanding of the Wait and WaitTimeout.
Wait says if another tr
Pardon my ignorance but is there any documentation on FbTransaction and
FbTransactionOptions?
What I want to do is start a transaction with IsolationLevel of snapshot,
and with wait timeout of 1/10 second.
Here is what I've come up with, but not sure I've the correct behavior nor
if this is even
On Thu, Mar 20, 2014 at 3:16 PM, E. D. Epperson Jr
wrote:
> recommend something I could try to reduce or eliminate the deadlocks
Without a knowledge of what and why the program is doing this it's
hard to have some advice. Basically you want to eliminate the records
being updated from two transact
I know. I'm rewriting that part of the code to try to eliminate the
multiple simultaneous hits. But I had thought Snapshot would eliminate it.
Can you recommend something I could try to reduce or eliminate the
deadlocks? I haven't put any WAIT into any of these procedures. Should I
try that?
That's normal FbException you get from server. Nothing magic. You're
getting deadlock in your transaction(s).
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
--
Learn Gr
I finally got an error message on this issue. Here is the data I pulled,
Maybe this will shed some light on what I'm doing wrong.
ErrorMsg: deadlock
ErrorData:
Procedure=DataAdapterReturnDT|SprocName=USPVALIDATESESSION|GUID=7c3713d9-26bd-43f5-ba64-5bd1eb8e3fa1|NEWSESSIONTIMEOUT=20|
ErrorStack:
When I hit this line:
conn.Open();
it breaks out of that block without throwing an exception. Actually it
breaks out of that class completely, but it doesn't return a datatable so
my calling class experiences a datatable == null exception, which I handle.
here is the code sample where I open the
On Wed, Mar 19, 2014 at 8:00 PM, E. D. Epperson Jr
wrote:
> At some point during every day, after creating the FbConnection, I then
> Open. It apparently throws an error, but my try/catch doesn't catch it.
How do you know it throw an exception? Did you tried attaching
debugger to VS (from other
