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: Marcos R. W. (JIRA) <tr...@fi...> - 2017-04-20 14:05:28
|
System.IndexOutOfRangeException
-------------------------------
Key: DNET-755
URL: http://tracker.firebirdsql.org/browse/DNET-755
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 5.8.1.0
Environment: Framework 4.0 / Firebird 3.0.2.32703 / Visual Studio 2015
Occurs eventually in windows 10 Pro/Enterprise / Windows 7 Enterprise
Reporter: Marcos R. Weimer
Assignee: Jiri Cincura
public void DisparaEvento(string evento)
{
using (FbCommand q = conexao.CreateCommand())
{
q.CommandType = CommandType.Text;
q.CommandText = "execute block as begin POST_EVENT '" + evento + "'; end";
q.ExecuteNonQuery();
}
}
Multiple calls in a row...
DisparaEvento("EnviarNF");
DisparaEvento("ReciboNF");
DisparaEvento("CancelarNF");
DisparaEvento("DownloadNF");
DisparaEvento("ConsDestNF");
DisparaEvento("NFSe");
eventually:
An unhandled exception of type 'System.IndexOutOfRangeException' occurred in FirebirdSql.Data.FirebirdClient.dll
Stack:
em FirebirdSql.Data.Common.StatementBase.ProcessStatementTypeInfoBuffer(Byte[] buffer)
em FirebirdSql.Data.Client.Managed.Version11.GdsStatement.Prepare(String commandText)
em FirebirdSql.Data.FirebirdClient.FbCommand.Prepare(Boolean returnsSet)
em FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand(CommandBehavior behavior, Boolean returnsSet)
em FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteNonQuery()
em UltraNFe.EventosFB.DisparaEvento(String evento) na C:\ultra\UltraNFe2\EventosFB.cs:linha 100
em UltraNFe.EventosFB.DispararEventos() na C:\ultra\UltraNFe2\EventosFB.cs:linha 110
em UltraNFe.FPrincipal.btnAutomatico_Click(Object sender, EventArgs e) na C:\ultra\UltraNFe2\Form1.cs:linha 506
em UltraNFe.FPrincipal.Form1_Shown(Object sender, EventArgs e) na C:\ultra\UltraNFe2\Form1.cs:linha 195
em System.Windows.Forms.Form.OnShown(EventArgs e)
em System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
em System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
em System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
em System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
em System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
em System.Windows.Forms.Control.InvokeMarshaledCallbacks()
em System.Windows.Forms.Control.WndProc(Message& m)
em System.Windows.Forms.Form.WndProc(Message& m)
em System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
em System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
em System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)
em System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
em System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
em UltraNFe.Program.Main() na C:\ultra\UltraNFe2\Program.cs:linha 64
em System.AppDomain._nExecuteAssembly(RuntimeAssembly assembly, String[] args)
em System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)
em Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
em System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
em System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
em System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
em System.Threading.ThreadHelper.ThreadStart()
Not ocurred in Firebird 2.5.7.27050 with FirebirdSQL.Data.FirebirdClient 2.7.7.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: Jiri C. (JIRA) <tr...@fi...> - 2017-04-20 12:13:31
|
Allow overriding only part of DefaultFbMigrationSqlGeneratorBehavior
---------------------------------------------------------------------
Key: DNET-754
URL: http://tracker.firebirdsql.org/browse/DNET-754
Project: .NET Data provider
Issue Type: Task
Components: Entity Framework support
Affects Versions: 5.8.1.0
Reporter: Jiri Cincura
Assignee: Jiri Cincura
Priority: Minor
Mostly trigger name.
--
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: Andreas P. (JIRA) <tr...@fi...> - 2017-04-19 14:49:29
|
Problem with Tablename and CodeFirst
------------------------------------
Key: DNET-753
URL: http://tracker.firebirdsql.org/browse/DNET-753
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 5.8.1.0
Environment: Firebird 2.5 Server, EntityFramework6.1.3, .net 4.6.2
Reporter: Andreas Patock
Assignee: Jiri Cincura
If we use a classname longer than 15 letters we get a "Name longer than database column size" on Update-Database.
I think someone does a byte count over a unicode string, so 16 letters result in 32 bytes and this is more than the firebird restriction.
What I wonder is that the problem didn't appear on foreignkey-names.
--
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: Clyde E. <ct...@gm...> - 2017-04-07 12:26:30
|
I finally remembered the additional step ... described in StackOverflow: //----------------------------------------------------------------------------------------------------------------------------------------------- //To install Firebird: Visual Studio 2013 -> File -> New -> Project, etc. ---------- then Tools -> Library Package Manager -> Manage NuGet //Packages -> search "firebird" -> Firebird ADO.NET Data provider -> Install (button). // //Resulted in 1) References -> FirebirdSql.Data.FirebirdClient, and 2) FirebirdSql.Data.FirebirdClient.5.8.0 subdir ... with Firebird .dll's. //add using FirebirdSql.Data.FirebirdClient; //----------------------------------------------------------------------------------------------------------------------------------------------- //!!!!!!!!!!!!!!!!stackoverflow.com/questions/42864674/how-do-i-create-a-firebird-database-file-programmatically!!!!!!!!!!!!!!!!!!!! // //From www.firebirdsql.org/en/firebird-3-0/ ... downloaded Firebird-3.0.2.32703-0_x64.zip // //Unzipped into temporary subdir (Unzip) // //Created fb3embedded subdir in project subdir ... next to bin, obj, etc. // //Move from Unzip subdir to fb3embedded subdir // intl folder and all contents // plugins\engine12.dll // fbclient.dll // firebird.msg // icu* // msvcp100.dll // msvcr100.dll // // add to the code public const string stCLIENT_LIBRARY = @"..\..\fb3embedded\fbclient.dll"; //----------------------------------------------------------------------------------------------------------------------------------------------- On Thu, Apr 6, 2017 at 8:36 AM, Clyde Eisenbeis <ct...@gm...> wrote: > After most things work, I decided to start with a new program / > project ... over time, the memory fades. > > Here is the procedure I used: > > To install Firebird: Visual Studio 2013 -> File -> New -> Project, > etc. ---------- then Tools -> Library Package Manager -> Manage NuGet > Packages -> search "firebird" -> Firebird ADO.NET Data provider -> > Install (button). > > Resulted in 1) References -> FirebirdSql.Data.FirebirdClient, and 2) > FirebirdSql.Data.FirebirdClient.5.8.0 subdir ... with Firebird .dll's. > > Then added "using FirebirdSql.Data.FirebirdClient". > > This statement results in a compile error: > > string stCreateConnectionString = new FbConnectionStringBuilder { > Database = stPathFilename, > UserID = stUserID, > Password = stPassword, > ServerType = FbServerType.Embedded, > ClientLibrary = stCLIENT_LIBRARY > }.ToString(); > > Does not like "stCLIENT_LIBRARY". What step am I missing? Thanks! |
|
From: Andreas P. (JIRA) <tr...@fi...> - 2017-04-07 09:09:07
|
No SQL-Statements in the console
--------------------------------
Key: DNET-752
URL: http://tracker.firebirdsql.org/browse/DNET-752
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 5.8.1.0
Reporter: Andreas Patock
Assignee: Jiri Cincura
Hi,
we have used version 4.10.0.0 and in this version we see sqlstatements in debug and release.
We want to switch to version 5.8.1.0, but now the output of the statements is completely gone.
I tried to add a tracelistener to the app.config like in:
https://www.tabsoverspaces.com/232603-improved-command-logging-in-ado-net-provider-for-firebird-part-2/?utm_source=blog.cincura.net&shared=email&msg=fail&shared=email&msg=fail
but this doesn't work.
Please help - we want to see the SQLStatements when we create a debugversion of the application.
--
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: Clyde E. <ct...@gm...> - 2017-04-06 13:36:59
|
After most things work, I decided to start with a new program /
project ... over time, the memory fades.
Here is the procedure I used:
To install Firebird: Visual Studio 2013 -> File -> New -> Project,
etc. ---------- then Tools -> Library Package Manager -> Manage NuGet
Packages -> search "firebird" -> Firebird ADO.NET Data provider ->
Install (button).
Resulted in 1) References -> FirebirdSql.Data.FirebirdClient, and 2)
FirebirdSql.Data.FirebirdClient.5.8.0 subdir ... with Firebird .dll's.
Then added "using FirebirdSql.Data.FirebirdClient".
This statement results in a compile error:
string stCreateConnectionString = new FbConnectionStringBuilder {
Database = stPathFilename,
UserID = stUserID,
Password = stPassword,
ServerType = FbServerType.Embedded,
ClientLibrary = stCLIENT_LIBRARY
}.ToString();
Does not like "stCLIENT_LIBRARY". What step am I missing? Thanks!
|
|
From: Nicolas T. <nft...@ho...> - 2017-04-06 11:44:37
|
Got it, tanks -----Mensagem original----- De: Jiří Činčura [mailto:ji...@ci...] Enviada em: quinta-feira, 6 de abril de 2017 08:40 Para: fir...@li... Assunto: Re: [Firebird-net-provider] RES: ADO.NET provider 5.8.1.0 You need new csproj support, aka VS2017. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ On Thu, Apr 6, 2017, at 13:37, Nicolas Timmers wrote: > Hello Jiri > > When i try to open the solution from version 5.8.1.0 I get the > fallowing message > > C:\temp\TEMP\Provider\Provider\src\FirebirdSql.Data.FirebirdClient\Fir > ebirdSql.Data.FirebirdClient_NET45.csproj > : error : The default XML namespace of the project must be the > MSBuild XML namespace. If the project is authored in the MSBuild 2003 > format, please add > xmlns="http://schemas.microsoft.com/developer/msbuild/2003" to the > <Project> element. If the project has been authored in the old 1.0 or > 1.2 format, please convert it to MSBuild 2003 format. > C:\temp\TEMP\Provider\Provider\src\FirebirdSql.Data.FirebirdClient\Fir > ebirdSql.Data.FirebirdClient_NET45.csproj > > > And the solution cannot be open, how can I proceed ? > > > -----Mensagem original----- > De: Jiří Činčura [mailto:ji...@ci...] Enviada em: quarta-feira, 5 > de abril de 2017 03:13 > Para: For users & developers of the Firebird .NET providers > <fir...@li...> > Cc: fir...@ya...; For discussion among Firebird > Developers <fir...@li...> > Assunto: [Firebird-net-provider] ADO.NET provider 5.8.1.0 > > More info: > https://www.tabsoverspaces.com/233609-ado-net-provider-5-8-1-0-for-fir > ebird-is-ready/ > . > > -- > 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: Jiří Č. <ji...@ci...> - 2017-04-06 11:40:23
|
You need new csproj support, aka VS2017. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ On Thu, Apr 6, 2017, at 13:37, Nicolas Timmers wrote: > Hello Jiri > > When i try to open the solution from version 5.8.1.0 I get the fallowing > message > > C:\temp\TEMP\Provider\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdSql.Data.FirebirdClient_NET45.csproj > : error : The default XML namespace of the project must be the MSBuild > XML namespace. If the project is authored in the MSBuild 2003 format, > please add xmlns="http://schemas.microsoft.com/developer/msbuild/2003" to > the <Project> element. If the project has been authored in the old 1.0 or > 1.2 format, please convert it to MSBuild 2003 format. > C:\temp\TEMP\Provider\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdSql.Data.FirebirdClient_NET45.csproj > > > And the solution cannot be open, how can I proceed ? > > > -----Mensagem original----- > De: Jiří Činčura [mailto:ji...@ci...] > Enviada em: quarta-feira, 5 de abril de 2017 03:13 > Para: For users & developers of the Firebird .NET providers > <fir...@li...> > Cc: fir...@ya...; For discussion among Firebird > Developers <fir...@li...> > Assunto: [Firebird-net-provider] ADO.NET provider 5.8.1.0 > > More info: > https://www.tabsoverspaces.com/233609-ado-net-provider-5-8-1-0-for-firebird-is-ready/ > . > > -- > 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: Nicolas T. <nft...@ho...> - 2017-04-06 11:37:24
|
Hello Jiri When i try to open the solution from version 5.8.1.0 I get the fallowing message C:\temp\TEMP\Provider\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdSql.Data.FirebirdClient_NET45.csproj : error : The default XML namespace of the project must be the MSBuild XML namespace. If the project is authored in the MSBuild 2003 format, please add xmlns="http://schemas.microsoft.com/developer/msbuild/2003" to the <Project> element. If the project has been authored in the old 1.0 or 1.2 format, please convert it to MSBuild 2003 format. C:\temp\TEMP\Provider\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdSql.Data.FirebirdClient_NET45.csproj And the solution cannot be open, how can I proceed ? -----Mensagem original----- De: Jiří Činčura [mailto:ji...@ci...] Enviada em: quarta-feira, 5 de abril de 2017 03:13 Para: For users & developers of the Firebird .NET providers <fir...@li...> Cc: fir...@ya...; For discussion among Firebird Developers <fir...@li...> Assunto: [Firebird-net-provider] ADO.NET provider 5.8.1.0 More info: https://www.tabsoverspaces.com/233609-ado-net-provider-5-8-1-0-for-firebird-is-ready/ . -- 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...> - 2017-04-05 06:13:08
|
More info: https://www.tabsoverspaces.com/233609-ado-net-provider-5-8-1-0-for-firebird-is-ready/ . -- Mgr. Jiří Činčura Independent IT Specialist |
|
From: Jiri C. (JIRA) <tr...@fi...> - 2017-04-05 06:07:10
|
In netstandard1.6's NuGet reference NETStandard.Library and then extra packages
-------------------------------------------------------------------------------
Key: DNET-751
URL: http://tracker.firebirdsql.org/browse/DNET-751
Project: .NET Data provider
Issue Type: Task
Components: NuGet packages
Affects Versions: 5.8.1.0
Reporter: Jiri Cincura
Assignee: Jiri Cincura
Priority: Minor
--
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: Roberto C. da S. (JIRA) <tr...@fi...> - 2017-04-04 19:56:15
|
is not possible applay command: Update-Database to migrate database on package manager console
----------------------------------------------------------------------------------------------
Key: DNET-750
URL: http://tracker.firebirdsql.org/browse/DNET-750
Project: .NET Data provider
Issue Type: Bug
Components: Entity Framework support
Affects Versions: 5.8.0.0
Environment: Visual Studio 2015
FirebirdSql.Data.FirebirdClient 5.8.0.0
EntityFramework.Firebird 5.8.0.0
aspnetboilerplate with Module Zero v1.5.2
Reporter: Roberto Carlos da Silva
Assignee: Jiri Cincura
Priority: Critical
PM> Update-Database -Verbose
Using StartUp project 'TestaSite.EntityFramework'.
Using NuGet project 'TestaSite.EntityFramework'.
Specify the '-Verbose' flag to view the SQL statements being applied to the target database.
System.NotSupportedException: There is no store type corresponding to the EDM type 'Edm.Byte' of primitive type 'Byte'.
at FirebirdSql.Data.EntityFramework6.FbProviderManifest.GetStoreType(TypeUsage edmType) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbProviderManifest.cs:line 417
at System.Data.Entity.ModelConfiguration.Edm.Services.StructuralTypeMappingGenerator.MapTableColumn(EdmProperty property, String columnName, Boolean isInstancePropertyOnDerivedType)
at System.Data.Entity.ModelConfiguration.Edm.Services.PropertyMappingGenerator.Generate(EntityType entityType, IEnumerable`1 properties, EntitySetMapping entitySetMapping, MappingFragment entityTypeMappingFragment, IList`1 propertyPath, Boolean createNewColumn)
at System.Data.Entity.ModelConfiguration.Edm.Services.TableMappingGenerator.Generate(EntityType entityType, DbDatabaseMapping databaseMapping)
at System.Data.Entity.ModelConfiguration.Edm.Services.DatabaseMappingGenerator.GenerateEntityTypes(DbDatabaseMapping databaseMapping)
at System.Data.Entity.ModelConfiguration.Edm.Services.DatabaseMappingGenerator.Generate(EdmModel conceptualModel)
at System.Data.Entity.DbModelBuilder.Build(DbProviderManifest providerManifest, DbProviderInfo providerInfo)
at System.Data.Entity.DbModelBuilder.Build(DbConnection providerConnection)
at System.Data.Entity.Internal.LazyInternalContext.CreateModel(LazyInternalContext internalContext)
at System.Data.Entity.Internal.RetryLazy`2.GetValue(TInput input)
at System.Data.Entity.Internal.LazyInternalContext.InitializeContext()
at System.Data.Entity.Internal.InternalContext.ForceOSpaceLoadingForKnownEntityTypes()
at System.Data.Entity.DbContext.System.Data.Entity.Infrastructure.IObjectContextAdapter.get_ObjectContext()
at Abp.EntityFramework.AbpDbContext.RegisterToChanges()
at Abp.Zero.EntityFramework.AbpZeroDbContext`3..ctor(String nameOrConnectionString)
at TestaSite.EntityFramework.TestaSiteDbContext..ctor() in C:\arquivos\TestaSite\TestaSite.EntityFramework\EntityFramework\TestaSiteDbContext.cs:line 20
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Data.Entity.Infrastructure.DbContextInfo.CreateInstance()
at System.Data.Entity.Infrastructure.DbContextInfo..ctor(Type contextType, DbProviderInfo modelProviderInfo, AppConfig config, DbConnectionInfo connectionInfo, Func`1 resolver)
at System.Data.Entity.Migrations.DbMigrator..ctor(DbMigrationsConfiguration configuration, DbContext usersContext, DatabaseExistenceState existenceState, Boolean calledByCreateDatabase)
at System.Data.Entity.Migrations.DbMigrator..ctor(DbMigrationsConfiguration configuration)
at System.Data.Entity.Migrations.Design.ToolingFacade.BaseRunner.GetMigrator()
at System.Data.Entity.Migrations.Design.ToolingFacade.UpdateRunner.Run()
at System.AppDomain.DoCallBack(CrossAppDomainDelegate callBackDelegate)
at System.AppDomain.DoCallBack(CrossAppDomainDelegate callBackDelegate)
at System.Data.Entity.Migrations.Design.ToolingFacade.Run(BaseRunner runner)
at System.Data.Entity.Migrations.Design.ToolingFacade.Update(String targetMigration, Boolean force)
at System.Data.Entity.Migrations.UpdateDatabaseCommand.<>c__DisplayClass2.<.ctor>b__0()
at System.Data.Entity.Migrations.MigrationsDomainCommand.Execute(Action command)
There is no store type corresponding to the EDM type 'Edm.Byte' of primitive type 'Byte'.
--
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: Donald J. (JIRA) <tr...@fi...> - 2017-03-30 11:03:21
|
System.StackOverflowException was unhandled
-------------------------------------------
Key: DNET-749
URL: http://tracker.firebirdsql.org/browse/DNET-749
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 5.8.0.0
Environment: Windows 10 and Windows 7
Reporter: Donald Jansen
Assignee: Jiri Cincura
Attachments: FirebirdConnector.cs, Untitled.png
The following exception is being thrown, and is not handled by a try...catch...finaly
System.StackOverflowException was unhandled
Message: An unhandled exception of type 'System.StackOverflowException' occurred in mscorlib.dll
There is no stacktrace available with this exception
The exception seems to come from the DataReader.Read()
If the DataReader is empty it is thrown directly,
if the DataReader has rows then it is thrown after the last row was handled
--
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: Slavomir S. <sko...@el...> - 2017-03-29 19:20:43
|
We are using this for all commands because developer are lazy. Together with explicit prepare, no possible performance loss, just memory. But I'm not sure for commands without prepare. If I remember API, there is possibility to execute SQL without prepare. And in this case, the first time will be slower because of roundtrip to server. Next time will be faster. But if are you using parameters, you must prepare SQL -> fist is same, second is better. Slavek > Is this only for commands that has Prepare() explicitly called on? > Is there a scenario where performance will be slower than currently? > > On 29 March 2017 at 11:58, Slavomir Skopalik <sko...@el...> wrote: > >> Hi all, >> >> after discussion with Jiri Cincura I prepare proposal for prepared >> statement cache that will be implemented inside .NET provider. >> >> Motivation: >> >> Preparation of SQL statement take a time and also server resources. Many >> SQL server has this functionality build in in engine, but FB not. >> >> More reading for example here: >> http://stackoverflow.com/questions/12141036/preparedstatement-caching- >> what-does-it-mean-how-does-it-work >> >> We implement this to speed up our web application (cache is persistent >> across web requests). >> >> >> Ideas: >> >> Each connection that already exists in pool well keep a private >> dictionary of cached statements (can be disable by config). >> >> Not used SQL will be released after some time out, also cache will have >> maximum statements like default 100. >> >> When application obtaining new connection from pool, provider will look >> for free connection with higher number of cached statements. >> >> >> The question: >> >> Is this interesting to have this functionality inside provider and fully >> transparent? >> |
|
From: Gerdus v. Z. <ger...@gm...> - 2017-03-29 13:27:48
|
Sound interesting to have in the provider. Is this only for commands that has Prepare() explicitly called on? Is there a scenario where performance will be slower than currently? On 29 March 2017 at 11:58, Slavomir Skopalik <sko...@el...> wrote: > Hi all, > > after discussion with Jiri Cincura I prepare proposal for prepared > statement cache that will be implemented inside .NET provider. > > Motivation: > > Preparation of SQL statement take a time and also server resources. Many > SQL server has this functionality build in in engine, but FB not. > > More reading for example here: > http://stackoverflow.com/questions/12141036/preparedstatement-caching- > what-does-it-mean-how-does-it-work > > We implement this to speed up our web application (cache is persistent > across web requests). > > > Ideas: > > Each connection that already exists in pool well keep a private > dictionary of cached statements (can be disable by config). > > Not used SQL will be released after some time out, also cache will have > maximum statements like default 100. > > When application obtaining new connection from pool, provider will look > for free connection with higher number of cached statements. > > > The question: > > Is this interesting to have this functionality inside provider and fully > transparent? > > Slavek > > PS: We combine this with RO transaction pool and also with data caching, > but this is different story. > > > -- > Ing. Slavomir Skopalik > Executive Head > Elekt Labs s.r.o. > Collection and evaluation of data from machines and laboratories > by means of system MASA (http://www.elektlabs.cz/m2demo) > ----------------------------------------------------------------- > Address: > Elekt Labs s.r.o. > Chaloupky 158 > 783 72 Velky Tynec > Czech Republic > --------------------------------------------------------------- > Mobile: +420 724 207 851 > icq:199 118 333 > skype:skopaliks > e-mail:sko...@el... > http://www.elektlabs.cz > > > > ------------------------------------------------------------ > ------------------ > 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 > -- ------------------------------------------------------------------------ Gerdus van Zyl www.infireal.com |
|
From: Jiri C. (JIRA) <tr...@fi...> - 2017-03-29 12:07:21
|
Improve input buffer
--------------------
Key: DNET-748
URL: http://tracker.firebirdsql.org/browse/DNET-748
Project: .NET Data provider
Issue Type: Improvement
Components: ADO.NET Provider
Affects Versions: 5.8.0.0
Reporter: Jiri Cincura
Assignee: Jiri Cincura
https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/pull/65
I looked at DNET-740 (http://tracker.firebirdsql.org/browse/DNET-740) and found the single threaded performance to be worse than it was.
Main performance killer was _inputBuffer.RemoveRange(0, data.Length);
Replaced the list with a class that keeps a list of the readbuffers and removes them when no longer needed.
Example performance on same data with 444528 rows
5.8: 11s
after this pull: 3.9s
--
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: Slavomir S. <sko...@el...> - 2017-03-29 10:58:49
|
Hi all, after discussion with Jiri Cincura I prepare proposal for prepared statement cache that will be implemented inside .NET provider. Motivation: Preparation of SQL statement take a time and also server resources. Many SQL server has this functionality build in in engine, but FB not. More reading for example here: http://stackoverflow.com/questions/12141036/preparedstatement-caching-what-does-it-mean-how-does-it-work We implement this to speed up our web application (cache is persistent across web requests). Ideas: Each connection that already exists in pool well keep a private dictionary of cached statements (can be disable by config). Not used SQL will be released after some time out, also cache will have maximum statements like default 100. When application obtaining new connection from pool, provider will look for free connection with higher number of cached statements. The question: Is this interesting to have this functionality inside provider and fully transparent? Slavek PS: We combine this with RO transaction pool and also with data caching, but this is different story. -- Ing. Slavomir Skopalik Executive Head Elekt Labs s.r.o. Collection and evaluation of data from machines and laboratories by means of system MASA (http://www.elektlabs.cz/m2demo) ----------------------------------------------------------------- Address: Elekt Labs s.r.o. Chaloupky 158 783 72 Velky Tynec Czech Republic --------------------------------------------------------------- Mobile: +420 724 207 851 icq:199 118 333 skype:skopaliks e-mail:sko...@el... http://www.elektlabs.cz |
|
From: Andrey (JIRA) <tr...@fi...> - 2017-03-28 03:31:25
|
The full path of the file database in the initial catalog causes the error.
---------------------------------------------------------------------------
Key: DNET-747
URL: http://tracker.firebirdsql.org/browse/DNET-747
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 5.8.0.0
Environment: windows xp x86
Reporter: Andrey
Assignee: Jiri Cincura
Priority: Critical
connection_string:
initial catalog="C:\Documents and Settings\user\Мои документы\Visual Studio 2010\Projects\Копия SWSpecNew\compile\Debug\SWSpecDB.FDB";dialect=3;data source=localhost;user id=SYSDBA;password=masterkey;server type=Embedded;pooling=True;min pool size=0;max pool size=50;client library="C:\Documents and Settings\user\Мои документы\Visual Studio 2010\Projects\Копия SWSpecNew\compile\Debug\firebird\fbclient.dll";character set=UTF8;DEFAULT CHARACTER SET = UTF8;
The full path of the file database in the initial catalog causes the error.
FbConnection.CreateDatabase(connection_string 8192, true, false);
or
FirebirdSql.Data.FirebirdClient.FbConnection fc = new FirebirdSql.Data.FirebirdClient.FbConnection(connection_string );
fc.Open();
error:
I/O error during "CreateFile (create)" operation for file "C:\DOCUMENTS AND SETTINGS\USER\ЌнШ ХнЪсУенты\VISUAL STUDIO 2010\PROJECTS\ЊнЯШя SWSPECNEW\COMPILE\DEBUG\SWSPECDB.FDB"
Error while trying to create file
If I use version 5.5 of this error does not occur.
--
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: Mark R. <ma...@la...> - 2017-03-25 18:32:01
|
On 25-3-2017 15:09, Clyde Eisenbeis wrote: > I should have started this email with ... C# ... Firebird ADO.NET ... > FirebirdClient.5.8.0 ... Visual Studio 2013. > > I tried entering > > CREATE GENERATOR gen_t1_id; > SET GENERATOR gen_t1_id TO 0; > > set term !! ; > CREATE TRIGGER T1_BI FOR T1 > > in my C# code ... the compiler complains. This appears to not be > relevant for C#. You need to show how you execute this. For example `set term` is unknown in Firebird itself, it is just client-side functionality in a number of Firebird tools (like isql, flame robin, and in the Firebird ADO.net provider FbScript tool. If you are not using FbScript, but executing these statements like normal commands, then you must execute 1) leave out `SET TERM`, and execute the statements individually. > What I need is the ability to add data and retrieve the primary key > which needs to be autoincremented ... see > http://stackoverflow.com/questions/42981872/why-the-executenonquery-catch-exception-validation-error-for-column-orgtable > for the current code. Use `INSERT .... RETURNING ID`. Mark -- Mark Rotteveel |
|
From: Clyde E. <ct...@gm...> - 2017-03-25 14:10:16
|
I should have started this email with ... C# ... Firebird ADO.NET ...
FirebirdClient.5.8.0 ... Visual Studio 2013.
I tried entering
CREATE GENERATOR gen_t1_id;
SET GENERATOR gen_t1_id TO 0;
set term !! ;
CREATE TRIGGER T1_BI FOR T1
in my C# code ... the compiler complains. This appears to not be
relevant for C#.
What I need is the ability to add data and retrieve the primary key
which needs to be autoincremented ... see
http://stackoverflow.com/questions/42981872/why-the-executenonquery-catch-exception-validation-error-for-column-orgtable
for the current code.
On Fri, Mar 24, 2017 at 10:57 AM, Scott Morgan <bl...@bl...> wrote:
> On 03/24/2017 03:09 PM, Clyde Eisenbeis wrote:
>> Using http://www.firebirdfaq.org/faq29/ as a reference.
>>
>> 1) If I understand this website, the CREATE GENERATOR is initiated only once?
>
> Yes. It's a global item like a table, so you just need to create it once
> (and commit that change to the DB,. Changes to tables and other global
> items like that all need to be committed before using them). It'll have
> an initial value of 0 and calls to GEN_ID will increment it by the
> specified value (usually 1)
>
>> 2) Likewise the CREATE TRIGGER is initiated only once?
>
> Yes. It's just associated with the table, ready to run whenever the
> specific event happens, so...
>
>> 3) When is the T1_BI used (CREATE TRIGGER T1_BI FOR T1)?
>
> The "ACTIVE BEFORE INSERT POSITION 0" specifies that. In this case
> 'BEFORE INSERT', so whenever a new item is inserted into the table, that
> trigger is run.
>
>> 4) I see the 'id' field in table t1. I see upper case 'ID' in the
>> TRIGGER. Are these two the same?
>
> Yes. (Bit of bad form in that FAQ there I'd say, mixing case) Unquoted
> identifiers (names of tables, columns, etc.) are stored in upper case.
> So id, ID, iD, and Id are all the same (ID).
>
>
> You'll get more detailed answers about this stuff on the main Firebird
> mailing list, and I highly recommend the Firebird Book by Helen Borrie,
> which covers all this clearly and in depth. It's things like triggers
> and foreign keys that make a proper DB so powerful, but it can take a
> bit of getting used to.
>
> Scott
>
>
> ------------------------------------------------------------------------------
> 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...> - 2017-03-25 07:08:50
|
This might help you with DDEX and VS2017. https://www.tabsoverspaces.com/233604-installing-ddex-provider-for-firebird-into-visual-studio-2017/ -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ |
|
From: Marcos R. W. (JIRA) <tr...@fi...> - 2017-03-24 20:28:20
|
FbScript Exception
------------------
Key: DNET-746
URL: http://tracker.firebirdsql.org/browse/DNET-746
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 5.8.0.0
Environment: Visual Studio 2015 / target .Net Framework 4.0
Reporter: Marcos R. Weimer
Assignee: Jiri Cincura
- Read script file and execute:
- Multiple lines with comments
- null except in execute this specific line: "delete from custo_reposicao_atual; -- deletar tudo pq na 514 teve alteracoes e pode estar errado o custo"
Example:
ExecuteScript("delete from custo_reposicao_atual; -- deletar tudo pq na 514 teve alteracoes e pode estar errado o custo")
public void ExecuteScript(string ASQL)
{
FbScript sc = new FbScript(ASql);
sc.Parse(); ---> exception here
FbBatchExecution fbe = new FbBatchExecution(FConexao);
fbe.AppendSqlStatements(sc);
fbe.Execute();
}
--
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: Scott M. <bl...@bl...> - 2017-03-24 15:57:18
|
On 03/24/2017 03:09 PM, Clyde Eisenbeis wrote: > Using http://www.firebirdfaq.org/faq29/ as a reference. > > 1) If I understand this website, the CREATE GENERATOR is initiated only once? Yes. It's a global item like a table, so you just need to create it once (and commit that change to the DB,. Changes to tables and other global items like that all need to be committed before using them). It'll have an initial value of 0 and calls to GEN_ID will increment it by the specified value (usually 1) > 2) Likewise the CREATE TRIGGER is initiated only once? Yes. It's just associated with the table, ready to run whenever the specific event happens, so... > 3) When is the T1_BI used (CREATE TRIGGER T1_BI FOR T1)? The "ACTIVE BEFORE INSERT POSITION 0" specifies that. In this case 'BEFORE INSERT', so whenever a new item is inserted into the table, that trigger is run. > 4) I see the 'id' field in table t1. I see upper case 'ID' in the > TRIGGER. Are these two the same? Yes. (Bit of bad form in that FAQ there I'd say, mixing case) Unquoted identifiers (names of tables, columns, etc.) are stored in upper case. So id, ID, iD, and Id are all the same (ID). You'll get more detailed answers about this stuff on the main Firebird mailing list, and I highly recommend the Firebird Book by Helen Borrie, which covers all this clearly and in depth. It's things like triggers and foreign keys that make a proper DB so powerful, but it can take a bit of getting used to. Scott |
|
From: Paul R. (JIRA) <tr...@fi...> - 2017-03-24 15:40:23
|
Collection was modified; enumeration operation may not execute.
---------------------------------------------------------------
Key: DNET-745
URL: http://tracker.firebirdsql.org/browse/DNET-745
Project: .NET Data provider
Issue Type: Bug
Affects Versions: 5.8.0.0
Environment: .Net 4 and4.5
Reporter: Paul Reeves
Assignee: Jiri Cincura
We have a client that have found what appears to be a bug in v5.8.0.0
The code and the stack trace are attached below.
The same code works fine with all versions between 4.1 and 5.7
They've also tested with .Net framework 4 and 4.5
They are happy to run a debug build to help fix this, but have not been able to create a test case.
#if DEBUG
var cmd = "select s.S_SHOPID, s.S_VALUE as FOO, s1.S_VALUE as BAR, s2.S_VALUE as SNAFU " +
"from SYSTEMSETTING s " +
"left join SYSTEMSETTING s1 on s.S_SHOPID = s1.S_SHOPID " +
"left join SYSTEMSETTING s2 on s.S_SHOPID = s2.S_SHOPID " +
"where s.S_SYSTEM_ID = 9202 " +
"and s1.S_SYSTEM_ID = 9200 " +
"and s2.S_SYSTEM_ID = 9201 " +
"and s.S_VALUE = 'Y' " +
"and s1.S_VALUE <> '' " +
"and s2.S_VALUE <> ''";
using (FbCommand fbCmd = new FbCommand(cmd)) {
using (DataTable myDT = new DataTable()) {
using (FbDataAdapter da = new FbDataAdapter()) {
da.SelectCommand = fbCmd;
fbCmd.Connection = DbConnection;
try {
LogFile.Log("Before Data Adapter.Fill() call. Managed Thread ID: " + System.Threading.Thread.CurrentThread.ManagedThreadId.ToString(), true);
da.Fill(myDT);
LogFile.Log("After Data Adapter.Fill() call. Managed Thread ID: " + System.Threading.Thread.CurrentThread.ManagedThreadId.ToString(), true);
foreach (DataRow row in myDT.Rows) {
LogFile.Log("Row Logged");
}
}
catch (Exception e) {
LogFile.Log("******--- ERROR ---******", true);
LogFile.Log("Managed Thread ID: " + System.Threading.Thread.CurrentThread.ManagedThreadId.ToString());
LogFile.Log("Error Message: " + e.Message);
LogFile.Log("Error Message: " + e.StackTrace);
}
}
}
}
LogFile.Log("After Select via SQL Test. Managed Thread ID: " + System.Threading.Thread.CurrentThread.ManagedThreadId.ToString(), true);
#endif
--------------------------------------------------------------------------------
Tuesday 21 March 2017 01:20:07.308 PM
--------------------------------------------------------------------------------
:Before Select via SQL Test. Managed Thread ID: 4
:FirebirdSql.Data.FirebirdClient version: 5.8.0.0
--------------------------------------------------------------------------------
Tuesday 21 March 2017 01:20:07.308 PM
--------------------------------------------------------------------------------
:Before Data Adapter.Fill() call. Managed Thread ID: 4
--------------------------------------------------------------------------------
Tuesday 21 March 2017 01:20:07.313 PM
--------------------------------------------------------------------------------
:******--- ERROR ---******
:Managed Thread ID: 4
:Error Message: Collection was modified; enumeration operation may not execute.
:Error Message: at System.ThrowHelper.ThrowInvalidOperationException(ExceptionResource resource)
at System.Collections.Generic.List`1.Enumerator.MoveNextRare()
at System.Linq.Enumerable.<TakeIterator>d__24`1.MoveNext()
at System.Linq.Buffer`1..ctor(IEnumerable`1 source)
at System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source)
at FirebirdSql.Data.Client.Managed.XdrStream.Read(Byte[] buffer, Int32 offset, Int32 count) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Managed\XdrStream.cs:line 249
at FirebirdSql.Data.Client.Managed.XdrStream.ReadBytes(Int32 count) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Managed\XdrStream.cs:line 336
at FirebirdSql.Data.Client.Managed.XdrStream.ReadOpaque(Int32 length) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Managed\XdrStream.cs:line 348
at FirebirdSql.Data.Client.Managed.GdsConnection.ProcessOperation(Int32 operation, XdrStream xdr) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Managed\GdsConnection.cs:line 362
at FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadSingleResponse() in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Managed\Version10\GdsDatabase.cs:line 638
at 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:line 593
at 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:line 605
at 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:line 77
at FirebirdSql.Data.FirebirdClient.FbCommand.Prepare(Boolean returnsSet) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:line 1148
at 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:line 1171
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:line 523
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at PNDataService.DbConnectionManager.InitializeEvents(String errorstatus, Boolean resumedFromDownTime) in C:\Dev VS\PNDATASERVICEVS4.5\DbConnectionManager.cs:line 987
--------------------------------------------------------------------------------
Tuesday 21 March 2017 01:20:07.329 PM
--------------------------------------------------------------------------------
:After Select via SQL Test. Managed Thread ID: 4
--
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: Clyde E. <ct...@gm...> - 2017-03-24 15:09:52
|
Using http://www.firebirdfaq.org/faq29/ as a reference. 1) If I understand this website, the CREATE GENERATOR is initiated only once? 2) Likewise the CREATE TRIGGER is initiated only once? 3) When is the T1_BI used (CREATE TRIGGER T1_BI FOR T1)? 4) I see the 'id' field in table t1. I see upper case 'ID' in the TRIGGER. Are these two the same? |
211 messages has been excluded from this view by a project administrator.
