All about development of the Firebird SQL .Net provider ()

Pavel (JIRA | 16 May 2013 13:11

[FB-Tracker] Created: (DNET-501) NullReferenceException with Connection.GetSchema

NullReferenceException with Connection.GetSchema 
-------------------------------------------------

                 Key: DNET-501
                 URL: http://tracker.firebirdsql.org/browse/DNET-501
             Project: .NET Data provider
          Issue Type: Bug
    Affects Versions: 2.5.2
         Environment: .NET Compact Framework 3.5 SP2/ Firebird 2.5.1
            Reporter: Pavel
            Assignee: Jiri Cincura
            Priority: Blocker

I try to use GetSchema in FirebirdClient-NETCF-2.5.2:

command.Connection.GetSchema("Generators"); - NullReferenceException Exception

   at FirebirdSql.Data.Schema.FbSchemaFactory.GetSchema(FbConnection connection, String
collectionName, String[] restrictions)
   at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.GetSchema(String collectionName,
String[] restrictions)
   at FirebirdSql.Data.FirebirdClient.FbConnection.GetSchema(String collectionName, String[] restrictions)
   at FirebirdSql.Data.FirebirdClient.FbConnection.GetSchema(String collectionName)

// Also the same exception:
DataTable parmsDataTable = connection.GetSchema("procedurearameters", new string[] { null, null,
spName });
return parmsDataTable.Rows.Count;

// Also the same exception:

(Continue reading)

headers

Muthu Annamalai | 9 May 2013 05:34

LINQ Outer Error

I Use VS 2012 Ultimate, EF 5.0 Code First, Firebird Provider 3.0.2.0

When I use the following LINQ query

public IQueryable<SalesTotalCount> ZDepartmentSalesPeriod

{

get

{

return (from r in ReceiptRepository.NoTracking()

where r.RECEIPTDATE >= ReportEndDate &

r.RECEIPTDATE <= ReportEndDate

from l in r.RECEIPTLINEs

let department =

l.ITEMSTYLE != null

? l.ITEMSTYLE.ITEM.CATEGORY.DEPARTMENT

: l.RECEIPTITEMs.FirstOrDefault().DEPARTMENT

group l by department

into receiptLines

select new SalesTotalCount

{

Name = receiptLines.Key.DEPARTMENTNAME,

Total = (double)receiptLines.Sum(l =>

l.QUANTITY * l.PRICE -

(l.RECEIPTDISCOUNTs.Any()

? l.RECEIPTDISCOUNTs.Sum(d => d.DISCOUNT)

: 0)),

Count = receiptLines.Count(),

Listed = receiptLines.Key.LISTED

});

}

Firebird is throwing this exception

SQL error code = -104

Token unknown - line 35, column 4

OUTER ---&gt; Dynamic SQL Error

SQL error code = -104

Token unknown - line 35, column 4

OUTER

at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior)

at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteDbDataReader(CommandBehavior behavior)

at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)

at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)</ExceptionString><InnerException><ExceptionType>FirebirdSql.Data.Common.IscException, FirebirdSql.Data.FirebirdClient, Version=3.0.2.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c</ExceptionType><Message>Dynamic SQL Error

------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and 
their applications. This 200-page book is written by three acclaimed 
leaders in the field. The early access version is available now. 
Download your free book today! http://p.sf.net/sfu/neotech_d2d_may

_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

headers

Yiannis Bourkelis | 3 May 2013 08:22

NET Provider that requires only .NET 2.0 and not 3.5?

Hello, I have a .NET 2.0 project and I want to use the firebird provider.

Which one should I choose from the downloads page here: http://www.firebirdsql.org/en/net-provider/ ?

I see a NETProvider-3.0.2.0-NET35.7z file but does this require NET 3.5 installed?

------------------------------------------------------------------------------
Get 100% visibility into Java/.NET code with AppDynamics Lite
It's a free troubleshooting tool designed for production
Get down to code-level detail for bottlenecks, with <2% overhead.
Download for free and get started troubleshooting in minutes.
http://p.sf.net/sfu/appdyn_d2d_ap2

_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

headers

Muthu Annamalai | 1 May 2013 01:15

EF Code First Attempted Update of read-only Column

I am using Provider 3.0.2.0 with EF 5.0 code First. When I call save changes it is giving FirebirdSql.Data.Common.IscException: attempted update of read-only column. I have trigger for id column and I don’t include values for those columns in code and there is no other computed column. I also tried saving a different table, but no use, when savechanges is called it is throwing the exception.

Here is the exception stack details.

-------------------------------------------------------------------------------------------------

