from:"Ralf Jansen"

Re: [Firebird-net-provider] About GUIDs in Firebird

2017-01-10 Thread Ralf Jansen

I may have missed the point or I'm not aware of all the details here but trying 
to use a GUID in its string representation is a failure by itself. 
I see no benefit in making something work that isn't advisable in the first 
place. Like trying to move a datetime as string to the db and hoping it get 
interpreted correctly. 

Is there a case where this is needed because doing it right (using a Guid as 
its type and not as string) and use parameters isn't possible? 

-Ursprüngliche Nachricht-
Von: Jiří Činčura [mailto:j...@cincura.net] 
Gesendet: Dienstag, 10. Januar 2017 15:20
An: For users & developers of the Firebird .NET providers 

Betreff: [Firebird-net-provider] About GUIDs in Firebird

Hi *,

we have this ticket DNET-509 in tracker. Although I agree the change would be 
nice, it's also a breaking change as huge as it can get. What's your take on 
it? Or do you see clean way out?

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

--
Developer Access Program for Intel Xeon Phi Processors Access to Intel Xeon Phi 
processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi 
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
--
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] [FB-Tracker] Created: (DNET-705) FBStatistical does not like pathes to database with non ascii characters in it

2016-10-05 Thread Ralf Jansen (JIRA)

FBStatistical  does not like pathes to database with non ascii characters in it
---

 Key: DNET-705
 URL: http://tracker.firebirdsql.org/browse/DNET-705
 Project: .NET Data provider
  Issue Type: Bug
  Components: ADO.NET Provider
Affects Versions: 5.0.5.0
 Environment: Windows 10 (de locale), Visual Studio 2015, Firebird 
Embedded 2.5.6 and 3.0.1
Reporter: Ralf Jansen
Assignee: Jiri Cincura


Trying to use FBStatistical against a database residing in a path with 
non-ascii characters (like german umlauts) fails with a Exception that the 
database can't be opened

Sample  

   FbStatistical stat = new FbStatistical();
   stat.ConnectionString = "server type=Embedded;character set=UTF8;initial 
catalog=C:\MyLovelyFolder\aö\database.fdb;user 
id=SYSDBA;password=masterkey;pooling=False;client 
library=C:\Firebird_x64\fbembed.dll"
   stat.Options = FbStatisticalFlags.HeaderPages;
   try
   {
   stat.Execute();
   }
   catch (FbException ex)
   {
   
   }

will result in an "Can't open database file 
C:\\MYLOVELYFOLDER\\Aö\\DATABASE.FDB" with ErrorCode 336920605 Exception.
Interesting sidenote the internal uppercasing ignored the ö umlaut.




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

   

--
Check out the vibrant tech community on one of the world's most 
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Error code 335544332 invalid transaction handle (expecting explicit transaction start)

2016-08-04 Thread Ralf Jansen

Tried the snapshot and can't reproduce the problem currently. I presumably 
misinterpreted the tracker info's.
 
-Ursprüngliche Nachricht-
Von: Ralf Jansen [mailto:ralf.jan...@mailstore.com] 
Gesendet: Donnerstag, 4. August 2016 14:55
An: For users and developers of the Firebird .NET providers 
<firebird-net-provider@lists.sourceforge.net>
Betreff: Re: [Firebird-net-provider] Error code 335544332 invalid transaction 
handle (expecting explicit transaction start)

Thanks Thomas,

