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: Gerdus v. Z. <ger...@gm...> - 2016-02-03 08:07:18
|
What I do in my code is issue the database shutdown command(see http://firebirdsql.org/manual/gfix-dbstartstop.html) after closing all connections I can. Imports FirebirdSql.Data.Services Dim s As New FbConfiguration() s.ConnectionString = Me.Connection.ConnectionString s.DatabaseShutdown(FbShutdownMode.Forced, 1) 'aborts all connections and transactions, 1 second timeout 'Copy File,etc s.DatabaseOnline() 'bring database online again But if you want to make a backup... FbBackup is of course much better and safer. Dim bkp As New FbBackup() bkp.BackupFiles.Add(New FbBackupFile(bkpfn, Nothing)) bkp.ConnectionString = constr bkp.Options = FbBackupFlags.IgnoreLimbo + FbBackupFlags.Expand 'so that program blocks till complete bkp.Verbose = True AddHandler bkp.ServiceOutput, Sub(sender As Object, e As ServiceOutputEventArgs) End Sub RaiseEvent BackupProgressEvent(String.Format("{0}: Creating Database Backup...", database.DatabaseName), 0) bkp.Execute() On Tue, Feb 2, 2016 at 8:26 AM, SUKHEN DASS <suk...@ya...> wrote: > its a single user application which only i am using and i am using > this code before IO.File.Replace is being called... which i forgot to > include in the code > For iLoop = 0 To 100 > Application.DoEvents() > Next > > > On Tuesday, February 2, 2016 11:28 AM, Jiří Činčura <ji...@ci...> > wrote: > > > Calling `FbConnection.ClearAllPools` is enough. You don't have to call > anything else. Though you might give server few ms to release the file - > it's not guaranteed that closing all connections will immediately > release the file. > > -- > 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 > Fir...@li... > 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 > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > > |
|
From: Mark R. <ma...@la...> - 2016-02-02 08:59:30
|
On Tue, 02 Feb 2016 06:57:03 +0100, Jiří Činčura <ji...@ci...> wrote: > Calling `FbConnection.ClearAllPools` is enough. You don't have to call > anything else. Though you might give server few ms to release the file - > it's not guaranteed that closing all connections will immediately > release the file. Maybe the problem might be related to not reading the op_response to the op_detach request (which for Jaybird 3 caused crashes with Firebird 2.1), maybe connections linger longer than necessary if that response packet isn't read. Mark |
|
From: SUKHEN D. <suk...@ya...> - 2016-02-02 06:29:24
|
its a single user application which only i am using and i am using this code before IO.File.Replace is being called... which i forgot to include in the codeFor iLoop = 0 To 100 Application.DoEvents()Next
On Tuesday, February 2, 2016 11:28 AM, Jiří Činčura <ji...@ci...> wrote:
Calling `FbConnection.ClearAllPools` is enough. You don't have to call
anything else. Though you might give server few ms to release the file -
it's not guaranteed that closing all connections will immediately
release the file.
--
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
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
|
|
From: Jiří Č. <ji...@ci...> - 2016-02-02 05:57:12
|
Calling `FbConnection.ClearAllPools` is enough. You don't have to call anything else. Though you might give server few ms to release the file - it's not guaranteed that closing all connections will immediately release the file. -- Mgr. Jiří Činčura Independent IT Specialist |
|
From: Jiri C. (JIRA) <tr...@fi...> - 2016-02-02 05:55:45
|
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
|
|
From: SUKHEN D. <suk...@ya...> - 2016-02-02 05:52:15
|
first i call openconnection method to update some field then i am calling Rename method
On Tuesday, February 2, 2016 11:16 AM, SUKHEN DASS <suk...@ya...> wrote:
Dear Team,
I am facing a problem of connection still in use after clearing the pool and dispose connection objectbut 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 belowImports System.DataImports System.Data.SqlClientImports FirebirdSql.Data.FirebirdClient'Imports FirebirdSql.Data.Firebird
Imports System.Windows.FormsImports System.IOImports System.TextImports 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 FunctionSub Rename_DBmyConnection.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
|
|
From: SUKHEN D. <suk...@ya...> - 2016-02-02 05:49:14
|
Dear Team, I am facing a problem of connection still in use after clearing the pool and dispose connection objectbut 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 belowImports System.DataImports System.Data.SqlClientImports FirebirdSql.Data.FirebirdClient'Imports FirebirdSql.Data.Firebird Imports System.Windows.FormsImports System.IOImports System.TextImports 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 FunctionSub Rename_DBmyConnection.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 |
|
From: alexedu (JIRA) <tr...@fi...> - 2016-02-01 22:18:49
|
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
|
|
From: alexedu (JIRA) <tr...@fi...> - 2016-02-01 22:18:46
|
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
|
|
From: Jiří Č. <ji...@ci...> - 2016-02-01 06:37:31
|
> I have neglected to update it for quite some time. I seem to be at > version 2.6.5. Guess I should upgrade, huh? :-) Yes. You should. -- Mgr. Jiří Činčura Independent IT Specialist |
|
From: Kjell R. <kj...@ri...> - 2016-02-01 06:10:21
|
Jiří Činčura skrev: > The ReadCommitted is RecVersion: > > case IsolationLevel.ReadCommitted: > case IsolationLevel.ReadUncommitted: > default: > options.TransactionBehavior |= > FbTransactionBehavior.ReadCommitted; > options.TransactionBehavior |= > FbTransactionBehavior.RecVersion; > break; > Oh, that's interesting. I'll have to check again then. The thing is that I noticed NoRecVersion reported by Sinática Monitor for queries executed by the framework. Has the mapping from IsolationLevel.ReadCommitted to TransactionBehavior changed? I have neglected to update it for quite some time. I seem to be at version 2.6.5. Guess I should upgrade, huh? :-) Regards, Kjell -- ---------------------------------------------------------------------- Kjell Rilbe <kj...@ri...> Home: +46 8 7610734 Mobile: +46 733 442464 ---------------------------------------------------------------------- "If there's a price for bein' me, that's one I'll have to pay" Aaron Tippin ---------------------------------------------------------------------- |
|
From: Jiří Č. <ji...@ci...> - 2016-01-31 17:13:42
|
The ReadCommitted is RecVersion: case IsolationLevel.ReadCommitted: case IsolationLevel.ReadUncommitted: default: options.TransactionBehavior |= FbTransactionBehavior.ReadCommitted; options.TransactionBehavior |= FbTransactionBehavior.RecVersion; break; -- Mgr. Jiří Činčura Independent IT Specialist On Sat, Jan 30, 2016, at 11:44, Kjell Rilbe wrote: > 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 <kj...@ri...> > 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 > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
|
From: Геннадий З. <zab...@gm...> - 2016-01-31 09:47:16
|
I think it is not possible. Mapping IsolationLevel <-> DbTransactionBuffer is hardcoded in FB.NET library. I know that EF I can use IDbCommandInterceptor and DbInterception.Add(suppressor); This allows to override transactions. In your framework could be something similar. On 31 January 2016 at 09:20, Kjell Rilbe <kj...@ri...> wrote: > den 2016-01-30 20:23, skrev Геннадий Забула: >> On 30 January 2016 at 12:44, Kjell Rilbe <kj...@ri...> wrote: >>> 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? >>> >>> >> I'm using custom extension function, that takes DbContext and >> depending on Database.Connection type creates manually tuned >> transaction for FB case. >> https://gist.github.com/zabulus/1e46010094e1b6678729 >> Here is snippet > > Nice, but I assume this is a function that you manually call in your own > code, instead of the regular DbConnection.BeginTransaction? > > The problem is that the framework I'm using does it all under the hood: > opens connection, starts and ends transactions and executes SQL. I add > the DbConnection component I need to my form, in my case an > FbConnection, and configure my framework's persistence handler to use > that connection. The persistence handler has a lot of settings for the > SQL connection, but for fetch and write transaction mode it uses the > standard System.Data.IsolationLevel enum type, so there's no way to > configure FireBird specific transaction options. > > What I need is some way to hook into the FbConnection's call to start a > transaction, or "globally" configure it to a specific transaction > option/mode/isolation level, either overriding the > System.Data.IsolationLevel that the framework's persitence handler > passes in, or map it in a different way than apparently is standard for > the Firebird .Net provider. I.e. map ReadCommitted to ReadCommitted + > RecVersion + NoWait rather than ReadCommitted + NoRecVersion + NoWait. > > Possible? Inherit from FbCOnnection and override BeginTransaction and > use that (derived) component in place of FbConnection? > > Kjell > > -- > --------------------------------------------------------------------------- > Kjell Rilbe <kj...@ri...> > 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 > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
|
From: Mark R. <ma...@la...> - 2016-01-31 08:10:53
|
On 31-1-2016 08:31, Kjell Rilbe wrote: > 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? These are equivalent to the isc_tpb_* constants with the same (or similar) names in Firebird. You need to refer to the (scarce) documentation of Firebird on these options. Mark -- Mark Rotteveel |
|
From: Kjell R. <kj...@ri...> - 2016-01-31 07:52:30
|
den 2016-01-30 20:23, skrev Геннадий Забула: > On 30 January 2016 at 12:44, Kjell Rilbe <kj...@ri...> wrote: >> 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? >> >> > I'm using custom extension function, that takes DbContext and > depending on Database.Connection type creates manually tuned > transaction for FB case. > https://gist.github.com/zabulus/1e46010094e1b6678729 > Here is snippet Nice, but I assume this is a function that you manually call in your own code, instead of the regular DbConnection.BeginTransaction? The problem is that the framework I'm using does it all under the hood: opens connection, starts and ends transactions and executes SQL. I add the DbConnection component I need to my form, in my case an FbConnection, and configure my framework's persistence handler to use that connection. The persistence handler has a lot of settings for the SQL connection, but for fetch and write transaction mode it uses the standard System.Data.IsolationLevel enum type, so there's no way to configure FireBird specific transaction options. What I need is some way to hook into the FbConnection's call to start a transaction, or "globally" configure it to a specific transaction option/mode/isolation level, either overriding the System.Data.IsolationLevel that the framework's persitence handler passes in, or map it in a different way than apparently is standard for the Firebird .Net provider. I.e. map ReadCommitted to ReadCommitted + RecVersion + NoWait rather than ReadCommitted + NoRecVersion + NoWait. Possible? Inherit from FbCOnnection and override BeginTransaction and use that (derived) component in place of FbConnection? Kjell -- --------------------------------------------------------------------------- Kjell Rilbe <kj...@ri...> 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 --------------------------------------------------------------------------- |
|
From: Kjell R. <kje...@ma...> - 2016-01-31 07:31:22
|
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 -- Marknadsinformation logotyp 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 <http://www.marknadsinformation.se> 08-514 905 90 Företagskontakt.se <http://xn--fretagskontakt-vpb.se> Personkontakt.se <http://personkontakt.se> |
|
From: Геннадий З. <zab...@gm...> - 2016-01-30 19:25:42
|
https://gist.github.com/zabulus/1e46010094e1b6678729 Here is snippet |
|
From: Геннадий З. <zab...@gm...> - 2016-01-30 19:23:45
|
I'm using custom extension function, that takes DbContext and depending on Database.Connection type creates manually tuned transaction for FB case. On 30 January 2016 at 12:44, Kjell Rilbe <kj...@ri...> wrote: > 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 <kj...@ri...> > 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 > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
|
From: Kjell R. <kje...@ma...> - 2016-01-30 14:39:02
|
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 -- Marknadsinformation logotyp 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 <http://www.marknadsinformation.se> 08-514 905 90 Företagskontakt.se <http://xn--fretagskontakt-vpb.se> Personkontakt.se <http://personkontakt.se> |
|
From: Kjell R. <kj...@ri...> - 2016-01-30 11:11:04
|
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 <kj...@ri...> 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 --------------------------------------------------------------------------- |
|
From: Kjell R. <kje...@ma...> - 2016-01-30 08:46:39
|
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 -- Marknadsinformation logotyp 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 <http://www.marknadsinformation.se> 08-514 905 90 Företagskontakt.se <http://xn--fretagskontakt-vpb.se> Personkontakt.se <http://personkontakt.se> |
|
From: Jiří Č. <ji...@ci...> - 2016-01-27 18:33:33
|
> News item has been published and download links have been updated. Thanks. -- Mgr. Jiří Činčura Independent IT Specialist |
|
From: Mark R. <ma...@la...> - 2016-01-27 17:47:45
|
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" <ji...@ci...> > Aan: <fir...@li...> > 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 >> Fir...@li... >>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 > Fir...@li... > 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 > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > -- Mark Rotteveel |
|
From: Mark R. <ma...@la...> - 2016-01-26 18:26:30
|
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" <ji...@ci...> > Aan: "For users and developers of the Firebird .NET providers" > <fir...@li...> > 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 > Fir...@li... > 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 > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > -- Mark Rotteveel |
|
From: M. R. <ma...@la...> - 2016-01-26 17:46:11
|
Sorry, I meant that I'll create a news item tonight, not a ticket. Mark ----- Bericht beantwoorden ----- Van: "Jiří Činčura" <ji...@ci...> Aan: "For users and developers of the Firebird .NET providers" <fir...@li...> 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 Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
211 messages has been excluded from this view by a project administrator.
