Jiri Cincura (JIRA | 2 Feb 06:55 2016

[FB-Tracker] Created: (DNET-668) Connection resiliency

Connection resiliency
---------------------

                 Key: DNET-668
                 URL: http://tracker.firebirdsql.org/browse/DNET-668
             Project: .NET Data provider
          Issue Type: New Feature
          Components: ADO.NET Provider
            Reporter: Jiri Cincura
            Assignee: Jiri Cincura

--

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

------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140
SUKHEN DASS | 2 Feb 06:46 2016
Picon

Disconnection Problem In Vb.net with Firebird

Dear Team,

I am facing a problem of connection still in use after clearing the pool and dispose connection object
but as i close the vb.net application it free the database connection and i can rename the database manually which i want to do at run time

Code as below
Imports System.Data
Imports System.Data.SqlClient
Imports FirebirdSql.Data.FirebirdClient
'Imports FirebirdSql.Data.Firebird

Imports System.Windows.Forms
Imports System.IO
Imports System.Text
Imports System.Globalization

Public myConnection As New FbConnection
Public Function OpenConnection(Optional ByVal ByPass_Message As Boolean = False) As Boolean
        Dim strConString As String = ""

        Try
            If myConnection.State = ConnectionState.Closed Then
                Dim fbConn As New FbConnectionStringBuilder()
                fbConn.Password = Password
                fbConn.UserID = UserID
                fbConn.Pooling = True
                fbConn.Role = "sysadmin"

                fbConn.MaxPoolSize = 20
                'fbConn.ClientLibrary = "fbclient.dll"
                If Is_Local_Connection = True Then
                    fbConn.Database = strLocalDatabase
                Else
                    fbConn.Database = Database_Path

                End If

                fbConn.DataSource = DB_Server
                fbConn.ConnectionLifeTime = 0
                fbConn.ConnectionTimeout = 30

                fbConn.Charset = "UTF8"
                fbConn.ServerType = ServerType
                fbConn.Dialect = 3

                If Val(strPort) = 0 Then
                    strPort = 3050
                End If
                fbConn.Port = strPort

                strConString = fbConn.ToString()

                myConnection.ConnectionString = fbConn.ToString
                If fbConn IsNot Nothing Then
                    fbConn = Nothing
                End If
                myConnection.Open()

            End If
            Return True
        Catch ex As Exception
            If ByPass_Message = False Then
                WriteError(ex.ToString() & vbCrLf & "DB Path :" & Database_Path & "," & vbCrLf & "Local DB:" & strLocalDatabase & vbCrLf & "Conn String:" & Replace(strConString, Password, ""))
                MessageBox.Show("Path is not valid...Please,check data direcotry setting...!" & vbCrLf & vbCrLf & _
                ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error)
            End If
            Return False
        End Try
    End Function
Sub Rename_DB
myConnection.ClearAllPools()
            FbConnection.ClearPool(myConnection)
            FbConnection.ClearAllPools()
            myConnection.Close()
            'AppDomain.Unload(AppDomain.CurrentDomain)
            myConnection.Dispose()
            myConnection = Nothing

IO.File.Replace(txtFile_Path.Text, strCurrent_Database_Path, "D:\Backup\Bkp.fdb")--this line is giving error file in used 
End Sub

------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
alexedu (JIRA | 1 Feb 23:18 2016

[FB-Tracker] Created: (DNET-667) Error reading from connection : FirebirdSQL Connection Pooling (ADO.NET) is not Working

Error reading from connection : FirebirdSQL Connection Pooling (ADO.NET) is not Working
---------------------------------------------------------------------------------------

                 Key: DNET-667
                 URL: http://tracker.firebirdsql.org/browse/DNET-667
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 4.6.0.0
         Environment: Firebird 2.5.3.26780 (x64); 
Windows 10 Pro;
            Reporter: alexedu
            Assignee: Jiri Cincura
            Priority: Blocker

Actual result: 
Engine Code: 335544726 
Engine Message: Error reading data from the connection. 
See: ADONETConnectionPoolingERROR.png 

Expected Result: 
The Connection Pooling should be automatically restored when any disconnection occurs between requests;

Steps to reproduce the issue: 
1- Open a  FirebirdSQL Connection Pooling (ADO.NET) using the ADO.NET Provider v.4.6.0.0 (Reference:
http://msdn.microsoft.com/en-us/library/8xx3tyca(v=vs.100).aspx) and do a Data request: The data
is received without any issue;
2- Interupt the FirebirdSQL Server (net stop FirebirdServerDefaultInstance) and restart it  (net start FirebirdServerDefaultInstance);
3- Try to request any other data from the Database using the same FirebirdSQL Connection Pooling open before.

Additional Information: 
This issue did not happen when using the previous ADO.NET Provider v.4.5.2.0.

--

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

------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140
alexedu (JIRA | 1 Feb 23:18 2016

[FB-Tracker] Created: (DNET-666) FirebirdSQL Connection Pooling (ADO.NET) is not Working since 4.5.2 version

FirebirdSQL Connection Pooling (ADO.NET) is not Working since 4.5.2 version
---------------------------------------------------------------------------

                 Key: DNET-666
                 URL: http://tracker.firebirdsql.org/browse/DNET-666
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 4.6.0.0
         Environment: Firebird 2.5.3.26780 (x64); 
Windows 10 Pro;
            Reporter: alexedu
            Assignee: Jiri Cincura
            Priority: Blocker

Actual result: 
Engine Code: 335544726 
Engine Message: Error reading data from the connection. 
See: ADONETConnectionPoolingERROR.png 

Expected Result: 
The Connection Pooling should be automatically restored when any disconnection occurs between requests;

Steps to reproduce the issue: 
1- Open a  FirebirdSQL Connection Pooling (ADO.NET) using the ADO.NET Provider v.4.6.0.0 (Reference:
http://msdn.microsoft.com/en-us/library/8xx3tyca(v=vs.100).aspx) and do a Data request: The data
is received without any issue;
2- Interupt the FirebirdSQL Server (net stop FirebirdServerDefaultInstance) and restart it  (net start FirebirdServerDefaultInstance);
3- Try to request any other data from the Database using the same FirebirdSQL Connection Pooling open before.

Additional Information: 
This issue did not happen when using the previous ADO.NET Provider v.4.5.2.0.

--

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

------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140
Kjell Rilbe | 31 Jan 08:31 2016
Picon

FbTransactionBehavior values docs/info?

Hi,

I am unable to find info about some of the FbTransactionBehavior values. Would be nice with some pointers or info. :-)
Consistency = 1, // What's this? Concurrency = 2, // What's this? Shared = 4, // Used only for pre locking of tables?? Protected = 8, // Used only for pre locking of tables?? Exclusive = 16, // Used only for pre locking of tables?? Wait = 32, // Wait specified amount of time if operation needs resource locked by other transaction. NoWait = 64, // Throw exception immediately if operation needs resource locked by other transaction. Read = 128, // Used only for pre locking of tables?? Write = 256, // Used only for pre locking of tables?? LockRead = 512, // Used only for pre locking of tables?? LockWrite = 1024, // Used only for pre locking of tables?? ReadCommitted = 2048, // Changes committed by other trans are seen, uncommitted changes are not seen, conflict only on write of same record. Autocommit = 4096, // What's this? RecVersion = 8192, // MVCC is used, so rec changed by other transaction can be read (but old version). NoRecVersion = 16384, // MVCC "not used", so can't read rec changed by other transaction. RestartRequests = 32768, // What's this? NoAutoUndo = 65536, // What's this? Thanks!
Kjell Rilbe

--
a:link, a:visited, a:hover, a:active { color: black !important; }

Kjell Rilbe
Telefon: 08-761 06 55
Mobil: 0733-44 24 64

Marknadsinformation i Sverige AB
Ulvsundavägen 106C
168 67 Bromma
www.marknadsinformation.se
08-514 905 90


------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Kjell Rilbe | 30 Jan 09:30 2016
Picon

Choose isolation level using System.Data.IsolationLevel?

Hi,

Using a framework that's "database agnostic", I am able to choose a value for transaction isolation level using the System.Data.IsolationLevel enum. I can't find a way to enter a FbTransationOptions struct or FbTransactionBehavior value.

Using System.Data.IsolationLevel, it seems I get transactions with behavior ReadCommitted + NoRecVersion. I would like to have RecVersion instead of NoRecVersion.

Any suggestions?

Regards,
Kjell Rilbe
--
a:link, a:visited, a:hover, a:active { color: black !important; }

Kjell Rilbe
Telefon: 08-761 06 55
Mobil: 0733-44 24 64

Marknadsinformation i Sverige AB
Ulvsundavägen 106C
168 67 Bromma
www.marknadsinformation.se
08-514 905 90


------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Kjell Rilbe | 30 Jan 11:44 2016
Picon

Choose isolation level using System.Data.IsolationLevel?

Hi,

Using a framework that's "database agnostic", I am able to choose a 
value for transaction isolation level using the 
System.Data.IsolationLevel enum. I can't find a way to enter a 
FbTransationOptions struct or FbTransactionBehavior value.

Using System.Data.IsolationLevel, it seems I get transactions with 
behavior ReadCommitted + NoRecVersion. I would like to have RecVersion 
instead of NoRecVersion.

Any suggestions?

Regards,
Kjell Rilbe

--

-- 
---------------------------------------------------------------------------
Kjell Rilbe <kjell@...>
Telefon: 0733-44 24 64 (+46 733 442464)
---------------------------------------------------------------------------
"If there's a price for bein' me, that's one I'll have to pay"
Aaron Tippin
---------------------------------------------------------------------------

------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140
Kjell Rilbe | 30 Jan 15:38 2016
Picon

Choose isolation level using System.Data.IsolationLevel?

Hi,

Using a framework that's "database agnostic", I am able to choose a value for transaction isolation level using the System.Data.IsolationLevel enum. I can't find a way to enter a FbTransationOptions struct or FbTransactionBehavior value.

Using System.Data.IsolationLevel, it seems I get transactions with behavior ReadCommitted + NoRecVersion. I would like to have RecVersion instead of NoRecVersion.

Any suggestions?

Regards,
Kjell Rilbe
--
a:link, a:visited, a:hover, a:active { color: black !important; }

Kjell Rilbe
Telefon: 08-761 06 55
Mobil: 0733-44 24 64

Marknadsinformation i Sverige AB
Ulvsundavägen 106C
168 67 Bromma
www.marknadsinformation.se
08-514 905 90


------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Mark Rotteveel | 27 Jan 18:47 2016
Picon
Gravatar

Re: Version 4.10 Download

News item has been published and download links have been updated.

Mark

On 26-1-2016 15:32, Mark Rotteveel wrote:
> I do have the rights. Did you already have the news item ready for
> publishing?
>
> Mark
>
>
> ----- Bericht beantwoorden -----
> Van: "Jiří Činčura" <jiri <at> cincura.net>
> Aan: <firebird-net-provider <at> lists.sourceforge.net>
> Onderwerp: [Firebird-net-provider] Version 4.10 Download
> Datum: di, jan. 26, 2016 15:26
>
> The website has not yet been updated. I don't have rights for that, so
> it's best to put it to tracker to DOC project.
>
> --
> Mgr. Jiří Činčura
> Independent IT Specialist
>
> On Tue, Jan 26, 2016, at 15:08, Nicolas Timmers wrote:
>> Hello, the new version of .net data provider is not available to
>> donwlonad on
>>http://www.firebirdsql.org/en/additional-downloads/
>>
>>  		 	   		
>> ------------------------------------------------------------------------------
>> Site24x7 APM Insight: Get Deep Visibility into Application Performance
>> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
>> Monitor end-to-end web transactions and take corrective actions now
>> Troubleshoot faster and improve end-user experience. Signup Now!
>>http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140
>> _______________________________________________
>> Firebird-net-provider mailing list
>> Firebird-net-provider <at> lists.sourceforge.net
>>https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
> ------------------------------------------------------------------------------
> Site24x7 APM Insight: Get Deep Visibility into Application Performance
> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
> Monitor end-to-end web transactions and take corrective actions now
> Troubleshoot faster and improve end-user experience. Signup Now!
> http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140
> _______________________________________________
> Firebird-net-provider mailing list
> Firebird-net-provider <at> lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>
>
> ------------------------------------------------------------------------------
> Site24x7 APM Insight: Get Deep Visibility into Application Performance
> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
> Monitor end-to-end web transactions and take corrective actions now
> Troubleshoot faster and improve end-user experience. Signup Now!
> http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140
>
>
>
> _______________________________________________
> Firebird-net-provider mailing list
> Firebird-net-provider <at> lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

--

-- 
Mark Rotteveel

------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Mark Rotteveel | 26 Jan 19:26 2016
Picon
Gravatar

Re: Version 4.10 Download

Ok, I can't seem to login into the CMS.

On 26-1-2016 18:45, Mark Rotteveel wrote:
> Sorry, I meant that I'll create a news item tonight, not a ticket.
>
> Mark
>
> ----- Bericht beantwoorden -----
> Van: "Jiří Činčura" <jiri <at> cincura.net>
> Aan: "For users and developers of the Firebird .NET providers"
> <firebird-net-provider <at> lists.sourceforge.net>
> Onderwerp: [Firebird-net-provider] Version 4.10 Download
> Datum: di, jan. 26, 2016 17:43
>
>> You also didn't create a request in WEB. I will create one tonight.
>
> Normally I'm sending this to Olga and Alexey, as requested. Creating
> ticket for that seems to be bit overkill.
>
> --
> Mgr. Jiří Činčura
> Independent IT Specialist
>
> ------------------------------------------------------------------------------
> Site24x7 APM Insight: Get Deep Visibility into Application Performance
> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
> Monitor end-to-end web transactions and take corrective actions now
> Troubleshoot faster and improve end-user experience. Signup Now!
> http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140
> _______________________________________________
> Firebird-net-provider mailing list
> Firebird-net-provider <at> lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>
>
> ------------------------------------------------------------------------------
> Site24x7 APM Insight: Get Deep Visibility into Application Performance
> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
> Monitor end-to-end web transactions and take corrective actions now
> Troubleshoot faster and improve end-user experience. Signup Now!
> http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140
>
>
>
> _______________________________________________
> Firebird-net-provider mailing list
> Firebird-net-provider <at> lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

--

-- 
Mark Rotteveel

------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Nicolas F. Timmers | 26 Jan 16:52 2016
Picon

RES: Version 4.10 Download

Have another link where i can download it, without nugget ?

 

De: Mark Rotteveel [mailto:mark-gyL5Wioy0x9z2lryZHS3NA@public.gmane.org]
Enviada em: terça-feira, 26 de janeiro de 2016 12:32
Para: For users and developers of the Firebird .NET providers <firebird-net-provider-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org>
Assunto: Re: [Firebird-net-provider] Version 4.10 Download

 

I do have the rights. Did you already have the news item ready for publishing?

 

Mark

 

 

----- Bericht beantwoorden -----
Van: "Jiří Činčura" <
jiri-i04QUkT9ABbR7s880joybQ@public.gmane.org>
Aan: <
firebird-net-provider-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org>
Onderwerp: [Firebird-net-provider] Version 4.10 Download
Datum: di, jan. 26, 2016 15:26

 

The website has not yet been updated. I don't have rights for that, so

it's best to put it to tracker to DOC project.

 

--

Mgr. Jiří Činčura

Independent IT Specialist

 

On Tue, Jan 26, 2016, at 15:08, Nicolas Timmers wrote:

> Hello, the new version of .net data provider is not available to

> donwlonad on

> http://www.firebirdsql.org/en/additional-downloads/

>

>                                       

> ------------------------------------------------------------------------------

> Site24x7 APM Insight: Get Deep Visibility into Application Performance

> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month

> Monitor end-to-end web transactions and take corrective actions now

> Troubleshoot faster and improve end-user experience. Signup Now!

> http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140

> _______________________________________________

> Firebird-net-provider mailing list

> Firebird-net-provider-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org

> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

 

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

Site24x7 APM Insight: Get Deep Visibility into Application Performance

APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month

Monitor end-to-end web transactions and take corrective actions now

Troubleshoot faster and improve end-user experience. Signup Now!

http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140

_______________________________________________

Firebird-net-provider mailing list

Firebird-net-provider-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org

https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Gmane