Menu
▾
▴
firebird-net-provider — All about development of the MS .Net provider
You can subscribe to this list here.
| 2002 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(10) |
Nov
(55) |
Dec
(36) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2003 |
Jan
(38) |
Feb
(108) |
Mar
(79) |
Apr
(95) |
May
(64) |
Jun
(130) |
Jul
(146) |
Aug
(121) |
Sep
(96) |
Oct
(149) |
Nov
(161) |
Dec
(113) |
| 2004 |
Jan
(113) |
Feb
(163) |
Mar
(248) |
Apr
(132) |
May
(157) |
Jun
(160) |
Jul
(236) |
Aug
(284) |
Sep
(293) |
Oct
(277) |
Nov
(257) |
Dec
(356) |
| 2005 |
Jan
(203) |
Feb
(190) |
Mar
(220) |
Apr
(165) |
May
(124) |
Jun
(160) |
Jul
(190) |
Aug
(142) |
Sep
(152) |
Oct
(189) |
Nov
(187) |
Dec
(159) |
| 2006 |
Jan
(170) |
Feb
(151) |
Mar
(212) |
Apr
(262) |
May
(226) |
Jun
(196) |
Jul
(223) |
Aug
(165) |
Sep
(163) |
Oct
(348) |
Nov
(225) |
Dec
(141) |
| 2007 |
Jan
(261) |
Feb
(161) |
Mar
(222) |
Apr
(193) |
May
(121) |
Jun
(157) |
Jul
(151) |
Aug
(159) |
Sep
(61) |
Oct
(123) |
Nov
(172) |
Dec
(96) |
| 2008 |
Jan
(104) |
Feb
(138) |
Mar
(131) |
Apr
(131) |
May
(74) |
Jun
(107) |
Jul
(89) |
Aug
(89) |
Sep
(172) |
Oct
(158) |
Nov
(119) |
Dec
(86) |
| 2009 |
Jan
(52) |
Feb
(84) |
Mar
(78) |
Apr
(83) |
May
(54) |
Jun
(79) |
Jul
(60) |
Aug
(62) |
Sep
(50) |
Oct
(147) |
Nov
(50) |
Dec
(70) |
| 2010 |
Jan
(135) |
Feb
(113) |
Mar
(74) |
Apr
(93) |
May
(35) |
Jun
(71) |
Jul
(33) |
Aug
(110) |
Sep
(47) |
Oct
(18) |
Nov
(61) |
Dec
(34) |
| 2011 |
Jan
(46) |
Feb
(47) |
Mar
(25) |
Apr
(24) |
May
(21) |
Jun
(22) |
Jul
(20) |
Aug
(51) |
Sep
(31) |
Oct
(42) |
Nov
(22) |
Dec
(22) |
| 2012 |
Jan
(31) |
Feb
(19) |
Mar
(25) |
Apr
(55) |
May
(16) |
Jun
(28) |
Jul
(33) |
Aug
(25) |
Sep
(32) |
Oct
(25) |
Nov
(52) |
Dec
(35) |
| 2013 |
Jan
(43) |
Feb
(18) |
Mar
(36) |
Apr
(45) |
May
(22) |
Jun
(13) |
Jul
(31) |
Aug
(24) |
Sep
(19) |
Oct
(59) |
Nov
(47) |
Dec
(25) |
| 2014 |
Jan
(27) |
Feb
(15) |
Mar
(38) |
Apr
(10) |
May
(15) |
Jun
(36) |
Jul
(24) |
Aug
(28) |
Sep
(16) |
Oct
(6) |
Nov
(44) |
Dec
(40) |
| 2015 |
Jan
(52) |
Feb
(22) |
Mar
(13) |
Apr
(17) |
May
(22) |
Jun
(36) |
Jul
(18) |
Aug
(41) |
Sep
(71) |
Oct
(60) |
Nov
(49) |
Dec
(43) |
| 2016 |
Jan
(60) |
Feb
(13) |
Mar
(21) |
Apr
(28) |
May
(23) |
Jun
(39) |
Jul
(17) |
Aug
(37) |
Sep
(33) |
Oct
(15) |
Nov
(22) |
Dec
(20) |
| 2017 |
Jan
(27) |
Feb
(40) |
Mar
(48) |
Apr
(19) |
May
(29) |
Jun
(2) |
Jul
(19) |
Aug
(36) |
Sep
(18) |
Oct
(10) |
Nov
(11) |
Dec
(5) |
| 2018 |
Jan
(5) |
Feb
(4) |
Mar
(5) |
Apr
(3) |
May
(4) |
Jun
(17) |
Jul
(7) |
Aug
(7) |
Sep
(12) |
Oct
(8) |
Nov
(2) |
Dec
|
| 2019 |
Jan
(8) |
Feb
(5) |
Mar
(3) |
Apr
(5) |
May
(3) |
Jun
(2) |
Jul
(8) |
Aug
(7) |
Sep
(3) |
Oct
(12) |
Nov
(7) |
Dec
(1) |
| 2020 |
Jan
(8) |
Feb
(3) |
Mar
(7) |
Apr
(1) |
May
(2) |
Jun
(1) |
Jul
(3) |
Aug
(25) |
Sep
(5) |
Oct
(3) |
Nov
(7) |
Dec
(16) |
| 2021 |
Jan
(11) |
Feb
(10) |
Mar
(16) |
Apr
(8) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Mark R. <ma...@la...> - 2015-08-18 19:14:59
|
On 18-8-2015 10:53, usman wrote: > Is there any solution to this problem. > I am using firebird client 4.7.0, DDEXProvider-3.0.2 with vs 2012 and still > getting the error. > Can you someone please guide how to resolve this issue. Which Firebird version are you using? A column unknown RDB$PROCEDURE_TYPE suggests that you are using Firebird 2.0 or earlier (or a database that is still ODS 11.0 or earlier and hasn't been upgraded). The column RDB$PROCEDURE_TYPE was introduced in Firebird 2.1, see http://tracker.firebirdsql.org/browse/CORE-779 Mark -- Mark Rotteveel |
|
From: Jiri C. (JIRA) <tr...@fi...> - 2015-08-18 11:24:19
|
Embedded does not read OCTETS correctly
---------------------------------------
Key: DNET-624
URL: http://tracker.firebirdsql.org/browse/DNET-624
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 4.7.0.0
Reporter: Jiri Cincura
Assignee: Jiri Cincura
https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/pull/31
--
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
|
|
From: usman <us...@ho...> - 2015-08-18 08:57:30
|
Is there any solution to this problem. I am using firebird client 4.7.0, DDEXProvider-3.0.2 with vs 2012 and still getting the error. Can you someone please guide how to resolve this issue. Regards, Usman -- View this message in context: http://firebird.1100200.n4.nabble.com/FB-Tracker-Created-DNET-616-FirebirdSql-Data-FirebirdClient-FbException-Column-unknown-RDB-PROCEDURE-tp4640116p4640403.html Sent from the firebird-net-provider mailing list archive at Nabble.com. |
|
From: André Z. (J. <tr...@fi...> - 2015-08-17 08:18:20
|
DDEX provider setup doesn't detect installed VS version
-------------------------------------------------------
Key: DNET-623
URL: http://tracker.firebirdsql.org/browse/DNET-623
Project: .NET Data provider
Issue Type: Bug
Components: DDEX Provider
Affects Versions: 3.0.2.0
Environment: Windows 8, VS2012 Update 4
Reporter: André Ziegler
Assignee: Jiri Cincura
I've tried to install the latest DDEX provider 3.0.2 and under advanced I see that VS2015 is selected while I only have VS2012 installed.
I expect that the installer detects the installed version and selects the correct entries.
--
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
|
|
From: LtColRDSChauhan <rds...@gm...> - 2015-08-17 08:13:40
|
Hi,
1. FbTransactionBehavior.LockRead allows reads in the code as under :
tx = con.BeginTransaction(
new FbTransactionOptions() {
TransactionBehavior =
FbTransactionBehavior.Consistency | FbTransactionBehavior.NoWait,
LockTables = new Dictionary<string, FbTransactionBehavior> {
{"PAYMENTS"
, FbTransactionBehavior.LockRead | FbTransactionBehavior.Exclusive}
}
}
);
2. Environment :
(a) FirebirdSql.Data.FirebirdClient-4.7.0.0
(b) Firebird-2.5.4.26856_0_Win32
(c) Windows 10
(d) .NET 4.5.1
3. If there a error in the code, please help. I had reported this
earlier, kindly bear one last time again.
Thanks and Regards,
Rajiv
|
|
From: Jiří Č. <ji...@ci...> - 2015-08-17 06:22:02
|
Hi, Can you test it with latest provider? 2.7.7 is couple of years old. -- Mgr. Jiří Činčura Independent IT Specialist |
|
From: Mr. J. <mr_...@ya...> - 2015-08-14 20:32:29
|
Hi,I use FB embedded version for a little local db,Firebird-2.5.4.26856-0_Win32_embed on W 8.1 x86 with Visual Basic 2012FirebirdClient 4.7 I run this simple code and when I close it,application closes but IDE still show "WindowsApplication1 Running" for up to 7 seconds,I think is waiting for some process to terminate Imports FirebirdSql.Data.FirebirdClientPublic Class Form1 Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim connectionString As String connectionString = "User=SYSDBA;" + _ "Password=mypass;" + _ "DataSource=localhost;" + _ "Dialect=3;" + _ "Charset=NONE;" + _ "Role=;" + _ "Connection lifetime=15;" + _ "Pooling=true;" + _ "Port=3050;" + _ "MinPoolSize=0;" + _ "MaxPoolSize=50;" + _ "Packet Size=8192;" + _ "ServerType=1;" + _ "Database=" + "mydb.FDB" Dim myConnection1 = New FbConnection(connectionString) myConnection1.Open() myConnection1.Close() End SubEnd Class I've disabled antivirus,firewall,tested on another machine:the same thing I tested with VB 2008 and FirebirdClient 2.7.7.0 - the same here If I change ServerType=1(embedded) to ServerType=0 (SS) all works fine,IDE ends running mode instantly How to fix that? I need embedded version (for a local db access) Also my application can be restarted for some maintenance,I used successfully that with SS for a long time but now with embedded application freezes after restart (I think is the same problem) Thanks for any help. |
|
From: Alexander Muylaert-G. (JIRA) <tr...@fi...> - 2015-08-12 11:05:11
|
Performance optimization for FbCommand.LogCommand
-------------------------------------------------
Key: DNET-622
URL: http://tracker.firebirdsql.org/browse/DNET-622
Project: .NET Data provider
Issue Type: Improvement
Components: ADO.NET Provider
Affects Versions: 4.7.0.0
Reporter: Alexander Muylaert-Gelein
Assignee: Jiri Cincura
Hi
I noticed that the emitting of the trace code is relatively slow. It takes a few percentages (6%) of the total duration of a restore script. Including Localhost traffic to the database.
First I disabled all the listeners inside the app config. This brought it down to 0.7% of the total time needed to rescript the db.
I propose one additional minor tweak to prevent formatting the message at all. That brings the required processing time down to 0.088%.
--
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
|
|
From: LtColRDSChauhan <rds...@gm...> - 2015-07-26 00:54:50
|
On Fri, Jul 24, 2015 at 12:57 PM, < fir...@li...> wrote: > > ------------------------------ > > Message: 4 > Date: Fri, 24 Jul 2015 07:01:39 +0000 > From: Ji?? ?in?ura <ji...@ci...> > Subject: [Firebird-net-provider] ADO.NET provider 4.7.0.0 and DDEX > 3.0.2 > To: "For users and developers of the Firebird .NET providers" > <fir...@li...>, "For discussion > among > Firebird Developers" <fir...@li... > >, > "fir...@ya..." <fir...@ya...> > Message-ID: <ee33b85b7aeb47f0bfb2d093a5f3a822@S05-MBX03-19.S05.local> > Content-Type: text/plain; charset="utf-8" > > More info: > * > http://blog.cincura.net/233515-ado-net-provider-4-7-0-0-for-firebird-is-ready/ > FbTransactionBehavior.LockRead allows reads. > * > http://blog.cincura.net/233514-ddex-provider-3-0-2-for-firebird-released/ > > The uploads on SF will be done when SF is back up working. > > -- > Mgr. Ji?? ?in?ura > Independent IT Specialist > > > ------------------------------ > End of Firebird-net-provider Digest, Vol 111, Issue 4 > ***************************************************** |
|
From: Zvjezdan T. (JIRA) <tr...@fi...> - 2015-07-24 08:21:56
|
Increase pagesize of CREATE DATABASE command to 16384 in order to o create bigger indices
-----------------------------------------------------------------------------------------
Key: DNET-621
URL: http://tracker.firebirdsql.org/browse/DNET-621
Project: .NET Data provider
Issue Type: Improvement
Components: Entity Framework support
Environment: WIN 7 64, VS2013
Reporter: Zvjezdan Tomicevic
Assignee: Jiri Cincura
Hi.
I played with ASP.NET Identity provider, and wanted to use firebird instead of sql server.
When i tried to generate database from scratch, it failed as it could not create indices on VARCHAR(128) fields, due to too small default page size of 4096 of create database statement.
This is easily mitigated by using larger page size of 16384 which is default in firebird 3 anyway.
--
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
|
|
From: Jiří Č. <ji...@ci...> - 2015-07-24 07:27:37
|
Yes, it’s on NuGet. It might take a minute or two before it’s indexed (so it should be done now for sure). -- Mgr. Jiří Činčura Independent IT Specialist From: Alexander Muylaert-Gelein [mailto:amu...@ho...] Sent: Friday, July 24, 2015 9:12 AM To: fir...@li...urceforge. Subject: Re: [Firebird-net-provider] ADO.NET provider 4.7.0.0 and DDEX 3.0.2 Hi Jiri Thanks, I'll make sure it is tested this weekend on our servers. Already available on nuget, because update-package doesn't work yet? thanks a > From: ji...@ci...<mailto:ji...@ci...> > To: fir...@li...<mailto:fir...@li...>; fir...@li...<mailto:fir...@li...>; fir...@ya...<mailto:fir...@ya...> > Date: Fri, 24 Jul 2015 07:01:39 +0000 > Subject: [Firebird-net-provider] ADO.NET provider 4.7.0.0 and DDEX 3.0.2 > > More info: > * http://blog.cincura.net/233515-ado-net-provider-4-7-0-0-for-firebird-is-ready/ > * http://blog.cincura.net/233514-ddex-provider-3-0-2-for-firebird-released/ > > The uploads on SF will be done when SF is back up working. > > -- > Mgr. Jiří Činčura > Independent IT Specialist > > ------------------------------------------------------------------------------ > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li...<mailto:Fir...@li...> > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
|
From: Alexander Muylaert-G. <amu...@ho...> - 2015-07-24 07:11:55
|
Hi Jiri Thanks, I'll make sure it is tested this weekend on our servers.Already available on nuget, because update-package doesn't work yet? thanks a > From: ji...@ci... > To: fir...@li...; fir...@li...; fir...@ya... > Date: Fri, 24 Jul 2015 07:01:39 +0000 > Subject: [Firebird-net-provider] ADO.NET provider 4.7.0.0 and DDEX 3.0.2 > > More info: > * http://blog.cincura.net/233515-ado-net-provider-4-7-0-0-for-firebird-is-ready/ > * http://blog.cincura.net/233514-ddex-provider-3-0-2-for-firebird-released/ > > The uploads on SF will be done when SF is back up working. > > -- > Mgr. Jiří Činčura > Independent IT Specialist > > ------------------------------------------------------------------------------ > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
|
From: Jiří Č. <ji...@ci...> - 2015-07-24 07:01:56
|
More info: * http://blog.cincura.net/233515-ado-net-provider-4-7-0-0-for-firebird-is-ready/ * http://blog.cincura.net/233514-ddex-provider-3-0-2-for-firebird-released/ The uploads on SF will be done when SF is back up working. -- Mgr. Jiří Činčura Independent IT Specialist |
|
From: Jiri C. (JIRA) <tr...@fi...> - 2015-07-23 12:14:02
|
Too much initialization for FbConnectionPoolManager
---------------------------------------------------
Key: DNET-620
URL: http://tracker.firebirdsql.org/browse/DNET-620
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 4.6.4.0
Reporter: Jiri Cincura
Assignee: Jiri Cincura
The FbConnectionPoolManager should use ExecutionAndPublication to not create garbage.
--
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
|
|
From: Jiří Č. <ji...@ci...> - 2015-07-23 11:05:47
|
> Does the releasing/disposing also require locking on _syncroot? If so: No. -- Mgr. Jiří Činčura Independent IT Specialist |
|
From: Mark R. <ma...@la...> - 2015-07-23 09:24:58
|
On Thu, 23 Jul 2015 07:56:09 +0000, Jiří Činčura <ji...@ci...> wrote: > Hi *, > > Anybody willing to give me a code review? > https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/compare/DNET-607 Does the releasing/disposing also require locking on _syncroot? If so: release.AsParallel().ForAll(x => x.Dispose()); Might cause a deadlock. |
|
From: Jiří Č. <ji...@ci...> - 2015-07-23 07:56:14
|
Hi *, Anybody willing to give me a code review? https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/compare/DNET-607 -- Mgr. Jiří Činčura Independent IT Specialist |
|
From: LtColRDSChauhan <rds...@gm...> - 2015-07-22 12:19:04
|
On Wed, Jul 22, 2015 at 12:08 PM, < fir...@li...> wrote: > Send Firebird-net-provider mailing list submissions to > fir...@li... > > To subscribe or unsubscribe via the World Wide Web, visit > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > or, via email, send a message with subject or body 'help' to > fir...@li... > > You can reach the person managing the list at > fir...@li... > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of Firebird-net-provider digest..." > > > Today's Topics: > > 1. Re: Future of .NET Provider (Ji?? ?in?ura) > 2. Read allowed despite locking table in transaction > (LtColRDSChauhan) > 3. Re: Read allowed despite locking table in transaction > (Ji?? ?in?ura) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Fri, 10 Jul 2015 08:05:14 +0000 > From: Ji?? ?in?ura <ji...@ci...> > Subject: Re: [Firebird-net-provider] Future of .NET Provider > To: "For users and developers of the Firebird .NET providers" > <fir...@li...> > Message-ID: <53b4e1e0ea5b46619e7aa74754b54c5e@S05-MBX03-22.S05.local> > Content-Type: text/plain; charset="utf-8" > > With the Firebird 3.0 Beta 2 release a few days ago, I would like to ask > when we could expect the .NET Provider working with it, also in combination > with Entity Framework (with support for new datatypes like > > Provider works with FB 3 (with legacy auth). With the new encryption etc. > I don?t have any ETA. Mark is doing the implementation in Java, so maybe > we?ll join forces. Without some investment from community it?s not going to > happen quickly. > > Boolean). > > The SQL boolean has slightly different NULL/Unknown logic than .NET null > (or any ?normal? NULL) and EF does not expect that. Although it?s not > difficult to add support, the logic in C# code is damn confusing. > > In that fashion, how about Entity Framework 7 - which will be released on > 20. July (with the new Visual Studio) - will it be supported in the near > future (including DDEX support for VS 2015)? > > http://tracker.firebirdsql.org/browse/DNET-609. Support for EF 7 is going > to happen after EF 6.2 will be out (because of Migrations). > > > -- > Mgr. Ji?? ?in?ura > Independent IT Specialist > > -------------- next part -------------- > An HTML attachment was scrubbed... > > ------------------------------ > > Message: 2 > Date: Tue, 21 Jul 2015 16:18:11 +0530 > From: LtColRDSChauhan <rds...@gm...> > Subject: [Firebird-net-provider] Read allowed despite locking table in > transaction > To: fir...@li... > Message-ID: > <CAMG8wxjpjHkQo5hjmHioQJ83HJLFoXQUFd=+ > fDO...@ma...> > Content-Type: text/plain; charset="utf-8" > > Hello, > > Earlier, by mistake I sent an incomplete mail on this issue. Apologies for > the same. > > 1. I want to lock a table then : > (a) read a record from this table and then > (b) write a record to this table. > 2. While I do the above, I want to disallow read and write to this table. > 3. The below mentioned code allows read while the transaction is in > progress. > > tx = con.BeginTransaction( > new FbTransactionOptions() { > TransactionBehavior = > FbTransactionBehavior.Consistency | FbTransactionBehavior.NoWait, > LockTables = new Dictionary<string > , FbTransactionBehavior> { > {lockTable1, > FbTransactionBehavior.Protected | FbTransactionBehavior.LockRead | > FbTransactionBehavior.Exclusive} > } > } > > 4. Environment : > (a) FirebirdSql.Data.FirebirdClient-4.6.4.0 > (b) Firebird-2.5.4.26856_0_Win32 > (c) .NET 4.5.2 > 5. Please help. > > Thanks and Regards, > Rajiv > -------------- next part -------------- > An HTML attachment was scrubbed... > > ------------------------------ > > Message: 3 > Date: Wed, 22 Jul 2015 06:38:02 +0000 > From: Ji?? ?in?ura <ji...@ci...> > Subject: Re: [Firebird-net-provider] Read allowed despite locking > table in transaction > To: "For users and developers of the Firebird .NET providers" > <fir...@li...> > Message-ID: <147af4d6c76445218f76bfca536ca9c4@S05-MBX03-22.S05.local> > Content-Type: text/plain; charset="utf-8" > > Don?t do that. Database engine (any) people do a great effort to reach > maximum throughput and you want to limit it to basically 1. If you need > someething like that, your design has serious flaw. > You are correct, designs (any) needing transactions are at the cost of throughput. In this case please help to point out the error in code. > -- > Mgr. Ji?? ?in?ura > Independent IT Specialist > > From: LtColRDSChauhan [mailto:rds...@gm...] > Sent: Tuesday, July 21, 2015 12:48 PM > To: fir...@li... > Subject: [Firebird-net-provider] Read allowed despite locking table in > transaction > > Hello, > > Earlier, by mistake I sent an incomplete mail on this issue. Apologies for > the same. > > 1. I want to lock a table then : > (a) read a record from this table and then > (b) write a record to this table. > 2. While I do the above, I want to disallow read and write to this table. > 3. The below mentioned code allows read while the transaction is in > progress. > > tx = con.BeginTransaction( > new FbTransactionOptions() { > TransactionBehavior = > FbTransactionBehavior.Consistency | FbTransactionBehavior.NoWait, > LockTables = new Dictionary<string, > FbTransactionBehavior> { > {lockTable1, > FbTransactionBehavior.Protected | FbTransactionBehavior.LockRead | > FbTransactionBehavior.Exclusive} > } > } > > 4. Environment : > (a) FirebirdSql.Data.FirebirdClient-4.6.4.0 > (b) Firebird-2.5.4.26856_0_Win32 > (c) .NET 4.5.2 > 5. Please help. > > Thanks and Regards, > Rajiv > -------------- next part -------------- > An HTML attachment was scrubbed... > > ------------------------------ > > > ------------------------------------------------------------------------------ > Don't Limit Your Business. Reach for the Cloud. > GigeNET's Cloud Solutions provide you with the tools and support that > you need to offload your IT needs and focus on growing your business. > Configured For All Businesses. Start Your Cloud Today. > https://www.gigenetcloud.com/ > > ------------------------------ > > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > > > End of Firebird-net-provider Digest, Vol 111, Issue 2 > ***************************************************** > -- Regards, Lt Col (Retd) Rajiv D.S. Chauhan in.linkedin.com/in/ltcolrdschauhan _____________________________ |
|
From: LtColRDSChauhan <rds...@gm...> - 2015-07-22 06:57:52
|
Hello,
1. I want to lock a table :
to read a record and follow up
tx = con.BeginTransaction(
new FbTransactionOptions() {
TransactionBehavior =
FbTransactionBehavior.Consistency | FbTransactionBehavior.NoWait,
LockTables = new Dictionary<string
, FbTransactionBehavior> {
{lockTable1,
FbTransactionBehavior.Protected | FbTransactionBehavior.LockRead |
FbTransactionBehavior.Exclusive}
}
}
--
Regards,
Lt Col (Retd) Rajiv D.S. Chauhan
in.linkedin.com/in/ltcolrdschauhan
_____________________________
|
|
From: Jiří Č. <ji...@ci...> - 2015-07-22 06:38:10
|
Don’t do that. Database engine (any) people do a great effort to reach maximum throughput and you want to limit it to basically 1. If you need someething like that, your design has serious flaw.
--
Mgr. Jiří Činčura
Independent IT Specialist
From: LtColRDSChauhan [mailto:rds...@gm...]
Sent: Tuesday, July 21, 2015 12:48 PM
To: fir...@li...
Subject: [Firebird-net-provider] Read allowed despite locking table in transaction
Hello,
Earlier, by mistake I sent an incomplete mail on this issue. Apologies for the same.
1. I want to lock a table then :
(a) read a record from this table and then
(b) write a record to this table.
2. While I do the above, I want to disallow read and write to this table.
3. The below mentioned code allows read while the transaction is in progress.
tx = con.BeginTransaction(
new FbTransactionOptions() {
TransactionBehavior = FbTransactionBehavior.Consistency | FbTransactionBehavior.NoWait,
LockTables = new Dictionary<string, FbTransactionBehavior> {
{lockTable1, FbTransactionBehavior.Protected | FbTransactionBehavior.LockRead | FbTransactionBehavior.Exclusive}
}
}
4. Environment :
(a) FirebirdSql.Data.FirebirdClient-4.6.4.0
(b) Firebird-2.5.4.26856_0_Win32
(c) .NET 4.5.2
5. Please help.
Thanks and Regards,
Rajiv
|
|
From: LtColRDSChauhan <rds...@gm...> - 2015-07-21 22:05:24
|
Hello,
Earlier, by mistake I sent an incomplete mail on this issue. Apologies for
the same.
1. I want to lock a table then :
(a) read a record from this table and then
(b) write a record to this table.
2. While I do the above, I want to disallow read and write to this table.
3. The below mentioned code allows read while the transaction is in
progress.
tx = con.BeginTransaction(
new FbTransactionOptions() {
TransactionBehavior =
FbTransactionBehavior.Consistency | FbTransactionBehavior.NoWait,
LockTables = new Dictionary<string
, FbTransactionBehavior> {
{lockTable1,
FbTransactionBehavior.Protected | FbTransactionBehavior.LockRead |
FbTransactionBehavior.Exclusive}
}
}
4. Environment :
(a) FirebirdSql.Data.FirebirdClient-4.6.4.0
(b) Firebird-2.5.4.26856_0_Win32
(c) .NET 4.5.2
5. Please help.
Thanks and Regards,
Rajiv
|
|
From: Jiří Č. <ji...@ci...> - 2015-07-10 08:05:24
|
With the Firebird 3.0 Beta 2 release a few days ago, I would like to ask when we could expect the .NET Provider working with it, also in combination with Entity Framework (with support for new datatypes like Provider works with FB 3 (with legacy auth). With the new encryption etc. I don’t have any ETA. Mark is doing the implementation in Java, so maybe we’ll join forces. Without some investment from community it’s not going to happen quickly. Boolean). The SQL boolean has slightly different NULL/Unknown logic than .NET null (or any “normal” NULL) and EF does not expect that. Although it’s not difficult to add support, the logic in C# code is damn confusing. In that fashion, how about Entity Framework 7 - which will be released on 20. July (with the new Visual Studio) - will it be supported in the near future (including DDEX support for VS 2015)? http://tracker.firebirdsql.org/browse/DNET-609. Support for EF 7 is going to happen after EF 6.2 will be out (because of Migrations). -- Mgr. Jiří Činčura Independent IT Specialist |
|
From: Rand R. <ran...@ou...> - 2015-07-10 06:59:22
|
With the Firebird 3.0 Beta 2 release a few days ago, I would like to ask when we could expect the .NET Provider working with it, also in combination with Entity Framework (with support for new datatypes like Boolean). In that fashion, how about Entity Framework 7 - which will be released on 20. July (with the new Visual Studio) - will it be supported in the near future (including DDEX support for VS 2015)? |
|
From: Jiří Č. <ji...@ci...> - 2015-07-02 16:10:37
|
Hi *, I would like to hear some opinions on http://tracker.firebirdsql.org/browse/DNET-390?focusedCommentId=29671&page=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel#action_29671 . What do you think? -- Mgr. Jiří Činčura Independent IT Specialist |
|
From: Alex G. (JIRA) <tr...@fi...> - 2015-07-01 09:39:48
|
Possible incorrect usage of WeakReference.Target in method FirebirdSql.Data.FirebirdClient.FbConnectionInternal.TransactionUpdated
----------------------------------------------------------------------------------------------------------------------------------
Key: DNET-619
URL: http://tracker.firebirdsql.org/browse/DNET-619
Project: .NET Data provider
Issue Type: Bug
Affects Versions: 4.6.4.0, 4.1.0.0
Environment: Windows 7 prof, sp1, CPU i5-3550, mem 8 GiB
Reporter: Alex Gaysinskiy
Assignee: Jiri Cincura
Implementation of FirebirdSql.Data.FirebirdClient.FbConnectionInternal.TransactionUpdated function (FirebirdClient\FbConnectionInternal.cs, line 298) has incorrect condition:
public void TransactionUpdated()
{
for (int i = 0; i < this.preparedCommands.Count; i++)
{
if (!this.preparedCommands[i].IsAlive)
continue;
FbCommand command = this.preparedCommands[i].Target as FbCommand; //<<<= may be a null
if (command.Transaction != null) //<<<= potential NRE. Correct code is: command != null && command.Transaction != null
{
command.CloseReader();
command.Transaction = null;
}
}
}
--
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
|
211 messages has been excluded from this view by a project administrator.