>From where to get that? The snapshot build on firebirdsql.org is older than 
>the tracker case. So the fix is presumably not in there.
I could get the master from Github but the recent commit history doesn't look 
like CORE-5307 has been fixed (at least it's not stated directly).


-Ursprüngliche Nachricht-
Von: Thomas Steinmaurer [mailto:t...@iblogmanager.com]
Gesendet: Donnerstag, 4. August 2016 14:15
An: For users and developers of the Firebird .NET providers 
<firebird-net-provider@lists.sourceforge.net>
Betreff: Re: [Firebird-net-provider] Error code 335544332 invalid transaction 
handle (expecting explicit transaction start)

On 04.08.2016 14:13, Thomas Steinmaurer wrote:
> Ralf,
>
>> I recently switched from an older provider version (2.x something) to 
>> the current 5.0.5.0 build and use it in an embedded scenario.
>>
>> In that process I also switched from FB 2.5 to 3.0
>>
>>
>>
>> I have stability problems when the system gets under heavy load with 
>> concurrent transactions/connections.
>>
>> I receive 335544332 errors (invalid transaction handle) from random 
>> locations.
>>
>>
>>
>> Any pointers at what to look?
>
> Quoting Dmitry Yemanov in firebird-support on July 12, 2016:
>
> "This appears to be a bug in Firebird 3, being researched right now. I 
> hope to have the fix committed in a day or two."

Found the CORE issue now:
http://tracker.firebirdsql.org/browse/CORE-5307

Marked as fixed, thus give a recent 3.0 snapshot a try.



--
With regards,
Thomas Steinmaurer
http://www.upscene.com/

Professional Tools and Services for Firebird FB TraceManager, IB LogManager, 
Database Health Check, Tuning etc.

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

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

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

Re: [Firebird-net-provider] Error code 335544332 invalid transaction handle (expecting explicit transaction start)

2016-08-04 Thread Ralf Jansen

Thanks Thomas,

>From where to get that? The snapshot build on firebirdsql.org is older than 
>the tracker case. So the fix is presumably not in there.
I could get the master from Github but the recent commit history doesn't look 
like CORE-5307 has been fixed (at least it's not stated directly).


-Ursprüngliche Nachricht-
Von: Thomas Steinmaurer [mailto:t...@iblogmanager.com] 
Gesendet: Donnerstag, 4. August 2016 14:15
An: For users and developers of the Firebird .NET providers 

Betreff: Re: [Firebird-net-provider] Error code 335544332 invalid transaction 
handle (expecting explicit transaction start)

On 04.08.2016 14:13, Thomas Steinmaurer wrote:
> Ralf,
>
>> I recently switched from an older provider version (2.x something)  
>> to the current 5.0.5.0 build and use it in an embedded scenario.
>>
>> In that process I also switched from FB 2.5 to 3.0
>>
>>
>>
>> I have stability problems when the system gets under heavy load with 
>> concurrent transactions/connections.
>>
>> I receive 335544332 errors (invalid transaction handle) from random 
>> locations.
>>
>>
>>
>> Any pointers at what to look?
>
> Quoting Dmitry Yemanov in firebird-support on July 12, 2016:
>
> "This appears to be a bug in Firebird 3, being researched right now. I 
> hope to have the fix committed in a day or two."

Found the CORE issue now:
http://tracker.firebirdsql.org/browse/CORE-5307

Marked as fixed, thus give a recent 3.0 snapshot a try.



--
With regards,
Thomas Steinmaurer
http://www.upscene.com/

Professional Tools and Services for Firebird FB TraceManager, IB LogManager, 
Database Health Check, Tuning etc.

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

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

[Firebird-net-provider] Error code 335544332 invalid transaction handle (expecting explicit transaction start)

2016-08-04 Thread Ralf Jansen

I recently switched from an older provider version (2.x something)  to the 
current 5.0.5.0 build and use it in an embedded scenario.
In that process I also switched from FB 2.5 to 3.0

I have stability problems when the system gets under heavy load with concurrent 
transactions/connections.
I receive 335544332 errors (invalid transaction handle) from random locations.

Any pointers at what to look?

Typical stacks look like

FirebirdSql.Data.Common.IscException: invalid transaction handle (expecting 
explicit transaction start)
   at FirebirdSql.Data.Client.Native.FesDatabase.ProcessStatusVector(IntPtr[] 
statusVector)
   at FirebirdSql.Data.Client.Native.FesStatement.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.ExecuteScalar()

or

FirebirdSql.Data.Common.IscException: invalid transaction handle (expecting 
explicit transaction start)
   at FirebirdSql.Data.Client.Native.FesDatabase.ProcessStatusVector(IntPtr[] 
statusVector)
   at FirebirdSql.Data.Client.Native.FesTransaction.Commit()
   at FirebirdSql.Data.FirebirdClient.FbTransaction.Commit()

or

FirebirdSql.Data.Common.IscException: invalid transaction handle (expecting 
explicit transaction start)
   at FirebirdSql.Data.Client.Native.FesDatabase.ProcessStatusVector(IntPtr[] 
statusVector)
   at FirebirdSql.Data.Client.Native.FesStatement.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.ExecuteScalar()



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

Re: [Firebird-net-provider] Zlib library

2016-08-02 Thread Ralf Jansen

I would still like to see a shim and as one default implementation you could 
use SharpZibLib.

Von: Jiří Činčura [mailto:j...@cincura.net]
Gesendet: Freitag, 29. Juli 2016 15:05
An: firebird-net-provider@lists.sourceforge.net
Betreff: Re: [Firebird-net-provider] Zlib library

Umm, yeah. Massive 9 votes.
[cid:image001.png@01D1ECB0.CF4E27E0]

Looks like SharpZipLib it is. I checked right now and it's using MIT license 
now, which should allow to take a piece of code and use.

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

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

Re: [Firebird-net-provider] using fb 2.5 and 3.0 embedded concurrently

2016-07-11 Thread Ralf Jansen

I changed my backup/restore routine and used gbak instead of the FBRestore 
class. That helps no more shutdowns now.
There seems to be something wrong with FBRestore. Calling the class is pretty 
straight. So I don't see a ~usage~ error of that class.

FbRestore restore = new FbRestore();
restore.BackupFiles.Add(new FbBackupFile(fromPath));
restore.ConnectionString = connectionString; 
restore.Options = FbRestoreFlags.Create;
restore.PageSize = 4096;
restore.Verbose = true;
restore.ServiceOutput += delegate(object sender, ServiceOutputEventArgs e) { 
callback(e.Message); };
restore.Execute();




-Ursprüngliche Nachricht-
Von: Ralf Jansen [mailto:ralf.jan...@mailstore.com] 
Gesendet: Donnerstag, 7. Juli 2016 18:19
An: For users and developers of the Firebird .NET providers 
<firebird-net-provider@lists.sourceforge.net>
Betreff: Re: [Firebird-net-provider] using fb 2.5 and 3.0 embedded concurrently

Checked. No dangling connections in the transaction pool after backup restore. 
Then when the ~connection shutdown~ error state is reached only 3.0 connections 
are in the pool.

If i wasn't clear I can't create any connection in that state. Not even create 
a new Database and connect to that. Any connection will throw a ~connection 
shutdown~ Exception after that state is reached.
It is not dependent to a certain database. Feels more like the hole embedded 
Firebird client is in a shutdown state then :(


-Ursprüngliche Nachricht-
Von: Ralf Jansen [mailto:ralf.jan...@mailstore.com]
Gesendet: Donnerstag, 7. Juli 2016 17:42
An: For users and developers of the Firebird .NET providers 
<firebird-net-provider@lists.sourceforge.net>
Betreff: Re: [Firebird-net-provider] using fb 2.5 and 3.0 embedded concurrently

I call FbConnection.ClearPool before backup. So there shouldn't be any 2.5 
connections to that database still hanging around. 
The backup restore I do is inplace. I have replaced the fdb database in its 
original location (2.5 before a 3.0 version afterwards). I assume if I had 
2.5er connections still in the pool that won't be allowed since there would be 
open handles to the database and I couldn't replace the file then? 

I will check if clearing the pool when I'm running into the ~ connection 
shutdown~ error state helps. But I doubt that this problem has something to do 
with the connection pool.


-Ursprüngliche Nachricht-
Von: Jiří Činčura [mailto:j...@cincura.net]
Gesendet: Donnerstag, 7. Juli 2016 17:31
An: firebird-net-provider@lists.sourceforge.net
Betreff: Re: [Firebird-net-provider] using fb 2.5 and 3.0 embedded concurrently

> To get that fixed I need to
> restart the process.

Are you sure. Isn't just cleaning the pool for that connection enough?

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

--
Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San 
Francisco, CA to explore cutting-edge tech and listen to tech luminaries 
present their vision of the future. This family event has something for 
everyone, including kids. Get more information and register today.
http://sdm.link/attshape
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
--
Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San 
Francisco, CA to explore cutting-edge tech and listen to tech luminaries 
present their vision of the future. This family event has something for 
everyone, including kids. Get more information and register today.
http://sdm.link/attshape
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
--
Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San 
Francisco, CA to explore cutting-edge tech and listen to tech luminaries 
present their vision of the future. This family event has something for 
everyone, including kids. Get more information and register today.
http://sdm.link/attshape
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
--
Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San
Francisco, CA to explore cutting-edge tech and listen to tech luminaries
present their vision of the future. This family event has something for
everyone, including kids. Get more information and register today.
http://sdm.link/attshape
___
Firebird-net-pro

Re: [Firebird-net-provider] using fb 2.5 and 3.0 embedded concurrently

2016-07-07 Thread Ralf Jansen

Checked. No dangling connections in the transaction pool after backup restore. 
Then when the ~connection shutdown~ error state is reached only 3.0 connections 
are in the pool.

If i wasn't clear I can't create any connection in that state. Not even create 
a new Database and connect to that. Any connection will throw a ~connection 
shutdown~ Exception after that state is reached.
It is not dependent to a certain database. Feels more like the hole embedded 
Firebird client is in a shutdown state then :(


-Ursprüngliche Nachricht-
Von: Ralf Jansen [mailto:ralf.jan...@mailstore.com] 
Gesendet: Donnerstag, 7. Juli 2016 17:42
An: For users and developers of the Firebird .NET providers 
<firebird-net-provider@lists.sourceforge.net>
Betreff: Re: [Firebird-net-provider] using fb 2.5 and 3.0 embedded concurrently

I call FbConnection.ClearPool before backup. So there shouldn't be any 2.5 
connections to that database still hanging around. 
The backup restore I do is inplace. I have replaced the fdb database in its 
original location (2.5 before a 3.0 version afterwards). I assume if I had 
2.5er connections still in the pool that won't be allowed since there would be 
open handles to the database and I couldn't replace the file then? 

I will check if clearing the pool when I'm running into the ~ connection 
shutdown~ error state helps. But I doubt that this problem has something to do 
with the connection pool.


-Ursprüngliche Nachricht-
Von: Jiří Činčura [mailto:j...@cincura.net]
Gesendet: Donnerstag, 7. Juli 2016 17:31
An: firebird-net-provider@lists.sourceforge.net
Betreff: Re: [Firebird-net-provider] using fb 2.5 and 3.0 embedded concurrently

> To get that fixed I need to
> restart the process.

Are you sure. Isn't just cleaning the pool for that connection enough?

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

--
Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San 
Francisco, CA to explore cutting-edge tech and listen to tech luminaries 
present their vision of the future. This family event has something for 
everyone, including kids. Get more information and register today.
http://sdm.link/attshape
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
--
Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San 
Francisco, CA to explore cutting-edge tech and listen to tech luminaries 
present their vision of the future. This family event has something for 
everyone, including kids. Get more information and register today.
http://sdm.link/attshape
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
--
Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San
Francisco, CA to explore cutting-edge tech and listen to tech luminaries
present their vision of the future. This family event has something for
everyone, including kids. Get more information and register today.
http://sdm.link/attshape
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] using fb 2.5 and 3.0 embedded concurrently

2016-07-07 Thread Ralf Jansen

I call FbConnection.ClearPool before backup. So there shouldn't be any 2.5 
connections to that database still hanging around. 
The backup restore I do is inplace. I have replaced the fdb database in its 
original location (2.5 before a 3.0 version afterwards). I assume if I had 
2.5er connections still in the pool that won't be allowed since there would be 
open handles to the database and I couldn't replace the file then? 

I will check if clearing the pool when I'm running into the ~ connection 
shutdown~ error state helps. But I doubt that this problem has something to do 
with the connection pool.


-Ursprüngliche Nachricht-
Von: Jiří Činčura [mailto:j...@cincura.net] 
Gesendet: Donnerstag, 7. Juli 2016 17:31
An: firebird-net-provider@lists.sourceforge.net
Betreff: Re: [Firebird-net-provider] using fb 2.5 and 3.0 embedded concurrently

> To get that fixed I need to
> restart the process.

Are you sure. Isn't just cleaning the pool for that connection enough?

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

--
Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San 
Francisco, CA to explore cutting-edge tech and listen to tech luminaries 
present their vision of the future. This family event has something for 
everyone, including kids. Get more information and register today.
http://sdm.link/attshape
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
--
Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San
Francisco, CA to explore cutting-edge tech and listen to tech luminaries
present their vision of the future. This family event has something for
everyone, including kids. Get more information and register today.
http://sdm.link/attshape
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] using fb 2.5 and 3.0 embedded concurrently

2016-07-07 Thread Ralf Jansen

Hi,

it looked good at first. But I have a problem when upgrading a database from 
2.5 to 3.0 in the process. 
Means I first open the database with the 2.5 client then do a backup/restore 
cycle via the FbBackup/FBRestore classes (Backup with the 2.5 fbembed.dll in 
the connectionstring, restore with the 3.0 fbembed.dll).

I can then use the database for, looks like, 60 seconds. After that I get an 
IscException (connection shutdown, error code 335544528) for any 3.0 database 
currently used in that process. To get that fixed I need to restart the process.
Anything in the provider or firebird itself with a 60 seconds timing?


-Ursprüngliche Nachricht-
Von: Ralf Jansen [mailto:ralf.jan...@mailstore.com] 
Gesendet: Mittwoch, 22. Juni 2016 12:36
An: For users and developers of the Firebird .NET providers 
<firebird-net-provider@lists.sourceforge.net>
Betreff: Re: [Firebird-net-provider] using fb 2.5 and 3.0 embedded concurrently

Seems to work in a short test. 
I will go that route further and see if there are some major stumbling blocks 
in the way (the provider's connection pooling for example).

-Original Message-
From: Jiří Činčura [mailto:j...@cincura.net]
Sent: Mittwoch, 22. Juni 2016 11:12
To: firebird-net-provider@lists.sourceforge.net
Subject: Re: [Firebird-net-provider] using fb 2.5 and 3.0 embedded concurrently

> Should that work? Can both libraries coexist? Can the Net. Provider 
> cope with that scenario?

I think yes. Just use the ClientLibrary and point it to correct DLLs. 

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

--
Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San 
Francisco, CA to explore cutting-edge tech and listen to tech luminaries 
present their vision of the future. This family event has something for 
everyone, including kids. Get more information and register today.
http://sdm.link/attshape
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
--
Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San 
Francisco, CA to explore cutting-edge tech and listen to tech luminaries 
present their vision of the future. This family event has something for 
everyone, including kids. Get more information and register today.
http://sdm.link/attshape
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
--
Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San
Francisco, CA to explore cutting-edge tech and listen to tech luminaries
present their vision of the future. This family event has something for
everyone, including kids. Get more information and register today.
http://sdm.link/attshape
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] [FB-Tracker] Created: (DNET-688) FBScript thinks that a comment at the end of a script file is a valid command

2016-07-07 Thread Ralf Jansen (JIRA)

FBScript thinks that a comment at the end of a script file is a valid command
-

 Key: DNET-688
 URL: http://tracker.firebirdsql.org/browse/DNET-688
 Project: .NET Data provider
  Issue Type: Bug
  Components: ADO.NET Provider
Affects Versions: 5.0.5.0
 Environment: Win8.1, VS2015, Net 4.5.1,  Firebird Provider build from 
source not taken from nuget
Reporter: Ralf Jansen
Assignee: Jiri Cincura


Example Script:

/* Pre comment */
UPDATE TABLE SET Field= 'HelloWorld' WHERE Id = 1;
/*Post comment */

In this case FbScript.Parse() will try to parse the post comment as command and 
throws a ""The type of the SQL statement could not be determined..." 
ArgumentException.

Workaround : Don't have a comment at the end of a script.




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



--
Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San
Francisco, CA to explore cutting-edge tech and listen to tech luminaries
present their vision of the future. This family event has something for
everyone, including kids. Get more information and register today.
http://sdm.link/attshape
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] using fb 2.5 and 3.0 embedded concurrently

2016-06-22 Thread Ralf Jansen

Seems to work in a short test. 
I will go that route further and see if there are some major stumbling blocks 
in the way (the provider's connection pooling for example).

-Original Message-
From: Jiří Činčura [mailto:j...@cincura.net] 
Sent: Mittwoch, 22. Juni 2016 11:12
To: firebird-net-provider@lists.sourceforge.net
Subject: Re: [Firebird-net-provider] using fb 2.5 and 3.0 embedded concurrently

> Should that work? Can both libraries coexist? Can the Net. Provider 
> cope with that scenario?

I think yes. Just use the ClientLibrary and point it to correct DLLs. 

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

--
Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San 
Francisco, CA to explore cutting-edge tech and listen to tech luminaries 
present their vision of the future. This family event has something for 
everyone, including kids. Get more information and register today.
http://sdm.link/attshape
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
--
Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San
Francisco, CA to explore cutting-edge tech and listen to tech luminaries
present their vision of the future. This family event has something for
everyone, including kids. Get more information and register today.
http://sdm.link/attshape
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] using fb 2.5 and 3.0 embedded concurrently

2016-06-22 Thread Ralf Jansen

Hi,

I'm in the process of migrating a large .Net application that is using firebird 
embedded 2.5 to 3.0. To get a smooth transition with a minimum of user hassle 
and downtime it would be helpful to have both client libraries (2.5 and 3.0) 
used concurrently in the same process.
There are presumably dozens of databases used by the process and I would like 
to migrate them one by one while the other databases keep running either via 
the 2.5 client or the 3.0 client library.

Should that work? Can both libraries coexist? Can the Net. Provider cope with 
that scenario?

--
Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San
Francisco, CA to explore cutting-edge tech and listen to tech luminaries
present their vision of the future. This family event has something for
everyone, including kids. Get more information and register today.
http://sdm.link/attshape___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] About GUIDs in Firebird

[Firebird-net-provider] [FB-Tracker] Created: (DNET-705) FBStatistical does not like pathes to database with non ascii characters in it

Re: [Firebird-net-provider] Error code 335544332 invalid transaction handle (expecting explicit transaction start)

Re: [Firebird-net-provider] Error code 335544332 invalid transaction handle (expecting explicit transaction start)

[Firebird-net-provider] Error code 335544332 invalid transaction handle (expecting explicit transaction start)

Re: [Firebird-net-provider] Zlib library

Re: [Firebird-net-provider] using fb 2.5 and 3.0 embedded concurrently

Re: [Firebird-net-provider] using fb 2.5 and 3.0 embedded concurrently

Re: [Firebird-net-provider] using fb 2.5 and 3.0 embedded concurrently

Re: [Firebird-net-provider] using fb 2.5 and 3.0 embedded concurrently

[Firebird-net-provider] [FB-Tracker] Created: (DNET-688) FBScript thinks that a comment at the end of a script file is a valid command

Re: [Firebird-net-provider] using fb 2.5 and 3.0 embedded concurrently

[Firebird-net-provider] using fb 2.5 and 3.0 embedded concurrently

13 matches

Site Navigation

Mail list logo

Footer information