Anton Veretennikov (JIRA | 27 Feb 13:52 2015

[FB-Tracker] Created: (DNET-594) In DDEX "|" is not recognized.

In DDEX "|" is not recognized.
------------------------------

                 Key: DNET-594
                 URL: http://tracker.firebirdsql.org/browse/DNET-594
             Project: .NET Data provider
          Issue Type: Bug
          Components: DDEX Provider
    Affects Versions: 4.6.1.0
         Environment: Windows 7
Firebird 2.5
VS 2013 ultimate

            Reporter: Anton Veretennikov
            Assignee: Jiri Cincura

I try to create TableAdapter with select comand for fill. 

SQL for Select comand:

SELECT        FIRM.FIRM_NAME, FIRM.FIRM_ADRESS, FIRM.PHONE, FIRM.FAX, FIRM.EMAIL,
list(f.FORM_INCORPORATION | | ' ' | | lp.LEGAL_PERSON) 
                         AS LEGAL_PERSONS_LIST
FROM            FIRM LEFT OUTER JOIN
                         LEGAL_PERSON lp ON FIRM.ID_FIRM = lp.ID_FIRM INNER JOIN
                         FORM_INCORPORATION f ON lp.ID_FORM_INCORPORATION = f.ID_FORM_INCORPORATION
WHERE        (lower(trim(FIRM.FIRM_NAME)) LIKE '%' | |  <at> name | | '%')
GROUP BY FIRM.FIRM_NAME, FIRM.FIRM_ADRESS, FIRM.PHONE, FIRM.FAX, FIRM.EMAIL

I get next error message. Query Builder throws exception.
(Continue reading)

MIHIR KADAM (JIRA | 21 Feb 16:08 2015

[FB-Tracker] Created: (DNET-593) lock conflict on no wait transaction deadlock update conflicts with concurrent update

lock conflict on no wait transaction deadlock update conflicts with concurrent update 
--------------------------------------------------------------------------------------

                 Key: DNET-593
                 URL: http://tracker.firebirdsql.org/browse/DNET-593
             Project: .NET Data provider
          Issue Type: Bug
         Environment: Windows service 
            Reporter: MIHIR KADAM
            Assignee: Jiri Cincura

Widows service running which continues listing to firebird database events. I received following
exception when service is running. 

2015-02-18 08:51:18,107 [9] ERROR WindowsService.FirebirdListener -
FirebirdSql.Data.FirebirdClient.FbException (0x80004005): lock conflict on no wait transaction
deadlock
update conflicts with concurrent update ---> lock conflict on no wait transaction
deadlock
update conflicts with concurrent update

Server stack trace: 
   at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteNonQuery() in
c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:line 514
   at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md,
Object[] args, Object server, Object[]& outArgs)
   at System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMessage msg,
IMessageSink replySink)

--

-- 
(Continue reading)

MIHIR KADAM (JIRA | 21 Feb 16:02 2015

[FB-Tracker] Created: (DNET-592) unable to allocate memory from operating system GDSCODE: 335544430 SYMBOlL: virmemexh

unable to allocate memory from operating system GDSCODE: 335544430 SYMBOlL: virmemexh
-------------------------------------------------------------------------------------

                 Key: DNET-592
                 URL: http://tracker.firebirdsql.org/browse/DNET-592
             Project: .NET Data provider
          Issue Type: Bug
          Components: ASP.NET Providers
    Affects Versions: 2.1.0
         Environment: Windows
            Reporter: MIHIR KADAM
            Assignee: Jiri Cincura

Widows service running which continues listing to firebird database events. I received following
exception when service is running.After this exception service stop working. 

2015-02-19 13:49:59,364 [87] ERROR WindowsService.FirebirdListener -
FirebirdSql.Data.FirebirdClient.FbException (0x80004005): unable to allocate memory from
operating system ---> unable to allocate memory from operating system

Server stack trace: 
   at FirebirdSql.Data.FirebirdClient.FbTransaction.BeginTransaction() in
c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbTransaction.cs:line 367
   at FirebirdSql.Data.FirebirdClient.FbCommand.Prepare(Boolean returnsSet) in
c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:line 1140
   at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand(CommandBehavior behavior, Boolean
returnsSet) in
c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:line 1201
   at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior) in
