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: Jiří Č. <ji...@ci...> - 2016-07-17 09:06:08
|
OK. Vote here http://goo.gl/X4hCxG . Not sure we'll get enough votes, though, to make it significant for decision. Arguments are welcome as well. -- Mgr. Jiří Činčura Independent IT Specialist |
From: Jiří Č. <ji...@ci...> - 2016-07-17 08:45:59
|
Update: http://blog.cincura.net/233566-external-procedures-in-firebird-in-net-done-ish/ -- Mgr. Jiří Činčura Independent IT Specialist On Wed, Jul 6, 2016, at 09:12, Jiří Činčura wrote: > http://blog.cincura.net/233565-early-very-preview-of-stored-procedures-functions-triggers-in-net-firebird/ > > Play with it. Think about problems hard (I'm sure you'll face some) > before asking. ;) Comment there. > -- > Mgr. Jiří Činčura > Independent IT Specialist |
From: Ralf J. <ral...@ma...> - 2016-07-11 16:28:29
|
I changed my backup/restore routine and used gbak instead of the FBRestore class. That helps no more shutdowns now. There seems to be something wrong with FBRestore. Calling the class is pretty straight. So I don't see a ~usage~ error of that class. FbRestore restore = new FbRestore(); restore.BackupFiles.Add(new FbBackupFile(fromPath)); restore.ConnectionString = connectionString; restore.Options = FbRestoreFlags.Create; restore.PageSize = 4096; restore.Verbose = true; restore.ServiceOutput += delegate(object sender, ServiceOutputEventArgs e) { callback(e.Message); }; restore.Execute(); -----Ursprüngliche Nachricht----- Von: Ralf Jansen [mailto:ral...@ma...] Gesendet: Donnerstag, 7. Juli 2016 18:19 An: For users and developers of the Firebird .NET providers <fir...@li...> Betreff: Re: [Firebird-net-provider] using fb 2.5 and 3.0 embedded concurrently Checked. No dangling connections in the transaction pool after backup restore. Then when the ~connection shutdown~ error state is reached only 3.0 connections are in the pool. If i wasn't clear I can't create any connection in that state. Not even create a new Database and connect to that. Any connection will throw a ~connection shutdown~ Exception after that state is reached. It is not dependent to a certain database. Feels more like the hole embedded Firebird client is in a shutdown state then :( -----Ursprüngliche Nachricht----- Von: Ralf Jansen [mailto:ral...@ma...] Gesendet: Donnerstag, 7. Juli 2016 17:42 An: For users and developers of the Firebird .NET providers <fir...@li...> Betreff: Re: [Firebird-net-provider] using fb 2.5 and 3.0 embedded concurrently I call FbConnection.ClearPool before backup. So there shouldn't be any 2.5 connections to that database still hanging around. The backup restore I do is inplace. I have replaced the fdb database in its original location (2.5 before a 3.0 version afterwards). I assume if I had 2.5er connections still in the pool that won't be allowed since there would be open handles to the database and I couldn't replace the file then? I will check if clearing the pool when I'm running into the ~ connection shutdown~ error state helps. But I doubt that this problem has something to do with the connection pool. -----Ursprüngliche Nachricht----- Von: Jiří Činčura [mailto:ji...@ci...] Gesendet: Donnerstag, 7. Juli 2016 17:31 An: fir...@li... Betreff: Re: [Firebird-net-provider] using fb 2.5 and 3.0 embedded concurrently > To get that fixed I need to > restart the process. Are you sure. Isn't just cleaning the pool for that connection enough? -- Mgr. Jiří Činčura Independent IT Specialist ------------------------------------------------------------------------------ Attend Shape: An AT&T Tech Expo July 15-16. Meet us at AT&T Park in San Francisco, CA to explore cutting-edge tech and listen to tech luminaries present their vision of the future. This family event has something for everyone, including kids. Get more information and register today. http://sdm.link/attshape _______________________________________________ Firebird-net-provider mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-net-provider ------------------------------------------------------------------------------ Attend Shape: An AT&T Tech Expo July 15-16. Meet us at AT&T Park in San Francisco, CA to explore cutting-edge tech and listen to tech luminaries present their vision of the future. This family event has something for everyone, including kids. Get more information and register today. http://sdm.link/attshape _______________________________________________ Firebird-net-provider mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-net-provider ------------------------------------------------------------------------------ Attend Shape: An AT&T Tech Expo July 15-16. Meet us at AT&T Park in San Francisco, CA to explore cutting-edge tech and listen to tech luminaries present their vision of the future. This family event has something for everyone, including kids. Get more information and register today. http://sdm.link/attshape _______________________________________________ Firebird-net-provider mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
From: Jiří Č. <ji...@ci...> - 2016-07-08 05:55:17
|
Empty the pool for that connection or do not use the pooling. -- Mgr. Jiří Činčura Independent IT Specialist |
From: Ralf J. <ral...@ma...> - 2016-07-07 16:19:09
|
Checked. No dangling connections in the transaction pool after backup restore. Then when the ~connection shutdown~ error state is reached only 3.0 connections are in the pool. If i wasn't clear I can't create any connection in that state. Not even create a new Database and connect to that. Any connection will throw a ~connection shutdown~ Exception after that state is reached. It is not dependent to a certain database. Feels more like the hole embedded Firebird client is in a shutdown state then :( -----Ursprüngliche Nachricht----- Von: Ralf Jansen [mailto:ral...@ma...] Gesendet: Donnerstag, 7. Juli 2016 17:42 An: For users and developers of the Firebird .NET providers <fir...@li...> Betreff: Re: [Firebird-net-provider] using fb 2.5 and 3.0 embedded concurrently I call FbConnection.ClearPool before backup. So there shouldn't be any 2.5 connections to that database still hanging around. The backup restore I do is inplace. I have replaced the fdb database in its original location (2.5 before a 3.0 version afterwards). I assume if I had 2.5er connections still in the pool that won't be allowed since there would be open handles to the database and I couldn't replace the file then? I will check if clearing the pool when I'm running into the ~ connection shutdown~ error state helps. But I doubt that this problem has something to do with the connection pool. -----Ursprüngliche Nachricht----- Von: Jiří Činčura [mailto:ji...@ci...] Gesendet: Donnerstag, 7. Juli 2016 17:31 An: fir...@li... Betreff: Re: [Firebird-net-provider] using fb 2.5 and 3.0 embedded concurrently > To get that fixed I need to > restart the process. Are you sure. Isn't just cleaning the pool for that connection enough? -- Mgr. Jiří Činčura Independent IT Specialist ------------------------------------------------------------------------------ Attend Shape: An AT&T Tech Expo July 15-16. Meet us at AT&T Park in San Francisco, CA to explore cutting-edge tech and listen to tech luminaries present their vision of the future. This family event has something for everyone, including kids. Get more information and register today. http://sdm.link/attshape _______________________________________________ Firebird-net-provider mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-net-provider ------------------------------------------------------------------------------ Attend Shape: An AT&T Tech Expo July 15-16. Meet us at AT&T Park in San Francisco, CA to explore cutting-edge tech and listen to tech luminaries present their vision of the future. This family event has something for everyone, including kids. Get more information and register today. http://sdm.link/attshape _______________________________________________ Firebird-net-provider mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
From: Ralf J. <ral...@ma...> - 2016-07-07 15:42:18
|
I call FbConnection.ClearPool before backup. So there shouldn't be any 2.5 connections to that database still hanging around. The backup restore I do is inplace. I have replaced the fdb database in its original location (2.5 before a 3.0 version afterwards). I assume if I had 2.5er connections still in the pool that won't be allowed since there would be open handles to the database and I couldn't replace the file then? I will check if clearing the pool when I'm running into the ~ connection shutdown~ error state helps. But I doubt that this problem has something to do with the connection pool. -----Ursprüngliche Nachricht----- Von: Jiří Činčura [mailto:ji...@ci...] Gesendet: Donnerstag, 7. Juli 2016 17:31 An: fir...@li... Betreff: Re: [Firebird-net-provider] using fb 2.5 and 3.0 embedded concurrently > To get that fixed I need to > restart the process. Are you sure. Isn't just cleaning the pool for that connection enough? -- Mgr. Jiří Činčura Independent IT Specialist ------------------------------------------------------------------------------ Attend Shape: An AT&T Tech Expo July 15-16. Meet us at AT&T Park in San Francisco, CA to explore cutting-edge tech and listen to tech luminaries present their vision of the future. This family event has something for everyone, including kids. Get more information and register today. http://sdm.link/attshape _______________________________________________ Firebird-net-provider mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
From: Jiří Č. <ji...@ci...> - 2016-07-07 15:31:06
|
> To get that fixed I need to > restart the process. Are you sure. Isn't just cleaning the pool for that connection enough? -- Mgr. Jiří Činčura Independent IT Specialist |
From: Ralf J. <ral...@ma...> - 2016-07-07 15:28:08
|
Hi, it looked good at first. But I have a problem when upgrading a database from 2.5 to 3.0 in the process. Means I first open the database with the 2.5 client then do a backup/restore cycle via the FbBackup/FBRestore classes (Backup with the 2.5 fbembed.dll in the connectionstring, restore with the 3.0 fbembed.dll). I can then use the database for, looks like, 60 seconds. After that I get an IscException (connection shutdown, error code 335544528) for any 3.0 database currently used in that process. To get that fixed I need to restart the process. Anything in the provider or firebird itself with a 60 seconds timing? -----Ursprüngliche Nachricht----- Von: Ralf Jansen [mailto:ral...@ma...] Gesendet: Mittwoch, 22. Juni 2016 12:36 An: For users and developers of the Firebird .NET providers <fir...@li...> Betreff: Re: [Firebird-net-provider] using fb 2.5 and 3.0 embedded concurrently Seems to work in a short test. I will go that route further and see if there are some major stumbling blocks in the way (the provider's connection pooling for example). -----Original Message----- From: Jiří Činčura [mailto:ji...@ci...] Sent: Mittwoch, 22. Juni 2016 11:12 To: fir...@li... Subject: Re: [Firebird-net-provider] using fb 2.5 and 3.0 embedded concurrently > Should that work? Can both libraries coexist? Can the Net. Provider > cope with that scenario? I think yes. Just use the ClientLibrary and point it to correct DLLs. -- Mgr. Jiří Činčura Independent IT Specialist ------------------------------------------------------------------------------ Attend Shape: An AT&T Tech Expo July 15-16. Meet us at AT&T Park in San Francisco, CA to explore cutting-edge tech and listen to tech luminaries present their vision of the future. This family event has something for everyone, including kids. Get more information and register today. http://sdm.link/attshape _______________________________________________ Firebird-net-provider mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-net-provider ------------------------------------------------------------------------------ Attend Shape: An AT&T Tech Expo July 15-16. Meet us at AT&T Park in San Francisco, CA to explore cutting-edge tech and listen to tech luminaries present their vision of the future. This family event has something for everyone, including kids. Get more information and register today. http://sdm.link/attshape _______________________________________________ Firebird-net-provider mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
From: Ralf J. (JIRA) <tr...@fi...> - 2016-07-07 14:17:16
|
FBScript thinks that a comment at the end of a script file is a valid command ----------------------------------------------------------------------------- Key: DNET-688 URL: http://tracker.firebirdsql.org/browse/DNET-688 Project: .NET Data provider Issue Type: Bug Components: ADO.NET Provider Affects Versions: 5.0.5.0 Environment: Win8.1, VS2015, Net 4.5.1, Firebird Provider build from source not taken from nuget Reporter: Ralf Jansen Assignee: Jiri Cincura Example Script: /* Pre comment */ UPDATE TABLE SET Field= 'HelloWorld' WHERE Id = 1; /*Post comment */ In this case FbScript.Parse() will try to parse the post comment as command and throws a ""The type of the SQL statement could not be determined..." ArgumentException. Workaround : Don't have a comment at the end of a script. -- 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: 冰风 <aeo...@qq...> - 2016-07-06 16:56:26
|
hi,guys I have a question about how to release database file. When i use the Firebird ADO.NET Data Provider and i use the firebird database as embedded server,my program can't release the database file though i have used function conn.Close() and conn.Dispose(). I can see that the database file is also linked by my demo in windows resource monitor,and i can't connect this database by other program such as Firebird Maestro. Now, the only way to release the database file is to close my program. How can i do to release the database file but not close my program? This is my program code (C#): FbConnectionStringBuilder connBuilder = new FbConnectionStringBuilder(); connBuilder.UserID = "sysdba"; connBuilder.ServerType = FbServerType.Embedded; connBuilder.Database = @"E:\db.fdb"; string strsql = "SELECT COUNT(RDB$RELATION_NAME) FROM RDB$RELATIONS WHERE (RDB$RELATION_NAME = 'TABLE_TMP') AND RDB$VIEW_SOURCE IS NULL;"; bool flag=false; using (FbConnection conn = new FbConnection(connBuilder.ConnectionString)) { conn.Open(); FbCommand cmd = new FbCommand(strsql, conn); FbDataReader dr = cmd.ExecuteReader(); dr.Read(); if ((int)dr[0] > 0) { flag = true; } conn.Close(); } please tell me how to do that . thanks so much! Best Regards, Aeolus Yang |
From: 陈. <91...@qq...> - 2016-07-06 09:26:59
|
thx so much. ------------------ 原始邮件 ------------------ 发件人: "Jiří Činčura";<ji...@ci...>; 发送时间: 2016年7月6日(星期三) 下午3:12 收件人: "For users & developers of the Firebird .NET providers"<fir...@li...>; 主题: [Firebird-net-provider] Early (very) preview of stored procedures(functions, triggers) in .NET in Firebird http://blog.cincura.net/233565-early-very-preview-of-stored-procedures-functions-triggers-in-net-firebird/ Play with it. Think about problems hard (I'm sure you'll face some) before asking. ;) Comment there. -- Mgr. Jiří Činčura Independent IT Specialist ------------------------------------------------------------------------------ Attend Shape: An AT&T Tech Expo July 15-16. Meet us at AT&T Park in San Francisco, CA to explore cutting-edge tech and listen to tech luminaries present their vision of the future. This family event has something for everyone, including kids. Get more information and register today. http://sdm.link/attshape _______________________________________________ Firebird-net-provider mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
From: Jiří Č. <ji...@ci...> - 2016-07-06 07:12:52
|
http://blog.cincura.net/233565-early-very-preview-of-stored-procedures-functions-triggers-in-net-firebird/ Play with it. Think about problems hard (I'm sure you'll face some) before asking. ;) Comment there. -- Mgr. Jiří Činčura Independent IT Specialist |
From: 陈. <91...@qq...> - 2016-07-03 04:14:59
|
hey,mark thx for your reply. i have already solve it. maybe some questions when i use the function of FBscript. anyway,thx a lot. Regards Chen ------------------ 原始邮件 ------------------ 发件人: "Mark Rotteveel";<ma...@la...>; 发送时间: 2016年7月3日(星期天) 凌晨5:23 收件人: "For users and developers of the Firebird .NET providers"<fir...@li...>; 主题: Re: [Firebird-net-provider]some questions about Firebirsql You need to remove set term instructions, it is not actually part of the Firebird syntax. They are only used by query tools like ISQL and Flamerobin. So remove both set term instructions and the ^ after the final end and you should be able to execute the create trigger using the .net provider. Mark ----- Bericht beantwoorden ----- Van: "陈文欢" <91...@qq...> Aan: "firebird-net-provider" <fir...@li...> Onderwerp: [Firebird-net-provider] some questions about Firebirsql Datum: za, jul. 2, 2016 12:25 hi,guys i have a question about how to create trigger. when i use the Firebird .net Provider 5.0 . i dont kown how to create the commandtext for trigger. e.g SET TERM ^ ; CREATE TRIGGER TCURRENTSET_BI FOR TCURRENTSET ACTIVE BEFORE INSERT POSITION 0 AS DECLARE VARIABLE tmp DECIMAL(18,0); BEGIN IF (NEW.RD IS NULL) THEN NEW.RD = GEN_ID(GEN_TCURRENTSET_RD, 1); ELSE BEGIN tmp = GEN_ID(GEN_TCURRENTSET_RD, 0); if (tmp < new.RD) then tmp = GEN_ID(GEN_TCURRENTSET_RD, new.RD-tmp); END END^ SET TERM ; ^ please tell me how to do that . thx so much Best Regards |
From: M. R. <ma...@la...> - 2016-07-02 21:23:33
|
You need to remove set term instructions, it is not actually part of the Firebird syntax. They are only used by query tools like ISQL and Flamerobin. So remove both set term instructions and the ^ after the final end and you should be able to execute the create trigger using the .net provider. Mark ----- Bericht beantwoorden ----- Van: "陈文欢" <91...@qq...> Aan: "firebird-net-provider" <fir...@li...> Onderwerp: [Firebird-net-provider] some questions about Firebirsql Datum: za, jul. 2, 2016 12:25 hi,guys i have a question about how to create trigger. when i use the Firebird .net Provider 5.0 . i dont kown how to create the commandtext for trigger. e.g SET TERM ^ ; CREATE TRIGGER TCURRENTSET_BI FOR TCURRENTSET ACTIVE BEFORE INSERT POSITION 0 AS DECLARE VARIABLE tmp DECIMAL(18,0); BEGIN IF (NEW.RD IS NULL) THEN NEW.RD = GEN_ID(GEN_TCURRENTSET_RD, 1); ELSE BEGIN tmp = GEN_ID(GEN_TCURRENTSET_RD, 0); if (tmp < new.RD) then tmp = GEN_ID(GEN_TCURRENTSET_RD, new.RD-tmp); END END^ SET TERM ; ^ please tell me how to do that . thx so much Best Regards |
From: stevyn d. <sr...@ya...> - 2016-07-02 20:46:18
|
Download and use FlameRobin .... easiest way! This message is intended only for the use of the individual or entity to which it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the reader of this message is not the intended you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you are not the intended reader, then you must destroy this communication immediately. From: 陈文欢 <91...@qq...> To: firebird-net-provider <fir...@li...> Sent: Saturday, July 2, 2016 3:25 AM Subject: [Firebird-net-provider] some questions about Firebirsql hi,guys i have a question about how to create trigger. when i use the Firebird .net Provider 5.0 . i dont kown how to create the commandtext for trigger. e.g SET TERM ^ ; CREATE TRIGGER TCURRENTSET_BI FOR TCURRENTSETACTIVE BEFORE INSERT POSITION 0ASDECLARE VARIABLE tmp DECIMAL(18,0);BEGIN IF (NEW.RD IS NULL) THEN NEW.RD = GEN_ID(GEN_TCURRENTSET_RD, 1); ELSE BEGIN tmp = GEN_ID(GEN_TCURRENTSET_RD, 0); if (tmp < new.RD) then tmp = GEN_ID(GEN_TCURRENTSET_RD, new.RD-tmp); ENDEND^ SET TERM ; ^ please tell me how to do that . thx so much Best Regards ------------------------------------------------------------------------------ Attend Shape: An AT&T Tech Expo July 15-16. Meet us at AT&T Park in San Francisco, CA to explore cutting-edge tech and listen to tech luminaries present their vision of the future. This family event has something for everyone, including kids. Get more information and register today. http://sdm.link/attshape _______________________________________________ Firebird-net-provider mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
From: 陈. <91...@qq...> - 2016-07-02 10:26:05
|
hi,guys i have a question about how to create trigger. when i use the Firebird .net Provider 5.0 . i dont kown how to create the commandtext for trigger. e.g SET TERM ^ ; CREATE TRIGGER TCURRENTSET_BI FOR TCURRENTSET ACTIVE BEFORE INSERT POSITION 0 AS DECLARE VARIABLE tmp DECIMAL(18,0); BEGIN IF (NEW.RD IS NULL) THEN NEW.RD = GEN_ID(GEN_TCURRENTSET_RD, 1); ELSE BEGIN tmp = GEN_ID(GEN_TCURRENTSET_RD, 0); if (tmp < new.RD) then tmp = GEN_ID(GEN_TCURRENTSET_RD, new.RD-tmp); END END^ SET TERM ; ^ please tell me how to do that . thx so much Best Regards |
From: Jiří Č. <ji...@ci...> - 2016-06-30 09:25:09
|
> Sure :). But from which disk? Client's or server's? Server of course. How it could even load it from client... -- Mgr. Jiří Činčura Independent IT Specialist |
From: Геннадий З. <zab...@gm...> - 2016-06-30 09:17:16
|
> It's assembly loaded from disk. Sure :). But from which disk? Client's or server's? On 29 June 2016 at 20:18, Jiří Činčura <ji...@ci...> wrote: >> I wonder where do code should persist? Server/Client? > > What? It's assembly loaded from disk. Simple as that. > >> What performance impact for such logic? > > We'll see. > > -- > Mgr. Jiří Činčura > Independent IT Specialist > > ------------------------------------------------------------------------------ > Attend Shape: An AT&T Tech Expo July 15-16. Meet us at AT&T Park in San > Francisco, CA to explore cutting-edge tech and listen to tech luminaries > present their vision of the future. This family event has something for > everyone, including kids. Get more information and register today. > http://sdm.link/attshape > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
From: Jiří Č. <ji...@ci...> - 2016-06-29 17:18:42
|
> I wonder where do code should persist? Server/Client? What? It's assembly loaded from disk. Simple as that. > What performance impact for such logic? We'll see. -- Mgr. Jiří Činčura Independent IT Specialist |
From: Leonard W. (JIRA) <tr...@fi...> - 2016-06-29 12:15:09
|
rollback the upgrade by using dbmigrator update("0") fails ---------------------------------------------------------- Key: DNET-687 URL: http://tracker.firebirdsql.org/browse/DNET-687 Project: .NET Data provider Issue Type: Bug Components: Entity Framework support Affects Versions: 5.0.5.0 Environment: windows 7 / firebird 2.5.2 / ef 6.1.3 Reporter: Leonard Wennekers Assignee: Jiri Cincura The following exception occurred: Test 'IOLAN.Context.Migration.UnitTests.UnitTestContextManagerFirebird.TestContextMigration' failed: System.InvalidCastException : Can't convert typee System.Data.Entity.Migrations.Model.DropTableOperation to System.Data.Entity.Migrations.Model.HistoryOperation. bij FirebirdSql.Data.EntityFramework6.FbMigrationSqlGenerator.Generate(IEnumerable`1 migrationOperations, String providerManifestToken) bij System.Data.Entity.Migrations.DbMigrator.ExecuteOperations(String migrationId, VersionedModel targetModel, IEnumerable`1 operations, IEnumerable`1 systemOperations, Boolean downgrading, Boolean auto) bij System.Data.Entity.Migrations.DbMigrator.RevertMigration(String migrationId, DbMigration migration, XDocument targetModel) bij System.Data.Entity.Migrations.Infrastructure.MigratorLoggingDecorator.RevertMigration(String migrationId, DbMigration migration, XDocument targetModel) bij System.Data.Entity.Migrations.DbMigrator.Downgrade(IEnumerable`1 pendingMigrations) bij System.Data.Entity.Migrations.Infrastructure.MigratorLoggingDecorator.Downgrade(IEnumerable`1 pendingMigrations) bij System.Data.Entity.Migrations.DbMigrator.UpdateInternal(String targetMigration) bij System.Data.Entity.Migrations.DbMigrator.EnsureDatabaseExists(Action mustSucceedToKeepDatabase) bij System.Data.Entity.Migrations.DbMigrator.Update(String targetMigration) -- 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: Геннадий З. <zab...@gm...> - 2016-06-29 09:37:23
|
Looks good. I wonder where do code should persist? Server/Client? What performance impact for such logic? On 28 June 2016 at 15:37, Daniel Rail <da...@ac...> wrote: > Hi, > > At June 27, 2016, 3:51 PM, Jiří Činčura wrote: > >> Hi *, > >> there's something I've been working on for a few evenings and weekends. >> As you might know, from Firebird 3 there's and interface to write a >> plugin that allows to execute any code as stored procedure, function or >> trigger. > >> So why not to have these in .NET, right? I have a working plugin right >> now. Currently only stored procedures are supported. No blobs at the >> moment as well. > >> You can check small example at the end of this email. > >> Now the important part. Is there enough interest in this to keep working >> it? The hardest part is mostly over. Now it's just adding support for >> more objects and polishing it, hardening it and probably adding features >> based on requests (like security). > > I can see myself and our company developing stored procedures, > functions and triggers in .Net. There were times were it will likely > be easier. And, stored procedures is a good starting point, since it > can be called from a trigger. Also, this will make it easier to reuse > business logic that is developed in .Net(without having to rewrite it > in PSQL), if it is to implement such logic in a stored procedure or > trigger. > > -- > Best regards, > Daniel Rail > Senior Software Developer > ACCRA Solutions Inc. (www.accra.ca) > ACCRA Med Software Inc. (www.filopto.com) > > > ------------------------------------------------------------------------------ > Attend Shape: An AT&T Tech Expo July 15-16. Meet us at AT&T Park in San > Francisco, CA to explore cutting-edge tech and listen to tech luminaries > present their vision of the future. This family event has something for > everyone, including kids. Get more information and register today. > http://sdm.link/attshape > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
From: Daniel R. <da...@ac...> - 2016-06-28 13:14:38
|
Hi, At June 27, 2016, 3:51 PM, Jiří Činčura wrote: > Hi *, > there's something I've been working on for a few evenings and weekends. > As you might know, from Firebird 3 there's and interface to write a > plugin that allows to execute any code as stored procedure, function or > trigger. > So why not to have these in .NET, right? I have a working plugin right > now. Currently only stored procedures are supported. No blobs at the > moment as well. > You can check small example at the end of this email. > Now the important part. Is there enough interest in this to keep working > it? The hardest part is mostly over. Now it's just adding support for > more objects and polishing it, hardening it and probably adding features > based on requests (like security). I can see myself and our company developing stored procedures, functions and triggers in .Net. There were times were it will likely be easier. And, stored procedures is a good starting point, since it can be called from a trigger. Also, this will make it easier to reuse business logic that is developed in .Net(without having to rewrite it in PSQL), if it is to implement such logic in a stored procedure or trigger. -- Best regards, Daniel Rail Senior Software Developer ACCRA Solutions Inc. (www.accra.ca) ACCRA Med Software Inc. (www.filopto.com) |
From: Jiří Č. <ji...@ci...> - 2016-06-28 12:58:23
|
Looks like you've made Firebird confused. :) How's the query looking? Is the error really random and other times it runs fine? -- Mgr. Jiří Činčura Independent IT Specialist On Tue, Jun 28, 2016, at 08:10, Nießen, Yves wrote: > Hello, > > > > currently i've got a Problem in an WebApi Project and i don't have any > clue where it comes from. > > It appears since i updated to .Net Prevodier > 5.0.0.0. > > Currently I am using .NetProvider 5.0.5.0 > > > > I'm using ninject to create one DbContext per Request. > > Sometimes I am getting the following exception after 1 hour, after 10 > hours, after a week. > > > > Exception occured: > System.Data.Entity.Core.EntityCommandExecutionException: An error > occurred while executing the command definition. See the inner > exception > for details. ---> FirebirdSql.Data.FirebirdClient.FbException: invalid > request BLR at offset 1094 context already in use (BLR error) ---> > FirebirdSql.Data.Common.IscException: invalid request BLR at > offset 1094 > context already in use (BLR error) > >bei >FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ProcessResponse(- >IResponse >response) in >C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\Firebir- >dSql.Data.FirebirdClient\Client\Managed\Version10\GdsDatabase.cs:Zeile >641. > >bei >FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadResponse() >in >C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\Firebir- >dSql.Data.FirebirdClient\Client\Managed\Version10\GdsDatabase.cs:Zeile >676. > >bei >FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadGenericR- >esponse() >in >C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\Firebir- >dSql.Data.FirebirdClient\Client\Managed\Version10\GdsDatabase.cs:Zeile >681. > >bei >FirebirdSql.Data.Client.Managed.Version11.GdsStatement.Prepare(String >commandText) in >C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\Firebir- >dSql.Data.FirebirdClient\Client\Managed\Version11\GdsStatement.cs:Zeile >84. > >bei FirebirdSql.Data.FirebirdClient.FbCommand.Prepare(Boolean >returnsSet) in >C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\Firebir- >dSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:Zeile >1178. > >bei >FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand(Comman- >dBehavior >behavior, Boolean returnsSet) in >C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\Firebir- >dSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:Zeile >1192. > >bei >FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior >behavior) in >C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\Firebir- >dSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:Zeile >528. > >--- Ende der internen Ausnahmestapelüberwachung --- > >bei >FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior >behavior) in >C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\Firebir- >dSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:Zeile >545. > >bei >FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteDbDataReader(Comman- >dBehavior >behavior) in >C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\Firebir- >dSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:Zeile >639. > >bei >System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Di- >spatch[TTarget,TInterceptionContext,TResult](TTarget >target, Func`3 operation, TInterceptionContext interceptionContext, >Action`3 executing, Action`3 executed) > >bei >System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.Rea- >der(DbCommand >command, DbCommandInterceptionContext interceptionContext) > >bei >System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.- >ExecuteStoreCommands(EntityCommand >entityCommand, CommandBehavior behavior) > >--- Ende der internen Ausnahmestapelüberwachung --- > >bei >System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.- >ExecuteStoreCommands(EntityCommand >entityCommand, CommandBehavior behavior) > >bei >System.Data.Entity.Core.Objects.Internal.ObjectQueryExecutionPlan.Exec- >ute[TResultType](ObjectContext >context, ObjectParameterCollection parameterValues) > >bei >System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[- >T](Func`1 >func, IDbExecutionStrategy executionStrategy, Boolean >startLocalTransaction, Boolean releaseConnectionOnSuccess) > >bei >System.Data.Entity.Core.Objects.ObjectQuery`1.<>c__DisplayClass3.<GetR- >esults>b__1() > >bei >System.Data.Entity.Core.Objects.ObjectQuery`1.GetResults(Nullable`1 >forMergeOption) > >bei >System.Data.Entity.Core.Objects.ObjectQuery`1.<System.Collections.Gene- >ric.IEnumerable<T>.GetEnumerator>b__0() > >bei System.Data.Entity.Internal.LazyEnumerator`1.MoveNext() > >bei System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) > >bei System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source) > > > > > > > > Any hints how to solve this issue? > > > > Greetings from Germany, > > Yves > > > Mit freundlichen Grüßen > Yves Nießen > Entwickler > > [cid:image3e2786.GIF@20a3e02d.42acc9c0] > <http://www.messe-stuttgart.de/suedback/> > > Follow us on [cid:image56de94.PNG@ee89e9ff.4f9e8255] > <https://www.linkedin.com/company/1169414?trk=vsrp_companies_cluster_name&trkInfo=VSRPsearchId%3A2413476321438776818271%2CVSRPtargetId%3A1169414%2CVSRPcmpt%3Acompanies_cluster> >[cid:imageb5e3cc.PNG@5092b274.4abfeb4d] > <https://twitter.com/tbx_software> > [cid:image978bb6.PNG@462061e4.4b87def2] > <https://www.xing.com/companies/toolboxsoftwaregmbh> > [cid:imagea434eb.PNG@4586128d.41b664c3] > <http://www.youtube.com/user/toolboxbakery> > > toolbox Software GmbH | Wilhelm-Lexis-Strasse 8 | 52249 Eschweiler | > Germany > Phone: +49 - 24 03 - 99 66 34 | Mobile: +49 - 151 - 54 45 15 34 | Fax: > +49 - 24 03 - 99 66 70 > > Yve...@to...<mailto:Yves.Niessen@toolbox- > software.com> > > toolbox ist spezialisiert auf Entwicklung und Implementierung von > maßgeschneiderten Versandsystemen für Backbetriebe und Partner > von über 750 Anwendern in mehr als 30 Ländern. > > Die Pflichtangaben finden Sie hier: > www.toolbox-software.com<http://www.toolbox-software.com> > ---------------------------------------------------------------------- > -------- > Attend Shape: An AT&T Tech Expo July 15-16. Meet us at AT&T > Park in San > Francisco, CA to explore cutting-edge tech and listen to tech > luminaries > present their vision of the future. This family event has > something for > everyone, including kids. Get more information and register today. > http://sdm.link/attshape > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > Email had 5 attachments: > + image3e2786.GIF >12k (image/gif) > + image56de94.PNG >1k (image/png) > + imageb5e3cc.PNG >1k (image/png) > + image978bb6.PNG >2k (image/png) > + imagea434eb.PNG >1k (image/png) |
From: Nießen, Y. <Yve...@to...> - 2016-06-28 06:09:33
|
Hello, currently i've got a Problem in an WebApi Project and i don't have any clue where it comes from. It appears since i updated to .Net Prevodier > 5.0.0.0. Currently I am using .NetProvider 5.0.5.0 I'm using ninject to create one DbContext per Request. Sometimes I am getting the following exception after 1 hour, after 10 hours, after a week. Exception occured: System.Data.Entity.Core.EntityCommandExecutionException: An error occurred while executing the command definition. See the inner exception for details. ---> FirebirdSql.Data.FirebirdClient.FbException: invalid request BLR at offset 1094 context already in use (BLR error) ---> FirebirdSql.Data.Common.IscException: invalid request BLR at offset 1094 context already in use (BLR error) bei FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ProcessResponse(IResponse response) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Managed\Version10\GdsDatabase.cs:Zeile 641. bei FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadResponse() in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Managed\Version10\GdsDatabase.cs:Zeile 676. bei FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadGenericResponse() in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Managed\Version10\GdsDatabase.cs:Zeile 681. bei FirebirdSql.Data.Client.Managed.Version11.GdsStatement.Prepare(String commandText) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Managed\Version11\GdsStatement.cs:Zeile 84. bei FirebirdSql.Data.FirebirdClient.FbCommand.Prepare(Boolean returnsSet) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:Zeile 1178. bei FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand(CommandBehavior behavior, Boolean returnsSet) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:Zeile 1192. bei FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:Zeile 528. --- Ende der internen Ausnahmestapelüberwachung --- bei FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:Zeile 545. bei FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteDbDataReader(CommandBehavior behavior) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:Zeile 639. bei System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget target, Func`3 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed) bei System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.Reader(DbCommand command, DbCommandInterceptionContext interceptionContext) bei System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior) --- Ende der internen Ausnahmestapelüberwachung --- bei System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior) bei System.Data.Entity.Core.Objects.Internal.ObjectQueryExecutionPlan.Execute[TResultType](ObjectContext context, ObjectParameterCollection parameterValues) bei System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess) bei System.Data.Entity.Core.Objects.ObjectQuery`1.<>c__DisplayClass3.<GetResults>b__1() bei System.Data.Entity.Core.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption) bei System.Data.Entity.Core.Objects.ObjectQuery`1.<System.Collections.Generic.IEnumerable<T>.GetEnumerator>b__0() bei System.Data.Entity.Internal.LazyEnumerator`1.MoveNext() bei System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) bei System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source) Any hints how to solve this issue? Greetings from Germany, Yves Mit freundlichen Grüßen Yves Nießen Entwickler [cid:image3e2786.GIF@20a3e02d.42acc9c0]<http://www.messe-stuttgart.de/suedback/> Follow us on [cid:image56de94.PNG@ee89e9ff.4f9e8255] <https://www.linkedin.com/company/1169414?trk=vsrp_companies_cluster_name&trkInfo=VSRPsearchId%3A2413476321438776818271%2CVSRPtargetId%3A1169414%2CVSRPcmpt%3Acompanies_cluster> [cid:imageb5e3cc.PNG@5092b274.4abfeb4d] <https://twitter.com/tbx_software> [cid:image978bb6.PNG@462061e4.4b87def2] <https://www.xing.com/companies/toolboxsoftwaregmbh> [cid:imagea434eb.PNG@4586128d.41b664c3] <http://www.youtube.com/user/toolboxbakery> toolbox Software GmbH | Wilhelm-Lexis-Strasse 8 | 52249 Eschweiler | Germany Phone: +49 - 24 03 - 99 66 34 | Mobile: +49 - 151 - 54 45 15 34 | Fax: +49 - 24 03 - 99 66 70 Yve...@to...<mailto:Yve...@to...> toolbox ist spezialisiert auf Entwicklung und Implementierung von maßgeschneiderten Versandsystemen für Backbetriebe und Partner von über 750 Anwendern in mehr als 30 Ländern. Die Pflichtangaben finden Sie hier: www.toolbox-software.com<http://www.toolbox-software.com> |
From: Adriano d. S. F. <adr...@gm...> - 2016-06-27 21:31:31
|
Em 27/06/2016 15:51, Jiří Činčura escreveu: > Hi *, > > there's something I've been working on for a few evenings and weekends. > As you might know, from Firebird 3 there's and interface to write a > plugin that allows to execute any code as stored procedure, function or > trigger. > > So why not to have these in .NET, right? I have a working plugin right > now. Currently only stored procedures are supported. No blobs at the > moment as well. > > You can check small example at the end of this email. > Nice. > Now the important part. Is there enough interest in this to keep working > it? The hardest part is mostly over. Now it's just adding support for > more objects and polishing it, hardening it and probably adding features > based on requests (like security). > Can it already attach to the caller's current transaction? Adriano |