[Firebird-net-provider] [FB-Tracker] Created: (DNET-1021) Support for fb_info_crypt_plugin
Support for fb_info_crypt_plugin Key: DNET-1021 URL: http://tracker.firebirdsql.org/browse/DNET-1021 Project: .NET Data provider Issue Type: Sub-task Reporter: Jiri Cincura Assignee: Jiri Cincura -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira ___ 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-1022) Support for fb_info_wire_crypt
Support for fb_info_wire_crypt -- Key: DNET-1022 URL: http://tracker.firebirdsql.org/browse/DNET-1022 Project: .NET Data provider Issue Type: Sub-task Reporter: Jiri Cincura Assignee: Jiri Cincura -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira ___ 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-1028) Support for fb_info_db_file_id
Support for fb_info_db_file_id -- Key: DNET-1028 URL: http://tracker.firebirdsql.org/browse/DNET-1028 Project: .NET Data provider Issue Type: Sub-task Reporter: Jiri Cincura Assignee: Jiri Cincura -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira ___ 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-1027) Support for fb_info_db_guid
Support for fb_info_db_guid --- Key: DNET-1027 URL: http://tracker.firebirdsql.org/browse/DNET-1027 Project: .NET Data provider Issue Type: Sub-task Reporter: Jiri Cincura Assignee: Jiri Cincura -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira ___ 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-1019) 8.0.0-alpha-3 System.InvalidCastException: Object cannot be cast from DBNull to other types.
8.0.0-alpha-3 System.InvalidCastException: Object cannot be cast from DBNull to other types. Key: DNET-1019 URL: http://tracker.firebirdsql.org/browse/DNET-1019 Project: .NET Data provider Issue Type: Bug Components: Entity Framework Core Affects Versions: 8.0.0.0 Environment: Windows 10 VS 2019 v16.8 Framework v4.8 Reporter: Lynn Bennett Assignee: Jiri Cincura Scaffold-DbContext -Provider FirebirdSql.EntityFrameworkCore.Firebird -Connection "localhost..." -Tables CT_RELAYS_VIEW -DataAnnotations -UseDatabaseNames System.InvalidCastException: Object cannot be cast from DBNull to other types. at System.DBNull.System.IConvertible.ToInt32(IFormatProvider provider) at System.Convert.ToInt32(Object value, IFormatProvider provider) at FirebirdSql.Data.Common.DbValue.GetInt32(AsyncWrappingCommonArgs async) at FirebirdSql.Data.FirebirdClient.FbDataReader.GetInt32(Int32 i) at FirebirdSql.EntityFrameworkCore.Firebird.Scaffolding.Internal.FbDatabaseModelFactory.GetTables(DbConnection connection, Func`3 filter) Firebird 2.5.3(Windows Build) CREATE TABLE CT_RELAYS_VIEW ( RELAY_TAG integer, ELEMENT_DESIGNATION char(21), ELEMENT_CODE char(4), DS_ZONE_NUMBER char(2), CT_TYPE char(2), CT_NAME char(11) ); -- 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 ___ 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-1030) Cannot connect to database if there is an existing connection.
Cannot connect to database if there is an existing connection. --- Key: DNET-1030 URL: http://tracker.firebirdsql.org/browse/DNET-1030 Project: .NET Data provider Issue Type: Bug Components: ADO.NET Provider, NuGet packages Environment: Windows 10, Windows 7, Windows XP Reporter: Joshua Ellis Assignee: Jiri Cincura I have Firebird DBs on multiple industrial machines where the PLC is constantly logging data to the Firebird DB located in a Windows environment. If I use the ADO.net connector it refuses to connect to the database because of an existing connection. I tried this on my own computer with the same results, any connection to the database using flamerobin, the IBPP library, etc would crash the .net connection. However using the IBPP library and writing the connection works just fine with no issues. I also have code running in C++ that works fine and is able to read database contents if there are multiple connections to the database. It would be nice to see this library support multiple connections to a DB no matter what else is connected to the DB it is trying to connect to. -- 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 ___ 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-1036) Reading numeric(18, 0) returns wrong value
Reading numeric(18,0) returns wrong value - Key: DNET-1036 URL: http://tracker.firebirdsql.org/browse/DNET-1036 Project: .NET Data provider Issue Type: Bug Components: ADO.NET Provider Affects Versions: 8.0.0.0 Reporter: Jiri Cincura Assignee: Jiri Cincura Priority: Blocker `select cast(3 as decimal(18,0)) from rdb$database` returns `0.3`. -- 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 ___ 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-1037) Rename ConsoleLoggerProvider to ConsoleLoggingProvider to match the interface name
Rename ConsoleLoggerProvider to ConsoleLoggingProvider to match the interface name -- Key: DNET-1037 URL: http://tracker.firebirdsql.org/browse/DNET-1037 Project: .NET Data provider Issue Type: Improvement Components: ADO.NET Provider Affects Versions: 8.0.0.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 ___ 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-1042) Performance regression between 7.10.1 and 8.0.1
Performance regression between 7.10.1 and 8.0.1 --- Key: DNET-1042 URL: http://tracker.firebirdsql.org/browse/DNET-1042 Project: .NET Data provider Issue Type: Bug Components: ADO.NET Provider Affects Versions: 8.0.1.0 Environment: Win10, FB 3.0.7 Reporter: Rand Random Assignee: Jiri Cincura The performance to read data dropped to half between 7.10.1 and 8.0.1. On 7.10.1 my test finishes with 11.14 s. On 8.0.1 my test finishes with 28.72 s. I have created this github project with the code demonstrating my issue https://github.com/Rand-Random/FbPerf Only this file contains code: https://github.com/Rand-Random/FbPerf/blob/main/FbPerf8/FbPerfTest.cs This *.cs file reads 1 million rows from a database containing 5 million records. You can find the used database 7-zipped as TESTPERF.7z in the root of the github project, the file FbPerfTest.cs also contains code how I created/filled the test database, in case it is relevent. The C# project FbPerf7 has the NuGet package for 7.10.1, while the C# project FbPerf8 has the NuGet package version 8.0.1. I am using BenchmarkDotNet for the performance tests, I added the results as images into the root of the github project. The perf7.jpg contains the result for the FbPerf7 C# project, and the perf8.jpg for the FbPerf8 C# project. Please be aware of the fact that the folder FbPerf7 only contains the *.csproj file and not a single *.cs file, this is because I am linking existing files from the FbPerf8 folder, I do this to avoid writing the test twice. -- 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 ___ 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-1043) Async operations executed with cancelled CancellationToken
Async operations executed with cancelled CancellationToken -- Key: DNET-1043 URL: http://tracker.firebirdsql.org/browse/DNET-1043 Project: .NET Data provider Issue Type: Bug Components: ADO.NET Provider Affects Versions: 8.0.1.0 Reporter: mace windu Assignee: Jiri Cincura After update to recent provider version (8.0.1.0) which introduce async operations support, several of our tests, that check proper handling of cancelled token started to fail as they expect OperationCanceledException, but instead of it operation succedded (similar issue we recently reported for npgsql 5 release https://github.com/npgsql/npgsql/issues/3379, so you can use sample code from there and replace npgsql types with fb types). I have no list of all affected async operations, but at least ExecuteNonQueryAsync is not failing as it is expected. -- 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 ___ 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-1016) Remove `params` from QueueEvents
Remove `params` from QueueEvents Key: DNET-1016 URL: http://tracker.firebirdsql.org/browse/DNET-1016 Project: .NET Data provider Issue Type: Task Components: ADO.NET Provider Reporter: Jiri Cincura Assignee: Jiri Cincura Priority: Trivial -- 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 ___ 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-1017) Handle script generation by using SET TERM
Handle script generation by using SET TERM -- Key: DNET-1017 URL: http://tracker.firebirdsql.org/browse/DNET-1017 Project: .NET Data provider Issue Type: Improvement Components: Entity Framework Core Affects Versions: 8.0.0.0 Reporter: Jiri Cincura Assignee: Jiri Cincura Priority: Minor Now possible in EF Core 5: https://github.com/dotnet/efcore/issues/14746. -- 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 ___ 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-1018) Support for FB4 in EF Core
Support for FB4 in EF Core -- Key: DNET-1018 URL: http://tracker.firebirdsql.org/browse/DNET-1018 Project: .NET Data provider Issue Type: Task Components: Entity Framework Core Reporter: Jiri Cincura Assignee: Jiri Cincura Priority: Minor Mostly identifiers length... -- 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 ___ 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-160) Global Temporary Table isn't redirected
Global Temporary Table isn't redirected Key: DNET-160 URL: http://tracker.firebirdsql.org/browse/DNET-160 Project: .NET Data provider Issue Type: Bug Affects Versions: 2.1.0 RC 2 Environment: Windows XP SP2 Reporter: Van den Wouwer Danny Assignee: Jiri Cincura If a temporary global table is being used, I expected that the tmp-files files for this table are created in the folder specified by: # # Temporary directories # # Provide ';'-separated trees list, where temporary files are stored. # Relative paths are treated relative to RootDirectory entry # (see above). Default value is determined using FIREBIRD_TMP, # TEMP or TMP environment options. Once the first specified # directory has no available space, the engine will switch to the # next one, and so on. # # E.g.: # TempDirectories = c:\temp # or # TempDirectories = c:\temp;d:\temp # # Type: string (special format) # TempDirectories = C:\TMP_FIREBIRD But it isn't, the tmp-file is created in the default temporary directory of windows. Is this by design? I expected to redirect all tempoary files to another disk to speed 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 - Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace ___ 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-264) BuildTpb() forgot too implement: IsolationLevel.Snapshot
BuildTpb() forgot too implement: IsolationLevel.Snapshot
-
Key: DNET-264
URL: http://tracker.firebirdsql.org/browse/DNET-264
Project: .NET Data provider
Issue Type: Improvement
Reporter: Van den Wouwer Danny
Assignee: Jiri Cincura
Hi Jiri,
The private method BuildTpb() inside FbTransaction.cs doesn't check the new
IsolationLevel.Snapshot
// Summary:
// Specifies the transaction locking behavior for the connection.
public enum IsolationLevel
{
// Summary:
// A different isolation level than the one specified is being used,
but the
// level cannot be determined.
Unspecified = -1,
//
// Summary:
// The pending changes from more highly isolated transactions cannot
be overwritten.
Chaos = 16,
//
// Summary:
// A dirty read is possible, meaning that no shared locks are issued
and no
// exclusive locks are honored.
ReadUncommitted = 256,
//
// Summary:
// Shared locks are held while the data is being read to avoid dirty
reads,
// but the data can be changed before the end of the transaction,
resulting
// in non-repeatable reads or phantom data.
ReadCommitted = 4096,
//
// Summary:
// Locks are placed on all data that is used in a query, preventing
other users
// from updating the data. Prevents non-repeatable reads but phantom
rows are
// still possible.
RepeatableRead = 65536,
//
// Summary:
// A range lock is placed on the System.Data.DataSet, preventing
other users
// from updating or inserting rows into the dataset until the
transaction is
// complete.
Serializable = 1048576,
//
*// Summary:
// Reduces blocking by storing a version of data that one
application can read
// while another is modifying the same data. Indicates that from one
transaction
// you cannot see changes made in other transactions, even if you
requery.
Snapshot = 16777216,
*}
And it seems that on other places this IsolationLevel.Snapshot is already
introduced (FbConnectionInternal.cs, FbConnectionString.cs, fbMetaData.xml)
So isn't it better to mimic this Isolation better then just taking the default
now (ReadCommitted, NoRecversion):
Shouldn't it be mapped on FbTransactionBehavior.Concurrency?
Like this:
private TransactionParameterBuffer BuildTpb()
{
FbTransactionOptions options = new FbTransactionOptions();
options.WaitTimeout = null;
options.TransactionBehavior = FbTransactionBehavior.Write;
options.TransactionBehavior |= FbTransactionBehavior.Wait;
/* Isolation level */
switch (this.isolationLevel)
{
case IsolationLevel.Serializable:
options.TransactionBehavior |=
FbTransactionBehavior.Consistency;
break;
case IsolationLevel.RepeatableRead:
*case IsolationLevel.Snapshot:*
options.TransactionBehavior |=
FbTransactionBehavior.Concurrency;
break;
case IsolationLevel.ReadUncommitted:
options.TransactionBehavior |=
FbTransactionBehavior.ReadCommitted;
options.TransactionBehavior |=
FbTransactionBehavior.RecVersion;
break;
case IsolationLevel.ReadCommitted:
default:
options.TransactionBehavior |=
FbTransactionBehavior.ReadCommitted;
options.TransactionBehavior |=
FbTransactionBehavior.NoRecVersion;
break;
}
// just empty FbTransactionOptionsValues struct
return this.BuildTpb(options);
}
--
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
--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
___
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-347) FbBatchExecution: Cannot determine SQL statement for ALTER CHARACTER SET
FbBatchExecution: Cannot determine SQL statement for ALTER CHARACTER SET
-
Key: DNET-347
URL: http://tracker.firebirdsql.org/browse/DNET-347
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 2.5.2
Environment: Irrelevant
Reporter: Vincent Van Den Berghe
Assignee: Jiri Cincura
When attempting to parse a script file containing the following Firebird 2.5
statement:
ALTER CHARACTER SET UTF8 SET DEFAULT COLLATION UNICODE;
... the following exception is thrown:
{The type of the SQL statement could not be determinated.}
The bug also occurs in the weekly build.
--
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
--
This SF.net Dev2Dev email is sponsored by:
Show off your parallel programming skills.
Enter the Intel(R) Threading Challenge 2010.
http://p.sf.net/sfu/intel-thread-sfd
___
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-364) Executing Procedure that returns values.
Executing Procedure that returns values. Key: DNET-364 URL: http://tracker.firebirdsql.org/browse/DNET-364 Project: .NET Data provider Issue Type: Bug Components: ADO.NET Provider Affects Versions: 2.6 Environment: C#,Windows 7, Visual Studio 2010, Net Framework 4 Reporter: Victor Israel Herrera Coronado Assignee: Jiri Cincura The problem or issue that I've with the new version of Firebird.Net 2.6. library it's that I can't execute store procedures as I'd usually do with the previous version (2.5). Not produces any kind of error, only the procedure that would output information returns nothing. For example: With C#, Getting a DataSet // Supposed m_fb_cnn as a valid FirebirdConnection FbAdapter m_fb_ad = new FbAdapter(GET_INFO, m_fb_cnn); m_fb_ad.SelectCommand.CommandType = CommandType.StoreProcedure; m_fb_ad.SelectCommand.Params.Add(V_PARAM,VALUE); // new dataset DataSet m_dst = new DataSet(); // fill dataset m_fb_ad.Fill(m_dst); It supposed that the dataset wouldn't be empty. With the library 2.5 that not occurs, this functioned very good but in this one (2.6) doesn't function. What I do wrong?? Best regards -- 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 -- The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE: Pinpoint memory and threading errors before they happen. Find and fix more than 250 security defects in the development cycle. Locate bottlenecks in serial and parallel code that limit performance. http://p.sf.net/sfu/intel-dev2devfeb ___ 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-394) error while modifying TapedDataset in database there are several foreign keys
error while modifying TapedDataset in database there are several foreign keys - Key: DNET-394 URL: http://tracker.firebirdsql.org/browse/DNET-394 Project: .NET Data provider Issue Type: Bug Components: ADO.NET Provider, DDEX Provider Affects Versions: 2.6.5, 2.6, 2.5.2, 2.5.1 Environment: Firebird 2.5, Windows 7, Visual Studio 2010, Firebird Client 2.6.5, DDEX Provider 2.0.5 Reporter: Roberto Carlos da Silva Assignee: Jiri Cincura Attachments: screenshot-1.jpg when adding tables to Typed Dataset or changes an a TableAdapter query. The visual studio tries to create foreign keys in the dataset, throwing this error. Configure TableAdapter TBL_IMOBILIARIAS failed. Object reference not set to an instance of an object. I believe the error is in DDEX Provider 2.0.5 I removed all the foreign keys in my database to test, and everything worked perfectly. I hope this tip helps solve this problem. -- 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 -- BlackBerryreg; DevCon Americas, Oct. 18-20, San Francisco, CA Learn about the latest advances in developing for the BlackBerryreg; mobile platform with sessions, labs more. See new tools and technologies. Register for BlackBerryreg; DevCon today! http://p.sf.net/sfu/rim-devcon-copy1 ___ 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-401) System.NullReferenceException: Sessão finalizada --- System.NullReferenceException: Object reference not set to an instance of an object
System.NullReferenceException: Sessão finalizada --- System.NullReferenceException: Object reference not set to an instance of an object - Key: DNET-401 URL: http://tracker.firebirdsql.org/browse/DNET-401 Project: .NET Data provider Issue Type: Bug Affects Versions: 2.6.5 Environment: Firebird 2.1, ASP.NET 4.0, Reporter: Roberto Carlos da Silva Assignee: Jiri Cincura Attachments: LogsAppp.log System.Web.HttpUnhandledException (0x80004005): Exception of type 'System.Web.HttpUnhandledException' was thrown. --- System.NullReferenceException: Sessão finalizada --- System.NullReferenceException: Object reference not set to an instance of an object. at FirebirdSql.Data.Client.Managed.Version10.GdsTransaction.BeginTransaction(TransactionParameterBuffer tpb) in C:\Users\Jiri\Desktop\NETProvider\source\FirebirdSql\Data\Client\Managed\Version10\GdsTransaction.cs:line 142 at FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.BeginTransaction(TransactionParameterBuffer tpb) in C:\Users\Jiri\Desktop\NETProvider\source\FirebirdSql\Data\Client\Managed\Version10\GdsDatabase.cs:line 573 at FirebirdSql.Data.FirebirdClient.FbTransaction.BeginTransaction() in C:\Users\Jiri\Desktop\NETProvider\source\FirebirdSql\Data\FirebirdClient\FbTransaction.cs:line 363 at FirebirdSql.Data.FirebirdClient.FbCommand.Prepare(Boolean returnsSet) in C:\Users\Jiri\Desktop\NETProvider\source\FirebirdSql\Data\FirebirdClient\FbCommand.cs:line 1148 at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand(CommandBehavior behavior, Boolean returnsSet) in C:\Users\Jiri\Desktop\NETProvider\source\FirebirdSql\Data\FirebirdClient\FbCommand.cs:line 1210 at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior) in C:\Users\Jiri\Desktop\NETProvider\source\FirebirdSql\Data\FirebirdClient\FbCommand.cs:line 561 at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader() in C:\Users\Jiri\Desktop\NETProvider\source\FirebirdSql\Data\FirebirdClient\FbCommand.cs:line 539 at FirebirdSql.Data.FirebirdClient.FbDataReader.GetSchemaTable() in C:\Users\Jiri\Desktop\NETProvider\source\FirebirdSql\Data\FirebirdClient\FbDataReader.cs:line 298 at System.Data.ProviderBase.SchemaMapping..ctor(DataAdapter adapter, DataSet dataset, DataTable datatable, DataReaderContainer dataReader, Boolean keyInfo, SchemaType schemaType, String sourceTableName, Boolean gettingData, DataColumn parentChapterColumn, Object parentChapterValue) at System.Data.Common.DataAdapter.FillMapping(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 schemaCount, DataColumn parentChapterColumn, Object parentChapterValue) at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue) at System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) at System.Data.Common.LoadAdapter.FillFromReader(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) at System.Data.DataTable.Load(IDataReader reader, LoadOption loadOption, FillErrorEventHandler errorHandler) -- 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 -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-novd2d ___ 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-446) Develop installer for DDEX provider, to facilitate the installation of this excellent provider
Develop installer for DDEX provider, to facilitate the installation of this excellent provider -- Key: DNET-446 URL: http://tracker.firebirdsql.org/browse/DNET-446 Project: .NET Data provider Issue Type: New Feature Components: ADO.NET Provider, ASP.NET Providers, Borland Data Provider, DDEX Provider, Entity Framework support Affects Versions: 2.7.7 Environment: Visual Studio 2005, 2008, 2012 etc.. Reporter: Roberto Carlos da Silva Assignee: Jiri Cincura Develop installer for DDEX provider, to facilitate the installation of this excellent provider. For programmers, the biggest impediment to adoption of the firebird with visual studio, it is certainly complicated steps to install and put into production the DDEX provider. It created an installer that is available at: http://sourceforge.net/projects/fbnetinstaller/?source=directory, would be very interesting to contact the programmer and see if you can add this to the installer project. NET Firebird provider. The developer community in the world would be grateful. -- 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 -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ ___ 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-460) Please upgrade install NET FirebirdClient so to install it automatically made the necessary changes in the file: machine.config, without requ
Please upgrade install NET FirebirdClient so to install it automatically made the necessary changes in the file: machine.config, without requiring manual editing of the same. Key: DNET-460 URL: http://tracker.firebirdsql.org/browse/DNET-460 Project: .NET Data provider Issue Type: Improvement Components: ADO.NET Provider, ASP.NET Providers, Borland Data Provider, DDEX Provider, Entity Framework support Affects Versions: 2.7.7, 2.7.5, 2.7, 2.6.5, 2.6 Environment: Windows all Reporter: Roberto Carlos da Silva Assignee: Jiri Cincura Please upgrade install NET FirebirdClient so to install it automatically made the necessary changes in the file: machine.config, without requiring manual editing of the same. as well as the installer does the following: http://sourceforge.net/projects/fbnetinstaller/?source=directory, Other installers can also do this, for example: ADO.NET Driver for MySQL (Connector / NET), System.Data.SQLite http://system.data.sqlite.org/index.html/doc/trunk/www/ downloads.wiki -- 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 -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_sfd2d_oct ___ 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-474) When the updated version. FirebirdClient net in NuGet package to version 3.0.2.0, file version FirebirdSql.Data.FirebirdClient.dll folder: \pac
When the updated version. FirebirdClient net in NuGet package to version 3.0.2.0, file version FirebirdSql.Data.FirebirdClient.dll folder: \packages\FirebirdSql.Data.FirebirdClient.3.0.2.0\lib\net40-client\, remains 3.0.0.0 --- Key: DNET-474 URL: http://tracker.firebirdsql.org/browse/DNET-474 Project: .NET Data provider Issue Type: Bug Components: ADO.NET Provider Affects Versions: 3.0.2.0 Environment: Windows 7 Visual Studio 2012 and 2012 Reporter: Roberto Carlos da Silva Assignee: Jiri Cincura Priority: Critical When the updated version. FirebirdClient net in NuGet package to version 3.0.2.0, file version FirebirdSql.Data.FirebirdClient.dll folder: \packages\FirebirdSql.Data.FirebirdClient.3.0.2.0\lib\net40-client\, remains 3.0.0.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 -- Monitor your physical, virtual and cloud infrastructure from a single web console. Get in-depth insight into apps, servers, databases, vmware, SAP, cloud infrastructure, etc. Download 30-day Free Trial. Pricing starts from $795 for 25 servers or applications! http://p.sf.net/sfu/zoho_dev2dev_nov ___ 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-545) Don't want to need Directory c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider
Don't want to need Directory c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider --- Key: DNET-545 URL: http://tracker.firebirdsql.org/browse/DNET-545 Project: .NET Data provider Issue Type: Improvement Components: ADO.NET Provider Affects Versions: 4.1.0.0 Environment: Perhaps important that I use Sharp develop 4.4. (Windows 7) Reporter: Firebird User unter Windows7 Assignee: Jiri Cincura I have tried to drop a table still there are StoredProecedures using it in the data base. I catched an exception. ok. But the text was: Can't load file FbTransaction.cs under c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\source\FirebirdSql\Data\FirebirdClient. So I have created an user jiri and so on. Isn't there any other solution? Than I got the real exception text. FirebirdSql.Data.FirebirdClient.FbException: unsuccessful metadata update cannot delete COLUMN RELATION1.MY_FR there are 3 dependencies The location was: c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\source\FirebirdSql\Data\FirebirdClient\FbTransaction.cs Line 174 By the way: I have heard that lock(this) is not a good way for synchronization. -- 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 -- Android apps run on BlackBerry 10 Introducing the new BlackBerry 10.2.1 Runtime for Android apps. Now with support for Jelly Bean, Bluetooth, Mapview and more. Get your Android app in front of a whole new audience. Start now. http://pubads.g.doubleclick.net/gampad/clk?id=124407151iu=/4140/ostg.clktrk ___ 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-736) Set Generator Value
Set Generator Value --- Key: DNET-736 URL: http://tracker.firebirdsql.org/browse/DNET-736 Project: .NET Data provider Issue Type: Bug Components: ADO.NET Provider Affects Versions: 5.7.0.0 Environment: Select Gen_ID not work Reporter: Marcos Gerene Felix Spirito Assignee: Jiri Cincura Look theses comands: 1. SET GENERATOR generator_name TO value 2. SELECT GEN_ID(generator_name, (SELECT MAX(id) FROM table_name) - GEN_ID(generator_name, 0)) FROM RDB$DATABASE; The 1 its Ok with FBCommand ExecuteNonQuery(); method, but 2 not work. -- 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 -- 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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] [FB-Tracker] Created: (DNET-707) Invalid SQL generated for migration if changing a column from null to not null
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 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 -- 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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] [FB-Tracker] Created: (DNET-708) DbModelBuilder.Entity().MapToStoredProcedures() creates an empty procedure
DbModelBuilder.Entity().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
--
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
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] [FB-Tracker] Created: (DNET-712) Problem with accented letters in charset NONE
Problem with accented letters in charset NONE
-
Key: DNET-712
URL: http://tracker.firebirdsql.org/browse/DNET-712
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 5.6.0.0
Environment: Firebird 2.5.6, Visual Studio Community 2015, C# 6.0,
.Net Framework 4.5.1, Windows 10 Home
Reporter: Marcos Gerene Felix Spirito
Assignee: Jiri Cincura
In this version, the ç, ê, ã and others like these are broken and show "?".
So, I downgrade to 5.5.0.0 and it's works ok again.
The example:
StringBuilder stringConnection = new StringBuilder();
stringConnection.AppendLine("User=SYSDBA;Password=masterkey;Database="+caminhoBanco+";DataSource="+ipServidor+";");
stringConnection.AppendLine("Port=" + portaFirebird +
";Dialect=3;Charset=NONE;Role=;Connection lifetime=15;Pooling=true;");
stringConnection.AppendLine("MinPoolSize=0;MaxPoolSize=50;Packet
Size=8192;ServerType=0;");
var connection = new FbConnection(stringConnection.ToString().Trim());
connection.Open();
var command = new FbCommand("SELECT * FROM EMPRESA WHERE EMP_ID = 1",
connection);
var rd = new command..ExecuteReader();
string test = "";
if (rd.Read())
{
test = rd["EMP_RAZAO"].ToString();
}
The string "test" returns "CONSTRU??O" in 5.6.0.0 (bug) and "CONSTRUÇÃO" in
5.5.0.0 (ok).
--
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
--
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] [FB-Tracker] Created: (DNET-750) is not possible applay command: Update-Database to migrate database on package manager console
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 -- Check out the vibrant tech community on one of the world's most engaging tech site
[Firebird-net-provider] [FB-Tracker] Created: (DNET-796) Mapping numeric types in the same configurable way you can do in Oracle
Mapping numeric types in the same configurable way you can do in Oracle --- Key: DNET-796 URL: http://tracker.firebirdsql.org/browse/DNET-796 Project: .NET Data provider Issue Type: New Feature Affects Versions: 5.vNext, 6.0.0.0 Environment: ADO.NET framework, entity Framework Reporter: Roberto Carlos da Silva Assignee: Jiri Cincura It would be great if in the Firebird .NET Drive there was a way to map the same numeric types you can do in the Oracle Driver. It would solve various system and framework migration incompatibility issues and make it easier to choose firebird as a database for the .NET platform. I think it would be very easy to do that. https://docs.oracle.com/database/121/ODPNT/entityDataTypeMapping.htm#ODPNT8300 -- 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 -- 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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] [FB-Tracker] Created: (DNET-816) Wrong EntityFramewordCore command with Asp.Net Core Identity
Wrong EntityFramewordCore command with Asp.Net Core Identity
Key: DNET-816
URL: http://tracker.firebirdsql.org/browse/DNET-816
Project: .NET Data provider
Issue Type: Bug
Components: Entity Framework Core
Environment:
Reporter: Adriano dos Santos Fernandes
Assignee: Jiri Cincura
OnModelCreating has:
builder.Entity().ToTable("IDENTITY_USER")
.Ignore(u => u.LockoutEnd);
builder.Entity()
.Property(p => p.Id).HasColumnName("ID");
builder.Entity()
.Property(p =>
p.AccessFailedCount).HasColumnName("ACCESS_FAILED_COUNT");
builder.Entity()
.Property(p => p.ConcurrencyStamp).HasColumnName("CONCURRENCY_STAMP");
builder.Entity()
.Property("Discriminator").HasColumnName("DISCRIMINATOR");
builder.Entity()
.Property(p => p.Email).HasColumnName("EMAIL");
builder.Entity()
.Property(p => p.EmailConfirmed).HasColumnName("EMAIL_CONFIRMED");
builder.Entity()
.Property(p => p.LockoutEnabled).HasColumnName("LOCKOUT_ENABLED");
builder.Entity()
.Property(p => p.NormalizedEmail).HasColumnName("NORMALIZED_EMAIL");
builder.Entity()
.Property(p =>
p.NormalizedUserName).HasColumnName("NORMALIZED_USER_NAME");
builder.Entity()
.Property(p => p.PasswordHash).HasColumnName("PASSWORD_HASH");
builder.Entity()
.Property(p => p.PhoneNumber).HasColumnName("PHONE_NUMBER");
builder.Entity()
.Property(p =>
p.PhoneNumberConfirmed).HasColumnName("PHONE_NUMBER_CONFIRMED");
builder.Entity()
.Property(p => p.SecurityStamp).HasColumnName("SECURITY_STAMP");
builder.Entity()
.Property(p => p.TwoFactorEnabled).HasColumnName("TWO_FACTOR_ENABLED");
builder.Entity()
.Property(p => p.UserName).HasColumnName("USER_NAME");
Error:
fail: Microsoft.EntityFrameworkCore.Database.Command[20102]
Failed executing DbCommand (55ms) [Parameters=[@p0='?' (Size = 256),
@p1='?', @p14='?' (Size = 8191), @p2='?' (Size = 8191), @p3='?' (Size = 256),
@p4='?', @p5='?', @p6='?' (Size = 256), @p7='?' (Size = 256), @p8='?' (Size =
8191), @p9='?' (Size = 8191), @p10='?', @p11='?' (Size = 8191), @p12='?',
@p13='?' (Size = 256)], CommandType='Text', CommandTimeout='30']
EXECUTE BLOCK (p0 VARCHAR(256) = ?, p1 INTEGER = ?, p2 VARCHAR(8191) = ?,
p3 VARCHAR(256) = ?, p4 BOOLEAN = ?, p5 BOOLEAN = ?, p6 VARCHAR(256) = ?, p7
VARCHAR(256) = ?, p8 VARCHAR(8191) = ?, p9 VARCHAR(8191) = ?, p10 BOOLEAN = ?,
p11 VARCHAR(8191) = ?, p12 BOOLEAN = ?, p13 VARCHAR(256) = ?)
RETURNS (ROWS_AFFECTED INT)
AS
BEGIN
UPDATE "IDENTITY_USER" SET "ACCESS_FAILED_COUNT" = :p1,
"CONCURRENCY_STAMP" = :p14, "EMAIL" = :p3, "EMAIL_CONFIRMED" = :p4,
"LOCKOUT_ENABLED" = :p5, "NORMALIZED_EMAIL" = :p6, "NORMALIZED_USER_NAME" =
:p7, "PASSWORD_HASH" = :p8, "PHONE_NUMBER" = :p9, "PHONE_NUMBER_CONFIRMED" =
:p10, "SECURITY_STAMP" = :p11, "TWO_FACTOR_ENABLED" = :p12, "USER_NAME" = :p13
WHERE "ID" = :p0 AND "CONCURRENCY_STAMP" = :p2;
ROWS_AFFECTED = ROW_COUNT;
SUSPEND;
END
;
FirebirdSql.Data.FirebirdClient.FbException (0x80004005): Dynamic SQL Error
SQL error code = -206
Column unknown
P14
At line 5, column 79 ---> Dynamic SQL Error
SQL error code = -206
Column unknown
P14
At line 5, column 79
--
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
--
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
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] [FB-Tracker] Created: (DNET-981) After upgrad to .NET 5 the FirebirdSql.EntityFrameworkCore.Firebird not work any more
After upgrad to .NET 5 the FirebirdSql.EntityFrameworkCore.Firebird not work any more - Key: DNET-981 URL: http://tracker.firebirdsql.org/browse/DNET-981 Project: .NET Data provider Issue Type: Bug Components: Entity Framework Core Affects Versions: 7.5.0.0 Environment: Visual Studio 2010, net5.0, Asp.net 5, FirebirdSql.EntityFrameworkCore.Firebird 7.5.0, Firebird 3.0.7, aspnetboilerplate 6.0 Reporter: Roberto Carlos da Silva Assignee: Jiri Cincura System.IO.FileNotFoundException HResult=0x80070002 Message=Could not load file or assembly 'Microsoft.Bcl.HashCode, Version=1.0.0.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51'. The system cannot find the file specified. Source=FirebirdSql.EntityFrameworkCore.Firebird StackTrace: at FirebirdSql.EntityFrameworkCore.Firebird.Infrastructure.Internal.FbOptionsExtension.ExtensionInfo.GetServiceProviderHashCode() at Microsoft.EntityFrameworkCore.Internal.ServiceProviderCache.<>c.b__4_1(Int64 t, IDbContextOptionsExtension e) at System.Linq.Enumerable.Aggregate[TSource,TAccumulate](IEnumerable`1 source, TAccumulate seed, Func`3 func) at Microsoft.EntityFrameworkCore.Internal.ServiceProviderCache.GetOrAdd(IDbContextOptions options, Boolean providerRequired) at Microsoft.EntityFrameworkCore.DbContext..ctor(DbContextOptions options) at Abp.EntityFrameworkCore.AbpDbContext..ctor(DbContextOptions options) at Abp.Zero.EntityFrameworkCore.AbpZeroCommonDbContext`3..ctor(DbContextOptions`1 options) at Abp.Zero.EntityFrameworkCore.AbpZeroDbContext`4..ctor(DbContextOptions`1 options) at NidaTech.DadosPublicos.EntityFrameworkCore.DadosPublicosDbContext..ctor(DbContextOptions`1 options) in C:\Users\rober\source\repos\dados-publicos-pj\src\NidaTech.DadosPublicos.EntityFrameworkCore\EntityFrameworkCore\DadosPublicosDbContext.cs:line 38 at Castle.Core.Internal.ReflectionUtil.Instantiate[TBase](Type subtypeofTBase, Object[] ctorArgs) at Castle.MicroKernel.ComponentActivator.DefaultComponentActivator.CreateInstanceCore(ConstructorCandidate constructor, Object[] arguments, Type implType) -- 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 ___ 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-982) After upgrad to .NET 5 the FirebirdSql.EntityFrameworkCore.Firebird not work
eResolverContext context) at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSite(ServiceCallSite callSite, TArgument argument) at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.Resolve(ServiceCallSite callSite, ServiceProviderEngineScope scope) at Microsoft.Extensions.DependencyInjection.ServiceLookup.DynamicServiceProviderEngine.<>c__DisplayClass1_0.b__0(ServiceProviderEngineScope scope) at Microsoft.Extensions.DependencyInjection.ServiceLookup.ServiceProviderEngine.GetService(Type serviceType, ServiceProviderEngineScope serviceProviderEngineScope) at Microsoft.Extensions.DependencyInjection.ServiceLookup.ServiceProviderEngineScope.GetService(Type serviceType) at Microsoft.Extensions.DependencyInjection.ServiceProviderServiceExtensions.GetRequiredService(IServiceProvider provider, Type serviceType) at Microsoft.Extensions.DependencyInjection.ServiceProviderServiceExtensions.GetRequiredService[T](IServiceProvider provider) at Microsoft.EntityFrameworkCore.DbContext.get_DbContextDependencies() at Microsoft.EntityFrameworkCore.DbContext.get_InternalServiceProvider() at Microsoft.EntityFrameworkCore.DbContext.Microsoft.EntityFrameworkCore.Infrastructure.IInfrastructure.get_Instance() at Microsoft.EntityFrameworkCore.Infrastructure.Internal.InfrastructureExtensions.GetService[TService](IInfrastructure`1 accessor) at Microsoft.EntityFrameworkCore.Infrastructure.AccessorExtensions.GetService[TService](IInfrastructure`1 accessor) at Microsoft.EntityFrameworkCore.Infrastructure.DatabaseFacade.get_Dependencies() at Microsoft.EntityFrameworkCore.Infrastructure.DatabaseFacade.CreateExecutionStrategy() at Microsoft.EntityFrameworkCore.RelationalDatabaseFacadeExtensions.BeginTransaction(DatabaseFacade databaseFacade, IsolationLevel isolationLevel) at Abp.EntityFrameworkCore.Uow.DbContextEfCoreTransactionStrategy.CreateDbContext[TDbContext](String connectionString, IDbContextResolver dbContextResolver) at Abp.EntityFrameworkCore.Uow.EfCoreUnitOfWork.GetOrCreateDbContext[TDbContext](Nullable`1 multiTenancySide, String name) at Abp.EntityFrameworkCore.Uow.UnitOfWorkExtensions.GetDbContext[TDbContext](IActiveUnitOfWork unitOfWork, Nullable`1 multiTenancySide, String name) at NidaTech.DadosPublicos.EntityFrameworkCore.Seed.SeedHelper.WithDbContext[TDbContext](IIocResolver iocResolver, Action`1 contextAction) in C:\Users\rober\source\repos\dados-publicos-pj\src\NidaTech.DadosPublicos.EntityFrameworkCore\EntityFrameworkCore\Seed\SeedHelper.cs:line 42 at NidaTech.DadosPublicos.EntityFrameworkCore.Seed.SeedHelper.SeedHostDb(IIocResolver iocResolver) in C:\Users\rober\source\repos\dados-publicos-pj\src\NidaTech.DadosPublicos.EntityFrameworkCore\EntityFrameworkCore\Seed\SeedHelper.cs:line 17 at NidaTech.DadosPublicos.EntityFrameworkCore.DadosPublicosEntityFrameworkModule.PostInitialize() in C:\Users\rober\source\repos\dados-publicos-pj\src\NidaTech.DadosPublicos.EntityFrameworkCore\EntityFrameworkCore\DadosPublicosEntityFrameworkModule.cs:line 48 at Abp.Modules.AbpModuleManager.<>c.b__15_2(AbpModuleInfo module) at System.Collections.Generic.List`1.ForEach(Action`1 action) at Abp.Modules.AbpModuleManager.StartModules() at Abp.AbpBootstrapper.Initialize() -- 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 ___ 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-196) Support CREATE DATABASE in FbBatchExecution
Support CREATE DATABASE in FbBatchExecution --- Key: DNET-196 URL: http://tracker.firebirdsql.org/browse/DNET-196 Project: .NET Data provider Issue Type: Improvement Components: ADO.NET Provider Affects Versions: 2.5.0 Reporter: Pham Huu Le Quoc Phuc Assignee: Jiri Cincura Priority: Critical -- 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 - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ 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-278) FbCommand can parse SQL text and make parameter list in Parameters before exec
FbCommand can parse SQL text and make parameter list in Parameters before exec -- Key: DNET-278 URL: http://tracker.firebirdsql.org/browse/DNET-278 Project: .NET Data provider Issue Type: New Feature Components: ADO.NET Provider Reporter: Pham Huu Le Quoc Phuc Assignee: Jiri Cincura I have a SQL text, I want to use FbCommand(or others) to create parameters in SQL text before FbCommand exec. -- 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 -- Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference ___ 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-677) CLONE -NullReferenceException in FirebirdSql.Data.FirebirdClient.FbConnectionInternal.TransactionUpdated()
CLONE -NullReferenceException in
FirebirdSql.Data.FirebirdClient.FbConnectionInternal.TransactionUpdated()
--
Key: DNET-677
URL: http://tracker.firebirdsql.org/browse/DNET-677
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 4.6.2.0
Environment: IDE: Visual studio communiti 2013. Framework: C# .Net
4.0. Platform: Windows Server 2012 x64. Server: Firebird Embedded 2.5.4 x64.
Reporter: Pedro Filipe de Morais Lima
Assignee: Jiri Cincura
Fix For: 4.7.0.0
Hi all.
First, sorry by my english, not native laguage.
Have the problem with x64 ADO.NET Provider.
In operations of adding, changing and deleting data in tables the program
throwing exception NullReferenceException.
Exception stack:
at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.TransactionUpdated()
at FirebirdSql.Data.FirebirdClient.FbTransaction.UpdateTransaction()
at FirebirdSql.Data.FirebirdClient.FbTransaction.Commit()
at FirebirdSql.Data.FirebirdClient.FbCommand.CommitImplicitTransaction()
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteNonQuery()
at *myMethod*
For example adding method:
if (dbConnect.State != ConnectionState.Open)
dbConnect.Open();
FbCommand findClientCom = new FbCommand("Select ID FROM CLIENTS
WHERE ID='" + ID.ToString() + "'", dbConnect);
FbDataAdapter FDA = new FbDataAdapter(findClientCom);
DataSet ds = new DataSet();
int count = FDA.Fill(ds);
if (count > 0)
{
errStr = "This Client is present";
return false;
}
String insertText = @"INSERT INTO CLIENTS (ID, NET_ID, NAME,
LOGIN, PASSWORD, RES_PU, RES_KP, CLUSTER)";
insertText += @" VALUES(@ID, @NET_ID, @NAME, @LOGIN, @PASSWORD,
@RES_PU, @RES_KP, @CLUSTER)";
FbCommand insertCom = new FbCommand(insertText, dbConnect);
insertCom.Parameters.AddWithValue("@ID", ID.ToString());
insertCom.Parameters.AddWithValue("@NET_ID", net_id.ToString());
insertCom.Parameters.AddWithValue("@NAME", name);
insertCom.Parameters.AddWithValue("@LOGIN", login);
insertCom.Parameters.AddWithValue("@PASSWORD", password);
insertCom.Parameters.AddWithValue("@RES_PU", res_pu);
insertCom.Parameters.AddWithValue("@RES_KP", res_kp);
insertCom.Parameters.AddWithValue("@CLUSTER",
cluster.ToString());
insertCom.ExecuteNonQuery();
errStr = "Client " + VikingServer.ushortToStr(ID) + " was
added";
return true;
}
catch (Exception ex)
{
errStr = ex.ToString();
return false;
}
My methods are working stable on 32 platform. On x64 tables are changing, but
after change i have this exception.
Please help me with this problem.
--
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
--
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceleration Library.
Click to learn more.
http://pubads.g.doubleclick.net/gampad/clk?id=278785471=/4140
___
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-679) Except after updating to 4.10.0
Except after updating to 4.10.0 --- Key: DNET-679 URL: http://tracker.firebirdsql.org/browse/DNET-679 Project: .NET Data provider Issue Type: Bug Components: ADO.NET Provider Affects Versions: 4.10.0.0 Environment: Windows Server R2 2008 R2 Enterprise 64-bits; IIS 7.5; .NET Framework 4.0.30319; Visual Studio 2013; Reporter: Pedro Filipe de Morais Lima Assignee: Jiri Cincura Priority: Critical Updated the " Firebird ADO.NET Data provider " for version 4.10.0 and I am getting , sometimes , the following exception in my application: Exception information: Exception type: NullReferenceException Exception message: Object reference not set to an instance of an object. at FirebirdSql.Data.Common.Extensions.TryGetTarget[T](WeakReference weakReference, T& target) at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.RemovePreparedCommand (FbCommand command) at FirebirdSql.Data.FirebirdClient.FbCommand.Release() at FirebirdSql.Data.FirebirdClient.FbCommand.Dispose(Boolean disposing) -- 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 -- Find and fix application performance issues faster with Applications Manager Applications Manager provides deep performance insights into multiple tiers of your business applications. It resolves application problems quickly and reduces your MTTR. Get your free trial! https://ad.doubleclick.net/ddm/clk/302982198;130105516;z ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