c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:line 556
(Continue reading)

Parzival | 20 Feb 18:16 2015
Picon
Picon

EF connectionstring with trusted authentication

Hello all,

 

I am using firebird .net provider and EF to connect to the firebird DB. The connection with the .net provider works fine with trusted authentication. The Windows Username of the current user is sent without a password to the database and it connects as expected.

 

 

When I try to do the same with EF I fail by removing the password.

 

   cU := System.Security.Principal.WindowsIdentity.GetCurrent()

   _currentUser := cU:Name

// this works

_efsb:ProviderConnectionString := "character set=ISO8859_1;data source=" + _server + ";initial catalog=" + _database + ";user id=" + _currentUser + ";role=BAURADAR_ADMIN;" 

 

// this does not work

_efsb:ProviderConnectionString := "character set=ISO8859_1;data source=" + _server + ";initial catalog=" + _database + ";user id=" + _currentUser + ";password=mypassword;role=BAURADAR_ADMIN;" 

 

I have removed the connectionstring section from the app.config in order to read the essential parameters (server, database) from a config file.

 

Is there any special setting I have to add that trusted authentication works with EF as well as it does with the .net provider?

 

Thanks

 

Niko

------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=190641631&iu=/4140/ostg.clktrk
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Kjell Rilbe | 11 Feb 13:56 2015
Picon

Prepare/reprepare?

Hi,

I'm writing a loop where a few FbCommands will be executed several times, so of course I call Prepare() before the loop starts.

But I would also like to commit the transaction at regular intervals in the loop, and start a new transaction. I assign the new transaction to each FbCommand.

Do I need to call Prepare() again on each FbCommand after the commit and new transaction assignment?

Btw, is there any way to check if a FbCommand is prepared or not?

Regards,
Kjell
--

Kjell Rilbe
Telefon: 08-761 06 55
Mobil: 0733-44 24 64

DataDIA AB
Ulvsundavägen 106
168 67 Bromma
www.datadia.se
08-514 905 90


Företagskontakt.se - urval av företag och kontaktinformation
Personkontakt.se - urval av hushållsadresser

