david | 14 Sep 20:25 2014

Re: Firebird-net-provider Digest, Vol 101, Issue 2

Sorry I missed you e-mail but I'm currently on leave. I will return to the office on Monday the 15th of September

For all support inquiries please contact the office on +353 (0)1 5253600 or +44 (0)203 4681247 

Alternatively please email support@... .

 Kind Regards,
 David

------------------------------------------------------------------------------
Want excitement?
Manually upgrade your production database.
When you want reliability, choose Perforce
Perforce version control. Predictably reliable.
http://pubads.g.doubleclick.net/gampad/clk?id=157508191&iu=/4140/ostg.clktrk
Jiří Činčura | 10 Sep 07:23 2014
Picon

ADO.NET provider 4.5.1.0 for Firebird is ready

This is just a small release with contributions on GitHub and so-called ProviderManifestToken resolving
improvements (database does not need to exist). High level overview of changes can be found in tracker.

You can get the bits from NuGet FirebirdSql.Data.FirebirdClient and EntityFramework.Firebird (or from firebirdsql.org).

More info: http://blog.cincura.net/233477-ado-net-provider-4-5-1-0-for-firebird-is-ready/


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

------------------------------------------------------------------------------
Want excitement?
Manually upgrade your production database.
When you want reliability, choose Perforce
Perforce version control. Predictably reliable.
http://pubads.g.doubleclick.net/gampad/clk?id=157508191&iu=/4140/ostg.clktrk
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Jiri Cincura (JIRA | 9 Sep 14:42 2014

[FB-Tracker] Created: (DNET-566) Pointer fixes

Pointer fixes
-------------

                 Key: DNET-566
                 URL: http://tracker.firebirdsql.org/browse/DNET-566
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 4.5.0.0
            Reporter: Jiri Cincura
            Assignee: Jiri Cincura

Contributed by PR https://github.com/cincuranet/NETProvider/pull/6#issuecomment-54961159.

--

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

------------------------------------------------------------------------------
Want excitement?
Manually upgrade your production database.
When you want reliability, choose Perforce.
Perforce version control. Predictably reliable.
http://pubads.g.doubleclick.net/gampad/clk?id=157508191&iu=/4140/ostg.clktrk
Jiri Cincura (JIRA | 9 Sep 14:42 2014

[FB-Tracker] Created: (DNET-567) TimeStamp fixed in embedded

TimeStamp fixed in embedded
---------------------------

                 Key: DNET-567
                 URL: http://tracker.firebirdsql.org/browse/DNET-567
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 4.5.0.0
            Reporter: Jiri Cincura
            Assignee: Jiri Cincura

Contributed by PR https://github.com/cincuranet/NETProvider/pull/6#issuecomment-54961159.

--

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

------------------------------------------------------------------------------
Want excitement?
Manually upgrade your production database.
When you want reliability, choose Perforce.
Perforce version control. Predictably reliable.
http://pubads.g.doubleclick.net/gampad/clk?id=157508191&iu=/4140/ostg.clktrk
Jiri Cincura (JIRA | 9 Sep 07:07 2014

[FB-Tracker] Created: (DNET-565) Improve getting ProvierManifestToken also for non-existing databases

Improve getting ProvierManifestToken also for non-existing databases
--------------------------------------------------------------------

                 Key: DNET-565
                 URL: http://tracker.firebirdsql.org/browse/DNET-565
             Project: .NET Data provider
          Issue Type: Improvement
          Components: Entity Framework support
    Affects Versions: 4.5.0.0
            Reporter: Jiri Cincura
            Assignee: Jiri Cincura

Improve getting ProvierManifestToken also for non-existing databases. It's needed i.e. for database initialization.

--

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

------------------------------------------------------------------------------
Want excitement?
Manually upgrade your production database.
When you want reliability, choose Perforce.
Perforce version control. Predictably reliable.
http://pubads.g.doubleclick.net/gampad/clk?id=157508191&iu=/4140/ostg.clktrk
Scott Morgan | 5 Sep 13:08 2014
Picon

Casting Text BLOB to null

Am I missing a trick here? I'm reading from a BLOB SUB_TYPE 1 column
using the following:

FbDataReader reader = /* blah */
string text = (string)reader["LONG_TEXT"];

It's okay when there is data, but if the column happens to be NULL I get
an error ("Unable to cast object of type 'System.DBNull' to type
'System.String'"), where I'd ideally like to get a plain null.

FbDataReader.GetString doesn't work for me as it just returns ""

So I'm left with a messy lump of GetOrdinal, IsDBNull, code. There's got
to be a better way, but I'm not seeing it.

Scott

------------------------------------------------------------------------------
Slashdot TV.  
Video for Nerds.  Stuff that matters.
http://tv.slashdot.org/
LtColRDSChauhan | 17 Aug 03:44 2014
Picon

Catching Exception

Hi,

1.  When I run my application, in Release configuration, through SharpDevelop IDE, the application catches "Handled Exception" -  "FirebirdSql.Data.Common.IscException: OVER_ALLOCATED_BED" thrown by Firebird stored procedure .

2.  Without debugger, the exception is not caught.  I do have catch blocks for : FbException, ApplicationException and Exception.

3.  Complication fails on adding catch block for FirebirdSql.Data.Common.IscException (appears to be internal).

4.  Please help.

Thanks and Regards,
Lt Col (Retd) Rajiv D.S. Chauhan
------------------------------------------------------------------------------
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Amro El-Fakharany (JIRA | 16 Aug 10:57 2014

[FB-Tracker] Created: (DNET-564) Parameters are ignored if a comment in a query contains a single or double quote

Parameters are ignored if a comment in a query contains a single or double quote
--------------------------------------------------------------------------------

                 Key: DNET-564
                 URL: http://tracker.firebirdsql.org/browse/DNET-564
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
            Reporter: Amro El-Fakharany
            Assignee: Jiri Cincura
            Priority: Minor

The following query fails with an unknown token exception:
select int_field
from test
-- a comment with ' 
where varchar_field =  <at> field

--

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

------------------------------------------------------------------------------
Marco Castro | 12 Aug 15:47 2014
Picon

SqlQuery is not working

Hello,

This procedure seems to be not working. I tried in MSSQL provider and it 
worked.

var r = entity.Database.SqlQuery<counter>( 
  "Select Gen_id(COUNTER, 1) cnt from rdb$database", new object[]{});

When I try to read "r" it returns this message:

Invalid attempt of read when the reader is closed.

Thanks,
Marco Castro

------------------------------------------------------------------------------
Marco Castro | 12 Aug 04:02 2014
Picon

Error when reading from connection

Hello,

I have an application that opens a Firebird connection and try to star a 
loop. In one computer the code runs fine and in another computer I get this 
message when this connection is in another server (Linux server). I tryed 
connections with and without pools with no difference. Firebird is 4.5, EDMX 
runs over ER6.1:

System.Data.Entity.Core.EntityCommandExecutionException: An error occurred 
while executing the command definition. See the inner exception for details. 
---> FirebirdSql.Data.FirebirdClient.FbException: Error reading data from 
the connection. 
---> FirebirdSql.Data.Common.IscException: Error reading data from the 
connection.
   em FirebirdSql.Data.Client.Managed.Version11.GdsStatement.Prepare(String 
commandText)
   em FirebirdSql.Data.FirebirdClient.FbCommand.Prepare(Boolean returnsSet)
   em 
FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand(CommandBehavior b
ehavior, Boolean returnsSet)
   em 
FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior be
havior)
   --- Fim do rastreamento de pilha de exceções internas ---
   em 
FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior be
havior)
   em 
FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteDbDataReader(CommandBehav
ior behavior)
   em System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
   em System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.
<Reader>b__c(DbCommand t, DbCommandInterceptionContext`1 c)
   em 
System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispat
ch[TTarget,TInterceptionContext,TResult](TTarget target, Func`3 operation, 
TInterceptionContext interceptionContext, Action`3 executing, Action`3 
executed)
   em 
System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.Reader(
DbCommand command, DbCommandInterceptionContext interceptionContext)
   em 
System.Data.Entity.Internal.InterceptableDbCommand.ExecuteDbDataReader(Com
mandBehavior behavior)
   em System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
   em 
System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.Exec
uteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
   --- Fim do rastreamento de pilha de exceções internas ---
   em 
System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.Exec
uteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
   em 
System.Data.Entity.Core.Objects.Internal.ObjectQueryExecutionPlan.Execute[
TResultType](ObjectContext context, ObjectParameterCollection 
parameterValues)
   em System.Data.Entity.Core.Objects.ObjectQuery`1.<>c__DisplayClass7.
<GetResul
ts>b__6()
   em System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T]
(Func`1 func, IDbExecutionStrategy executionStrategy, Boolean 
startLocalTransaction, Boolean releaseConnectionOnSuccess)
   em System.Data.Entity.Core.Objects.ObjectQuery`1.<>c__DisplayClass7.
<GetResults>b__5()
   em 
System.Data.Entity.Infrastructure.DefaultExecutionStrategy.Execute[TResult
](Func`1 operation)
   em System.Data.Entity.Core.Objects.ObjectQuery`1.GetResults(Nullable`1 
forMergeOption)
   em System.Data.Entity.Core.Objects.ObjectQuery`1.
<System.Collections.Generic.IEnumerable<T>.GetEnumerator>b__0()
   em System.Data.Entity.Internal.LazyEnumerator`1.MoveNext()
   em System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
   em System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
   em McSoft.Regras.BI.ConsultasOLAP.Consulta(Int32 _filial, DateTime _from, 
DateTime _to, Nullable`1 _produto, String _marca)

****************

Well, where can I start the issue solve?

Thanks,
Marco Casrto

------------------------------------------------------------------------------
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Lukáš Vykydal | 8 Aug 12:05 2014
Picon

Abbility to use "no garbage collect" connection parameter

Hi

i d'like to add support for option NoGarbageCollect to connection 
parameters.

I purpouse this implementation:
     - Connection String will be extended with parameter "no garbage 
collect" (synonym: "nogarbagecollect")
     - Connection String Builder will be extended eigher (.NET property 
- bool name NoGarbageCollect)
     - FbConnectionInternal will add isc_dpb_no_garbace_collect into 
Database Parameter Buffer during BuildDpb method

We use Firebird database for web application, and we run backups every 
night. So we d'like to keep garbage collect for backup and speed-up 
normal operation of web.

Please let me know what you think about it.

Lukáš Vykydal

------------------------------------------------------------------------------
Want fast and easy access to all the code in your enterprise? Index and
search up to 200,000 lines of code with a free copy of Black Duck
Code Sight - the same software that powers the world's largest code
search on Ohloh, the Black Duck Open Hub! Try it now.
http://p.sf.net/sfu/bds

Gmane