[Firebird-net-provider] [FB-Tracker] Created: (DNET-600) Connection string improperly parsed
Connection string improperly parsed --- Key: DNET-600 URL: http://tracker.firebirdsql.org/browse/DNET-600 Project: .NET Data provider Issue Type: Bug Components: ADO.NET Provider Affects Versions: 4.6.1.0 Reporter: Jiri Cincura Assignee: Jiri Cincura Connection string data source=localhost;port number=20455;initial catalog=;user id=SYSDBA;password=masterkey;pooling=False;packet size=16384;character set=UTF8 is not properly parsed. The initial catalog is mixed with user id. -- 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 -- BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT Develop your own process in accordance with the BPMN 2 standard Learn Process modeling best practices with Bonita BPM through live exercises http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_ source=Sourceforge_BPM_Camp_5_6_15utm_medium=emailutm_campaign=VA_SF ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] [FB-Tracker] Created: (DNET-599) SetDefaultOptions sets catalog instead of initial catalog
SetDefaultOptions sets catalog instead of initial catalog - Key: DNET-599 URL: http://tracker.firebirdsql.org/browse/DNET-599 Project: .NET Data provider Issue Type: Bug Components: ADO.NET Provider Affects Versions: 4.6.1.0 Reporter: Jiri Cincura Assignee: Jiri Cincura Priority: Minor The line this.options.Add(catalog, DefaultCatalog); should be this.options.Add(initial catalog, DefaultCatalog);. -- 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 -- BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT Develop your own process in accordance with the BPMN 2 standard Learn Process modeling best practices with Bonita BPM through live exercises http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_ source=Sourceforge_BPM_Camp_5_6_15utm_medium=emailutm_campaign=VA_SF ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] [FB-Tracker] Created: (DNET-598) DDEX crashes Visual studio
DDEX crashes Visual studio -- Key: DNET-598 URL: http://tracker.firebirdsql.org/browse/DNET-598 Project: .NET Data provider Issue Type: Bug Components: DDEX Provider Affects Versions: 4.6.1.0 Environment: Windows 8 Pro, Visual Studio 2013 Pro, Firebird 2.5, Version of firebird .net adapter is 4.6.1.0. DDEX 3.0.1.0 Reporter: Sergey Isupov Assignee: Jiri Cincura Priority: Critical I'm trying to create table adapter wiht the following query: select i.ID, count(C.ID_LEGAL_PERSON) as CLIENT_COUNT, sum(ceil(a.symbols_count / e.STRING_LENGTH)) as SYMBOLS_COUNT, sum(p.issue_sum) as TOTAL_SUM, count(a.id) as ADS_COUNT from ISSUE I inner join ISSUE_ADS IA on I.ID = IA.ID_ISSUE inner join ADS A on IA.ID_ADS = A.ID inner join Client C on A.C_ID = C.ID_LEGAL_PERSON inner join PAYMENT P on P.id = ia.id_payment inner join Edition e on e.ID = i.ID_EDITION where I.ID = @ID_ISSUE and C.ID_SOURCE = @ID_SOURCE and e.id = @id_edition group by 1 On the last step after clicking Finish button Visual Studio crashes and restarts. -System logs--- Application: devenv.exe Platform version: v4.0.30319 Exception: System.AccessViolationException Stack: в Microsoft.VisualStudio.Data.Interop.IVsDataObjectChangeEvents.OnObjectAdded(System.String, System.Object[]) в Microsoft.VisualStudio.DataTools.DataServices.DataConnection+DataObjectChangeEvents.OnObjectAdded(Microsoft.VisualStudio.Data.DataObjectChangedEventArgs) в Microsoft.VisualStudio.Data.Compatibility.OldObjectChangeEvents.Microsoft.VisualStudio.Data.Compatibility.IVsDataCompatibleObjectMicrosoft.VisualStudio.Data.Services.IVsDataObjectChangeEvents.set_CompatibleObjectb__1(System.Object, Microsoft.VisualStudio.Data.Services.DataObjectAddedEventArgs) в System.EventHandler`1[[System.__Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]].Invoke(System.Object, System.__Canon) в Microsoft.VisualStudio.Data.Package.DataObjectChangeEvents.OnObjectAdded(Microsoft.VisualStudio.Data.Services.DataObjectAddedEventArgs) в Microsoft.VisualStudio.Data.Package.DataObjectChangeEvents.EndEventGroup(Int32) в Microsoft.VisualStudio.Data.Package.DataObjectStore+Tree.RaisePendingObjectChangeEvents() в Microsoft.VisualStudio.Data.Package.DataObjectStore.SelectObjects(System.String, System.Object[], System.String[], System.String, System.String, Boolean) в Microsoft.VisualStudio.Data.Package.DataMappedObjectSelector.SelectMappedObjects[[System.__Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]](System.String, System.Object[], Boolean) в Microsoft.VisualStudio.Data.Package.DataMappedObjectSelector.SelectMappedObjects[[System.__Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]](System.Object[], Boolean) в Microsoft.VisualStudio.DataTools.MetaData.Generic.MetaDataEnumerator.Microsoft.VisualStudio.DataTools.MetaData.Interop.IMetaDataEnumerator.EnumerateTables(System.String, System.String, System.String, Boolean) в Microsoft.VisualStudio.DataTools.Interop.ICQryAuto.set_NewSQLText(System.String) в Microsoft.VSDesigner.Data.VS.QueryEditor.set_CommandText(System.String) в Microsoft.VSDesigner.Data.VS.QueryEditor..ctor(Microsoft.VSDesigner.Data.ConfigurationContext, System.String) в Microsoft.VSDesigner.DataSource.DbSource.GetDataSource(Microsoft.VSDesigner.DataSource.DbSourceCommand, Microsoft.VSDesigner.Data.ConfigurationContext) в Microsoft.VSDesigner.DataSource.DbSource.UpdateDbObjectInfo() в Microsoft.VSDesigner.DataSource.DbSource.get_DbObjectType() в Microsoft.VSDesigner.DataSource.DesignDataSource.Get1TableBasedDesignTables() в Microsoft.VSDesigner.DataSource.Designer.DataSourceRootDesigner.GetRelatedRelationsFromDb(Microsoft.VSDesigner.DataSource.DesignTable) в Microsoft.VSDesigner.DataSource.Designer.DataSourceRootDesigner.ExecCmdAddRadTable() в Microsoft.VSDesigner.DataSource.Designer.DataSourceRootDesigner.OnCmdAddRadTable(System.Object, System.EventArgs) в System.ComponentModel.Design.MenuCommand.Invoke() в Microsoft.VSDesigner.DesignerFramework.VSMenuCommand.Invoke() в System.ComponentModel.Design.MenuCommand.Invoke(System.Object) в Microsoft.VisualStudio.Shell.OleMenuCommandService.Microsoft.VisualStudio.OLE.Interop.IOleCommandTarget.Exec(System.Guid ByRef, UInt32, UInt32, IntPtr, IntPtr) в Microsoft.VisualStudio.Shell.Interop.IVsUIDataSource.Invoke(System.String, System.Object, System.Object ByRef) в Microsoft.Internal.VisualStudio.PlatformUI.DataSource.Invoke(System.String, System.Object, System.Object ByRef) в Microsoft.VisualStudio.PlatformUI.VsCommand.Execute(System.Object) в
Re: [Firebird-net-provider] Random crashes in Finalizers
That's why I think my suggested changes won't impact most users of Dnet provider. On Thursday, April 9, 2015, Alexander Muylaert-Gelein amuylaert_gel...@hotmail.com wrote: Hi No, I have to admit I've abondoned EF long time ago. Too much magic behind the scenes for me. I couldn't predict the behavior of EF and that was too hard to manage. I also don't use embedded. I have a lot of pooled connections on cs and ss and normal stay open long connections on mostly ss. For mapping I prefer LLBLGEN pro, because it is dumb and thus does what I want and nothing extra. thanks a Date: Wed, 8 Apr 2015 18:16:36 +0300 From: zabulu...@gmail.com javascript:_e(%7B%7D,'cvml','zabulu...@gmail.com'); To: firebird-net-provider@lists.sourceforge.net javascript:_e(%7B%7D,'cvml','firebird-net-provider@lists.sourceforge.net'); Subject: Re: [Firebird-net-provider] Random crashes in Finalizers We use FbConnection in EF. EF does not always calls Dispose on classes provided by the FB Data provider. Alexander, what server do you use? For example, we use embedded configuration in our production. And code of the Fes* namespace doesn't work well in finalizers as we see. On Wed, Apr 8, 2015 at 6:12 PM, Alexander Muylaert-Gelein amuylaert_gel...@hotmail.com javascript:_e(%7B%7D,'cvml','amuylaert_gel...@hotmail.com'); wrote: Hi I intensively use firebird and provider... I always use the dispose method (using) and I don't depend on the GC for this. I never had any of the exceptions refererred to. Wouldn't it be better *not* to depend on something horrible as the gc for something as important as your db connectivity? Isn't it better to prevent then to cure? thanks a Date: Wed, 8 Apr 2015 18:00:26 +0300 From: zabulu...@gmail.com javascript:_e(%7B%7D,'cvml','zabulu...@gmail.com'); To: firebird-net-provider@lists.sourceforge.net javascript:_e(%7B%7D,'cvml','firebird-net-provider@lists.sourceforge.net'); Subject: [Firebird-net-provider] Random crashes in Finalizers Hello everyone. I want to discuss changes in finalizers regarding a couple of crashes we experience in our FB using. Issues in tracker: http://tracker.firebirdsql.org/browse/DNET-582 http://tracker.firebirdsql.org/browse/DNET-597 As for 582 we have discussion in PR that crutches it on GitHub: https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/pull/19 As for 597 try...catch doesn't work, it is a more complicated problem. My suggestion is to refactor Dispose/Finalizer methods to not use managed objects which might be already disposed. Maybe anyone have another thought? JIri, what do you think? -- BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT Develop your own process in accordance with the BPMN 2 standard Learn Process modeling best practices with Bonita BPM through live exercises http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_ source=Sourceforge_BPM_Camp_5_6_15utm_medium=emailutm_campaign=VA_SF ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net javascript:_e(%7B%7D,'cvml','Firebird-net-provider@lists.sourceforge.net'); https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT Develop your own process in accordance with the BPMN 2 standard Learn Process modeling best practices with Bonita BPM through live exercises http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_ source=Sourceforge_BPM_Camp_5_6_15utm_medium=emailutm_campaign=VA_SF ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net javascript:_e(%7B%7D,'cvml','Firebird-net-provider@lists.sourceforge.net'); https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT Develop your own process in accordance with the BPMN 2 standard Learn Process modeling best practices with Bonita BPM through live exercises http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_ source=Sourceforge_BPM_Camp_5_6_15utm_medium=emailutm_campaign=VA_SF ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net javascript:_e(%7B%7D,'cvml','Firebird-net-provider@lists.sourceforge.net'); https://lists.sourceforge.net/lists/listinfo/firebird-net-provider