(System.Data.Entity.Infrastructure.DbUpdateException: An error occurred while updating the entries. See the inner exception for details. ---> System.Data.UpdateException: An error occurred while updating the entries. See the inner exception for details. ---> FirebirdSql.Data.FirebirdClient.FbException: attempted update of read-only column ---> FirebirdSql.Data.Common.IscException: attempted update of read-only column

at FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ProcessResponse(IResponse response)

at FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadResponse()

at FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadGenericResponse()

at FirebirdSql.Data.Client.Managed.Version11.GdsStatement.Prepare(String commandText)

at FirebirdSql.Data.FirebirdClient.FbCommand.Prepare(Boolean returnsSet)

at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand(CommandBehavior behavior, Boolean returnsSet)

at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior)

--- End of inner exception stack trace ---

at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior)

at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteDbDataReader(CommandBehavior behavior)

at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)

at System.Data.Mapping.Update.Internal.DynamicUpdateCommand.Execute(UpdateTranslator translator, EntityConnection connection, Dictionary`2 identifierValues, List`1 generatedValues)

at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter)

--- End of inner exception stack trace ---

at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter)

at System.Data.EntityClient.EntityAdapter.Update(IEntityStateManager entityCache)

at System.Data.Objects.ObjectContext.SaveChanges(SaveOptions options)

at System.Data.Entity.Internal.InternalContext.SaveChanges()

--- End of inner exception stack trace ---

at System.Data.Entity.Internal.InternalContext.SaveChanges()

at System.Data.Entity.Internal.LazyInternalContext.SaveChanges()

at System.Data.Entity.DbContext.SaveChanges()

at Pearlpos.Data.Models.Entities.SaveChanges() in c:\Users\Muthu Annamalai\Documents\Visual Studio 2012\Projects\Pearlpos\Pearlpos.Data\Models\Entities.cs:line 85