------------------------------------------------------------------------------
Dive into the World of Parallel Programming. The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net/
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Serj Dolzhenko (JIRA | 9 Feb 11:07 2015

[FB-Tracker] Created: (DNET-591) Problem with FbConnect

Problem with FbConnect
----------------------

                 Key: DNET-591
                 URL: http://tracker.firebirdsql.org/browse/DNET-591
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 4.6.1.0
         Environment: Windows 7/Windows 2008R2, C# 4.0 
            Reporter: Serj Dolzhenko
            Assignee: Jiri Cincura

In my code i have one FbConnection for listening events from DB, it opens at programm starts and normaly
closes only with program, but if there is no events for some reason for long interval of time i made close
connection and try to open it again. Then i'm testing this version of .Net data provider i found that open
connection didn't throw any exception and open connection to remote DB then there is no link to lan and DB at
all. Previous version that i test (4.1.0.0) throws here exception - unable to complete network request.

--

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

------------------------------------------------------------------------------
Dive into the World of Parallel Programming. The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net/
Jiri Cincura (JIRA | 5 Feb 09:06 2015

[FB-Tracker] Created: (DNET-590) Use constants for defaults for FbConnectionString and FbConnectionStringBuilder

Use constants for defaults for FbConnectionString and FbConnectionStringBuilder
-------------------------------------------------------------------------------

                 Key: DNET-590
                 URL: http://tracker.firebirdsql.org/browse/DNET-590
             Project: .NET Data provider
          Issue Type: Improvement
          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

------------------------------------------------------------------------------
Dive into the World of Parallel Programming. The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net/
Christoph Gasser | 31 Jan 12:46 2015

Firebird EF6 DDEX adding Views

I’m using VS 2012, Firebird 2.5, EF6. When trying to add a View to my model in the designer I get the message:

 

“The table/view 'Firebird.Firebird.V_MYVIEW' does not have a primary key defined and no valid primary key could be inferred. This table/view has been excluded. To use the entity, you will need to review your schema, add the correct keys, and uncomment it.”

 

That’s because EF need a PK for every table / view. When using MSSQL there is an approach using ISNULL in the view to be able to add the view to the model. But ISNULL is not supported in Firebird.

The underlying table of the view has PK which is also marked as #PK_GEN# . And I’m able to add this table to my model.

 

So my question is: Does anyone know how to add a view to a EF6 model in designer?

 

BR
C

------------------------------------------------------------------------------
Dive into the World of Parallel Programming. The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net/
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Hernan Martinez | 27 Jan 17:06 2015

Decorators for FbConnectionString properties

Hi dev(s)!

One nice addition would be to decorate FbConnectionString public properties with Attribute decorators like Category, Description, Editor, DefaultValue, etc.
It’s a fairly easy mod (if only with English texts) and I can do it by myself. Would you accept patches? Do you expect any problem with regards to Mono?

Regards,

Hernán Martínez-Foffani
_________________________ 
OBI - on board intelligence
Director de Tecnología

------------------------------------------------------------------------------
Dive into the World of Parallel Programming. The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net/
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Luciano Mendes (JIRA | 23 Jan 20:54 2015

[FB-Tracker] Created: (DNET-589) CLONE -FirebirdSQL Connection Pooling (ADO.NET) is not Working

CLONE -FirebirdSQL Connection Pooling (ADO.NET) is not Working
--------------------------------------------------------------

                 Key: DNET-589
                 URL: http://tracker.firebirdsql.org/browse/DNET-589
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 4.6.0.0
         Environment: Firebird 2.5.3.26780 (x64); 
Windows 10 Pro;
            Reporter: Luciano Mendes
            Assignee: Jiri Cincura
            Priority: Blocker

Actual result: 
Engine Code: 335544726 
Engine Message: Error reading data from the connection. 
See: ADONETConnectionPoolingERROR.png 

Expected Result: 
The Connection Pooling should be automatically restored when any disconnection occurs between requests;

Steps to reproduce the issue: 
1- Open a  FirebirdSQL Connection Pooling (ADO.NET) using the ADO.NET Provider v.4.6.0.0 (Reference:
http://msdn.microsoft.com/en-us/library/8xx3tyca(v=vs.100).aspx) and do a Data request: The data
is received without any issue;
2- Interupt the FirebirdSQL Server (net stop FirebirdServerDefaultInstance) and restart it  (net start FirebirdServerDefaultInstance);
3- Try to request any other data from the Database using the same FirebirdSQL Connection Pooling open before.

Additional Information: 
This issue did not happen when using the previous ADO.NET Provider v.4.5.2.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

------------------------------------------------------------------------------
New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
GigeNET is offering a free month of service with a new server in Ashburn.
Choose from 2 high performing configs, both with 100TB of bandwidth.
Higher redundancy.Lower latency.Increased capacity.Completely compliant.
http://p.sf.net/sfu/gigenet
Nicolas F. Timmers | 23 Jan 11:48 2015
Picon

Error reading data from the connection

Hello

I am experiencing an error regarding the new version of Firebird Client 4.6.0

In summary the following steps are necessary to generate the error

 

1) Using a page Ex: Default.aspx, make a connection to the database

2) After made the connection end the firebird service by windows services

3) When you return to the page and try to make a new connection an error is generated

4) Error reading data from the connection

 

What did seems to be is that when the firebird service is stopped the Firebird Client is trying to use the Pooling my question is if an attempt is made in pooling successfully should not the DLL fill the pooling again?

------------------------------------------------------------------------------
New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
GigeNET is offering a free month of service with a new server in Ashburn.
Choose from 2 high performing configs, both with 100TB of bandwidth.
Higher redundancy.Lower latency.Increased capacity.Completely compliant.
http://p.sf.net/sfu/gigenet
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Gmane