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: Hennadii Z. (JIRA) <tr...@fi...> - 2017-01-08 09:39:24
|
Issue with FesBlob.GetSegment
-----------------------------
Key: DNET-731
URL: http://tracker.firebirdsql.org/browse/DNET-731
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Reporter: Hennadii Zabula
Assignee: Jiri Cincura
For additional info see:
https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/pull/63/files/e40822db87455eb2d30bb9038ecf9bd574de722b#diff-baa9635582d6046a02882cb1d4877249R145
There could be a bug with segmentLength/requested.
I suggest, that in case segmentLength bigger than requested, this code should re-run with extended tmp buffer to segmentLegth buffer.
Or if the code is right, remove completely this condition.
--
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: Jiri C. (JIRA) <tr...@fi...> - 2017-01-05 07:01:31
|
FirebirdSql.Data.Schema.FbMetaData.xml not in netstandard1.6 version
--------------------------------------------------------------------
Key: DNET-730
URL: http://tracker.firebirdsql.org/browse/DNET-730
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 5.7.0.0
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: Eric Bole-F. (JIRA) <tr...@fi...> - 2016-12-30 11:31:39
|
Conflict with ionic zip package
-------------------------------
Key: DNET-729
URL: http://tracker.firebirdsql.org/browse/DNET-729
Project: .NET Data provider
Issue Type: Improvement
Components: ADO.NET Provider
Affects Versions: 5.7.0.0
Environment: visual studio 2015
Reporter: Eric Bole-Feysot
Assignee: Jiri Cincura
Priority: Minor
I use in my app dotnetzip package (ioniczip dll) and when I installed firebird ado.net provider, I got a conflict because of a duplicated reference. I had to use an alias on my dotnetzip reference to fix the problem.
Could you set your dotnetzip as a nugget references instead of including it in the package ?
Thanks
--
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: Sergey (JIRA) <tr...@fi...> - 2016-12-20 10:11:55
|
Wrong definition of firebird procedures.
----------------------------------------
Key: DNET-728
URL: http://tracker.firebirdsql.org/browse/DNET-728
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 5.7.0.0, 5.6.0.0
Environment: Firebird 2.5.2, Firebird Entity Framework Provider and Firebird ADO.NET Data Povider: from version 5.6.0, Entity Framework - version 6.1.3
Reporter: Sergey
Assignee: Jiri Cincura
Hey there, I found bugs here: StoreSchemaDefinitionVersion3.ssdl while testing FirebirdClient with my database.
Some procedures have no returning parameters, but body have "SUSPEND". In that case rdb$procedure_type will be 1 but rdb$procedure_outputs will be NULL. In model will be added as function.
Some procedures can have rdb$procedure_type = 2, but rdb$procedure_outputs can be more than 0. That function cannot be selectable, but can be executed. In model will be added as procedure. That ok.
There is also some more problems: too much time need to add procedures/functions in model, even I ask one procedure or I don't add procedures at all. I have tested requests for tables and functions/procedures with raw: executing in 1 and 6 minuts respectively.
Also, requests not return MaxLength for procedure/function parameters. In that case SqlGenerator wrongly casts all varchars with fixed length as VARCHAR(8191) ( http://tracker.firebirdsql.org/browse/DNET-723 )
--
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: Eric Bole-F. (JIRA) <tr...@fi...> - 2016-12-17 15:54:07
|
Random crash: NullReferenceException and invalid database handle (crashing application available)
-------------------------------------------------------------------------------------------------
Key: DNET-727
URL: http://tracker.firebirdsql.org/browse/DNET-727
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 5.7.0.0, 5.6.0.0, 5.5.0.0, 5.1.1.0, 5.1.0.0, 5.0.5.0, 5.0.0.0, 4.10.0.0, 4.9.0.0
Environment: Windows 10, desktop
Reporter: Eric Bole-Feysot
Assignee: Jiri Cincura
Priority: Blocker
Hi
I would like to report some random crash I met since v4.8.1 on FirebirdSql.Data.Client. It happens randomly so it is not easy to reproduce. One of my app user reported this bug some days ago and I took a new look at it.
I manage to modify my application to reproduce this bug (still random).
I tried with the latest 5.7.0 and it is still there.
System.NullReferenceException: Object reference not set to an instance of an object.
at FirebirdSql.Data.FirebirdClient.FbCommand.Release() in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:line 832
at FirebirdSql.Data.FirebirdClient.FbCommand.Dispose(Boolean disposing) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:line 376
at System.ComponentModel.Component.Finalize()
invalid database handle (no active connection)
at FirebirdSql.Data.Client.Native.FesDatabase.ProcessStatusVector(IntPtr[] statusVector) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Native\FesDatabase.cs:line 365
at FirebirdSql.Data.Client.Native.FesStatement.Free(Int32 option) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Native\FesStatement.cs:line 621
at FirebirdSql.Data.Common.StatementBase.Release() in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Common\StatementBase.cs:line 241
at FirebirdSql.Data.Client.Native.FesStatement.Release() in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Native\FesStatement.cs:line 246
at FirebirdSql.Data.Client.Native.FesStatement.Dispose(Boolean disposing) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Native\FesStatement.cs:line 181
at FirebirdSql.Data.FirebirdClient.FbCommand.Release() in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:line 838
at FirebirdSql.Data.FirebirdClient.FbCommand.Dispose(Boolean disposing) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:line 376
at System.ComponentModel.Component.Finalize()
I suppose both are related. It happens during the dispose of objects.
I got a compiled application (46 MB). Tell me if you want to give it a try and I will upload it to my domain server.
Currently I'm stuck in v4.8.1 (in fact I did a v4.8.2 with a dirty hack to catch the exception and I didn't see any side effect so far), but I would like to catch up with the latest release.
Thanks for your work and I hope you will find a fix as it is very annoying.
Eric
--
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-12-16 22:58:46
|
If the event you mentioned means, "nothing happens, I'm just alive and send you this", then you should only fire some event that means server alive, nothing else. No one cares that event occurs just because server sent something. On 17 December 2016 at 00:22, Si Carter <s1c...@gm...> wrote: > No it doesn't make sense, a bit like saying "look, nothing happened" but > here you go anyways... > > On 16 Dec 2016 15:15, "Jiří Činčura" <ji...@ci...> wrote: >> >> Hi *, >> >> As I'm now reworking some pieces in events (together with finalizers), >> I'm wondering whether it make sense to fire the event for events when >> the event count was 0. From outside POV it doesn't make much sense. >> >> What do you think? >> >> -- >> Mgr. Jiří Činčura >> Independent IT Specialist >> >> >> ------------------------------------------------------------------------------ >> Check out the vibrant tech community on one of the world's most >> engaging tech sites, SlashDot.org! http://sdm.link/slashdot >> _______________________________________________ >> Firebird-net-provider mailing list >> Fir...@li... >> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > > > ------------------------------------------------------------------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, SlashDot.org! http://sdm.link/slashdot > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > |
|
From: Si C. <s1c...@gm...> - 2016-12-16 22:22:54
|
No it doesn't make sense, a bit like saying "look, nothing happened" but here you go anyways... On 16 Dec 2016 15:15, "Jiří Činčura" <ji...@ci...> wrote: > Hi *, > > As I'm now reworking some pieces in events (together with finalizers), > I'm wondering whether it make sense to fire the event for events when > the event count was 0. From outside POV it doesn't make much sense. > > What do you think? > > -- > Mgr. Jiří Činčura > Independent IT Specialist > > ------------------------------------------------------------ > ------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, SlashDot.org! http://sdm.link/slashdot > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > |
|
From: Jiří Č. <ji...@ci...> - 2016-12-16 15:13:35
|
Server sends whole buffer with all registered events. Some are sometimes obviously 0 (or actually last count, because in server it's incremental), if not fired, but still in buffer. -- Mgr. Jiří Činčura Independent IT Specialist On Fri, Dec 16, 2016, at 15:48, Ivan Arabadzhiev wrote: > Why would the engine throw such an event in the first place? > Does it have > an actual reason or is it a bug to be fixed? I don't think the > provider > should just ignore server messages sent on purpose, but there > might be an > actual option on whether the current user actually needs them or not. > > 2016-12-16 16:18 GMT+02:00 Alexander Muylaert-Gelein < > amu...@ho...>: > > > I say ney. It doesn’t make sense to raise unraised events. > > > > > > > > Sent from Mail <https://go.microsoft.com/fwlink/?LinkId=550986> for > > Windows 10 > > > > > > > > *From: *Jiří Činčura <ji...@ci...> > > *Sent: *vrijdag 16 december 2016 17:15 > > *To: *For users & developers of the Firebird .NET providers > > <fir...@li...> > > *Subject: *[Firebird-net-provider] Firing event when event > > count is 0 > > > > > > Hi *, > > > > As I'm now reworking some pieces in events (together with > > finalizers), > > I'm wondering whether it make sense to fire the event for > > events when > > the event count was 0. From outside POV it doesn't make much sense. > > > > What do you think? > > > > -- > > Mgr. Jiří Činčura > > Independent IT Specialist > > > > ------------------------------------------------------------ > > ------------------ > > Check out the vibrant tech community on one of the world's most > > engaging tech sites, SlashDot.org! http://sdm.link/slashdot > > _______________________________________________ > > Firebird-net-provider mailing list > > Fir...@li... > > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > > > > ------------------------------------------------------------ > > ------------------ > > Check out the vibrant tech community on one of the world's most > > engaging tech sites, SlashDot.org! http://sdm.link/slashdot > > _______________________________________________ > > Firebird-net-provider mailing list > > Fir...@li... > > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > > > > > ---------------------------------------------------------------------- > -------- > Check out the vibrant tech community on one of the world's most > engaging tech sites, SlashDot.org! http://sdm.link/slashdot > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
|
From: Ivan A. <int...@un...> - 2016-12-16 14:49:08
|
Why would the engine throw such an event in the first place? Does it have an actual reason or is it a bug to be fixed? I don't think the provider should just ignore server messages sent on purpose, but there might be an actual option on whether the current user actually needs them or not. 2016-12-16 16:18 GMT+02:00 Alexander Muylaert-Gelein < amu...@ho...>: > I say ney. It doesn’t make sense to raise unraised events. > > > > Sent from Mail <https://go.microsoft.com/fwlink/?LinkId=550986> for > Windows 10 > > > > *From: *Jiří Činčura <ji...@ci...> > *Sent: *vrijdag 16 december 2016 17:15 > *To: *For users & developers of the Firebird .NET providers > <fir...@li...> > *Subject: *[Firebird-net-provider] Firing event when event count is 0 > > > Hi *, > > As I'm now reworking some pieces in events (together with finalizers), > I'm wondering whether it make sense to fire the event for events when > the event count was 0. From outside POV it doesn't make much sense. > > What do you think? > > -- > Mgr. Jiří Činčura > Independent IT Specialist > > ------------------------------------------------------------ > ------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, SlashDot.org! http://sdm.link/slashdot > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > > ------------------------------------------------------------ > ------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, SlashDot.org! http://sdm.link/slashdot > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > > |
|
From: Alexander Muylaert-G. <amu...@ho...> - 2016-12-16 14:18:37
|
I say ney. It doesn’t make sense to raise unraised events. Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10 From: Jiří Činčura<mailto:ji...@ci...> Sent: vrijdag 16 december 2016 17:15 To: For users & developers of the Firebird .NET providers<mailto:fir...@li...> Subject: [Firebird-net-provider] Firing event when event count is 0 Hi *, As I'm now reworking some pieces in events (together with finalizers), I'm wondering whether it make sense to fire the event for events when the event count was 0. From outside POV it doesn't make much sense. What do you think? -- Mgr. Jiří Činčura Independent IT Specialist ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, SlashDot.org! http://sdm.link/slashdot _______________________________________________ Firebird-net-provider mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
|
From: Jiří Č. <ji...@ci...> - 2016-12-16 14:14:38
|
Hi *, As I'm now reworking some pieces in events (together with finalizers), I'm wondering whether it make sense to fire the event for events when the event count was 0. From outside POV it doesn't make much sense. What do you think? -- Mgr. Jiří Činčura Independent IT Specialist |
|
From: Jiří Č. <ji...@ci...> - 2016-12-12 14:43:35
|
More info: http://blog.cincura.net/233588-ado-net-provider-5-7-0-0-for-firebird-is-ready/ . -- Mgr. Jiří Činčura Independent IT Specialist |
|
From: Jiri C. (JIRA) <tr...@fi...> - 2016-12-12 09:11:14
|
Support for SIO_LOOPBACK_FAST_PATH
-----------------------------------
Key: DNET-726
URL: http://tracker.firebirdsql.org/browse/DNET-726
Project: .NET Data provider
Issue Type: Improvement
Components: ADO.NET Provider
Affects Versions: 5.6.0.0
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: Ivan M. (JIRA) <tr...@fi...> - 2016-12-09 10:58:19
|
Connect throws System.PlatformNotSupportedException in Linux (NET Core)
-----------------------------------------------------------------------
Key: DNET-725
URL: http://tracker.firebirdsql.org/browse/DNET-725
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 5.6.0.0
Environment: FibirdSql.Data.FirebirdClient 5.6.0.0
.NET Command Line Tools (1.0.0-preview2-1-003177)
Runtime Environment: Linux ubuntu 16.10 x64
Reporter: Ivan Masmitja
Assignee: Jiri Cincura
Testing last versión in NET Core I had PlatformNotSupportedException when it tries to connect.
System.PlatformNotSupportedException: Operation is not supported on this platform.
at System.Net.Sockets.SocketPal.WindowsIoctl(SafeCloseSocket handle, Int32 ioControlCode, Byte[] optionInValue, Byte[] optionOutValue, Int32& optionLength)
at System.Net.Sockets.Socket.IOControl(Int32 ioControlCode, Byte[] optionInValue, Byte[] optionOutValue)
at FirebirdSql.Data.Common.Extensions.SetKeepAlive(Socket socket, UInt64 time, UInt64 interval)
at FirebirdSql.Data.Client.Managed.GdsConnection.Connect()
at FirebirdSql.Data.FirebirdClient.ClientFactory.CreateManagedDatabase(FbConnectionString options)
at FirebirdSql.Data.FirebirdClient.ClientFactory.CreateDatabase(FbConnectionString options)
at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.Connect()
at FirebirdSql.Data.FirebirdClient.FbConnectionPoolManager.Pool.CreateNewConnectionIfPossibleImpl(FbConnectionString connectionString)
at FirebirdSql.Data.FirebirdClient.FbConnectionPoolManager.Pool.GetConnection(FbConnection owner)
at FirebirdSql.Data.FirebirdClient.FbConnection.Open()
at TestFirebird.Program.Main(String[] args)
Test code:
private static void TestFirebird()
{
FbConnectionStringBuilder csb = new FbConnectionStringBuilder();
csb.DataSource = "testserver";
csb.Database = "testdb";
csb.UserID = "SYSDBA";
csb.Password = "masterkey";
var cstr = csb.ToString();
FbConnection connection = new FbConnection(cstr);
connection.Open();
connection.Close();
}
--
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-12-09 07:23:31
|
Can you connect with telnet? Is the Firebird port opened on firewall? Basic network error triage… -- Mgr. Jiří Činčura Independent IT Specialist On Fri, Dec 9, 2016, at 05:15, LtColRDSChauhan wrote: > Hi, > > 1. I installed Firebird-3.0.1.32609_0_Win32 without opting to support > legacy user. After installation i could connect my database > through ISQL > and Flamerobin but my .NET application failed reporting: > > incompatible wire cryption levels for client and server > so to the firebird.conf file i added the following and re-started > firebird > service : > WireCrypt Enabled > > 2. Now on the server machine "SERVER_MACHINE" database gets > connected but > from other machine "CLIENT_MACHINE" error reported: > unable to complete network request to "SERVER_MACHINE". > I could ping the "SERVER_MACHINE" from "CLIENT_MACHINE" and flamerobin > could connect to database on "SERVER_MACHINE" from "CLIENT_MACHINE". > > 3. Made following changes to the firebird.conf file still from the > "CLIENT_MACHINE" i get error repeated - unable to complete network > request > to "SERVER_MACHINE" > > UserManager = Legacy_UserManager > WireCrypt = Disabled > AuthServer = Legacy_Auth, Srp, Win_Sspi > AuthClient = Legacy_Auth, Srp, Win_Sspi > TracePlugin = fbtrace > Providers = Remote,Engine12,Loopback > WireCryptPlugin = Arc4 > > 4. Please help me to set up correctly New Authentication for > Firebird 3 > for > the "CLIENT_MACHINE" . > > Regards, > Rajiv > ---------------------------------------------------------------------- > -------- > Developer Access Program for Intel Xeon Phi Processors > Access to Intel Xeon Phi processor-based developer platforms. > With one year of Intel Parallel Studio XE. > Training and support from Colfax. > Order your platform today.http://sdm.link/xeonphi > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
|
From: LtColRDSChauhan <rds...@gm...> - 2016-12-09 07:18:27
|
> > Message: 3 > Date: Thu, 8 Dec 2016 08:05:28 +0530 > From: LtColRDSChauhan <rds...@gm...> > Subject: [Firebird-net-provider] FbStreamingBackup Fails Now > To: fir...@li... > Message-ID: > <CAMG8wxieZMCftSSUOkrQY-4e=GJZtq_nMB6F+42Gx04DORj9PA@mail. > gmail.com> > Content-Type: text/plain; charset="utf-8" > > Hi, > > 1. I had been backing up using FbStreamingBackup since quite some time. > Recently it fails. The message reported is: > > Unable to complete network request to host " > No message for error code 335544721 found. > > 2. The ConnectionString of FbStreamingBackup at break point before Execute > is called has the following value: > > user=SYSDBA;password="abcdef"; > database=D:\abc\AppAbc\ABCFireBird\ABC.FDB; > datasource=MyPC;port=3050; > dialect=3;charset=NONE;connection lifetime=15; > compression=True; > pooling=true;minpoolsize=5;maxpoolsize=50; > packet size=8192;servertype=Default > > 3. I have checked up after removing compression=True; error remains. I have > allowed the port 3050, the fire bird service and my .NET application to > communicate through windows firewall. > > 4. Please help. > > Regards, > Rajiv > > Wanted to add: firebird version migrated to > Firebird-3.0.2.32641-0_Win32 from > Firebird-3.0.1.32609_0_Win32 > > Additional observations: Before reporting the error Unable to complete network request to host " No message for error code 335544721 found. the back up file is made and reaches size of 200MB, much lesser then expected about 370MB. Does FbStreamingBackup requires setting up file size ? |
|
From: LtColRDSChauhan <rds...@gm...> - 2016-12-09 04:15:35
|
Hi, 1. I installed Firebird-3.0.1.32609_0_Win32 without opting to support legacy user. After installation i could connect my database through ISQL and Flamerobin but my .NET application failed reporting: incompatible wire cryption levels for client and server so to the firebird.conf file i added the following and re-started firebird service : WireCrypt Enabled 2. Now on the server machine "SERVER_MACHINE" database gets connected but from other machine "CLIENT_MACHINE" error reported: unable to complete network request to "SERVER_MACHINE". I could ping the "SERVER_MACHINE" from "CLIENT_MACHINE" and flamerobin could connect to database on "SERVER_MACHINE" from "CLIENT_MACHINE". 3. Made following changes to the firebird.conf file still from the "CLIENT_MACHINE" i get error repeated - unable to complete network request to "SERVER_MACHINE" UserManager = Legacy_UserManager WireCrypt = Disabled AuthServer = Legacy_Auth, Srp, Win_Sspi AuthClient = Legacy_Auth, Srp, Win_Sspi TracePlugin = fbtrace Providers = Remote,Engine12,Loopback WireCryptPlugin = Arc4 4. Please help me to set up correctly New Authentication for Firebird 3 for the "CLIENT_MACHINE" . Regards, Rajiv |
|
From: Jiří Č. <ji...@ci...> - 2016-12-08 07:00:51
|
Regular FbConnection works? Did you tried plain telnet? -- Mgr. Jiří Činčura Independent IT Specialist On Thu, Dec 8, 2016, at 03:35, LtColRDSChauhan wrote: > Hi, > > 1. I had been backing up using FbStreamingBackup since quite some > time. > Recently it fails. The message reported is: > > Unable to complete network request to host " > No message for error code 335544721 found. > > 2. The ConnectionString of FbStreamingBackup at break point before > Execute > is called has the following value: > > user=SYSDBA;password="abcdef"; > database=D:\abc\AppAbc\ABCFireBird\ABC.FDB; > datasource=MyPC;port=3050; > dialect=3;charset=NONE;connection lifetime=15; > compression=True; > pooling=true;minpoolsize=5;maxpoolsize=50; > packet size=8192;servertype=Default > > 3. I have checked up after removing compression=True; error remains. I > have > allowed the port 3050, the fire bird service and my .NET > application to > communicate through windows firewall. > > 4. Please help. > > Regards, > Rajiv > ---------------------------------------------------------------------- > -------- > Developer Access Program for Intel Xeon Phi Processors > Access to Intel Xeon Phi processor-based developer platforms. > With one year of Intel Parallel Studio XE. > Training and support from Colfax. > Order your platform today.http://sdm.link/xeonphi > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
|
From: LtColRDSChauhan <rds...@gm...> - 2016-12-08 04:22:57
|
Wanted to add: firebird version migrated to Firebird-3.0.2.32641-0_Win32 from Firebird-3.0.1.32609_0_Win32 |
|
From: LtColRDSChauhan <rds...@gm...> - 2016-12-08 02:35:35
|
Hi, 1. I had been backing up using FbStreamingBackup since quite some time. Recently it fails. The message reported is: Unable to complete network request to host " No message for error code 335544721 found. 2. The ConnectionString of FbStreamingBackup at break point before Execute is called has the following value: user=SYSDBA;password="abcdef"; database=D:\abc\AppAbc\ABCFireBird\ABC.FDB; datasource=MyPC;port=3050; dialect=3;charset=NONE;connection lifetime=15; compression=True; pooling=true;minpoolsize=5;maxpoolsize=50; packet size=8192;servertype=Default 3. I have checked up after removing compression=True; error remains. I have allowed the port 3050, the fire bird service and my .NET application to communicate through windows firewall. 4. Please help. Regards, Rajiv |
|
From: Jiri C. (JIRA) <tr...@fi...> - 2016-12-07 11:45:21
|
IOException in GdsEventManager
------------------------------
Key: DNET-724
URL: http://tracker.firebirdsql.org/browse/DNET-724
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 5.6.0.0
Reporter: Jiri Cincura
Assignee: Jiri Cincura
Reported to me privately:
Message: IOException: Unable to read data from the transport connection: An established connection was aborted by the software in your host machine.
System.Net.Sockets.NetworkStream.Read:0
FirebirdSql.Data.Client.Managed.XdrStream.Read:0
FirebirdSql.Data.Client.Managed.XdrStream.ReadBytes:0
FirebirdSql.Data.Client.Managed.XdrStream.ReadNextOperation:0
FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.NextOperation:0
FirebirdSql.Data.Client.Managed.Version10.GdsEventManager.ThreadHandler:0
System.Threading.ThreadHelper.ThreadStart_Context:0
System.Threading.ExecutionContext.RunInternal:0
System.Threading.ExecutionContext.Run:0
System.Threading.ExecutionContext.Run:0
System.Threading.ThreadHelper.ThreadStart: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: Denis M. (JIRA) <tr...@fi...> - 2016-11-24 11:03:25
|
Wrong generate SQL statement for the stored procedure
-----------------------------------------------------
Key: DNET-723
URL: http://tracker.firebirdsql.org/browse/DNET-723
Project: .NET Data provider
Issue Type: Bug
Components: Entity Framework support
Affects Versions: 5.6.0.0
Environment: Firebird 2.5.2, Firebird Entity Framework Provider - version 5.6.0, Firebird ADO.NET Data Povider - version 5.6.0, Entity Framework - version 6.1.3
Reporter: Denis Maslov
Assignee: Jiri Cincura
Good day!
When I try execute simple procedure over EF, i got the next error: "FirebirdSql.Data.FirebirdClient.FbException: Dynamic SQL Error SQL error code = -204 Implementation limit exceeded ..."
In the end, I found that the problem in the wrong EF generation sql statement.
Text procedure (Firebrd):
procedure B_IMP_I_REESTR (
IDUSER integer,
IMPMODE integer,
IDGEN integer,
IDPARENT integer,
IDTCH integer,
NOMER varchar(15),
SBORNIK integer,
NAME varchar(250),
VIX_DAN blob sub_type 0 segment size 80,
ISSYSTEM integer,
POKAZ varchar(8),
GOD integer,
RABMAT integer,
IDGROUP integer,
IDPODGROUP integer,
IDTYPE integer,
ORDERVIEW integer,
CREATEDATE date,
AUTHOR varchar(250),
NORM_GUID varchar(100),
INSTALL_GUID varchar(100),
INDEX_YEAR integer,
INDEX_MONTH integer,
INDEX_ORGNAME varchar(250),
INDTYPE varchar(50))
returns (
ID integer)
...
Text procedure (EF generate):
SELECT
1 AS "C1",
"A"."ID" AS "ID"
FROM "B_IMP_I_REESTR"(CAST(@IDUSER AS INT), CAST(@IMPMODE AS INT), CAST(@IDGEN AS INT), CAST(@IDPARENT AS INT), CAST(@IDTCH AS INT), CAST(@NOMER AS VARCHAR(8191)), CAST(@SBORNIK AS INT), CAST(@NAME AS VARCHAR(8191)), CAST(@VIX_DAN AS BLOB SUB_TYPE BINARY), CAST(@ISSYSTEM AS INT), CAST(@POKAZ AS VARCHAR(8191)), CAST(@GOD AS INT), CAST(@RABMAT AS INT), CAST(@IDGROUP AS INT), CAST(@IDPODGROUP AS INT), CAST(@IDTYPE AS INT), CAST(@ORDERVIEW AS INT), CAST(@CREATEDATE AS TIMESTAMP), CAST(@AUTHOR AS VARCHAR(8191)), CAST(@NORM_GUID AS VARCHAR(8191)), CAST(@INSTALL_GUID AS VARCHAR(8191)), CAST(@INDEX_YEAR AS INT), CAST(@INDEX_MONTH AS INT), CAST(@INDEX_ORGNAME AS VARCHAR(8191)), CAST(@INDTYPE AS VARCHAR(8191))) AS "A"
For example, why INDTYPE varchar(50) -> CAST(@INDTYPE AS VARCHAR(8191)) ???
Regards, Maslov Denis.
--
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: Vladimir (JIRA) <tr...@fi...> - 2016-11-24 10:11:29
|
Dynamic SQL Statement generation limit error: eror code = -204 Implementation limit exceeded block size exceeds implementation restriction
------------------------------------------------------------------------------------------------------------------------------------------
Key: DNET-722
URL: http://tracker.firebirdsql.org/browse/DNET-722
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider, DDEX Provider, Entity Framework support
Affects Versions: 5.6.0.0
Environment: Windows 8, Visual Studio 2013 Update 5, Firebird-2.5.6.27020_0 (Win32), FirebirdSql.Data.FirebirdClient 5.6.0.0, DDEXProvider-3.0.2.0
Reporter: Vladimir
Assignee: Jiri Cincura
Hello, please help me with "Dynamic SQL Error: error code = -204 Implementation limit exceeded block size exceeds implementation restriction" error
Project details: .NET 4.5.2 WPF-app
nuget-packages:
Firebird Entity Framework Provider - version 5.6.0
Firebird ADO.NET Data Povider - version 5.6.0
Entity Framework - version 6.1.3
I have a number of Stored Procedures in my DB, which i use a lot. But when i tried to use these procedures with EntityFramework, i faced with an unsolvable problem. For this bug i chose two similar Stored Procedures: B_IMP_I_OGL and B_IMP_I_REESTR and created two projects to work with them. B_IMP_I_OGL - works perfectly, B_IMP_I_REESTR - returns following error during compilation:
"FirebirdSql.Data.FirebirdClient.FbException: Dynamic SQL Error
SQL error code = -204
Implementation limit exceeded
block size exceeds implementation restriction"
B_IMP_I_REESTR has 25 input parameters, while B_IMI_I_OGL has only 7 parameters. (Both procedures return only one parameter - integer ID)
This is my procedure:
create or alter procedure B_IMP_I_REESTR (
IDUSER integer,
IMPMODE integer,
IDGEN integer,
IDPARENT integer,
IDTCH integer,
NOMER varchar(15),
SBORNIK integer,
NAME varchar(250),
VIX_DAN blob sub_type 0 segment size 80,
ISSYSTEM integer,
POKAZ varchar(8),
GOD integer,
RABMAT integer,
IDGROUP integer,
IDPODGROUP integer,
IDTYPE integer,
ORDERVIEW integer,
CREATEDATE date,
AUTHOR varchar(250),
NORM_GUID varchar(100),
INSTALL_GUID varchar(100),
INDEX_YEAR integer,
INDEX_MONTH integer,
INDEX_ORGNAME varchar(250),
INDTYPE varchar(50))
returns (
ID integer)
as
declare variable REORDERING integer;
declare variable AINSERTING integer;
declare variable IDIND integer;
declare variable ISSYSTEM_OLD integer;
declare variable IDPARENT_OLD integer;
BEGIN
...
END
execute procedure B_IMP_U_REESTR_HIDE(:ID);
SUSPEND;
END
1) I added this Stored Procedure "B_IMP_I_REESTR" to my model.edmx file (and checked in Model Browser\Storage Model, that it has been added)
2) Then i opened Model Browser again and created complex type with one integer field named ID (return type for import function)
3) Then i created import function for B_IMP_I_REESTR procedure, which returns complex type (2)
4) This is calling code:
var temp_B_IMP_I_REESTR = Context.B_IMP_I_REESTR(10, 1, 19105302, 1399455, null, "132456", 0, "some text", null, 0, "", null, 0,
1, 1, 1399451, 6000000, null, "some other text", Guid.NewGuid().ToString(), null, null, null, "", "some random text");
foreach (B_IMP_I_REESTR_ReturnType bImpReestReturnComplexType in temp_B_IMP_I_REESTR)
{
MessageBox.Show(bImpReestReturnComplexType.ID.ToString());
}
And then i get unresolved exception:
"System.Data.Entity.Core.EntityCommandExecutionException" in EntityFramework.dll
Visual studio Output gives me the following statement:
FirebirdSql.Data.FirebirdClient Information: 0 : Command:
SELECT
1 AS "C1",
"A"."ID" AS "ID"
FROM "B_IMP_I_REESTR"(CAST(@IDUSER AS INT), CAST(@IMPMODE AS INT), CAST(@IDGEN AS INT), CAST(@IDPARENT AS INT), CAST(@IDTCH AS INT), CAST(@NOMER AS VARCHAR(8191)), CAST(@SBORNIK AS INT), CAST(@NAME AS VARCHAR(8191)), CAST(@VIX_DAN AS BLOB SUB_TYPE BINARY), CAST(@ISSYSTEM AS INT), CAST(@POKAZ AS VARCHAR(8191)), CAST(@GOD AS INT), CAST(@RABMAT AS INT), CAST(@IDGROUP AS INT), CAST(@IDPODGROUP AS INT), CAST(@IDTYPE AS INT), CAST(@ORDERVIEW AS INT), CAST(@CREATEDATE AS TIMESTAMP), CAST(@AUTHOR AS VARCHAR(8191)), CAST(@NORM_GUID AS VARCHAR(8191)), CAST(@INSTALL_GUID AS VARCHAR(8191)), CAST(@INDEX_YEAR AS INT), CAST(@INDEX_MONTH AS INT), CAST(@INDEX_ORGNAME AS VARCHAR(8191)), CAST(@INDTYPE AS VARCHAR(8191))) AS "A"
Parameters:
Name:IDUSER Type:Integer Used Value:10
Name:IMPMODE Type:Integer Used Value:1
Name:IDGEN Type:Integer Used Value:19105302
Name:IDPARENT Type:Integer Used Value:1399455
Name:IDTCH Type:Integer Used Value:<null>
Name:NOMER Type:VarChar Used Value:132456
Name:SBORNIK Type:Integer Used Value:0
Name:NAME Type:VarChar Used Value:some text
Name:VIX_DAN Type:Binary Used Value:<null>
Name:ISSYSTEM Type:Integer Used Value:0
Name:POKAZ Type:VarChar Used Value:
Name:GOD Type:Integer Used Value:<null>
Name:RABMAT Type:Integer Used Value:0
Name:IDGROUP Type:Integer Used Value:1
Name:IDPODGROUP Type:Integer Used Value:1
Name:IDTYPE Type:Integer Used Value:1399451
Name:ORDERVIEW Type:Integer Used Value:6000000
Name:CREATEDATE Type:TimeStamp Used Value:<null>
Name:AUTHOR Type:VarChar Used Value:some other text
Name:NORM_GUID Type:VarChar Used Value:da204a67-c82d-49ba-8475-945110f3c2f7
Name:INSTALL_GUID Type:VarChar Used Value:<null>
Name:INDEX_YEAR Type:Integer Used Value:<null>
Name:INDEX_MONTH Type:Integer Used Value:<null>
Name:INDEX_ORGNAME Type:VarChar Used Value:
Name:INDTYPE Type:VarChar Used Value:some random text
FirebirdSql.Data.FirebirdClient.FbException: Dynamic SQL Error
SQL error code = -204
Implementation limit exceeded
block size exceeds implementation restriction ---&gt; FirebirdSql.Data.Common.IscException: Dynamic SQL Error
SQL error code = -204
Implementation limit exceeded
block size exceeds implementation restriction
в FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ProcessResponse(IResponse response)
в FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadResponse()
в FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadGenericResponse()
в FirebirdSql.Data.Client.Managed.Version11.GdsStatement.Prepare(String commandText)
в FirebirdSql.Data.FirebirdClient.FbCommand.Prepare(Boolean returnsSet)
в FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand(CommandBehavior behavior, Boolean returnsSet)
в FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior)
--
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: Vladimir (JIRA) <tr...@fi...> - 2016-11-24 10:05:25
|
Dynamic SQL Statement generation limit error: eror code = -204 Implementation limit exceeded block size exceeds implementation restriction
------------------------------------------------------------------------------------------------------------------------------------------
Key: DNET-721
URL: http://tracker.firebirdsql.org/browse/DNET-721
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider, DDEX Provider, Entity Framework support
Affects Versions: 5.6.0.0
Environment: Windows 8, Visual Studio 2013 Update 5, Firebird-2.5.6.27020_0 (Win32), FirebirdSql.Data.FirebirdClient 5.6.0.0, DDEXProvider-3.0.2.0
Reporter: Vladimir
Assignee: Jiri Cincura
Hello, please help me with "Dynamic SQL Error: error code = -204 Implementation limit exceeded block size exceeds implementation restriction" error
Project details: .NET 4.5.2 WPF-app
nuget-packages:
Firebird Entity Framework Provider - version 5.6.0
Firebird ADO.NET Data Povider - version 5.6.0
Entity Framework - version 6.1.3
I have a number of Stored Procedures in my DB, which i use a lot. But when i tried to use these procedures with EntityFramework, i faced with an unsolvable problem. For this bug i chose two similar Stored Procedures: B_IMP_I_OGL and B_IMP_I_REESTR and created two projects to work with them. B_IMP_I_OGL - works perfectly, B_IMP_I_REESTR - returns following error during compilation:
"FirebirdSql.Data.FirebirdClient.FbException: Dynamic SQL Error
SQL error code = -204
Implementation limit exceeded
block size exceeds implementation restriction"
B_IMP_I_REESTR has 20 input parameters, while B_IMI_I_OGL has only 7 parameters. (Both procedures return only one parameter - integer ID)
This is my procedure:
create or alter procedure B_IMP_I_REESTR (
IDUSER integer,
IMPMODE integer,
IDGEN integer,
IDPARENT integer,
IDTCH integer,
NOMER varchar(15),
SBORNIK integer,
NAME varchar(250),
VIX_DAN blob sub_type 0 segment size 80,
ISSYSTEM integer,
POKAZ varchar(8),
GOD integer,
RABMAT integer,
IDGROUP integer,
IDPODGROUP integer,
IDTYPE integer,
ORDERVIEW integer,
CREATEDATE date,
AUTHOR varchar(250),
NORM_GUID varchar(100),
INSTALL_GUID varchar(100),
INDEX_YEAR integer,
INDEX_MONTH integer,
INDEX_ORGNAME varchar(250),
INDTYPE varchar(50))
returns (
ID integer)
as
declare variable REORDERING integer;
declare variable AINSERTING integer;
declare variable IDIND integer;
declare variable ISSYSTEM_OLD integer;
declare variable IDPARENT_OLD integer;
BEGIN
...
END
execute procedure B_IMP_U_REESTR_HIDE(:ID);
SUSPEND;
END
1) I added this Stored Procedure "B_IMP_I_REESTR" to my model.edmx file (and checked in Model Browser\Storage Model, that it has been added)
2) Then i opened Model Browser again and created complex type with one integer field named ID (return type for import function)
3) Then i created import function for B_IMP_I_REESTR procedure, which returns complex type (2)
4) This is calling code:
var temp_B_IMP_I_REESTR = Context.B_IMP_I_REESTR(10, 1, 19105302, 1399455, null, "132456", 0, "some text", null, 0, "", null, 0,
1, 1, 1399451, 6000000, null, "some other text", Guid.NewGuid().ToString(), null, null, null, "", "some random text");
foreach (B_IMP_I_REESTR_ReturnType bImpReestReturnComplexType in temp_B_IMP_I_REESTR)
{
MessageBox.Show(bImpReestReturnComplexType.ID.ToString());
}
And then i get unresolved exception:
"System.Data.Entity.Core.EntityCommandExecutionException" in EntityFramework.dll
Visual studio Output gives me the following statement:
FirebirdSql.Data.FirebirdClient Information: 0 : Command:
SELECT
1 AS "C1",
"A"."ID" AS "ID"
FROM "B_IMP_I_REESTR"(CAST(@IDUSER AS INT), CAST(@IMPMODE AS INT), CAST(@IDGEN AS INT), CAST(@IDPARENT AS INT), CAST(@IDTCH AS INT), CAST(@NOMER AS VARCHAR(8191)), CAST(@SBORNIK AS INT), CAST(@NAME AS VARCHAR(8191)), CAST(@VIX_DAN AS BLOB SUB_TYPE BINARY), CAST(@ISSYSTEM AS INT), CAST(@POKAZ AS VARCHAR(8191)), CAST(@GOD AS INT), CAST(@RABMAT AS INT), CAST(@IDGROUP AS INT), CAST(@IDPODGROUP AS INT), CAST(@IDTYPE AS INT), CAST(@ORDERVIEW AS INT), CAST(@CREATEDATE AS TIMESTAMP), CAST(@AUTHOR AS VARCHAR(8191)), CAST(@NORM_GUID AS VARCHAR(8191)), CAST(@INSTALL_GUID AS VARCHAR(8191)), CAST(@INDEX_YEAR AS INT), CAST(@INDEX_MONTH AS INT), CAST(@INDEX_ORGNAME AS VARCHAR(8191)), CAST(@INDTYPE AS VARCHAR(8191))) AS "A"
Parameters:
Name:IDUSER Type:Integer Used Value:10
Name:IMPMODE Type:Integer Used Value:1
Name:IDGEN Type:Integer Used Value:19105302
Name:IDPARENT Type:Integer Used Value:1399455
Name:IDTCH Type:Integer Used Value:<null>
Name:NOMER Type:VarChar Used Value:132456
Name:SBORNIK Type:Integer Used Value:0
Name:NAME Type:VarChar Used Value:some text
Name:VIX_DAN Type:Binary Used Value:<null>
Name:ISSYSTEM Type:Integer Used Value:0
Name:POKAZ Type:VarChar Used Value:
Name:GOD Type:Integer Used Value:<null>
Name:RABMAT Type:Integer Used Value:0
Name:IDGROUP Type:Integer Used Value:1
Name:IDPODGROUP Type:Integer Used Value:1
Name:IDTYPE Type:Integer Used Value:1399451
Name:ORDERVIEW Type:Integer Used Value:6000000
Name:CREATEDATE Type:TimeStamp Used Value:<null>
Name:AUTHOR Type:VarChar Used Value:some other text
Name:NORM_GUID Type:VarChar Used Value:da204a67-c82d-49ba-8475-945110f3c2f7
Name:INSTALL_GUID Type:VarChar Used Value:<null>
Name:INDEX_YEAR Type:Integer Used Value:<null>
Name:INDEX_MONTH Type:Integer Used Value:<null>
Name:INDEX_ORGNAME Type:VarChar Used Value:
Name:INDTYPE Type:VarChar Used Value:some random text
FirebirdSql.Data.FirebirdClient.FbException: Dynamic SQL Error
SQL error code = -204
Implementation limit exceeded
block size exceeds implementation restriction ---&gt; FirebirdSql.Data.Common.IscException: Dynamic SQL Error
SQL error code = -204
Implementation limit exceeded
block size exceeds implementation restriction
в FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ProcessResponse(IResponse response)
в FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadResponse()
в FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadGenericResponse()
в FirebirdSql.Data.Client.Managed.Version11.GdsStatement.Prepare(String commandText)
в FirebirdSql.Data.FirebirdClient.FbCommand.Prepare(Boolean returnsSet)
в FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand(CommandBehavior behavior, Boolean returnsSet)
в FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior)
--
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: Vladimir (JIRA) <tr...@fi...> - 2016-11-24 09:48:34
|
Dynamic SQL Statement generation limit error: eror code = -204 Implementation limit exceeded block size exceeds implementation restriction
------------------------------------------------------------------------------------------------------------------------------------------
Key: DNET-720
URL: http://tracker.firebirdsql.org/browse/DNET-720
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider, DDEX Provider, Entity Framework support
Affects Versions: 5.6.0.0
Environment: Windows 8, Visual Studio 2013 Update 5, Firebird-2.5.6.27020_0 (Win32), FirebirdSql.Data.FirebirdClient 5.6.0.0, DDEXProvider-3.0.2.0
Reporter: Vladimir
Assignee: Jiri Cincura
Hello, please help me with "Dynamic SQL Error: error code = -204 Implementation limit exceeded block size exceeds implementation restriction" error
Project details: .NET 4.5.2 WPF-app
nuget-packages:
Firebird Entity Framework Provider - version 5.6.0
Firebird ADO.NET Data Povider - version 5.6.0
Entity Framework - version 6.1.3
I have a number of Stored Procedures in my DB, which i use a lot. But when i tried to use these procedures with EntityFramework, i faced with an unsolvable problem. For this bug i chose two similar Stored Procedures: B_IMP_I_OGL and B_IMP_I_REESTR and created two projects to work with them. B_IMP_I_OGL - works perfectly, B_IMP_I_REESTR - returns following error during compilation:
"FirebirdSql.Data.FirebirdClient.FbException: Dynamic SQL Error
SQL error code = -204
Implementation limit exceeded
block size exceeds implementation restriction"
B_IMP_I_REESTR has 20 input parameters, while B_IMI_I_OGL has only 7 parameters. (Both procedures return only one parameter - integer ID)
This is my procedure:
create or alter procedure B_IMP_I_REESTR (
IDUSER integer,
IMPMODE integer,
IDGEN integer,
IDPARENT integer,
IDTCH integer,
NOMER varchar(15),
SBORNIK integer,
NAME varchar(250),
VIX_DAN blob sub_type 0 segment size 80,
ISSYSTEM integer,
POKAZ varchar(8),
GOD integer,
RABMAT integer,
IDGROUP integer,
IDPODGROUP integer,
IDTYPE integer,
ORDERVIEW integer,
CREATEDATE date,
AUTHOR varchar(250),
NORM_GUID varchar(100),
INSTALL_GUID varchar(100),
INDEX_YEAR integer,
INDEX_MONTH integer,
INDEX_ORGNAME varchar(250),
INDTYPE varchar(50))
returns (
ID integer)
as
declare variable REORDERING integer;
declare variable AINSERTING integer;
declare variable IDIND integer;
declare variable ISSYSTEM_OLD integer;
declare variable IDPARENT_OLD integer;
BEGIN
IF (:IDTCH = 0)
THEN IDTCH = NULL;
UPDATE B_TEMP_BLOB SET BLOB1 = :VIX_DAN WHERE ID = :IDGEN;
SELECT BLOB1 FROM B_TEMP_BLOB WHERE ID = :IDGEN INTO :VIX_DAN;
IF (:NORM_GUID <> '') THEN
BEGIN
SELECT ID, ISSYSTEM
FROM B_IMP_F_REESTR(:IDUSER, :IMPMODE, :NORM_GUID)
INTO ID, ISSYSTEM_OLD;
/* Только поиск для определения наличия записи */
IF (IMPMODE = 2) THEN BEGIN
SUSPEND;
EXIT;
END
IF (:ORDERVIEW IS NULL OR :ORDERVIEW <= 0)
THEN
SELECT MAX(ORDERVIEW) + 1
FROM B_REESTR
WHERE IDPARENT = :IDPARENT
/*AND RABMAT = :RABMAT /* для подстраховки */
INTO :ORDERVIEW;
ELSE
REORDERING = 1;
IF (ORDERVIEW IS NULL) THEN
ORDERVIEW = 1;
ELSE
REORDERING = 1;
IF (:ID IS NULL) THEN
BEGIN
ID = GEN_ID (A_G_SMETA, 1);
AINSERTING = 1;
END
IF (:IDGROUP = 0 OR :IDPODGROUP = 0) THEN
SELECT IDGROUP, IDPODGROUP
FROM B_READ_DEFAULT_REESTR_GROUPS (:IDUSER, :GOD)
INTO :IDGROUP, :IDPODGROUP;
IF (:REORDERING = 1) THEN
EXECUTE PROCEDURE B_WRITE_NEWORDER_REESTR(
:IDUSER, :ID, :IDPARENT, :RABMAT, :ORDERVIEW )
RETURNING_VALUES (:REORDERING);
SELECT INDEX_ID_MES
FROM B_FIND_IND_PARAMS (:IDUSER, :INDEX_YEAR, :INDEX_MONTH, :INDEX_ORGNAME)
INTO :IDIND;
IF (:AINSERTING = 1) THEN
BEGIN
INSERT INTO B_REESTR (
ID, IDPARENT, IDTCH, NOMER, SBORNIK, NAME, VIX_DAN, ISSYSTEM,
POKAZ, GOD, RABMAT, IDGROUP, IDPODGROUP, IDTYPE, IDIND,
ORDERVIEW, CREATEDATE, AUTHOR, NORM_GUID, INDTYPE, INSTALL_GUID)
VALUES (
:ID, :IDPARENT, :IDTCH, :NOMER, :SBORNIK, :NAME, :VIX_DAN, :ISSYSTEM,
:POKAZ, :GOD, :RABMAT, :IDGROUP, :IDPODGROUP, :IDTYPE, :IDIND,
:ORDERVIEW, :CREATEDATE, :AUTHOR, :NORM_GUID, :INDTYPE, :INSTALL_GUID);
END
ELSE
BEGIN
IF (:ISSYSTEM_OLD = 1)
THEN ISSYSTEM = 1;
/* <[9129]> - перенос нескрытых папок и сборников внутри скрываемого */
if ((:SBORNIK=0) and (-10000/*FEB60E9A677D*/ - :RABMAT in (0, 2, 3)/*[9F5FFA1322A6]*/)) then
for select :IDPARENT
from B_REESTR
where ID = :ID
into :IDPARENT_OLD
do
update B_REESTR
set IDPARENT = :IDPARENT_OLD
where IDPARENT = :ID
and RABMAT in (0, 2, 3);/*[9F5FFA1322A6]*/
/* поиск нескрытых родителей по рекурсии вверх, равно как и перенос
нескрытых дочерних узлов нижних уровней, выполнится в процессе Их
(родительских или дочерних узлов) "сокрытия" при импорте
</[9129]> */
UPDATE B_REESTR
SET IDPARENT = :IDPARENT,
IDTCH = :IDTCH,
NOMER = :NOMER,
SBORNIK = :SBORNIK,
NAME = :NAME,
VIX_DAN = :VIX_DAN,
ISSYSTEM = :ISSYSTEM,
POKAZ = :POKAZ,
GOD = :GOD,
RABMAT = :RABMAT,
IDGROUP = :IDGROUP,
IDPODGROUP = :IDPODGROUP,
IDTYPE = :IDTYPE,
ORDERVIEW = :ORDERVIEW,
IDIND = :IDIND,
CREATEDATE = :CREATEDATE,
AUTHOR = :AUTHOR,
NORM_GUID = :NORM_GUID,
INDTYPE = :INDTYPE,
INSTALL_GUID = :INSTALL_GUID
WHERE ID = :ID;
END
END
execute procedure B_IMP_U_REESTR_HIDE(:ID); /* [9129] - поддержка информации о скрытии/удалении */
SUSPEND;
END
1) I added this Stored Procedure "B_IMP_I_REESTR" to my model.edmx file (and checked in Model Browser\Storage Model, that it has been added)
2) Then i opened Model Browser again and created complex type with one integer field named ID (return type for import function)
3) Then i created import function for B_IMP_I_REESTR procedure, which returns complex type (2)
4) This is calling code:
var temp_B_IMP_I_REESTR = Context.B_IMP_I_REESTR(10, 1, 19105302, 1399455, null, "132456", 0, "some text", null, 0, "", null, 0,
1, 1, 1399451, 6000000, null, "some other text", Guid.NewGuid().ToString(), null, null, null, "", "some random text");
foreach (B_IMP_I_REESTR_ReturnType bImpReestReturnComplexType in temp_B_IMP_I_REESTR)
{
MessageBox.Show(bImpReestReturnComplexType.ID.ToString());
}
And then i get unresolved exception:
"System.Data.Entity.Core.EntityCommandExecutionException" in EntityFramework.dll
Visual studio Output gives me the following statement:
FirebirdSql.Data.FirebirdClient Information: 0 : Command:
SELECT
1 AS "C1",
"A"."ID" AS "ID"
FROM "B_IMP_I_REESTR"(CAST(@IDUSER AS INT), CAST(@IMPMODE AS INT), CAST(@IDGEN AS INT), CAST(@IDPARENT AS INT), CAST(@IDTCH AS INT), CAST(@NOMER AS VARCHAR(8191)), CAST(@SBORNIK AS INT), CAST(@NAME AS VARCHAR(8191)), CAST(@VIX_DAN AS BLOB SUB_TYPE BINARY), CAST(@ISSYSTEM AS INT), CAST(@POKAZ AS VARCHAR(8191)), CAST(@GOD AS INT), CAST(@RABMAT AS INT), CAST(@IDGROUP AS INT), CAST(@IDPODGROUP AS INT), CAST(@IDTYPE AS INT), CAST(@ORDERVIEW AS INT), CAST(@CREATEDATE AS TIMESTAMP), CAST(@AUTHOR AS VARCHAR(8191)), CAST(@NORM_GUID AS VARCHAR(8191)), CAST(@INSTALL_GUID AS VARCHAR(8191)), CAST(@INDEX_YEAR AS INT), CAST(@INDEX_MONTH AS INT), CAST(@INDEX_ORGNAME AS VARCHAR(8191)), CAST(@INDTYPE AS VARCHAR(8191))) AS "A"
Parameters:
Name:IDUSER Type:Integer Used Value:10
Name:IMPMODE Type:Integer Used Value:1
Name:IDGEN Type:Integer Used Value:19105302
Name:IDPARENT Type:Integer Used Value:1399455
Name:IDTCH Type:Integer Used Value:<null>
Name:NOMER Type:VarChar Used Value:132456
Name:SBORNIK Type:Integer Used Value:0
Name:NAME Type:VarChar Used Value:some text
Name:VIX_DAN Type:Binary Used Value:<null>
Name:ISSYSTEM Type:Integer Used Value:0
Name:POKAZ Type:VarChar Used Value:
Name:GOD Type:Integer Used Value:<null>
Name:RABMAT Type:Integer Used Value:0
Name:IDGROUP Type:Integer Used Value:1
Name:IDPODGROUP Type:Integer Used Value:1
Name:IDTYPE Type:Integer Used Value:1399451
Name:ORDERVIEW Type:Integer Used Value:6000000
Name:CREATEDATE Type:TimeStamp Used Value:<null>
Name:AUTHOR Type:VarChar Used Value:some other text
Name:NORM_GUID Type:VarChar Used Value:da204a67-c82d-49ba-8475-945110f3c2f7
Name:INSTALL_GUID Type:VarChar Used Value:<null>
Name:INDEX_YEAR Type:Integer Used Value:<null>
Name:INDEX_MONTH Type:Integer Used Value:<null>
Name:INDEX_ORGNAME Type:VarChar Used Value:
Name:INDTYPE Type:VarChar Used Value:some random text
FirebirdSql.Data.FirebirdClient.FbException: Dynamic SQL Error
SQL error code = -204
Implementation limit exceeded
block size exceeds implementation restriction ---&gt; FirebirdSql.Data.Common.IscException: Dynamic SQL Error
SQL error code = -204
Implementation limit exceeded
block size exceeds implementation restriction
в FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ProcessResponse(IResponse response)
в FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadResponse()
в FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadGenericResponse()
в FirebirdSql.Data.Client.Managed.Version11.GdsStatement.Prepare(String commandText)
в FirebirdSql.Data.FirebirdClient.FbCommand.Prepare(Boolean returnsSet)
в FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand(CommandBehavior behavior, Boolean returnsSet)
в FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
|
211 messages has been excluded from this view by a project administrator.
