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: Scot L. (JIRA) <tr...@fi...> - 2016-10-25 02:39:58
|
Invalid Blob Handle With Compression = true
-------------------------------------------
Key: DNET-709
URL: http://tracker.firebirdsql.org/browse/DNET-709
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 5.5.0.0
Environment: Win7 64, 3.0.0.32483
Reporter: Scot Lunsford
Assignee: Jiri Cincura
invalid BLOB handle exception when attempting to read a specific blob value if the new compression features is ON. Most reads are successful, but it consistently fails reading a specific files stored as a zip file in the blob field. If compression is turned off it reads the BLOB successfully.
I can provide the specific file if needed.
at FirebirdSql.Data.FirebirdClient.FbDataReader.CheckedGetValue[T](Func`1 f) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbDataReader.cs:line 850
at FirebirdSql.Data.FirebirdClient.FbDataReader.GetValue(Int32 i) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbDataReader.cs:line 453
at System.Data.Entity.Core.Common.Internal.Materialization.Shaper.ErrorHandlingValueReader`1.GetUntypedValueDefault(DbDataReader reader, Int32 ordinal)
at System.Data.Entity.Core.Common.Internal.Materialization.Shaper.ErrorHandlingValueReader`1.GetValue(DbDataReader reader, Int32 ordinal)
--
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-10-24 15:14:37
|
Install 3.0.2.1. -- Mgr. Jiří Činčura Independent IT Specialist On Mon, Oct 24, 2016, at 16:58, Todd Manchester wrote: > > Hi, > > > First let me apologize if this is the wrong place to place this but I > could not determine how else to contact you and it it related. > > > When I use the NuGet package manager to for the > FirebirdSql.Data.FirebirdClient and I select the the version should be > 3.0.2 (I need this version). It places version 3.0.0.0 instead in my > project. This makes it not possible to use. Is it possible that the > correct version could take its place? Thanks for your hard work! I am > attaching 2 screenshots > > https://1drv.ms/i/s!ApL4KEEAk0xwh69c6QN36H6XKRAwEA > > [https://storage.live.com/Items/704C93004128F892%21120796%3ACustomThumbnailSource%2CHighRes%2CDefault?width=1016&height=663&authKey=%21AOkDd-h-lykQMBA]<https://1drv.ms/i/s!ApL4KEEAk0xwh69c6QN36H6XKRAwEA> > > NugetPackageManager.png<https://1drv.ms/i/s!ApL4KEEAk0xwh69c6QN36H6XKRAwEA> > 1drv.ms > PNG Image > > https://1drv.ms/f/s!ApL4KEEAk0xwh69bUEbPU9nBNW7y2Q > > [https://storage.live.com/Items/704C93004128F892%21120797%3ACustomThumbnailSource%2CHighRes%2CDefault?width=354&height=886&authKey=%21AFBGz1PZwTVu8tk]<https://1drv.ms/f/s!ApL4KEEAk0xwh69bUEbPU9nBNW7y2Q> > > Firebird<https://1drv.ms/f/s!ApL4KEEAk0xwh69bUEbPU9nBNW7y2Q> > 1drv.ms > Folder > > > > Sincerely, > > Todd Manchester > Chronicle Technologies Inc. > ------------------------------------------------------------------------------ > 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: Todd M. <to...@ho...> - 2016-10-24 14:58:25
|
Hi, First let me apologize if this is the wrong place to place this but I could not determine how else to contact you and it it related. When I use the NuGet package manager to for the FirebirdSql.Data.FirebirdClient and I select the the version should be 3.0.2 (I need this version). It places version 3.0.0.0 instead in my project. This makes it not possible to use. Is it possible that the correct version could take its place? Thanks for your hard work! I am attaching 2 screenshots https://1drv.ms/i/s!ApL4KEEAk0xwh69c6QN36H6XKRAwEA [https://storage.live.com/Items/704C93004128F892%21120796%3ACustomThumbnailSource%2CHighRes%2CDefault?width=1016&height=663&authKey=%21AOkDd-h-lykQMBA]<https://1drv.ms/i/s!ApL4KEEAk0xwh69c6QN36H6XKRAwEA> NugetPackageManager.png<https://1drv.ms/i/s!ApL4KEEAk0xwh69c6QN36H6XKRAwEA> 1drv.ms PNG Image https://1drv.ms/f/s!ApL4KEEAk0xwh69bUEbPU9nBNW7y2Q [https://storage.live.com/Items/704C93004128F892%21120797%3ACustomThumbnailSource%2CHighRes%2CDefault?width=354&height=886&authKey=%21AFBGz1PZwTVu8tk]<https://1drv.ms/f/s!ApL4KEEAk0xwh69bUEbPU9nBNW7y2Q> Firebird<https://1drv.ms/f/s!ApL4KEEAk0xwh69bUEbPU9nBNW7y2Q> 1drv.ms Folder Sincerely, Todd Manchester Chronicle Technologies Inc. |
|
From: Charles J C. II (JIRA) <tr...@fi...> - 2016-10-20 17:24:56
|
DbModelBuilder.Entity<TEntity>().MapToStoredProcedures() creates an empty procedure
-----------------------------------------------------------------------------------
Key: DNET-708
URL: http://tracker.firebirdsql.org/browse/DNET-708
Project: .NET Data provider
Issue Type: Bug
Components: Entity Framework support
Affects Versions: 5.5.0.0
Environment: Windows 7, Visual Studio 2015 Enterprise, Firebird 3.0.0.32485, EntityFramework.Firebird 5.5.0, FirebirdSql.Data.FirebirdClient 5.5.0
Reporter: Charles J Christie II
Assignee: Jiri Cincura
Priority: Minor
I attempted to map my entities as procedures in the model builder. I then went to test my database and, upon calling SaveChanges on my context, I got the following exception:
"Dynamic SQL Error
SQL error code = -84
procedure Address_Insert does not return any values
At line 1, column 15"
I opened the database using DBeaver and loaded the code used for the generated stored procedure:
CREATE OR ALTER PROCEDURE Address_Insert ("FirstName" VARCHAR(100), "LastName" VARCHAR(100), "AttnLine" VARCHAR(100), "Line1" VARCHAR(255), "Line2" VARCHAR(255), "City" VARCHAR(50), "State" VARCHAR(50), "Zip" VARCHAR(10), "Country" VARCHAR(53), "Job_Id" INTEGER, "Profile_Id" INTEGER)
AS
BEGIN
END
And in the migration:
CreateStoredProcedure(
"dbo.Address_Insert",
p => new
{
FirstName = p.String(maxLength: 100),
LastName = p.String(maxLength: 100),
AttnLine = p.String(maxLength: 100),
Line1 = p.String(maxLength: 255),
Line2 = p.String(maxLength: 255),
City = p.String(maxLength: 50),
State = p.String(maxLength: 50),
Zip = p.String(maxLength: 10),
Country = p.String(maxLength: 53),
Job_Id = p.Int(),
Profile_Id = p.Int(),
},
body: ""
);
All of the generated stored procedures have the same problem. They're all completely blank.
For now I won't use them. I'd suggest that if you don't want to implement this functionality any time soon, that you make it throw a NotImplementedException if you can, or have it prominently shown in your documentation that it doesn't do anything. Thank you.
--
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: Charles J C. II (JIRA) <tr...@fi...> - 2016-10-20 15:24:00
|
Invalid SQL generated for migration if changing a column from null to not null
------------------------------------------------------------------------------
Key: DNET-707
URL: http://tracker.firebirdsql.org/browse/DNET-707
Project: .NET Data provider
Issue Type: Bug
Components: Entity Framework support
Affects Versions: 5.5.0.0
Environment: Windows 7, VS 2015 Enterprise, EF 6.1.3, EntityFramework.Firebird 5.5.0, FirebirdSql.Data.FirebirdClient 5.5.0, Firebird 3.0.0.32485
Reporter: Charles J Christie II
Assignee: Jiri Cincura
I changed a column's type and null constraint during development of a new application. I found out later that Firebird doesn't support that through the ALTER TABLE ALTER COLUMN syntax, and that other options are available here: http://www.firebirdfaq.org/faq103/
Here's the line that was generated by migrations when I changed the data type on a property from Nullable<int> to long:
ALTER TABLE "Booklets" ALTER COLUMN "File_Size" TYPE BIGINT NOT NULL
;
Apparently, according to that page, all admin tools change the value on the system table. Maybe we should do that here too.
--
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...> - 2016-10-09 07:45:45
|
Support for isc_spb_expected_db
-------------------------------
Key: DNET-706
URL: http://tracker.firebirdsql.org/browse/DNET-706
Project: .NET Data provider
Issue Type: Sub-task
Components: ADO.NET Provider
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: Ralf J. (JIRA) <tr...@fi...> - 2016-10-05 14:03:45
|
FBStatistical does not like pathes to database with non ascii characters in it
-------------------------------------------------------------------------------
Key: DNET-705
URL: http://tracker.firebirdsql.org/browse/DNET-705
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 5.0.5.0
Environment: Windows 10 (de locale), Visual Studio 2015, Firebird Embedded 2.5.6 and 3.0.1
Reporter: Ralf Jansen
Assignee: Jiri Cincura
Trying to use FBStatistical against a database residing in a path with non-ascii characters (like german umlauts) fails with a Exception that the database can't be opened
Sample
FbStatistical stat = new FbStatistical();
stat.ConnectionString = "server type=Embedded;character set=UTF8;initial catalog=C:\MyLovelyFolder\aö\database.fdb;user id=SYSDBA;password=masterkey;pooling=False;client library=C:\Firebird_x64\fbembed.dll"
stat.Options = FbStatisticalFlags.HeaderPages;
try
{
stat.Execute();
}
catch (FbException ex)
{
....
}
will result in an "Can't open database file C:\\MYLOVELYFOLDER\\Aö\\DATABASE.FDB" with ErrorCode 336920605 Exception.
Interesting sidenote the internal uppercasing ignored the ö umlaut.
--
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-10-05 08:08:48
|
More info: http://blog.cincura.net/233576-ado-net-provider-5-5-0-0-for-firebird-is-ready/ . -- Mgr. Jiří Činčura Independent IT Specialist |
|
From: Marcos R. W. (JIRA) <tr...@fi...> - 2016-09-29 19:20:43
|
An unhandled exception of type 'System.NullReferenceException' - FbCommand
---------------------------------------------------------------------------
Key: DNET-704
URL: http://tracker.firebirdsql.org/browse/DNET-704
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 5.1.1.0, 2.7.7
Environment: Visual Studio 2012 / Windows 10/11/ Server 2012 / .Net Framework 4.0 / 4.5
Reporter: Marcos R. Weimer
Assignee: Jiri Cincura
Exception: An unhandled exception of type 'System.NullReferenceException' occurred in FirebirdSql.Data.FirebirdClient.dll
in RollbackImplicitTransaction (line 764):
int transactionCount = Connection.InnerConnection.Database.TransactionCount;
Connection = has connection value
InnerConnection = null
Sporadic error, did not identify the cause of the problem.
Trace:
<TraceRecord xmlns="http://schemas.microsoft.com/2004/10/E2ETraceEvent/TraceRecord" Severity="Critical"><TraceIdentifier>http://msdn.microsoft.com/TraceCodes/System/ActivityTracing/2004/07/Reliability/Exception/Unhandled</TraceIdentifier><Description>Exceção não tratada</Description><AppDomain>UltraNFe.vshost.exe</AppDomain><Exception><ExceptionType>System.NullReferenceException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</ExceptionType><Message>Referência de objeto não definida para uma instância de um objeto.</Message><StackTrace> em FirebirdSql.Data.FirebirdClient.FbCommand.RollbackImplicitTransaction() na C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:linha 768
em FirebirdSql.Data.FirebirdClient.FbCommand.Release() na C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:linha 806
em FirebirdSql.Data.FirebirdClient.FbCommand.Dispose(Boolean disposing) na C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:linha 372
em System.ComponentModel.Component.Finalize()</StackTrace><ExceptionString>System.NullReferenceException: Referência de objeto não definida para uma instância de um objeto.
em FirebirdSql.Data.FirebirdClient.FbCommand.RollbackImplicitTransaction() na C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:linha 768
em FirebirdSql.Data.FirebirdClient.FbCommand.Release() na C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:linha 806
em FirebirdSql.Data.FirebirdClient.FbCommand.Dispose(Boolean disposing) na C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:linha 372
em System.ComponentModel.Component.Finalize()</ExceptionString></Exception></TraceRecord>
sorry for my English
--
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: Thomas K. (JIRA) <tr...@fi...> - 2016-09-29 12:07:13
|
Update or insert parameterName
------------------------------
Key: DNET-703
URL: http://tracker.firebirdsql.org/browse/DNET-703
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 5.1.1.0
Environment: Windows
Reporter: Thomas Kragh
Assignee: Jiri Cincura
Hey
After upgrading Firebird provider from 4.7.0 to 5.1.1 I receive the following exception: "FbParameterCollection already contains FbParameter with ParameterName 'id'." when executing the following update or insert statement(the statement have been simplified).
UPDATE OR INSERT INTO TESTTABLE (id)
VALUES (@id)
matching (id)
returning id
The statement is executed with a input parameter named "@id" and a output variable named "id".
On the project i work on this pattern is used many times, is there a chance that this change can be reverted?
--
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: fish (JIRA) <tr...@fi...> - 2016-09-29 03:34:29
|
The database file cannot be released immediately when disconnected
------------------------------------------------------------------
Key: DNET-702
URL: http://tracker.firebirdsql.org/browse/DNET-702
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 5.1.1.0
Environment: Firebird 3.0.0/3.0.1/2.5.5, Windows 10, x64
Reporter: fish
Assignee: Jiri Cincura
using (FbConnection fbconn = new FbConnection("Database=F:\\fb[30|25].gdb;User ID=SYSDBA;Password=masterkey;Pooling=False"))
{
fbconn.Open();
fbconn.Close();
FbConnection.ClearAllPools();
File.Delete("F:\\fb30.gdb"); //Failed in FB 3.0.0 and 3.0.1(x64) --> The process cannot access the file 'F:\\fb30.gdb' because it is being used by another process.
File.Delete("F:\\fb25.gdb"); //Worked in FB 2.5.5(x64)
}
--
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: fish (JIRA) <tr...@fi...> - 2016-09-27 04:52:17
|
No exception with ExecuteReader()
---------------------------------
Key: DNET-701
URL: http://tracker.firebirdsql.org/browse/DNET-701
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 5.1.1.0
Environment: Windows 10
Reporter: fish
Assignee: Jiri Cincura
CREATE TABLE A (A integer)
CREATE VIEW V AS SELECT * FROM A
DROP TABLE A //with ExecuteReader() -> No exception
DROP TABLE A //with ExecuteNonQuery() -> throw the excaption: cannot delete COLUMN A.A there are 1 dependences.
If you use ExecuteNonQuery() then the exception will come up but if you use ExecuteReader() it will not come up.
--
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: Fabiano R. (JIRA) <tr...@fi...> - 2016-09-26 19:26:16
|
Migration Sql generate for AddColumn operation for non nullable Guid field is wrong
-----------------------------------------------------------------------------------
Key: DNET-700
URL: http://tracker.firebirdsql.org/browse/DNET-700
Project: .NET Data provider
Issue Type: Bug
Components: Entity Framework support
Affects Versions: 5.1.1.0
Environment: Firebird 3, Windows 10, 64 bits
Reporter: Fabiano Rezende
Assignee: Jiri Cincura
The Migration below
public partial class MyMigration : DbMigration
{
public override void Up()
{
AddColumn("dbo.TableName", "Id", c => c.Guid(nullable: false));
}
}
Generats the Sql:
ALTER TABLE "TableName" ADD "Id" CHAR(16) CHARACTER SET OCTETS DEFAULT CHAR_TO_UUID('00000000-0000-0000-0000-000000000000') NOT NULL
Firebird does not recognize DEFAULT CHAR_TO_UUID('00000000-0000-0000-0000-000000000000')
--
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-09-21 09:12:27
|
> Your comment "...is only in database, not in context" indicates that > something needs to be done here: But what? You need to fix the problem in entity (or detach it, if you just want to throw it away). -- Mgr. Jiří Činčura Independent IT Specialist |
|
From: Nikolaus K. <par...@gm...> - 2016-09-21 08:34:52
|
Hello Jiri, thanks for the fast response. I still have troubles arround clearing the context after an error happend on the database. I loop through N entities and modify them. The 3rd creates an error on the database which is reported back in an exception. Now the 4th and ongoing context.SaveChanges() will fail with the same error - but without having the problem at all. In my understanding the error stucks inside the context and I need to clean it up. Your comment "...is only in database, not in context" indicates that something needs to be done here: But what? Thanks Niko -----Ursprüngliche Nachricht----- Von: Jiří Činčura [mailto:ji...@ci...] Gesendet: Dienstag, 13. September 2016 18:22 An: fir...@li... Betreff: Re: [Firebird-net-provider] Best practice for Rollback with EF and Firebird > Is it really neccesssary to get transaction before > context:SaveChanges() in order to rollback? Yes, if you want to rollback manually. OTOH if there's an error while processing the data, the rollback is automatic. Also take into account that the transaction is only in database, not in context. -- Mgr. Jiří Činčura Independent IT Specialist ------------------------------------------------------------------------------ _______________________________________________ Firebird-net-provider mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
|
From: Jiří Č. <ji...@ci...> - 2016-09-21 05:27:38
|
> Any suggestions? To see any difference you need a lot of data and slow connection. -- Mgr. Jiří Činčura Independent IT Specialist |
|
From: Rick R. <ric...@gm...> - 2016-09-20 15:52:37
|
I've tried compression on a local and remote FB3 database and am not seeing any difference using compression or Packet/Fetch size. Do I have settings correct: On server: WireCompression = true connection string: initial catalog=<>;compression=True;data source=<>;port number=3051;role name=Office;user id=<>;password=<>;character set=ISO8859_1;packet size=32767;fetch size=32767; I have tried compression true/false and removed the packet and fetch size (so they default) and seen basically no difference. Any suggestions? Regards, Rick On Tue, Sep 20, 2016 at 6:15 AM Jiří Činčura <ji...@ci...> wrote: > And Thanks for testing BTW. > > -- > Mgr. Jiří Činčura > Independent IT Specialist > > > > ------------------------------------------------------------------------------ > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > |
|
From: Jiří Č. <ji...@ci...> - 2016-09-20 12:13:50
|
And Thanks for testing BTW. -- Mgr. Jiří Činčura Independent IT Specialist |
|
From: Jiří Č. <ji...@ci...> - 2016-09-20 12:13:18
|
> was almost half; eg without compression 6 seconds vs 3.4s with > compression. Yes. It also highly depends on data. > Increasing the PacketSize and FetchSize to maximum 32767 also has a large > positive impact on transfer time over internet connection. Honestly I'm thinking about removing these two and using "the largest reasonable value". Almost nobody knows about these and even less people know what they are doing. And especially with PacketSize the bigger the better, maybe unless you're running on 40MB RAM. -- Mgr. Jiří Činčura Independent IT Specialist |
|
From: Gerdus v. Z. <ger...@gm...> - 2016-09-20 12:07:08
|
I have run my application's test suite on Firebird 3 with and without compression and all seems OK. Verified it's using compression by looking at the server version string returned by connection (ends with P13:Z). Have also run tests with compression on high latency connection on database hosted on Azure. The difference in transfer time is highly variable but the best case I saw was almost half; eg without compression 6 seconds vs 3.4s with compression. Increasing the PacketSize and FetchSize to maximum 32767 also has a large positive impact on transfer time over internet connection. Thanks. On Mon, Sep 19, 2016 at 7:39 PM, Jiří Činčura <ji...@ci...> wrote: > Hi *, > > anybody testing the compression: > http://blog.cincura.net/233572-compression-support-in-firebirdclient-beta/ > ? > > If not, there's no point in holding the beta. I'll just release it and > let's see what happens [1]. I can't test it much more myself. > > [1]: As it's said. You need to break an egg to make an omelette. > > -- > Mgr. Jiří Činčura > Independent IT Specialist > > ------------------------------------------------------------ > ------------------ > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > -- ------------------------------------------------------------------------ Gerdus van Zyl www.infireal.com |
|
From: Jiří Č. <ji...@ci...> - 2016-09-19 17:39:58
|
Hi *, anybody testing the compression: http://blog.cincura.net/233572-compression-support-in-firebirdclient-beta/ ? If not, there's no point in holding the beta. I'll just release it and let's see what happens [1]. I can't test it much more myself. [1]: As it's said. You need to break an egg to make an omelette. -- Mgr. Jiří Činčura Independent IT Specialist |
|
From: Jiri C. (JIRA) <tr...@fi...> - 2016-09-16 13:11:40
|
FbDataReader should use only Ordinal CS/CI matches for column names
-------------------------------------------------------------------
Key: DNET-699
URL: http://tracker.firebirdsql.org/browse/DNET-699
Project: .NET Data provider
Issue Type: Improvement
Components: ADO.NET Provider
Affects Versions: 5.1.1.0
Reporter: Jiri Cincura
Assignee: Jiri Cincura
The InvariantCulture doesn't make much sense. These are identifiers written by developers. They should do the work properly.
--
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-09-15 18:38:43
|
> but when it grows you get the error How many bytes needed for error to occur? Is it greater 8192 bytes? |
|
From: GUILLERMO F. <gfa...@ho...> - 2016-09-15 13:38:12
|
Good morning.
We are having problems when trying to save a serialized object as xml in a blob field.
The definition of the table is as follows:
CREATE TABLE TPROPIEDADESPERSONA
(
Integer IDENTITY NOT NULL,
RespondentID Integer NOT NULL,
IDPROPIEDAD Integer NOT NULL,
ID Integer NOT NULL,
DATE NOT NULL Timestamp,
DESCRIPTION VARCHAR255NULL,
IDPRESTADOR Integer NOT NULL,
POSITION Integer,
MASCARA Integer NOT NULL,
Blob INFOADICIONAL sub_type 1
Timestamp FechaAlta NOT NULL,
IDLOGINALTA Integer NOT NULL,
ULTIMAMODIF Timestamp,
IDLOGINULTIMAMODIF Integer,
PRIMARY KEY (IDENTITY, RespondentID, IDPROPIEDAD, ID)
);
Everything is with firebird 3 and the latest version of FirebirdClient.dll (5.1.1)
The multiturnos.xml file contains an example of serialized object and it is only the effects you see that's what we're keeping (basically a string of about 32KB). This object contains the reference to the file list (the definition of the location and then go for them and get the bytes and so to download). This according to the logic of the system in question.
However, when the object to serialize is small (the information of 3 or 4 files for example) everything works fine. but when it grows you get the error:
"Arithmetic exception, numeric overflow, or string truncation \ r \ nSTRING right truncation"
The portion of code is as follows:
// aux
public override DbCommand crearComandoConConexion (stmt string, bool abreConexion, DbConnection Connection, DbTransaction transaction)
{
var result = new FbCommand (stmt, as FbConnection connection, as FbTransaction transaction);
result.CommandTimeout = 0;
if (abreConexion conexion.State &&! = ConnectionState.Open)
result.Connection.Open ();
return result;
}
// aux
FbParameter private agregarInfoAdicional (FbCommand cmd, string string, string nombreParam = "@infoAdicional")
{
var cmd.CreateParameter p = ();
p.ParameterName = nombreParam;
p.FbDbType = FbDbType.Text;
p.Value = string;
return p;
}
// aux
private void armarParametrosPropiedadesPersona (PropiedadPersona property, id int, int idLogin, FbCommand / * DbCommand * / cmd)
{
cmd.agregar ( "@ identity" propiedad.idEntidad);
cmd.agregar ( "@ RespondentID" propiedad.idPersona);
cmd.agregar ( "@ idPropiedad" propiedad.idPropiedad);
cmd.agregar ( "@ id", id);
cmd.agregar ( "@ date" propiedad.fecha);
if (! string.IsNullOrEmpty (propiedad.descripcion))
cmd.agregar ( "@ description" propiedad.descripcion);
else
cmd.agregar ( "@ description", null);
cmd.agregar ( "@ idPrestador" propiedad.idPrestador);
if (propiedad.posicion> 0)
cmd.agregar ( "@ position" propiedad.posicion);
else
cmd.agregar ( "@ position", null);
cmd.agregar ( "@ mask" propiedad.mascara);
cmd.Parameters.Add (agregarInfoAdicional (cmd, propiedad.infoAdicional.ToString ()));
cmd.agregar ( "@ idLogin" idLogin);
}
// ------------------
// ------------------
This is the method Where the mistake OCCURS
FbConnection connection ....
......
using (FbTransaction tr = conexion.BeginTransaction ()) {
....
....
using (var cmd = crearComando (stmt, true, connection, tr) as FbCommand) // defined above for your understanding
{
armarParametrosPropiedadesPersona (property, result, idLogin, cmd); // defined above for your understanding
cmd.ExecuteNonQuery (); // Exception !!!
}
|
|
From: Jiří Č. <ji...@ci...> - 2016-09-14 06:54:06
|
Hi, http://blog.cincura.net/233572-compression-support-in-firebirdclient-beta/ Give it a nice good test. The sooner we test it, the sooner it will be released. -- Mgr. Jiří Činčura Independent IT Specialist |
211 messages has been excluded from this view by a project administrator.
