[Firebird-net-provider] [FB-Tracker] Created: (DNET-264) BuildTpb() forgot too implement: IsolationLevel.Snapshot
BuildTpb() forgot too implement: IsolationLevel.Snapshot
-
Key: DNET-264
URL: http://tracker.firebirdsql.org/browse/DNET-264
Project: .NET Data provider
Issue Type: Improvement
Reporter: Van den Wouwer Danny
Assignee: Jiri Cincura
Hi Jiri,
The private method BuildTpb() inside FbTransaction.cs doesn't check the new
IsolationLevel.Snapshot
// Summary:
// Specifies the transaction locking behavior for the connection.
public enum IsolationLevel
{
// Summary:
// A different isolation level than the one specified is being used,
but the
// level cannot be determined.
Unspecified = -1,
//
// Summary:
// The pending changes from more highly isolated transactions cannot
be overwritten.
Chaos = 16,
//
// Summary:
// A dirty read is possible, meaning that no shared locks are issued
and no
// exclusive locks are honored.
ReadUncommitted = 256,
//
// Summary:
// Shared locks are held while the data is being read to avoid dirty
reads,
// but the data can be changed before the end of the transaction,
resulting
// in non-repeatable reads or phantom data.
ReadCommitted = 4096,
//
// Summary:
// Locks are placed on all data that is used in a query, preventing
other users
// from updating the data. Prevents non-repeatable reads but phantom
rows are
// still possible.
RepeatableRead = 65536,
//
// Summary:
// A range lock is placed on the System.Data.DataSet, preventing
other users
// from updating or inserting rows into the dataset until the
transaction is
// complete.
Serializable = 1048576,
//
*// Summary:
// Reduces blocking by storing a version of data that one
application can read
// while another is modifying the same data. Indicates that from one
transaction
// you cannot see changes made in other transactions, even if you
requery.
Snapshot = 16777216,
*}
And it seems that on other places this IsolationLevel.Snapshot is already
introduced (FbConnectionInternal.cs, FbConnectionString.cs, fbMetaData.xml)
So isn't it better to mimic this Isolation better then just taking the default
now (ReadCommitted, NoRecversion):
Shouldn't it be mapped on FbTransactionBehavior.Concurrency?
Like this:
private TransactionParameterBuffer BuildTpb()
{
FbTransactionOptions options = new FbTransactionOptions();
options.WaitTimeout = null;
options.TransactionBehavior = FbTransactionBehavior.Write;
options.TransactionBehavior |= FbTransactionBehavior.Wait;
/* Isolation level */
switch (this.isolationLevel)
{
case IsolationLevel.Serializable:
options.TransactionBehavior |=
FbTransactionBehavior.Consistency;
break;
case IsolationLevel.RepeatableRead:
*case IsolationLevel.Snapshot:*
options.TransactionBehavior |=
FbTransactionBehavior.Concurrency;
break;
case IsolationLevel.ReadUncommitted:
options.TransactionBehavior |=
FbTransactionBehavior.ReadCommitted;
options.TransactionBehavior |=
FbTransactionBehavior.RecVersion;
break;
case IsolationLevel.ReadCommitted:
default:
options.TransactionBehavior |=
FbTransactionBehavior.ReadCommitted;
options.TransactionBehavior |=
FbTransactionBehavior.NoRecVersion;
break;
}
// just empty FbTransactionOptionsValues struct
return this.BuildTpb(options);
}
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Compact Framework: Unable to load assembly..
please, help me to resolve this problem... Firebird dot net connector for compact framework doesn't work :( It raises an error: Could not load type 'FirebirdSql.Data.FirebirdClient.FbConnection' from assembly 'FirebirdSql.Data.FirebirdClient, Version=2.5.0.0, Culture=neutral, PublicKeyToken=3750ABCC3150B00C'. -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Compact Framework: Unable to loadassembly..
Yes, i'm sure that i use the same library... I have only one file FirebirdSql.Data.FirebirdClient.dll ( version 2.5.0 File size: 333 312 bytes file date: 17.05.2009 MD5: fce5f32951b905696fabf76b1ad78f63 ) and this library (with this MD5 checksum) is on the Pocket PC in the same directory as executable file Jiri Cincura disk...@cincura.net wrote : news:d2fa8bfb0908221452w75e99ab4mac39d220f8dda...@mail.gmail.com... On Thu, Aug 20, 2009 at 11:35, Sergioseke...@gmail.com wrote: Are you sure you're using same library for compile and for run? Looks like not. Looks like you have proper version for compile, but something different for run. -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Compact Framework: Unable to loadassembly..
On Sun, Aug 23, 2009 at 00:00, Sergioseke...@gmail.com wrote:
Yes, i'm sure that i use the same library... I have only one file
FirebirdSql.Data.FirebirdClient.dll
(
version 2.5.0
File size: 333 312 bytes
file date: 17.05.2009
MD5: fce5f32951b905696fabf76b1ad78f63
)
and this library (with this MD5 checksum) is on the Pocket PC in the same
directory as executable file
Are you able to run it directly from VS attached to device/emulator
(or deploy it from VS and then manually run)? If not, something is
wrong with your environment.
--
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.cincura.net/ | http://www.ID3renamer.com
--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Compact Framework: Unable toloadassembly..
Are you able to run it directly from VS attached to device/emulator (or deploy it from VS and then manually run)? If not, something is wrong with your environment. i tried to debug project directly from VS 2005 and VS2008 (attached to device) the same problem.. Also i tried to reinstall Windows and VS2008 (clear machine) - the same problem :( Hard reset pocket pc - rebuild an redeploy project from VS - the same problem -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Firebird DDEX error on (Visual Studio 2008) Windows 7
2009/8/17 ibrahim akgün ibrahimak...@msn.com:
Hi all,
i have got problems while getting work Firebird DDEX on visual studio 2008
at Windows 7 OS. i am getting ; The Given assembly name or codebase was
invalid. Exception from HRESULT : 0X80131047 error.And can not connect
firebird and generate db items.My firebird version is 2.5. Beta 2..Everyting
is correct Reg files , client setup , machine.config , and gacutil is ok.but
i could not work.This is about Windows 7 OR something ?
I have W7 VS2010 running DDEX without problems. Did you use version
with SDK or without?
--
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.cincura.net/ | http://www.ID3renamer.com
--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
