Alex Gaysinskiy (JIRA | 1 Jul 11:39 2015

[FB-Tracker] Created: (DNET-619) Possible incorrect usage of WeakReference.Target in method FirebirdSql.Data.FirebirdClient.FbConnectionInternal.TransactionUpdated

Possible incorrect usage of WeakReference.Target in method FirebirdSql.Data.FirebirdClient.FbConnectionInternal.TransactionUpdated
----------------------------------------------------------------------------------------------------------------------------------

                 Key: DNET-619
                 URL: http://tracker.firebirdsql.org/browse/DNET-619
             Project: .NET Data provider
          Issue Type: Bug
    Affects Versions: 4.6.4.0, 4.1.0.0
         Environment: Windows 7 prof, sp1, CPU i5-3550, mem 8 GiB
            Reporter: Alex Gaysinskiy
            Assignee: Jiri Cincura

Implementation of FirebirdSql.Data.FirebirdClient.FbConnectionInternal.TransactionUpdated
function (FirebirdClient\FbConnectionInternal.cs, line 298) has incorrect condition:
		
                public void TransactionUpdated()
		{
			for (int i = 0; i < this.preparedCommands.Count; i++)
			{
				if (!this.preparedCommands[i].IsAlive)
					continue;

				FbCommand command = this.preparedCommands[i].Target as FbCommand; //<<<= may be a null

				if (command.Transaction != null) //<<<= potential NRE. Correct code is: command != null &&
command.Transaction != null
				{
					command.CloseReader();
					command.Transaction = null;
				}
(Continue reading)

Pantarei Andrea (JIRA | 1 Jul 11:33 2015

[FB-Tracker] Created: (DNET-618) Select query with a parameter value that is longer than the size of the column results in an exception, only with firebird

Select query with a parameter value that is longer than the size of the column results in an exception, only
with firebird
--------------------------------------------------------------------------------------------------------------------------

                 Key: DNET-618
                 URL: http://tracker.firebirdsql.org/browse/DNET-618
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 2.6
         Environment: Windows
            Reporter: Pantarei Andrea
            Assignee: Jiri Cincura

I upgraded my .Net DataProvider from 2.5.2 to 2.6.5.
A simple select query that ran with no problems using the 2.5.2 version, will now throw an exception when
using the 2.6.5 version.

When I execute a query with a (string)parameter value that is longer than the size of the column in the
database an IscException occurs.

the error code is: 335544321 and the message is 'Arithmetic overflow or division by zero has occurred.
arithmetic exception, numeric overflow, or string truncation. string right truncation.'

If it is possible I would like the behaviour of the 2.5.2 version back, because it makes my code a lot simpler.
Otherwise I have to make sure a user can not enter data that will result in an exception.

--

-- 
This message is automatically generated by JIRA.
-
(Continue reading)

Rand Random (JIRA | 29 Jun 12:16 2015

[FB-Tracker] Created: (DNET-617) NullReferenceException

NullReferenceException
----------------------

                 Key: DNET-617
                 URL: http://tracker.firebirdsql.org/browse/DNET-617
             Project: .NET Data provider
          Issue Type: Bug
    Affects Versions: 4.6.4.0
         Environment: Win7, Newest FB .Net Provider
            Reporter: Rand Random
            Assignee: Jiri Cincura

I updated to the latest version of FB .Net Provider.

And I am getting NullReferenceException with the following stacktrace

   bei FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.Write(Int32 value) in
c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\src\FirebirdSql.Data.FirebirdClient\Client\Managed\Version10\GdsDatabase.cs:Zeile 1002.

(Yes its only this line)

--

-- 
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 25 network devices or servers for free with OpManager!
(Continue reading)

Christian Waldmann | 26 Jun 16:34 2015
Picon

Re: Handling of boolean in .Net Provider 4.6.2

Using SMALLINT in table to store 'bool' value from C# works perfect with stand alone and embedded server.
(May be I have a char set problem (none, ASCII, UTF8,...) in DB or connection when using CHAR(1) to store a 'bool'!)
Thanks
> 
> Thanks for the info
> I will do some test with a SMALLINT field.
> 
> >
> > We are using SMALLINT type in our project.
> > FB EF provider also generates tables with SMALLINT fields for code-
> > first class fields.
> >
> > On 26 June 2015 at 14:49, Christian Waldmann <christian.waldmann <at> rte-
> > ag.ch> wrote:
> > > I am using Firebird 2.5.4, superServer and embedded, Visula Studio
> > > 2013, .Net Framework 4.5.1, .Net Provider 4.6.2
> > >
> > >
> >
> //====================================================================
> > > ======
> > > =================
> > > I have defined a table with "CyclePassed" CHAR(1) to store a
> boolean
> > > result
> > >
> > > CREATE TABLE "SampleSummaries" (
> > >     "UniqueId"            BIGINT DEFAULT 0 NOT NULL,
> > >     "EndTestRunId"        BIGINT NOT NULL,
> > >     "Cycle"               BIGINT NOT NULL,
(Continue reading)

Picon

Re: Handling of boolean in .Net Provider 4.6.2

We are using SMALLINT type in our project.
FB EF provider also generates tables with SMALLINT fields for
code-first class fields.

On 26 June 2015 at 14:49, Christian Waldmann
<christian.waldmann@...> wrote:
> I am using Firebird 2.5.4, superServer and embedded, Visula Studio 2013,
> .Net Framework 4.5.1, .Net Provider 4.6.2
>
> //==========================================================================
> =================
> I have defined a table with "CyclePassed" CHAR(1) to store a boolean result
>
> CREATE TABLE "SampleSummaries" (
>     "UniqueId"            BIGINT DEFAULT 0 NOT NULL,
>     "EndTestRunId"        BIGINT NOT NULL,
>     "Cycle"               BIGINT NOT NULL,
>     "LoadPressure"        FLOAT,
>     "LoadPressureMin"     FLOAT,
>     "LoadPressureMax"     FLOAT,
>     "ShutoffPressure"     FLOAT,
>     "ShutoffPressureMin"  FLOAT,
>     "ShutoffPressureMax"  FLOAT,
>     "TravelTime"          FLOAT,
>     "TravelTimeMin"       FLOAT,
>     "TravelTimeMax"       FLOAT,
>     "CyclePassed"         CHAR(1)
> );
>
>
(Continue reading)

Christian Waldmann | 26 Jun 13:49 2015
Picon

Handling of boolean in .Net Provider 4.6.2

I am using Firebird 2.5.4, superServer and embedded, Visula Studio 2013,
.Net Framework 4.5.1, .Net Provider 4.6.2

//==========================================================================
=================
I have defined a table with "CyclePassed" CHAR(1) to store a boolean result

CREATE TABLE "SampleSummaries" (
    "UniqueId"            BIGINT DEFAULT 0 NOT NULL,
    "EndTestRunId"        BIGINT NOT NULL,
    "Cycle"               BIGINT NOT NULL,
    "LoadPressure"        FLOAT,
    "LoadPressureMin"     FLOAT,
    "LoadPressureMax"     FLOAT,
    "ShutoffPressure"     FLOAT,
    "ShutoffPressureMin"  FLOAT,
    "ShutoffPressureMax"  FLOAT,
    "TravelTime"          FLOAT,
    "TravelTimeMin"       FLOAT,
    "TravelTimeMax"       FLOAT,
    "CyclePassed"         CHAR(1)
);

//==========================================================================
=================
// access to table from C# 

bool cyclePassed = true;
FbCommand command = new FbCommand();

(Continue reading)

Jiří Činčura | 26 Jun 11:32 2015
Picon

ADO.NET provider 4.6.4.0

More info http://blog.cincura.net/233511-ado-net-provider-4-6-4-0-for-firebird-is-ready/ .

-- 
Mgr. Jiří Činčura
Independent IT Specialist

------------------------------------------------------------------------------
Monitor 25 network devices or servers for free with OpManager!
OpManager is web-based network management software that monitors 
network devices and physical & virtual servers, alerts via email & sms 
for fault. Monitor 25 devices for free with no restriction. Download now
http://ad.doubleclick.net/ddm/clk/292181274;119417398;o
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
hastenrom (JIRA | 25 Jun 22:32 2015

[FB-Tracker] Created: (DNET-616) [FirebirdSql.Data.FirebirdClient.FbException] - Column unknown RDB$PROCEDURE_TYPE (SQL error code = -206)

[FirebirdSql.Data.FirebirdClient.FbException] - Column unknown RDB$PROCEDURE_TYPE (SQL error code
= -206)
---------------------------------------------------------------------------------------------------------

                 Key: DNET-616
                 URL: http://tracker.firebirdsql.org/browse/DNET-616
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider, Entity Framework support, NuGet packages
    Affects Versions: 4.6.3.0
         Environment: OS:
Windows7

DLLs:
EntityFramework 6.0.0.0 (EntityFramework)
EntityFramework.Firebird 4.6.3.0 (FirebirdClient - Entity Framework Provider)
FirebirdSql.Data.FirebirdClient 4.6.3.0 (FirebirdClient - ADO.NET Data Provider)
            Reporter: hastenrom
            Assignee: Jiri Cincura

Exception log:

---------------------------
Microsoft Visual Studio
---------------------------
An error occurred while connecting to the database. The database might be unavailable. An exception of
type 'System.Data.Entity.Core.EntityCommandExecutionException' occurred. The error message is:
'An error occurred while executing the command definition. See the inner exception for details.

The inner exception caught was of type 'FirebirdSql.Data.FirebirdClient.FbException', with this
(Continue reading)

Jiri Cincura (JIRA | 25 Jun 13:33 2015

[FB-Tracker] Created: (DNET-615) Support ALTER ROLE statement

Support ALTER ROLE statement
----------------------------

                 Key: DNET-615
                 URL: http://tracker.firebirdsql.org/browse/DNET-615
             Project: .NET Data provider
          Issue Type: Improvement
          Components: ADO.NET Provider
    Affects Versions: 4.6.3.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

------------------------------------------------------------------------------
Monitor 25 network devices or servers for free with OpManager!
OpManager is web-based network management software that monitors 
network devices and physical & virtual servers, alerts via email & sms 
for fault. Monitor 25 devices for free with no restriction. Download now
http://ad.doubleclick.net/ddm/clk/292181274;119417398;o
Jiří Činčura | 25 Jun 08:07 2015
Picon

ADO.NET provider 4.6.3.0

More info http://blog.cincura.net/233510-ado-net-provider-4-6-3-0-for-firebird-is-ready/ .

-- 
Mgr. Jiří Činčura
Independent IT Specialist

------------------------------------------------------------------------------
Monitor 25 network devices or servers for free with OpManager!
OpManager is web-based network management software that monitors 
network devices and physical & virtual servers, alerts via email & sms 
for fault. Monitor 25 devices for free with no restriction. Download now
http://ad.doubleclick.net/ddm/clk/292181274;119417398;o
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Jiri Cincura (JIRA | 25 Jun 07:43 2015

[FB-Tracker] Created: (DNET-614) Improve FbBatchExecution's ctors to make it more clear

Improve FbBatchExecution's ctors to make it more clear
------------------------------------------------------

                 Key: DNET-614
                 URL: http://tracker.firebirdsql.org/browse/DNET-614
             Project: .NET Data provider
          Issue Type: Task
          Components: ADO.NET Provider
    Affects Versions: 4.6.2.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

------------------------------------------------------------------------------
Monitor 25 network devices or servers for free with OpManager!
OpManager is web-based network management software that monitors 
network devices and physical & virtual servers, alerts via email & sms 
for fault. Monitor 25 devices for free with no restriction. Download now
http://ad.doubleclick.net/ddm/clk/292181274;119417398;o

Gmane