LtColRDSChauhan | 26 Jul 02:54 2015
Picon

Re: Firebird-net-provider Digest, Vol 111, Issue 4



On Fri, Jul 24, 2015 at 12:57 PM, <firebird-net-provider-request-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org> wrote:

------------------------------

Message: 4
Date: Fri, 24 Jul 2015 07:01:39 +0000
From: Ji?? ?in?ura <jiri-i04QUkT9ABbR7s880joybQ@public.gmane.org>
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"
        <firebird-net-provider-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org>,  "For discussion among
        Firebird        Developers" <firebird-devel-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org>,
        "firebird-tools-hHKSG33TihhbjbujkaE4pw@public.gmane.org" <firebird-tools-hHKSG33TihhbjbujkaE4pw@public.gmane.org>
Message-ID: <ee33b85b7aeb47f0bfb2d093a5f3a822-0lXuZ8s1cGPc2aQ8m7znSLjjLBE8jN/0@public.gmane.org>
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
*****************************************************
------------------------------------------------------------------------------
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Zvjezdan Tomicevic (JIRA | 24 Jul 10:21 2015

[FB-Tracker] Created: (DNET-621) Increase pagesize of CREATE DATABASE command to 16384 in order to o create bigger indices

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

------------------------------------------------------------------------------
Jiří Činčura | 24 Jul 09:01 2015
Picon

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
Firebird-net-provider <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Jiri Cincura (JIRA | 23 Jul 14:13 2015

[FB-Tracker] Created: (DNET-620) Too much initialization for FbConnectionPoolManager

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

------------------------------------------------------------------------------
Jiří Činčura | 23 Jul 09:56 2015
Picon

DNET-607

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

------------------------------------------------------------------------------
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
LtColRDSChauhan | 22 Jul 14:18 2015
Picon

Re: Firebird-net-provider Digest, Vol 111, Issue 2



On Wed, Jul 22, 2015 at 12:08 PM, <firebird-net-provider-request-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org> wrote:
Send Firebird-net-provider mailing list submissions to
        firebird-net-provider-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org

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
        firebird-net-provider-request-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org

You can reach the person managing the list at
        firebird-net-provider-owner-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org

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 <jiri-i04QUkT9ABbR7s880joybQ@public.gmane.org>
Subject: Re: [Firebird-net-provider] Future of .NET Provider
To: "For users and developers of the Firebird .NET providers"
        <firebird-net-provider-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org>
Message-ID: <53b4e1e0ea5b46619e7aa74754b54c5e-0lXuZ8s1cGPYuK8bORUGmbjjLBE8jN/0@public.gmane.org>
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 <rdsc1964 <at> gmail.com>
Subject: [Firebird-net-provider] Read allowed despite locking table in
        transaction
To: firebird-net-provider-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
Message-ID:
        <CAMG8wxjpjHkQo5hjmHioQJ83HJLFoXQUFd=+fDOJYax-bGuJug-JsoAwUIsXosN+BqQ9rBEUg@public.gmane.org>
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 <jiri-i04QUkT9ABbR7s880joybQ@public.gmane.org>
Subject: Re: [Firebird-net-provider] Read allowed despite locking
        table   in      transaction
To: "For users and developers of the Firebird .NET providers"
        <firebird-net-provider-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org>
Message-ID: <147af4d6c76445218f76bfca536ca9c4-0lXuZ8s1cGPYuK8bORUGmbjjLBE8jN/0@public.gmane.org>
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:rdsc1964 <at> gmail.com]
Sent: Tuesday, July 21, 2015 12:48 PM
To: firebird-net-provider-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
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
Firebird-net-provider-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
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
_____________________________
------------------------------------------------------------------------------
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
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
LtColRDSChauhan | 20 Jul 07:50 2015
Picon

Locking Table for Read and Write

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
_____________________________
------------------------------------------------------------------------------
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
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
LtColRDSChauhan | 21 Jul 12:48 2015
Picon

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
------------------------------------------------------------------------------
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
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Rand Random | 10 Jul 08:46 2015

Future of .NET Provider

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)?
 
 
------------------------------------------------------------------------------
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
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Jiří Činčura | 2 Jul 18:10 2015
Picon

Events on FbBatchExecution firing opinion

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

------------------------------------------------------------------------------
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
Firebird-net-provider <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Alex Gaysinskiy (JIRA | 1 Jul 11:39 2015

[FB-Tracker] Created: (DNET-619) Possible incorrect usage of WeakReference.Target in method FirebirdSql.Data.FirebirdClient.FbConnectionInternal.TransactionUpdated

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

------------------------------------------------------------------------------
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/

Gmane