Menu
▾
▴
firebird-net-provider — All about development of the MS .Net provider
You can subscribe to this list here.
| 2002 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(10) |
Nov
(55) |
Dec
(36) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2003 |
Jan
(38) |
Feb
(108) |
Mar
(79) |
Apr
(95) |
May
(64) |
Jun
(130) |
Jul
(146) |
Aug
(121) |
Sep
(96) |
Oct
(149) |
Nov
(161) |
Dec
(113) |
| 2004 |
Jan
(113) |
Feb
(163) |
Mar
(248) |
Apr
(132) |
May
(157) |
Jun
(160) |
Jul
(236) |
Aug
(284) |
Sep
(293) |
Oct
(277) |
Nov
(257) |
Dec
(356) |
| 2005 |
Jan
(203) |
Feb
(190) |
Mar
(220) |
Apr
(165) |
May
(124) |
Jun
(160) |
Jul
(190) |
Aug
(142) |
Sep
(152) |
Oct
(189) |
Nov
(187) |
Dec
(159) |
| 2006 |
Jan
(170) |
Feb
(151) |
Mar
(212) |
Apr
(262) |
May
(226) |
Jun
(196) |
Jul
(223) |
Aug
(165) |
Sep
(163) |
Oct
(348) |
Nov
(225) |
Dec
(141) |
| 2007 |
Jan
(261) |
Feb
(161) |
Mar
(222) |
Apr
(193) |
May
(121) |
Jun
(157) |
Jul
(151) |
Aug
(159) |
Sep
(61) |
Oct
(123) |
Nov
(172) |
Dec
(96) |
| 2008 |
Jan
(104) |
Feb
(138) |
Mar
(131) |
Apr
(131) |
May
(74) |
Jun
(107) |
Jul
(89) |
Aug
(89) |
Sep
(172) |
Oct
(158) |
Nov
(119) |
Dec
(86) |
| 2009 |
Jan
(52) |
Feb
(84) |
Mar
(78) |
Apr
(83) |
May
(54) |
Jun
(79) |
Jul
(60) |
Aug
(62) |
Sep
(50) |
Oct
(147) |
Nov
(50) |
Dec
(70) |
| 2010 |
Jan
(135) |
Feb
(113) |
Mar
(74) |
Apr
(93) |
May
(35) |
Jun
(71) |
Jul
(33) |
Aug
(110) |
Sep
(47) |
Oct
(18) |
Nov
(61) |
Dec
(34) |
| 2011 |
Jan
(46) |
Feb
(47) |
Mar
(25) |
Apr
(24) |
May
(21) |
Jun
(22) |
Jul
(20) |
Aug
(51) |
Sep
(31) |
Oct
(42) |
Nov
(22) |
Dec
(22) |
| 2012 |
Jan
(31) |
Feb
(19) |
Mar
(25) |
Apr
(55) |
May
(16) |
Jun
(28) |
Jul
(33) |
Aug
(25) |
Sep
(32) |
Oct
(25) |
Nov
(52) |
Dec
(35) |
| 2013 |
Jan
(43) |
Feb
(18) |
Mar
(36) |
Apr
(45) |
May
(22) |
Jun
(13) |
Jul
(31) |
Aug
(24) |
Sep
(19) |
Oct
(59) |
Nov
(47) |
Dec
(25) |
| 2014 |
Jan
(27) |
Feb
(15) |
Mar
(38) |
Apr
(10) |
May
(15) |
Jun
(36) |
Jul
(24) |
Aug
(28) |
Sep
(16) |
Oct
(6) |
Nov
(44) |
Dec
(40) |
| 2015 |
Jan
(52) |
Feb
(22) |
Mar
(13) |
Apr
(17) |
May
(22) |
Jun
(36) |
Jul
(18) |
Aug
(41) |
Sep
(71) |
Oct
(60) |
Nov
(49) |
Dec
(43) |
| 2016 |
Jan
(60) |
Feb
(13) |
Mar
(21) |
Apr
(28) |
May
(23) |
Jun
(39) |
Jul
(17) |
Aug
(37) |
Sep
(33) |
Oct
(15) |
Nov
(22) |
Dec
(20) |
| 2017 |
Jan
(27) |
Feb
(40) |
Mar
(48) |
Apr
(19) |
May
(29) |
Jun
(2) |
Jul
(19) |
Aug
(36) |
Sep
(18) |
Oct
(10) |
Nov
(11) |
Dec
(5) |
| 2018 |
Jan
(5) |
Feb
(4) |
Mar
(5) |
Apr
(3) |
May
(4) |
Jun
(17) |
Jul
(7) |
Aug
(7) |
Sep
(12) |
Oct
(8) |
Nov
(2) |
Dec
|
| 2019 |
Jan
(8) |
Feb
(5) |
Mar
(3) |
Apr
(5) |
May
(3) |
Jun
(2) |
Jul
(8) |
Aug
(7) |
Sep
(3) |
Oct
(12) |
Nov
(7) |
Dec
(1) |
| 2020 |
Jan
(8) |
Feb
(3) |
Mar
(7) |
Apr
(1) |
May
(2) |
Jun
(1) |
Jul
(3) |
Aug
(25) |
Sep
(5) |
Oct
(3) |
Nov
(7) |
Dec
(16) |
| 2021 |
Jan
(11) |
Feb
(10) |
Mar
(16) |
Apr
(8) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Ernesto C. <ern...@gm...> - 2014-07-29 18:43:43
|
As far as I understand, with embedded server you don't specify the server;
just the database name, eventually with the full path. I've tested both
with and without path. I've copied all files from lib directory under
firebird, so the linux equivalents to icu*.dll etc are present. Also copied
firebird.msg, .conf and security2.fdb.
I think the server is working fine, I can create the database with isql;
there is something wrong with the provider's resources, or the way they are
accessed in mono.
Ernesto
2014-07-29 11:12 GMT-03:00 Edward Mendez <Eme...@nc...>:
> Ernesto,
>
>
>
> In my connection string for Embedded Server (on Windows) I have the
> following;
>
>
>
> "data source=localhost;Client Library=|DataDirectory|fbembed.dll;initial
> catalog=<pathToDatabase>\<DataBaseName>.FDB;user
> id=sysdba;password=masterkey;server type=1"
>
>
>
> I needed to specify the path to the Database File, along with the Path to
> the fbembed.dll and also the localhost. I also needed to include the
> following files in my output folder…
>
>
>
> firebird.conf, firebird.msg, ib_util.dll, icudt30.dll, icuin30.dll,
> icuuc30.dll
>
>
>
> Hope this helps,
>
>
>
> Ed Mendez
>
>
>
> *From:* Ernesto Cullen [mailto:ern...@gm...]
> *Sent:* Tuesday, July 29, 2014 9:28 AM
> *To:* fir...@li...
> *Subject:* [Firebird-net-provider] Problem reading resources on linux
>
>
>
> I've created a small program to test firebird access with an embedded
> server on linux (with mono), but I am getting errors related to resources.
>
>
> This is the program:
> namespace ConsoleFBTest
> {
> class MainClass
> {
> public static void Main (string[] args)
> {
> Console.WriteLine ("Creating database...");
> FbConnection.CreateDatabase(
> "ServerType=1;client library=libfbembed;Dialect=3;Database=test.fdb;User=sysdba;password=masterkey"
> );
> }
> }
> }
>
>
>
> easy enough, I just want to create a database. I've copied all firebird
> lib/* files into target dir, along with firebird.msg, security2.fdb,
> firebird.conf, intl/*. I tested that the embedded server works copying also
> isql and executing from command line.
>
> When I run previous program, both from MonoDevelop and from command line,
> I get the output below. I think it may have to do with resources formatting
> or embedding in the firebird client dll? maybe eol characters? old mono
> version? running out of ideas here, please help!
>
> Ernesto Cullen
>
>
>
> Mono version:
> -------------------------------------
> mono --version
> Mono JIT compiler version 2.10.8 (tarball Mon Apr 7 03:54:27 IST 2014)
> Copyright (C) 2002-2011 Novell, Inc, Xamarin, Inc and Contributors.
> www.mono-project.com
> TLS: __thread
> SIGSEGV: altstack
> Notifications: epoll
> Architecture: amd64
> Disabled: none
> Misc: debugger softdebug
> LLVM: supported, not enabled.
> GC: Included Boehm (with typed GC and Parallel Mark)
>
> NETProvider: NETProvider-4.2.0.0-MONO_LINUX
>
> Firebird: FirebirdCS-2.5.3.26778-0.amd64
>
>
>
> program output
> -------------------------------------------------------------------
>
> Creating database...
>
> Unhandled Exception: System.ObjectDisposedException: The object was used
> after being disposed.
> at System.IO.UnmanagedMemoryStream.Seek (Int64 offset, SeekOrigin loc)
> [0x00000] in <filename unknown>:0
> at System.Resources.ResourceReader.LoadResourceValues
> (.ResourceCacheItem[] store) [0x00000] in <filename unknown>:0
> at System.Resources.ResourceReader+ResourceEnumerator.FillCache ()
> [0x00000] in <filename unknown>:0
> at System.Resources.ResourceReader+ResourceEnumerator..ctor
> (System.Resources.ResourceReader readerToEnumerate) [0x00000] in <filename
> unknown>:0
> at System.Resources.ResourceReader.GetEnumerator () [0x00000] in
> <filename unknown>:0
> at System.Resources.ResourceSet.ReadResources () [0x00000] in <filename
> unknown>:0
> at System.Resources.ResourceSet.GetObjectInternal (System.String name,
> Boolean ignoreCase) [0x00000] in <filename unknown>:0
> at System.Resources.ResourceSet.GetObject (System.String name, Boolean
> ignoreCase) [0x00000] in <filename unknown>:0
> at System.Resources.ResourceSet.GetStringInternal (System.String name,
> Boolean ignoreCase) [0x00000] in <filename unknown>:0
> at System.Resources.ResourceSet.GetString (System.String name) [0x00000]
> in <filename unknown>:0
> at FirebirdSql.Data.Common.IscException.BuildSqlState () [0x00000] in
> <filename unknown>:0
> at FirebirdSql.Data.Common.IscException.BuildExceptionData () [0x00000]
> in <filename unknown>:0
> at FirebirdSql.Data.Client.Native.FesConnection.ParseStatusVector
> (System.IntPtr[] statusVector, FirebirdSql.Data.Common.Charset charset)
> [0x00000] in <filename unknown>:0
> at FirebirdSql.Data.Client.Native.FesDatabase.ParseStatusVector
> (System.IntPtr[] statusVector) [0x00000] in <filename unknown>:0
> at FirebirdSql.Data.Client.Native.FesDatabase.CreateDatabase
> (FirebirdSql.Data.Common.DatabaseParameterBuffer dpb, System.String
> dataSource, Int32 port, System.String database) [0x00000] in <filename
> unknown>:0
> at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.CreateDatabase
> (FirebirdSql.Data.Common.DatabaseParameterBuffer dpb) [0x00000] in
> <filename unknown>:0
> at (wrapper remoting-invoke-with-check)
> FirebirdSql.Data.FirebirdClient.FbConnectionInternal:CreateDatabase
> (FirebirdSql.Data.Common.DatabaseParameterBuffer)
> at FirebirdSql.Data.FirebirdClient.FbConnection.CreateDatabase
> (System.String connectionString, Int32 pageSize, Boolean forcedWrites,
> Boolean overwrite) [0x00000] in <filename unknown>:0
> at FirebirdSql.Data.FirebirdClient.FbConnection.CreateDatabase
> (System.String connectionString) [0x00000] in <filename unknown>:0
> at ConsoleFBTest.MainClass.Main (System.String[] args) [0x00000] in
> <filename unknown>:0
> [ERROR] FATAL UNHANDLED EXCEPTION: System.ObjectDisposedException: The
> object was used after being disposed.
> at System.IO.UnmanagedMemoryStream.Seek (Int64 offset, SeekOrigin loc)
> [0x00000] in <filename unknown>:0
> at System.Resources.ResourceReader.LoadResourceValues
> (.ResourceCacheItem[] store) [0x00000] in <filename unknown>:0
> at System.Resources.ResourceReader+ResourceEnumerator.FillCache ()
> [0x00000] in <filename unknown>:0
> at System.Resources.ResourceReader+ResourceEnumerator..ctor
> (System.Resources.ResourceReader readerToEnumerate) [0x00000] in <filename
> unknown>:0
> at System.Resources.ResourceReader.GetEnumerator () [0x00000] in
> <filename unknown>:0
> at System.Resources.ResourceSet.ReadResources () [0x00000] in <filename
> unknown>:0
> at System.Resources.ResourceSet.GetObjectInternal (System.String name,
> Boolean ignoreCase) [0x00000] in <filename unknown>:0
> at System.Resources.ResourceSet.GetObject (System.String name, Boolean
> ignoreCase) [0x00000] in <filename unknown>:0
> at System.Resources.ResourceSet.GetStringInternal (System.String name,
> Boolean ignoreCase) [0x00000] in <filename unknown>:0
> at System.Resources.ResourceSet.GetString (System.String name) [0x00000]
> in <filename unknown>:0
> at FirebirdSql.Data.Common.IscException.BuildSqlState () [0x00000] in
> <filename unknown>:0
> at FirebirdSql.Data.Common.IscException.BuildExceptionData () [0x00000]
> in <filename unknown>:0
> at FirebirdSql.Data.Client.Native.FesConnection.ParseStatusVector
> (System.IntPtr[] statusVector, FirebirdSql.Data.Common.Charset charset)
> [0x00000] in <filename unknown>:0
> at FirebirdSql.Data.Client.Native.FesDatabase.ParseStatusVector
> (System.IntPtr[] statusVector) [0x00000] in <filename unknown>:0
> at FirebirdSql.Data.Client.Native.FesDatabase.CreateDatabase
> (FirebirdSql.Data.Common.DatabaseParameterBuffer dpb, System.String
> dataSource, Int32 port, System.String database) [0x00000] in <filename
> unknown>:0
> at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.CreateDatabase
> (FirebirdSql.Data.Common.DatabaseParameterBuffer dpb) [0x00000] in
> <filename unknown>:0
> at (wrapper remoting-invoke-with-check)
> FirebirdSql.Data.FirebirdClient.FbConnectionInternal:CreateDatabase
> (FirebirdSql.Data.Common.DatabaseParameterBuffer)
> at FirebirdSql.Data.FirebirdClient.FbConnection.CreateDatabase
> (System.String connectionString, Int32 pageSize, Boolean forcedWrites,
> Boolean overwrite) [0x00000] in <filename unknown>:0
> at FirebirdSql.Data.FirebirdClient.FbConnection.CreateDatabase
> (System.String connectionString) [0x00000] in <filename unknown>:0
> at ConsoleFBTest.MainClass.Main (System.String[] args) [0x00000] in
> <filename unknown>:0
>
> --
>
> "Either write something worth reading or do something worth writing" B.
> Franklin
>
>
> ------------------------------------------------------------------------------
> Infragistics Professional
> Build stunning WinForms apps today!
> Reboot your WinForms applications with our WinForms controls.
> Build a bridge from your legacy apps to the future.
>
> http://pubads.g.doubleclick.net/gampad/clk?id=153845071&iu=/4140/ostg.clktrk
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>
--
"Either write something worth reading or do something worth writing" B.
Franklin
|
|
From: Edward M. <Eme...@nc...> - 2014-07-29 14:27:48
|
Ernesto,
In my connection string for Embedded Server (on Windows) I have the following;
"data source=localhost;Client Library=|DataDirectory|fbembed.dll;initial catalog=<pathToDatabase>\<DataBaseName>.FDB;user id=sysdba;password=masterkey;server type=1"
I needed to specify the path to the Database File, along with the Path to the fbembed.dll and also the localhost. I also needed to include the following files in my output folder…
firebird.conf, firebird.msg, ib_util.dll, icudt30.dll, icuin30.dll, icuuc30.dll
Hope this helps,
Ed Mendez
From: Ernesto Cullen [mailto:ern...@gm...]
Sent: Tuesday, July 29, 2014 9:28 AM
To: fir...@li...
Subject: [Firebird-net-provider] Problem reading resources on linux
I've created a small program to test firebird access with an embedded server on linux (with mono), but I am getting errors related to resources.
This is the program:
namespace ConsoleFBTest
{
class MainClass
{
public static void Main (string[] args)
{
Console.WriteLine ("Creating database...");
FbConnection.CreateDatabase("ServerType=1;client library=libfbembed;Dialect=3;Database=test.fdb;User=sysdba;password=masterkey");
}
}
}
easy enough, I just want to create a database. I've copied all firebird lib/* files into target dir, along with firebird.msg, security2.fdb, firebird.conf, intl/*. I tested that the embedded server works copying also isql and executing from command line.
When I run previous program, both from MonoDevelop and from command line, I get the output below. I think it may have to do with resources formatting or embedding in the firebird client dll? maybe eol characters? old mono version? running out of ideas here, please help!
Ernesto Cullen
Mono version:
-------------------------------------
mono --version
Mono JIT compiler version 2.10.8 (tarball Mon Apr 7 03:54:27 IST 2014)
Copyright (C) 2002-2011 Novell, Inc, Xamarin, Inc and Contributors. www.mono-project.com
TLS: __thread
SIGSEGV: altstack
Notifications: epoll
Architecture: amd64
Disabled: none
Misc: debugger softdebug
LLVM: supported, not enabled.
GC: Included Boehm (with typed GC and Parallel Mark)
NETProvider: NETProvider-4.2.0.0-MONO_LINUX
Firebird: FirebirdCS-2.5.3.26778-0.amd64
program output
-------------------------------------------------------------------
Creating database...
Unhandled Exception: System.ObjectDisposedException: The object was used after being disposed.
at System.IO.UnmanagedMemoryStream.Seek (Int64 offset, SeekOrigin loc) [0x00000] in <filename unknown>:0
at System.Resources.ResourceReader.LoadResourceValues (.ResourceCacheItem[] store) [0x00000] in <filename unknown>:0
at System.Resources.ResourceReader+ResourceEnumerator.FillCache () [0x00000] in <filename unknown>:0
at System.Resources.ResourceReader+ResourceEnumerator..ctor (System.Resources.ResourceReader readerToEnumerate) [0x00000] in <filename unknown>:0
at System.Resources.ResourceReader.GetEnumerator () [0x00000] in <filename unknown>:0
at System.Resources.ResourceSet.ReadResources () [0x00000] in <filename unknown>:0
at System.Resources.ResourceSet.GetObjectInternal (System.String name, Boolean ignoreCase) [0x00000] in <filename unknown>:0
at System.Resources.ResourceSet.GetObject (System.String name, Boolean ignoreCase) [0x00000] in <filename unknown>:0
at System.Resources.ResourceSet.GetStringInternal (System.String name, Boolean ignoreCase) [0x00000] in <filename unknown>:0
at System.Resources.ResourceSet.GetString (System.String name) [0x00000] in <filename unknown>:0
at FirebirdSql.Data.Common.IscException.BuildSqlState () [0x00000] in <filename unknown>:0
at FirebirdSql.Data.Common.IscException.BuildExceptionData () [0x00000] in <filename unknown>:0
at FirebirdSql.Data.Client.Native.FesConnection.ParseStatusVector (System.IntPtr[] statusVector, FirebirdSql.Data.Common.Charset charset) [0x00000] in <filename unknown>:0
at FirebirdSql.Data.Client.Native.FesDatabase.ParseStatusVector (System.IntPtr[] statusVector) [0x00000] in <filename unknown>:0
at FirebirdSql.Data.Client.Native.FesDatabase.CreateDatabase (FirebirdSql.Data.Common.DatabaseParameterBuffer dpb, System.String dataSource, Int32 port, System.String database) [0x00000] in <filename unknown>:0
at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.CreateDatabase (FirebirdSql.Data.Common.DatabaseParameterBuffer dpb) [0x00000] in <filename unknown>:0
at (wrapper remoting-invoke-with-check) FirebirdSql.Data.FirebirdClient.FbConnectionInternal:CreateDatabase (FirebirdSql.Data.Common.DatabaseParameterBuffer)
at FirebirdSql.Data.FirebirdClient.FbConnection.CreateDatabase (System.String connectionString, Int32 pageSize, Boolean forcedWrites, Boolean overwrite) [0x00000] in <filename unknown>:0
at FirebirdSql.Data.FirebirdClient.FbConnection.CreateDatabase (System.String connectionString) [0x00000] in <filename unknown>:0
at ConsoleFBTest.MainClass.Main (System.String[] args) [0x00000] in <filename unknown>:0
[ERROR] FATAL UNHANDLED EXCEPTION: System.ObjectDisposedException: The object was used after being disposed.
at System.IO.UnmanagedMemoryStream.Seek (Int64 offset, SeekOrigin loc) [0x00000] in <filename unknown>:0
at System.Resources.ResourceReader.LoadResourceValues (.ResourceCacheItem[] store) [0x00000] in <filename unknown>:0
at System.Resources.ResourceReader+ResourceEnumerator.FillCache () [0x00000] in <filename unknown>:0
at System.Resources.ResourceReader+ResourceEnumerator..ctor (System.Resources.ResourceReader readerToEnumerate) [0x00000] in <filename unknown>:0
at System.Resources.ResourceReader.GetEnumerator () [0x00000] in <filename unknown>:0
at System.Resources.ResourceSet.ReadResources () [0x00000] in <filename unknown>:0
at System.Resources.ResourceSet.GetObjectInternal (System.String name, Boolean ignoreCase) [0x00000] in <filename unknown>:0
at System.Resources.ResourceSet.GetObject (System.String name, Boolean ignoreCase) [0x00000] in <filename unknown>:0
at System.Resources.ResourceSet.GetStringInternal (System.String name, Boolean ignoreCase) [0x00000] in <filename unknown>:0
at System.Resources.ResourceSet.GetString (System.String name) [0x00000] in <filename unknown>:0
at FirebirdSql.Data.Common.IscException.BuildSqlState () [0x00000] in <filename unknown>:0
at FirebirdSql.Data.Common.IscException.BuildExceptionData () [0x00000] in <filename unknown>:0
at FirebirdSql.Data.Client.Native.FesConnection.ParseStatusVector (System.IntPtr[] statusVector, FirebirdSql.Data.Common.Charset charset) [0x00000] in <filename unknown>:0
at FirebirdSql.Data.Client.Native.FesDatabase.ParseStatusVector (System.IntPtr[] statusVector) [0x00000] in <filename unknown>:0
at FirebirdSql.Data.Client.Native.FesDatabase.CreateDatabase (FirebirdSql.Data.Common.DatabaseParameterBuffer dpb, System.String dataSource, Int32 port, System.String database) [0x00000] in <filename unknown>:0
at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.CreateDatabase (FirebirdSql.Data.Common.DatabaseParameterBuffer dpb) [0x00000] in <filename unknown>:0
at (wrapper remoting-invoke-with-check) FirebirdSql.Data.FirebirdClient.FbConnectionInternal:CreateDatabase (FirebirdSql.Data.Common.DatabaseParameterBuffer)
at FirebirdSql.Data.FirebirdClient.FbConnection.CreateDatabase (System.String connectionString, Int32 pageSize, Boolean forcedWrites, Boolean overwrite) [0x00000] in <filename unknown>:0
at FirebirdSql.Data.FirebirdClient.FbConnection.CreateDatabase (System.String connectionString) [0x00000] in <filename unknown>:0
at ConsoleFBTest.MainClass.Main (System.String[] args) [0x00000] in <filename unknown>:0
--
"Either write something worth reading or do something worth writing" B. Franklin
|
|
From: Ernesto C. <ern...@gm...> - 2014-07-29 13:28:18
|
I've created a small program to test firebird access with an embedded
server on linux (with mono), but I am getting errors related to resources.
This is the program:
namespace ConsoleFBTest
{
class MainClass
{
public static void Main (string[] args)
{
Console.WriteLine ("Creating database...");
FbConnection.CreateDatabase("ServerType=1;client library=
libfbembed;Dialect=3;Database=test.fdb;User=sysdba;password=masterkey");
}
}
}
easy enough, I just want to create a database. I've copied all firebird
lib/* files into target dir, along with firebird.msg, security2.fdb,
firebird.conf, intl/*. I tested that the embedded server works copying also
isql and executing from command line.
When I run previous program, both from MonoDevelop and from command line, I
get the output below. I think it may have to do with resources formatting
or embedding in the firebird client dll? maybe eol characters? old mono
version? running out of ideas here, please help!
Ernesto Cullen
Mono version:
-------------------------------------
mono --version
Mono JIT compiler version 2.10.8 (tarball Mon Apr 7 03:54:27 IST 2014)
Copyright (C) 2002-2011 Novell, Inc, Xamarin, Inc and Contributors.
www.mono-project.com
TLS: __thread
SIGSEGV: altstack
Notifications: epoll
Architecture: amd64
Disabled: none
Misc: debugger softdebug
LLVM: supported, not enabled.
GC: Included Boehm (with typed GC and Parallel Mark)
NETProvider: NETProvider-4.2.0.0-MONO_LINUX
Firebird: FirebirdCS-2.5.3.26778-0.amd64
program output
-------------------------------------------------------------------
Creating database...
Unhandled Exception: System.ObjectDisposedException: The object was used
after being disposed.
at System.IO.UnmanagedMemoryStream.Seek (Int64 offset, SeekOrigin loc)
[0x00000] in <filename unknown>:0
at System.Resources.ResourceReader.LoadResourceValues
(.ResourceCacheItem[] store) [0x00000] in <filename unknown>:0
at System.Resources.ResourceReader+ResourceEnumerator.FillCache ()
[0x00000] in <filename unknown>:0
at System.Resources.ResourceReader+ResourceEnumerator..ctor
(System.Resources.ResourceReader readerToEnumerate) [0x00000] in <filename
unknown>:0
at System.Resources.ResourceReader.GetEnumerator () [0x00000] in
<filename unknown>:0
at System.Resources.ResourceSet.ReadResources () [0x00000] in <filename
unknown>:0
at System.Resources.ResourceSet.GetObjectInternal (System.String name,
Boolean ignoreCase) [0x00000] in <filename unknown>:0
at System.Resources.ResourceSet.GetObject (System.String name, Boolean
ignoreCase) [0x00000] in <filename unknown>:0
at System.Resources.ResourceSet.GetStringInternal (System.String name,
Boolean ignoreCase) [0x00000] in <filename unknown>:0
at System.Resources.ResourceSet.GetString (System.String name) [0x00000]
in <filename unknown>:0
at FirebirdSql.Data.Common.IscException.BuildSqlState () [0x00000] in
<filename unknown>:0
at FirebirdSql.Data.Common.IscException.BuildExceptionData () [0x00000]
in <filename unknown>:0
at FirebirdSql.Data.Client.Native.FesConnection.ParseStatusVector
(System.IntPtr[] statusVector, FirebirdSql.Data.Common.Charset charset)
[0x00000] in <filename unknown>:0
at FirebirdSql.Data.Client.Native.FesDatabase.ParseStatusVector
(System.IntPtr[] statusVector) [0x00000] in <filename unknown>:0
at FirebirdSql.Data.Client.Native.FesDatabase.CreateDatabase
(FirebirdSql.Data.Common.DatabaseParameterBuffer dpb, System.String
dataSource, Int32 port, System.String database) [0x00000] in <filename
unknown>:0
at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.CreateDatabase
(FirebirdSql.Data.Common.DatabaseParameterBuffer dpb) [0x00000] in
<filename unknown>:0
at (wrapper remoting-invoke-with-check)
FirebirdSql.Data.FirebirdClient.FbConnectionInternal:CreateDatabase
(FirebirdSql.Data.Common.DatabaseParameterBuffer)
at FirebirdSql.Data.FirebirdClient.FbConnection.CreateDatabase
(System.String connectionString, Int32 pageSize, Boolean forcedWrites,
Boolean overwrite) [0x00000] in <filename unknown>:0
at FirebirdSql.Data.FirebirdClient.FbConnection.CreateDatabase
(System.String connectionString) [0x00000] in <filename unknown>:0
at ConsoleFBTest.MainClass.Main (System.String[] args) [0x00000] in
<filename unknown>:0
[ERROR] FATAL UNHANDLED EXCEPTION: System.ObjectDisposedException: The
object was used after being disposed.
at System.IO.UnmanagedMemoryStream.Seek (Int64 offset, SeekOrigin loc)
[0x00000] in <filename unknown>:0
at System.Resources.ResourceReader.LoadResourceValues
(.ResourceCacheItem[] store) [0x00000] in <filename unknown>:0
at System.Resources.ResourceReader+ResourceEnumerator.FillCache ()
[0x00000] in <filename unknown>:0
at System.Resources.ResourceReader+ResourceEnumerator..ctor
(System.Resources.ResourceReader readerToEnumerate) [0x00000] in <filename
unknown>:0
at System.Resources.ResourceReader.GetEnumerator () [0x00000] in
<filename unknown>:0
at System.Resources.ResourceSet.ReadResources () [0x00000] in <filename
unknown>:0
at System.Resources.ResourceSet.GetObjectInternal (System.String name,
Boolean ignoreCase) [0x00000] in <filename unknown>:0
at System.Resources.ResourceSet.GetObject (System.String name, Boolean
ignoreCase) [0x00000] in <filename unknown>:0
at System.Resources.ResourceSet.GetStringInternal (System.String name,
Boolean ignoreCase) [0x00000] in <filename unknown>:0
at System.Resources.ResourceSet.GetString (System.String name) [0x00000]
in <filename unknown>:0
at FirebirdSql.Data.Common.IscException.BuildSqlState () [0x00000] in
<filename unknown>:0
at FirebirdSql.Data.Common.IscException.BuildExceptionData () [0x00000]
in <filename unknown>:0
at FirebirdSql.Data.Client.Native.FesConnection.ParseStatusVector
(System.IntPtr[] statusVector, FirebirdSql.Data.Common.Charset charset)
[0x00000] in <filename unknown>:0
at FirebirdSql.Data.Client.Native.FesDatabase.ParseStatusVector
(System.IntPtr[] statusVector) [0x00000] in <filename unknown>:0
at FirebirdSql.Data.Client.Native.FesDatabase.CreateDatabase
(FirebirdSql.Data.Common.DatabaseParameterBuffer dpb, System.String
dataSource, Int32 port, System.String database) [0x00000] in <filename
unknown>:0
at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.CreateDatabase
(FirebirdSql.Data.Common.DatabaseParameterBuffer dpb) [0x00000] in
<filename unknown>:0
at (wrapper remoting-invoke-with-check)
FirebirdSql.Data.FirebirdClient.FbConnectionInternal:CreateDatabase
(FirebirdSql.Data.Common.DatabaseParameterBuffer)
at FirebirdSql.Data.FirebirdClient.FbConnection.CreateDatabase
(System.String connectionString, Int32 pageSize, Boolean forcedWrites,
Boolean overwrite) [0x00000] in <filename unknown>:0
at FirebirdSql.Data.FirebirdClient.FbConnection.CreateDatabase
(System.String connectionString) [0x00000] in <filename unknown>:0
at ConsoleFBTest.MainClass.Main (System.String[] args) [0x00000] in
<filename unknown>:0
--
"Either write something worth reading or do something worth writing" B.
Franklin
|
|
From: Ernesto C. <ern...@gm...> - 2014-07-28 14:27:28
|
Hi all, I am trying to port an application using Firebird from Windows (.net 4.0) to Linux under Mono, and I am having problems with the firebird provider. I try to compile it using MonoDevelop 5.0 and could not build the project 'FirebirdSql.Data.FirebirdClient'. I get several errors regarding EntityFramework, which I resolved defining 'NET_35' in project options (there are #if (!(NET_35 && !ENTITY_FRAMEWORK)) directives in several files, but the project had 'NET_40' defined), but I'm still getting errors like 'System.Data.Metadata' namespace not found. - why is the expression using NET_35? does it compile in .net 4 under mono? - Is the 'Entity' folder usable/needed under linux? I removed the 'Entity' folder from the project. Now the build stops saying that FirebirdSql.Data.FirebirdClient/FirebirdClient/FbCommand.cs(22,22): Error CS1061: Type `FirebirdSql.Data.FirebirdClient.FbCommand' does not contain a definition for `expectedColumnTypes' and no extension method `expectedColumnTypes' of type `FirebirdSql.Data.FirebirdClient.FbCommand' could be found. Are you missing an assembly reference? (CS1061) (FirebirdSql.Data.FirebirdClient) Looking at the top of the file I find the definition: #if (!(NET_35 && !ENTITY_FRAMEWORK)) private Type[] expectedColumnTypes; #endif ENTITY_FRAMEWORK is not defined, NET_35 is defined, so the expression evaluates to if !(true && true) -> false so the expectedColumnTypes definition is not compiled. - is this array needed when Entity_framework is not defined, i.e. in Linux? if so, the expression is wrong. Or, - if this array is not needed outside Entity framework, its usage should be enclosed in similar #if expression (lines 318, 368) How do you compile the mono dll included in the release? thanks, Ernesto Cullen -- "Either write something worth reading or do something worth writing" B. Franklin |
|
From: diskuze <di...@ci...> - 2014-07-28 08:54:01
|
I'm pleased to announce new version of .NET provider. You can read more at http://blog.cincura.net/233471-ado-net-provider-4-5-0-0-for-firebird-is-ready/ . -- Mgr. Jiri Cincura Independent IT Specialist |
|
From: Jiri C. (JIRA) <tr...@fi...> - 2014-07-28 07:39:14
|
Events getting "forgotten" for unknown reason
---------------------------------------------
Key: DNET-562
URL: http://tracker.firebirdsql.org/browse/DNET-562
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 4.2.0.0
Reporter: Jiri Cincura
Assignee: Jiri Cincura
Reported by me privately, with more or less reliable steps to reproduce.
--
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
|
|
From: André Z. (J. <tr...@fi...> - 2014-07-25 08:34:52
|
Add ETW logging support to the provider to get better error logging and have a way to trace the performance of the .Net provider
--------------------------------------------------------------------------------------------------------------------------------
Key: DNET-561
URL: http://tracker.firebirdsql.org/browse/DNET-561
Project: .NET Data provider
Issue Type: New Feature
Components: ADO.NET Provider
Affects Versions: vNext
Environment: Windows 8, VS2012 Update 4
Reporter: André Ziegler
Assignee: Jiri Cincura
With Microsoft.Diagnostics.Tracing.EventSource class (https://www.nuget.org/packages/Microsoft.Diagnostics.Tracing.EventSource) there is a great wrapper for Event Tracing for Windows (ETW - http://msdn.microsoft.com/en-us/library/windows/desktop/aa363668%28v=vs.85%29.aspx) which can be easily used to log Events from the provider.
It would be nice if the EF provider would implement ETW events (at start and end of methods which shows how long a method was executed) to allow perf tracing. It should also be used for logging errors/warnings.
--
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
|
|
From: André Z. (J. <tr...@fi...> - 2014-07-25 08:22:47
|
Firebird .Net Provider Installer doesn't remove entries from the machine.config <DbProviderFactories> when removing/repair the provider
---------------------------------------------------------------------------------------------------------------------------------------
Key: DNET-560
URL: http://tracker.firebirdsql.org/browse/DNET-560
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 4.2.0.0
Environment: Windows 8, VS2012 Update 4
Reporter: André Ziegler
Assignee: Jiri Cincura
Priority: Critical
The Installer has some issues with the machine.config file. When you remove and older provider, the config settings for Firebird under <DbProviderFactories> are still left in the config.
Wen you now install a new FB provider version, a 2nd entry is added. This caused VS crashes for me when working with DDEX provider when trying to do Reverse Engineering a DB to EDMX Model. Also, when you repair the provider, a second entry is added. Also the structure of the XML config is corrupted, when the other entry is added and this causes that other providers like SQL CE fail to load.
Removing all the bad entries fixes both VS issues (crash and SQL CE errors).
--
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
|
|
From: Geolffrey M. (JIRA) <tr...@fi...> - 2014-07-22 17:04:06
|
Null reference exception on fbcommand dispose in NET CF 3.5
-----------------------------------------------------------
Key: DNET-559
URL: http://tracker.firebirdsql.org/browse/DNET-559
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 2.5.2
Environment: Compact Framework 3.5
Reporter: Geolffrey Mena
Assignee: Jiri Cincura
My application is crashing and returning the following errors:
System.NullReferenceException was unhandled
Message="NullReferenceException"
StackTrace:
at FirebirdSql.Data.FirebirdClient.FbCommand.RollbackImplicitTransaction()
at FirebirdSql.Data.FirebirdClient.FbCommand.Release()
at FirebirdSql.Data.FirebirdClient.FbCommand.Dispose(Boolean disposing)
at System.ComponentModel.Component.Finalize()
I realize this happen only when the application is trying to save (update/insert).
I have review this tracker system trying to find a solution and I found the bug was fixed in the version 2.7.7. Which after some test does not work with Compact Framework 3.5. Is there any compiled version for Compact Framework or can any of you can give some advise about what I need to do in order to make it work with NET CF 3.5.
Thanks in advanced.
--
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
|
|
From: Mark R. <ma...@la...> - 2014-07-14 07:49:02
|
On Sun, 13 Jul 2014 23:21:04 +0530, LtColRDSChauhan <rds...@gm...> wrote: > No luck. Still could not connect to Firebird 3.0 Alpha 2. Could though > revert back to Alpha 1 successfully. You need to have a fresh security3.fdb with Alpha 2: you cannot use the security database created with Alpha 1 due to incompatible changes. However I seem to remember that I also had some problems with Alpha 2 and that I switched to a more recent snapshot when testing. However, I am not sure about the details. I will try with a fresh install and let you know. Mark |
|
From: didmiller <jdi...@ho...> - 2014-07-14 04:34:37
|
Entity Framework (EF) is an object-relational mapper that enables .NET developers to work with relational data using domain-specific objects. It eliminates the need for most of the data-access code that developers usually need to write. with the help of this, i think it can import stored procedure. generate barcode in ssrs <http://www.keepdynamic.com/barcoding/barcode-reporting-service.shtml> -- View this message in context: http://firebird.1100200.n4.nabble.com/Entity-Framework-not-importing-stored-procedures-tp4632625p4636721.html Sent from the firebird-net-provider mailing list archive at Nabble.com. |
|
From: LtColRDSChauhan <rds...@gm...> - 2014-07-13 17:51:12
|
> > 4. Connecting to Firebird 3.0 Alpha 2 (LtColRDSChauhan) > 5. Re: Connecting to Firebird 3.0 Alpha 2 (Mark Rotteveel) > 6. Re: Connecting to Firebird 3.0 Alpha 2 (Norbert Saint Georges) > > > Message: 5 > Date: Mon, 07 Jul 2014 18:06:38 +0200 > From: Mark Rotteveel <ma...@la...> > Subject: Re: [Firebird-net-provider] Connecting to Firebird 3.0 Alpha > 2 > To: "For users and developers of the Firebird .NET providers" > <fir...@li...> > Message-ID: <53B...@la...> > Content-Type: text/plain; charset=ISO-8859-1; format=flowed > > On 7-7-2014 15:43, LtColRDSChauhan wrote: > > Hi, > > > > 1. I attempted to migrate from Firebird 3.0 Alpha 1 to Alpha 2. After > > a backup / restore I'm not able to connect to the database using .NET > > Provider. I've the following updated in the Firebird Config file : > > > > UserManager = Legacy_UserManager > > > > AuthClient = Srp, Win_Sspi, Legacy_Auth > > > > > > 2. FlameRobin connects fine. > > > > 3. Please help. > > When you install Firebird 3 - unless you already enabled legacy > authentication in the installer - you will only have a user account in > the new SRP authentication model. As you edited the firebird.conf later, > you currently do not have a legacy authentication user. > > To fix this, you need to > 1) Edit firebird.conf again and > 1a)set the UserManager to Legacy_UserManager: > > UserManager = Legacy_UserManager > > 1b) Set WireCrypt to Enabled (instead of Required), or even Disabled so > that the server doesn't require encryption > > WireCrypt = Enabled > > 2) Restart Firebird (not 100% sure if necessary) > > 3) Next you need to create another SYSDBA account (using gsec) so it > also exists as a legacy user. I am not 100% sure if you only need to do > "gsec -user sysdba -password masterkey", or that you explicitly need to > do "add sysdba -pw masterke" from the gsec prompt. > > No luck. Still could not connect to Firebird 3.0 Alpha 2. Could though revert back to Alpha 1 successfully. > The reason Flamerobin works is that it uses the Firebird 3 fbclient.dll, > so it automatically supports the new authentication model and encryption. > > Mark > -- > Mark Rotteveel > > > > ------------------------------ > > Message: 6 > Date: Mon, 7 Jul 2014 19:40:14 +0300 > From: "Norbert Saint Georges" <ns...@te...> > Subject: Re: [Firebird-net-provider] Connecting to Firebird 3.0 Alpha > 2 > To: "For users and developers of the Firebird .NET providers" > <fir...@li...> > Message-ID: <666624F4077B9243BF64C0A5B64D49DA189125@sharepoint> > Content-Type: text/plain; charset="utf-8" > > Hi, > > force good client library for Firebird? > eg "customer library = j: \ firebird-3 \ fbclient30.dll;" in the > connection string. > > Tried setting ClientLibrary in the connection string. No luck, again. > > > > > Norbert Saint Georges > > > > TetraSys Oy > > Bergantie 69, FI-02540 Kylm?l? > > Tel. : +358 (0) 400 27 25 18 > > E- mail : ns...@te... <mailto:tar...@te...> > > _____________________________ |
|
From: Mark R. <ma...@la...> - 2014-07-12 20:06:18
|
On 7-7-2014 18:40, Norbert Saint Georges wrote: > Hi, > > forcegood client library for Firebird? > eg "customer library = j: \ firebird-3 \ fbclient30.dll;" in the > connection string. By default the .net provider uses a C# implementation of the wire protocol, not the Firebird client library. Mark -- Mark Rotteveel |
|
From: Norbert S. G. <ns...@te...> - 2014-07-07 16:59:22
|
Hi, force good client library for Firebird? eg "customer library = j: \ firebird-3 \ fbclient30.dll;" in the connection string. Norbert Saint Georges TetraSys Oy Bergantie 69, FI-02540 Kylmälä Tel. : +358 (0) 400 27 25 18 E- mail : ns...@te... <mailto:tar...@te...> De : LtColRDSChauhan [mailto:rds...@gm...] Envoyé : lundi 7 juillet 2014 16:43 À : fir...@li... Objet : [Firebird-net-provider] Connecting to Firebird 3.0 Alpha 2 Hi, 1. I attempted to migrate from Firebird 3.0 Alpha 1 to Alpha 2. After a backup / restore I'm not able to connect to the database using .NET Provider. I've the following updated in the Firebird Config file : UserManager = Legacy_UserManager AuthClient = Srp, Win_Sspi, Legacy_Auth 2. FlameRobin connects fine. 3. Please help. Regards, Lt Col RDS Chauhan |
|
From: Mark R. <ma...@la...> - 2014-07-07 16:06:43
|
On 7-7-2014 15:43, LtColRDSChauhan wrote: > Hi, > > 1. I attempted to migrate from Firebird 3.0 Alpha 1 to Alpha 2. After > a backup / restore I'm not able to connect to the database using .NET > Provider. I've the following updated in the Firebird Config file : > > UserManager = Legacy_UserManager > > AuthClient = Srp, Win_Sspi, Legacy_Auth > > > 2. FlameRobin connects fine. > > 3. Please help. When you install Firebird 3 - unless you already enabled legacy authentication in the installer - you will only have a user account in the new SRP authentication model. As you edited the firebird.conf later, you currently do not have a legacy authentication user. To fix this, you need to 1) Edit firebird.conf again and 1a)set the UserManager to Legacy_UserManager: UserManager = Legacy_UserManager 1b) Set WireCrypt to Enabled (instead of Required), or even Disabled so that the server doesn't require encryption WireCrypt = Enabled 2) Restart Firebird (not 100% sure if necessary) 3) Next you need to create another SYSDBA account (using gsec) so it also exists as a legacy user. I am not 100% sure if you only need to do "gsec -user sysdba -password masterkey", or that you explicitly need to do "add sysdba -pw masterke" from the gsec prompt. The reason Flamerobin works is that it uses the Firebird 3 fbclient.dll, so it automatically supports the new authentication model and encryption. Mark -- Mark Rotteveel |
|
From: LtColRDSChauhan <rds...@gm...> - 2014-07-07 13:43:11
|
Hi, 1. I attempted to migrate from Firebird 3.0 Alpha 1 to Alpha 2. After a backup / restore I'm not able to connect to the database using .NET Provider. I've the following updated in the Firebird Config file : UserManager = Legacy_UserManager AuthClient = Srp, Win_Sspi, Legacy_Auth 2. FlameRobin connects fine. 3. Please help. Regards, Lt Col RDS Chauhan |
|
From: Mark R. <ma...@la...> - 2014-07-06 08:28:39
|
On 6-7-2014 01:14, ma...@la... wrote: > Your parameter is DECIMAL(18,2). If you want scale 2, specify that. That should of course have read "If you want scale 4, specify that". Mark -- Mark Rotteveel |
|
From: <ma...@la...> - 2014-07-05 23:15:06
|
Your parameter is DECIMAL(18,2). If you want scale 2, specify that.
Mark
----- Reply message -----
Van: "Muthu Annamalai" <pea...@ho...>
Aan: <fir...@li...>
Onderwerp: [Firebird-net-provider] Scale Precision 4 Truncates to 2 in Database
Datum: zo, jul. 6, 2014 00:46
Hi,
I am using Provider 4.2.0.0 and EF 6.0.0.0 in VS 2012.
When I update a value with 4 digit precision as 1.9999, the value in
database is saved as 1.99. The last 2 digits got truncated.
I really want 4 digit precision. Any help is appreciated.
In database table the field is set to a domain, which is
CREATE DOMAIN DECIMAL4 AS
NUMERIC(15,4)
DEFAULT 0
NOT NULL;
On submit changes from Visual Studio , the output from the provider is
FirebirdSql.Data.FirebirdClient Information: 0 : Command:
EXECUTE BLOCK (
p0 DECIMAL(18,2) = @p0, p1 INT = @p1
) RETURNS (
"DESCRIPTION" BLOB SUB_TYPE TEXT)
AS BEGIN
UPDATE "ITEMSTYLE"
SET "PRICE" = :p0
WHERE ("ID" = :p1)
RETURNING "DESCRIPTION" INTO :"DESCRIPTION";
SUSPEND;
END
Parameters:
Name:@p0 Type:Decimal Used Value:1.9999
Name:@p1 Type:Integer Used Value:19191
Thanks,
Annam
------------------------------------------------------------------------------
Open source business process management suite built on Java and Eclipse
Turn processes into business applications with Bonita BPM Community Edition
Quickly connect people, data, and systems into organized workflows
Winner of BOSSIE, CODIE, OW2 and Gartner awards
http://p.sf.net/sfu/Bonitasoft
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
|
From: Muthu A. <pea...@ho...> - 2014-07-05 22:46:14
|
Hi,
I am using Provider 4.2.0.0 and EF 6.0.0.0 in VS 2012.
When I update a value with 4 digit precision as 1.9999, the value in
database is saved as 1.99. The last 2 digits got truncated.
I really want 4 digit precision. Any help is appreciated.
In database table the field is set to a domain, which is
CREATE DOMAIN DECIMAL4 AS
NUMERIC(15,4)
DEFAULT 0
NOT NULL;
On submit changes from Visual Studio , the output from the provider is
FirebirdSql.Data.FirebirdClient Information: 0 : Command:
EXECUTE BLOCK (
p0 DECIMAL(18,2) = @p0, p1 INT = @p1
) RETURNS (
"DESCRIPTION" BLOB SUB_TYPE TEXT)
AS BEGIN
UPDATE "ITEMSTYLE"
SET "PRICE" = :p0
WHERE ("ID" = :p1)
RETURNING "DESCRIPTION" INTO :"DESCRIPTION";
SUSPEND;
END
Parameters:
Name:@p0 Type:Decimal Used Value:1.9999
Name:@p1 Type:Integer Used Value:19191
Thanks,
Annam
|
|
From: Andrew (JIRA) <tr...@fi...> - 2014-07-03 06:18:53
|
FbCommand with CommandTest containing "EXECUTE BLOCK" will not excpet input FbParamaters
----------------------------------------------------------------------------------------
Key: DNET-558
URL: http://tracker.firebirdsql.org/browse/DNET-558
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 4.2.0.0
Environment: VS2013 .NET 4.0
Reporter: Andrew
Assignee: Jiri Cincura
When using a FbCommand object to execute a command which contains one or more FbParamters causes a FirebirdSql.Data.Common.IscException.
Below is details of how to reproduce as well as a fix.
Can someone please check that this problem is in fact a real problem (i.e. perhaps there is a way to already do this). IF it is a bug, is the fixed code blow (towards end of this post) OK.
Exception details:
FirebirdSql.Data.Common.IscException occurred
_HResult=-2146233088
HResult=-2146233088
IsTransient=false
Message=Dynamic SQL Error
SQL error code = -104
Token unknown - line 2, column 35
Steps to reproduce:
1) Create a table to hold the example data:
CREATE TABLE ADDRESS (ADDRESSID INTEGER NOT NULL, STREET VARCHAR(50), LAST_MOD DATE);
2) Executing the following via a FbCommand object. Note that work as expected.
EXECUTE BLOCK AS
DECLARE VARIABLE ADDRESSID INT = 8;
DECLARE VARIABLE STREET VARCHAR(50) = 'Fred';
DECLARE VARIABLE LAST_MOD DATE = '2014-07-03 13:37:59';
BEGIN
IF (EXISTS(SELECT ADDRESSID FROM ADDRESS WHERE ADDRESSID = :ADDRESSID)) THEN
UPDATE ADDRESS SET STREET = :STREET, LAST_MOD = :LAST_MOD WHERE ADDRESSID = :ADDRESSID AND LAST_MOD < :LAST_MOD;
ELSE
INSERT INTO ADDRESS(ADDRESSID, STREET, LAST_MOD) VALUES(:ADDRESSID, :STREET, :LAST_MOD);
END;
3) Executing the following via a FbCommand object and use FbParamters to pass in variables.
EXECUTE BLOCK AS
DECLARE VARIABLE ADDRESSID INT = @X;
DECLARE VARIABLE STREET VARCHAR(50) = @Y;
DECLARE VARIABLE LAST_MOD DATE = @Z;
BEGIN
IF (EXISTS(SELECT ADDRESSID FROM ADDRESS WHERE ADDRESSID = :ADDRESSID)) THEN
UPDATE ADDRESS SET STREET = :STREET, LAST_MOD = :LAST_MOD WHERE ADDRESSID = :ADDRESSID AND LAST_MOD < :LAST_MOD;
ELSE
INSERT INTO ADDRESS(ADDRESSID, STREET, LAST_MOD) VALUES(:ADDRESSID, :STREET, :LAST_MOD);
END;
C# Code below is a working example of the bug.
string connectionString = "[Insert valid connection strign here]";
connection = new FbConnection(connectionString);
connection.Open();
string sql = "EXECUTE BLOCK AS\r\n " +
"DECLARE VARIABLE ADDRESSID INT = @X;\r\n" +
"DECLARE VARIABLE STREET VARCHAR(50) = @Y;\r\n" +
"DECLARE VARIABLE LAST_MOD DATE = @Z;\r\n" +
"BEGIN\r\n" +
" IF (EXISTS(SELECT ADDRESSID FROM ADDRESS WHERE ADDRESSID = :ADDRESSID)) THEN\r\n" +
" UPDATE ADDRESS SET STREET = :STREET, LAST_MOD = :LAST_MOD WHERE ADDRESSID = :ADDRESSID AND LAST_MOD < :LAST_MOD;\r\n" +
" ELSE\r\n" +
" INSERT INTO ADDRESS(ADDRESSID, STREET, LAST_MOD) VALUES(:ADDRESSID, :STREET, :LAST_MOD);\r\n" +
"END;";
FbCommand fbCommand = new FbCommand(sql, connection);
FbParameter fbParameter = new FbParameter("@X", FbDbType.Integer);
fbParameter.Value = 5;
fbCommand.Parameters.Add(fbParameter);
fbParameter = new FbParameter("@Y", FbDbType.VarChar);
fbParameter.Size = 50;
fbParameter.Value = "Fred";
fbCommand.Parameters.Add(fbParameter);
fbParameter = new FbParameter("@Z", FbDbType.Date);
fbParameter.Value = DateTime.Now;
fbCommand.Parameters.Add(fbParameter);
fbCommand.ExecuteNonQuery();
4) The below is a fix. Can someone please check that it is OK?
Edit the following source file: $\NETProvider\source\FirebirdSql\Data\FirebirdClient\FbCommand.cs
See if block following comments "Work around for "EXECUTE BLOCK" with FbParameters."
private void Prepare(bool returnsSet)
{
LogCommand();
FbConnectionInternal innerConn = this.connection.InnerConnection;
// Check if we have a valid transaction
if (this.transaction == null)
{
if (innerConn.IsEnlisted)
{
this.transaction = innerConn.ActiveTransaction;
}
else
{
this.implicitTransaction = true;
this.transaction = new FbTransaction(this.connection, this.connection.ConnectionOptions.IsolationLevel);
this.transaction.BeginTransaction();
// Update Statement transaction
if (this.statement != null)
{
this.statement.Transaction = this.transaction.Transaction;
}
}
}
// Check if we have a valid statement handle
if (this.statement == null)
{
this.statement = innerConn.Database.CreateStatement(this.transaction.Transaction);
}
// Prepare the statement if needed
if (!this.statement.IsPrepared)
{
// Close the inner DataReader if needed
this.CloseReader();
// Reformat the SQL statement if needed
string sql = this.commandText;
if (this.commandType == CommandType.StoredProcedure)
{
sql = this.BuildStoredProcedureSql(sql, returnsSet);
}
try
{
//Work around for "EXECUTE BLOCK" with FbParameters.
if (sql.ToUpper().StartsWith("EXECUTE BLOCK") && sql.ToUpper().Contains("DECLARE VARIABLE") && this.parameters.Count > 0)
{
sql = this.SubstituteParameters(sql);
}
// Try to prepare the command
this.statement.Prepare(this.ParseNamedParameters(sql));
}
catch
{
// Release the statement and rethrow the exception
this.statement.Release();
this.statement = null;
throw;
}
// Add this command to the active command list
innerConn.AddPreparedCommand(this);
}
else
{
// Close statement for subsequently executions
this.Close();
}
}
New code...
private string SubstituteParameters(string sql)
{
string sqlCommand = sql;
for (int i = 0; i < this.parameters.Count; i++)
{
FbParameter fbParameter = this.parameters[i];
if (fbParameter.Value == null)
{
sqlCommand = sqlCommand.Replace(fbParameter.ParameterName, "NULL");
}
else
{
switch (fbParameter.FbDbType)
{
case FbDbType.BigInt:
long longValue = (long)fbParameter.Value;
sqlCommand = sqlCommand.Replace(fbParameter.ParameterName, longValue.ToString());
break;
case FbDbType.Boolean:
bool boolValue = (bool)fbParameter.Value;
string boolStringValue = "0";
if (boolValue)
{
boolStringValue = "1";
}
sqlCommand = sqlCommand.Replace(fbParameter.ParameterName, boolStringValue);
break;
case FbDbType.Char:
case FbDbType.Text:
case FbDbType.VarChar:
string strValue = (string)fbParameter.Value;
sqlCommand = sqlCommand.Replace(fbParameter.ParameterName, "'" + strValue.Replace("'", "''") + "'");
break;
case FbDbType.Date:
case FbDbType.Time:
case FbDbType.TimeStamp:
DateTime dateValue = (DateTime)fbParameter.Value;
sqlCommand = sqlCommand.Replace(fbParameter.ParameterName, "'" + dateValue.ToString("yyyy-MM-dd HH:mm:ss") + "'");
break;
case FbDbType.Decimal:
decimal decValue = (decimal)fbParameter.Value;
sqlCommand = sqlCommand.Replace(fbParameter.ParameterName, decValue.ToString());
break;
case FbDbType.Double:
double dblValue = (double)fbParameter.Value;
sqlCommand = sqlCommand.Replace(fbParameter.ParameterName, dblValue.ToString());
break;
case FbDbType.Float:
float floatValue = (float)fbParameter.Value;
sqlCommand = sqlCommand.Replace(fbParameter.ParameterName, floatValue.ToString());
break;
case FbDbType.Guid:
Guid guid = (Guid)fbParameter.Value;
string guidString = "CHAR_TO_UUID('" + guid.ToString() + "')";
sqlCommand = sqlCommand.Replace(fbParameter.ParameterName, guidString.ToString());
break;
case FbDbType.Integer:
int intValue = (int)fbParameter.Value;
sqlCommand = sqlCommand.Replace(fbParameter.ParameterName, intValue.ToString());
break;
case FbDbType.Numeric:
double numValue = (double)fbParameter.Value;
sqlCommand = sqlCommand.Replace(fbParameter.ParameterName, numValue.ToString());
break;
case FbDbType.SmallInt:
short shtValue = (short)fbParameter.Value;
sqlCommand = sqlCommand.Replace(fbParameter.ParameterName, shtValue.ToString());
break;
default:
throw new NotImplementedException("Parameter of " + fbParameter.FbDbType.ToString("G") + " not implemented in 'EXECUTE BLOCK' commands.");
}
}
}
return sqlCommand;
}
--
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
|
|
From: Scott M. <bl...@bl...> - 2014-06-30 10:07:49
|
On 27/06/14 17:27, Mark Rotteveel wrote: > On 27-6-2014 18:09, Scott Morgan wrote: >> Trying to drop a DB opened with the embedded system, but something seems >> to be holding the file open after the connection is closed. > > The .net provider has a connection pool, so the physical connection is > still open. You need to flush the pool, or disable connection pooling. > > You can flush the pool with: > FbConnection.ClearAllPools(); That did the job, thanks. (Had a feeling it was pooling, but completely missed that function) Scott |
|
From: Mark R. <ma...@la...> - 2014-06-27 16:27:11
|
On 27-6-2014 18:09, Scott Morgan wrote:
> Trying to drop a DB opened with the embedded system, but something seems
> to be holding the file open after the connection is closed.
>
> Test case from a console app:
>
> Console.WriteLine("Attempting to open DB...");
> var conn = new FbConnection();
> conn.ConnectionString = myConnectionString;
> conn.Open();
>
> Console.WriteLine("Attempting to close DB...");
> conn.Close();
>
> conn = null;
> GC.Collect(); // Getting desperate here
>
> Console.WriteLine("Attempting to delete DB...");
> FbConnection.DropDatabase(ConnectionString);
> // File.Delete(DBPath); // doesn't work either
The .net provider has a connection pool, so the physical connection is
still open. You need to flush the pool, or disable connection pooling.
You can flush the pool with:
FbConnection.ClearAllPools();
and disable connection pooling by setting Pooling=false in the
connection string.
Mark
--
Mark Rotteveel
|
|
From: Scott M. <bl...@bl...> - 2014-06-27 16:09:14
|
Trying to drop a DB opened with the embedded system, but something seems
to be holding the file open after the connection is closed.
Test case from a console app:
Console.WriteLine("Attempting to open DB...");
var conn = new FbConnection();
conn.ConnectionString = myConnectionString;
conn.Open();
Console.WriteLine("Attempting to close DB...");
conn.Close();
conn = null;
GC.Collect(); // Getting desperate here
Console.WriteLine("Attempting to delete DB...");
FbConnection.DropDatabase(ConnectionString);
// File.Delete(DBPath); // doesn't work either
Scott
|
|
From: Scott M. <bl...@bl...> - 2014-06-25 14:19:36
|
On 25/06/14 14:50, Jiri Cincura wrote: > You need to use Verbose = true. :\ Ah yes, it throws a relevant exception now. Thanks. Scott |
|
From: Jiri C. <di...@ci...> - 2014-06-25 13:50:54
|
You need to use Verbose = true. :\
--
Jiri {x2} Cincura
http://blog.cincura.net/ | http://www.ID3renamer.com
|
211 messages has been excluded from this view by a project administrator.