at Pearlpos.Data.Repository`1.SaveChanges() in c:\Users\Muthu Annamalai\Documents\Visual Studio 2012\Projects\Pearlpos\Pearlpos.Data\Repository.cs:line 93

at Pearlpos.Data.Utils.DataInit.SetDefaultUser() in c:\Users\Muthu Annamalai\Documents\Visual Studio 2012\Projects\Pearlpos\Pearlpos.Data\Utils\DataInit.cs:line 295

at Pearlpos.Data.Utils.DataInit.DatabaseConnection() in c:\Users\Muthu Annamalai\Documents\Visual Studio 2012\Projects\Pearlpos\Pearlpos.Data\Utils\DataInit.cs:line 42} System.Exception {System.Data.Entity.Infrastructure.DbUpdateException}

-------------------------------------------------------------------------------------------------

Thanks,

Muthu Annamalai

------------------------------------------------------------------------------
Introducing AppDynamics Lite, a free troubleshooting tool for Java/.NET
Get 100% visibility into your production application - at no cost.
Code-level diagnostics for performance bottlenecks with <2% overhead
Download for free and get started troubleshooting in minutes.
http://p.sf.net/sfu/appdyn_d2d_ap1

_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

headers

Toni Martir (JIRA | 30 Apr 2013 12:59

[FB-Tracker] Created: (DNET-500) GetExecutionPlan() minor bug

GetExecutionPlan() minor bug
----------------------------

                 Key: DNET-500
                 URL: http://tracker.firebirdsql.org/browse/DNET-500
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 3.0.2.0
         Environment: VS 2010 Windows 7 Firebird 2.5
            Reporter: Toni Martir
            Assignee: Jiri Cincura
            Priority: Minor

GetExecutionPlan functions throws exeptions when the query has no plan (ALTER TABLE...)

File StatetementBase.cs Function, GetExecutionPlan

Line:
			int len = buffer[1];
throws execption because buffer length is 1

Just before this line the fix may be:
         if (buffer[0] == IscCodes.isc_info_end)
            return "";
I tested this bugfix and works 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

------------------------------------------------------------------------------
Introducing AppDynamics Lite, a free troubleshooting tool for Java/.NET
Get 100% visibility into your production application - at no cost.
Code-level diagnostics for performance bottlenecks with <2% overhead
Download for free and get started troubleshooting in minutes.
http://p.sf.net/sfu/appdyn_d2d_ap1

headers

Hayatuddeen Sadiq (JIRA | 29 Apr 2013 08:14

[FB-Tracker] Created: (DNET-499) Backup problem in Windows 7

Backup problem in Windows 7
---------------------------

                 Key: DNET-499
                 URL: http://tracker.firebirdsql.org/browse/DNET-499
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 2.5.1
         Environment: Windows 7
            Reporter: Hayatuddeen Sadiq
            Assignee: Jiri Cincura

Hello,

I have a desktop application that the backup is working fine but when i move it to window 7 the backup is not working.

This is the code:

Private Sub BackupDatabase(ByVal backupFile As String)

            'Dim cs As New FirebirdSql.Data.FirebirdClient.FbConnectionStringBuilder

            'cs.UserID = "sysdba"
            'cs.Password = "masterkey"
            'cs.Database = "localhost:ndahrm"

            Dim bkp As New FirebirdSql.Data.Services.FbBackup

            bkp.ConnectionString = DB.ConnectionString

            Dim bp As New FirebirdSql.Data.Services.FbBackupFile(backupFile, 2048)
            bkp.BackupFiles.Add(bp)

            bkp.Verbose = True
            bkp.Options = FirebirdSql.Data.Services.FbBackupFlags.IgnoreLimbo

            Try
                bkp.Execute()
                Timer1.Stop()
                prgBar.Value = 100
                MessageBox.Show("Processing Completed Successfully.", Application.ProductName,
MessageBoxButtons.OK, MessageBoxIcon.Information)
            Catch ex As Exception
                MessageBox.Show(ex.Message)
            End Try

End Sub

And this is the error code:

Invalid clumplet buffer structure: buffer end before end of clumplet - no length component

--

-- 
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

------------------------------------------------------------------------------
Try New Relic Now & We'll Send You this Cool Shirt
New Relic is the only SaaS-based application performance monitoring service 
that delivers powerful full stack analytics. Optimize and monitor your
browser, app, & servers with just a few lines of code. Try New Relic
and get this awesome Nerd Life shirt! http://p.sf.net/sfu/newrelic_d2d_apr

headers

Arkadiusz Widera | 27 Apr 2013 18:39

Windows CE

Hello!

I try connect do Firebird database from Windows CE 5.2. I install
Microsoft Compact Framework 3.5 on PDA, and NETProvider-2.5.2-CF.

            String cs2 = "character set=UTF8;data
source=192.168.91.101;initial catalog=D:\\D\\P.FDB;user
id=SYSDBA;password=xxx";
            FbConnection fbc = new FbConnection();
            fbc.ConnectionString = cs2;
            fbc.Open();

Open command get error: {"MissingMethodException"}. Any idea?

w DeviceApplication3.Form1.button2_Click()
w System.Windows.Forms.Control.OnClick()
w System.Windows.Forms.Button.OnClick()
w System.Windows.Forms.ButtonBase.WnProc()
w System.Windows.Forms.Control._InternalWnProc()
w Microsoft.AGL.Forms.EVL.EnterMainLoop()
w System.Windows.Forms.Application.Run()
w DeviceApplication3.Program.Main()

--

-- 
Podrowienia
 Arkadiusz Widera

------------------------------------------------------------------------------
Try New Relic Now & We'll Send You this Cool Shirt
New Relic is the only SaaS-based application performance monitoring service 
that delivers powerful full stack analytics. Optimize and monitor your
browser, app, & servers with just a few lines of code. Try New Relic
and get this awesome Nerd Life shirt! http://p.sf.net/sfu/newrelic_d2d_apr

headers

Martin Ågren | 25 Apr 2013 09:46

Exception on exit application

Hi,

I have a wpf application, and when exiting I always get a debug output:

A first chance exception of type 'System.NullReferenceException' occurred in FirebirdSql.Data.FirebirdClient.dll

Firebird 2.5, Firebird Client 3.0.2.0, Runtime v4.0.30319

I havn’t been able to track down a cause for this. Any clues?

/Martin

------------------------------------------------------------------------------
Try New Relic Now & We'll Send You this Cool Shirt
New Relic is the only SaaS-based application performance monitoring service 
that delivers powerful full stack analytics. Optimize and monitor your
browser, app, & servers with just a few lines of code. Try New Relic
and get this awesome Nerd Life shirt! http://p.sf.net/sfu/newrelic_d2d_apr

_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

headers

Jiri Cincura | 20 Apr 2013 08:18

Migrations

Hi *,

is there an interest in Migrations provider (for EF) for Firebird?

--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

------------------------------------------------------------------------------
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter

headers

Phosgen Tepes (JIRA | 18 Apr 2013 22:41

[FB-Tracker] Created: (DNET-498) Error in double quoting database object names (tables, columns)

Error in double quoting database object names (tables, columns)
---------------------------------------------------------------

                 Key: DNET-498
                 URL: http://tracker.firebirdsql.org/browse/DNET-498
             Project: .NET Data provider
          Issue Type: Bug
          Components: DDEX Provider
    Affects Versions: 3.0.0.0
         Environment: 1. Windows 7 SP1 x86, Visual Studio 2012, Firebird 2.5.2 x86, DDEX Provider 3.0.0.0, .NET
Provider 3.0.2.0
2. Windows 7 SP1 x64, Visual Studio 2012 Update 2, Firebird 2.5.2 x64, DDEX Provider 3.0.0.0, .NET Provider 3.0.2.0
            Reporter: Phosgen Tepes
            Assignee: Jiri Cincura
            Priority: Critical

I create strongly typed data set, drag table which have double quoted name and columns, in this stage
everything is ok, but if i delete or cut any column in data table via designer (real column from database or
added via designer) in select command in designer double quoting are dissapearing, and nothing not work
because need double quoting. please fix this bug. 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

------------------------------------------------------------------------------
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter

headers

Alex Castillo | 18 Apr 2013 05:58

Using factories in 3.0.2

Hello all,

I'm trying to update an application that uses Factories from version 2.1 to 3.0.2 of the provider.

I've registered the dll in the gac by using gacutil.exe from VS2010 command line. This is the output of /l option:
FirebirdSql.Data.FirebirdClient, Version=3.0.2.0, Culture=neutral,
PublicKeyToken=3750abcc3150b00c, processorArchitecture=MSIL

I've added the next lines to machine.config from v2 and v4 of the config directory:

2:
<section name="firebirdsql.data.firebirdclient"
type="System.Data.Common.DbProviderConfigurationHandler, System.Data, Version=2.0.0.0,
Culture=neutral, PublicKeyToken=b77a5c561934e089" />

<add name="FirebirdClient Data Provider" invariant="FirebirdSql.Data.FirebirdClient"
description=".Net Framework Data Provider for Firebird"
type="FirebirdSql.Data.FirebirdClient.FirebirdClientFactory,
FirebirdSql.Data.FirebirdClient, Version=3.0.2.0, Culture=neutral,
PublicKeyToken=3750abcc3150b00c" />

4:
<section name="firebirdsql.data.firebirdclient"
type="System.Data.Common.DbProviderConfigurationHandler, System.Data, Version=4.0.0.0,
Culture=neutral, PublicKeyToken=b77a5c561934e089" />

<add name="FirebirdClient Data Provider" invariant="FirebirdSql.Data.FirebirdClient"
description=".NET Framework Data Provider for Firebird"
type="FirebirdSql.Data.FirebirdClient.FirebirdClientFactory,
FirebirdSql.Data.FirebirdClient, Version=3.0.2.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c"/>

But my app crashes every time I'm trying to execute it.

Could you please help me to fix this issue?? What is wrong?

Thanks in advance.

Regards,

------------------------------------------------------------------------------
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter

13	May 2013
44	April 2013
36	March 2013
18	February 2013
43	January 2013
35	December 2012
52	November 2012
25	October 2012
32	September 2012
24	August 2012
33	July 2012
28	June 2012
16	May 2012
55	April 2012
25	March 2012
19	February 2012
31	January 2012
22	December 2011
22	November 2011
42	October 2011
31	September 2011
51	August 2011
20	July 2011
22	June 2011
21	May 2011
24	April 2011
25	March 2011
47	February 2011
46	January 2011
34	December 2010
61	November 2010
18	October 2010
47	September 2010
110	August 2010
33	July 2010
71	June 2010
39	May 2010
93	April 2010
74	March 2010
110	February 2010
135	January 2010
70	December 2009
50	November 2009
147	October 2009
50	September 2009
62	August 2009
59	July 2009
76	June 2009
53	May 2009
83	April 2009
78	March 2009
84	February 2009
52	January 2009
86	December 2008
119	November 2008
158	October 2008
172	September 2008
89	August 2008
89	July 2008
107	June 2008
74	May 2008
131	April 2008
131	March 2008
138	February 2008
104	January 2008
96	December 2007
172	November 2007
123	October 2007
61	September 2007
158	August 2007
150	July 2007
158	June 2007
120	May 2007
192	April 2007
223	March 2007
161	February 2007
261	January 2007
141	December 2006
225	November 2006
348	October 2006
163	September 2006
164	August 2006
223	July 2006
197	June 2006
225	May 2006
262	April 2006
212	March 2006
150	February 2006
170	January 2006
160	December 2005
167	November 2005
66	October 2005

Mon	Tue	Wed	Thu	Fri	Sat	Sun

		1	2	3	4	5
6	7	8	9	10	11	12
13	14	15	16	17	18	19
20	21	22	23	24	25	26
27	28	29	30	31