firebird-net-provider Mailing List for Firebird

System.StackOverflowException was unhandled
-------------------------------------------

                 Key: DNET-749
                 URL: http://tracker.firebirdsql.org/browse/DNET-749
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 5.8.0.0
         Environment: Windows 10 and Windows 7
            Reporter: Donald Jansen
            Assignee: Jiri Cincura
         Attachments: FirebirdConnector.cs, Untitled.png

The following exception is being thrown, and is not handled by a try...catch...finaly

System.StackOverflowException was unhandled
Message: An unhandled exception of type 'System.StackOverflowException' occurred in mscorlib.dll

There is no stacktrace available with this exception

The exception seems to come from the DataReader.Read()
If the DataReader is empty it is thrown directly,
if the DataReader has rows then it is thrown after the last row was handled


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

        

We are using this for all commands because developer are lazy.
Together with explicit prepare, no possible performance loss, just memory.
But I'm not sure for commands without prepare.

If I remember API, there is possibility to execute SQL without prepare.
And in this case, the first time will be slower because of roundtrip to 
server.
Next time will be faster.
But if are you using parameters, you must prepare SQL -> fist is same, 
second is better.

Slavek


> Is this only for commands that has Prepare() explicitly called on?
> Is there a scenario where performance will be slower than currently?
>
> On 29 March 2017 at 11:58, Slavomir Skopalik <sko...@el...> wrote:
>
>> Hi all,
>>
>> after discussion with Jiri Cincura I prepare proposal for prepared
>> statement cache that will be implemented inside .NET provider.
>>
>> Motivation:
>>
>> Preparation of SQL statement take a time and also server resources. Many
>> SQL server has this functionality build in in engine, but FB not.
>>
>> More reading for example here:
>> http://stackoverflow.com/questions/12141036/preparedstatement-caching-
>> what-does-it-mean-how-does-it-work
>>
>> We implement this to speed up our web application (cache is persistent
>> across web requests).
>>
>>
>> Ideas:
>>
>> Each connection that already exists in pool well keep a private
>> dictionary of cached statements (can be disable by config).
>>
>> Not used SQL will be released after some time out, also cache will have
>> maximum statements like default 100.
>>
>> When application obtaining new connection from pool, provider will look
>> for free connection with higher number of cached statements.
>>
>>
>> The question:
>>
>> Is this interesting to have this functionality inside provider and fully
>> transparent?
>>

Sound interesting to have in the provider.

Is this only for commands that has Prepare() explicitly called on?
Is there a scenario where performance will be slower than currently?

On 29 March 2017 at 11:58, Slavomir Skopalik <sko...@el...> wrote:

> Hi all,
>
> after discussion with Jiri Cincura I prepare proposal for prepared
> statement cache that will be implemented inside .NET provider.
>
> Motivation:
>
> Preparation of SQL statement take a time and also server resources. Many
> SQL server has this functionality build in in engine, but FB not.
>
> More reading for example here:
> http://stackoverflow.com/questions/12141036/preparedstatement-caching-
> what-does-it-mean-how-does-it-work
>
> We implement this to speed up our web application (cache is persistent
> across web requests).
>
>
> Ideas:
>
> Each connection that already exists in pool well keep a private
> dictionary of cached statements (can be disable by config).
>
> Not used SQL will be released after some time out, also cache will have
> maximum statements like default 100.
>
> When application obtaining new connection from pool, provider will look
> for free connection with higher number of cached statements.
>
>
> The question:
>
> Is this interesting to have this functionality inside provider and fully
> transparent?
>
> Slavek
>
> PS: We combine this with RO transaction pool and also with data caching,
> but this is different story.
>
>
> --
> Ing. Slavomir Skopalik
> Executive Head
> Elekt Labs s.r.o.
> Collection and evaluation of data from machines and laboratories
> by means of system MASA (http://www.elektlabs.cz/m2demo)
> -----------------------------------------------------------------
> Address:
> Elekt Labs s.r.o.
> Chaloupky 158
> 783 72 Velky Tynec
> Czech Republic
> ---------------------------------------------------------------
> Mobile: +420 724 207 851
> icq:199 118 333
> skype:skopaliks
> e-mail:sko...@el...
> http://www.elektlabs.cz
>
>
>
> ------------------------------------------------------------
> ------------------
> 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
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>



-- 
------------------------------------------------------------------------
Gerdus van Zyl
www.infireal.com

Improve input buffer
--------------------

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


https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/pull/65

I looked at DNET-740 (http://tracker.firebirdsql.org/browse/DNET-740) and found the single threaded performance to be worse than it was.
Main performance killer was _inputBuffer.RemoveRange(0, data.Length);

Replaced the list with a class that keeps a list of the readbuffers and removes them when no longer needed.

Example performance on same data with 444528 rows
5.8: 11s
after this pull: 3.9s

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

        

Hi all,

after discussion with Jiri Cincura I prepare proposal for prepared 
statement cache that will be implemented inside .NET provider.

Motivation:

Preparation of SQL statement take a time and also server resources. Many 
SQL server has this functionality build in in engine, but FB not.

More reading for example here: 
http://stackoverflow.com/questions/12141036/preparedstatement-caching-what-does-it-mean-how-does-it-work

We implement this to speed up our web application (cache is persistent 
across web requests).


Ideas:

Each connection that already exists in pool well keep a private 
dictionary of cached statements (can be disable by config).

Not used SQL will be released after some time out, also cache will have 
maximum statements like default 100.

When application obtaining new connection from pool, provider will look 
for free connection with higher number of cached statements.


The question:

Is this interesting to have this functionality inside provider and fully 
transparent?

Slavek

PS: We combine this with RO transaction pool and also with data caching, 
but this is different story.


-- 
Ing. Slavomir Skopalik
Executive Head
Elekt Labs s.r.o.
Collection and evaluation of data from machines and laboratories
by means of system MASA (http://www.elektlabs.cz/m2demo)
-----------------------------------------------------------------
Address:
Elekt Labs s.r.o.
Chaloupky 158
783 72 Velky Tynec
Czech Republic
---------------------------------------------------------------
Mobile: +420 724 207 851
icq:199 118 333
skype:skopaliks
e-mail:sko...@el...
http://www.elektlabs.cz

The full path of the file database in the initial catalog causes the error.
---------------------------------------------------------------------------

                 Key: DNET-747
                 URL: http://tracker.firebirdsql.org/browse/DNET-747
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 5.8.0.0
         Environment: windows xp x86 
            Reporter: Andrey
            Assignee: Jiri Cincura
            Priority: Critical


connection_string:
initial catalog="C:\Documents and Settings\user\Мои документы\Visual Studio 2010\Projects\Копия SWSpecNew\compile\Debug\SWSpecDB.FDB";dialect=3;data source=localhost;user id=SYSDBA;password=masterkey;server type=Embedded;pooling=True;min pool size=0;max pool size=50;client library="C:\Documents and Settings\user\Мои документы\Visual Studio 2010\Projects\Копия SWSpecNew\compile\Debug\firebird\fbclient.dll";character set=UTF8;DEFAULT CHARACTER SET = UTF8;

The full path of the file database in the initial catalog causes the error.

FbConnection.CreateDatabase(connection_string 8192, true, false); 
or 

FirebirdSql.Data.FirebirdClient.FbConnection fc = new FirebirdSql.Data.FirebirdClient.FbConnection(connection_string );
fc.Open();

error:
I/O error during "CreateFile (create)" operation for file "C:\DOCUMENTS AND SETTINGS\USER\ЌнШ ХнЪсУенты\VISUAL STUDIO 2010\PROJECTS\ЊнЯШя SWSPECNEW\COMPILE\DEBUG\SWSPECDB.FDB"
Error while trying to create file

If I use version 5.5 of this error does not occur.


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

       

On 25-3-2017 15:09, Clyde Eisenbeis wrote:
> I should have started this email with ... C# ... Firebird ADO.NET ...
> FirebirdClient.5.8.0 ... Visual Studio 2013.
>
> I tried entering
>
>     CREATE GENERATOR gen_t1_id;
>     SET GENERATOR gen_t1_id TO 0;
>
>     set term !! ;
>     CREATE TRIGGER T1_BI FOR T1
>
> in my C# code ... the compiler complains.  This appears to not be
> relevant for C#.

You need to show how you execute this. For example `set term` is unknown 
in Firebird itself, it is just client-side functionality in a number of 
Firebird tools (like isql, flame robin, and in the Firebird ADO.net 
provider FbScript tool.

If you are not using FbScript, but executing these statements like 
normal commands, then you must execute 1) leave out `SET TERM`, and 
execute the statements individually.

> What I need is the ability to add data and retrieve the primary key
> which needs to be autoincremented ... see
> http://stackoverflow.com/questions/42981872/why-the-executenonquery-catch-exception-validation-error-for-column-orgtable
> for the current code.

Use `INSERT .... RETURNING ID`.

Mark
-- 
Mark Rotteveel

I should have started this email with ... C# ... Firebird ADO.NET ...
FirebirdClient.5.8.0 ... Visual Studio 2013.

I tried entering

    CREATE GENERATOR gen_t1_id;
    SET GENERATOR gen_t1_id TO 0;

    set term !! ;
    CREATE TRIGGER T1_BI FOR T1

in my C# code ... the compiler complains.  This appears to not be
relevant for C#.

What I need is the ability to add data and retrieve the primary key
which needs to be autoincremented ... see
http://stackoverflow.com/questions/42981872/why-the-executenonquery-catch-exception-validation-error-for-column-orgtable
for the current code.

On Fri, Mar 24, 2017 at 10:57 AM, Scott Morgan <bl...@bl...> wrote:
> On 03/24/2017 03:09 PM, Clyde Eisenbeis wrote:
>> Using http://www.firebirdfaq.org/faq29/ as a reference.
>>
>> 1) If I understand this website, the CREATE GENERATOR is initiated only once?
>
> Yes. It's a global item like a table, so you just need to create it once
> (and commit that change to the DB,. Changes to tables and other global
> items like that all need to be committed before using them). It'll have
> an initial value of 0 and calls to GEN_ID will increment it by the
> specified value (usually 1)
>
>> 2) Likewise the CREATE TRIGGER is initiated only once?
>
> Yes. It's just associated with the table, ready to run whenever the
> specific event happens, so...
>
>> 3) When is the T1_BI used (CREATE TRIGGER T1_BI FOR T1)?
>
> The "ACTIVE BEFORE INSERT POSITION 0" specifies that. In this case
> 'BEFORE INSERT', so whenever a new item is inserted into the table, that
> trigger is run.
>
>> 4) I see the 'id' field in table t1.  I see upper case 'ID' in the
>> TRIGGER.  Are these two the same?
>
> Yes. (Bit of bad form in that FAQ there I'd say, mixing case) Unquoted
> identifiers (names of tables, columns, etc.) are stored in upper case.
> So id, ID, iD, and Id are all the same (ID).
>
>
> You'll get more detailed answers about this stuff on the main Firebird
> mailing list, and I highly recommend the Firebird Book by Helen Borrie,
> which covers all this clearly and in depth. It's things like triggers
> and foreign keys that make a proper DB so powerful, but it can take a
> bit of getting used to.
>
> Scott
>
>
> ------------------------------------------------------------------------------
> 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
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

This might help you with DDEX and VS2017.

https://www.tabsoverspaces.com/233604-installing-ddex-provider-for-firebird-into-visual-studio-2017/

-- 
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/

FbScript Exception
------------------

                 Key: DNET-746
                 URL: http://tracker.firebirdsql.org/browse/DNET-746
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 5.8.0.0
         Environment: Visual Studio 2015 / target .Net Framework 4.0
            Reporter: Marcos R. Weimer
            Assignee: Jiri Cincura


- Read script file and execute:
- Multiple lines with comments
- null except in execute this specific line: "delete from custo_reposicao_atual;  -- deletar tudo pq na 514 teve alteracoes e pode estar errado o custo"

Example:

ExecuteScript("delete from custo_reposicao_atual;  -- deletar tudo pq na 514 teve alteracoes e pode estar errado o custo") 

public void ExecuteScript(string ASQL)
{
            FbScript sc = new FbScript(ASql);

            sc.Parse(); ---> exception here
            FbBatchExecution fbe = new FbBatchExecution(FConexao);
            fbe.AppendSqlStatements(sc);
            fbe.Execute();
}


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

        

On 03/24/2017 03:09 PM, Clyde Eisenbeis wrote:
> Using http://www.firebirdfaq.org/faq29/ as a reference.
> 
> 1) If I understand this website, the CREATE GENERATOR is initiated only once?

Yes. It's a global item like a table, so you just need to create it once
(and commit that change to the DB,. Changes to tables and other global
items like that all need to be committed before using them). It'll have
an initial value of 0 and calls to GEN_ID will increment it by the
specified value (usually 1)

> 2) Likewise the CREATE TRIGGER is initiated only once?

Yes. It's just associated with the table, ready to run whenever the
specific event happens, so...

> 3) When is the T1_BI used (CREATE TRIGGER T1_BI FOR T1)?

The "ACTIVE BEFORE INSERT POSITION 0" specifies that. In this case
'BEFORE INSERT', so whenever a new item is inserted into the table, that
trigger is run.

> 4) I see the 'id' field in table t1.  I see upper case 'ID' in the
> TRIGGER.  Are these two the same?

Yes. (Bit of bad form in that FAQ there I'd say, mixing case) Unquoted
identifiers (names of tables, columns, etc.) are stored in upper case.
So id, ID, iD, and Id are all the same (ID).


You'll get more detailed answers about this stuff on the main Firebird
mailing list, and I highly recommend the Firebird Book by Helen Borrie,
which covers all this clearly and in depth. It's things like triggers
and foreign keys that make a proper DB so powerful, but it can take a
bit of getting used to.

Scott

Collection was modified; enumeration operation may not execute.
---------------------------------------------------------------

                 Key: DNET-745
                 URL: http://tracker.firebirdsql.org/browse/DNET-745
             Project: .NET Data provider
          Issue Type: Bug
    Affects Versions: 5.8.0.0
         Environment: .Net 4 and4.5
            Reporter: Paul Reeves
            Assignee: Jiri Cincura


We have a client that have found what appears to be a bug in v5.8.0.0

The code and the stack trace are attached below.

The same code works fine with all versions between 4.1 and 5.7

They've also tested with .Net framework 4 and 4.5

They are happy to run a debug build to help fix this, but have not been able to create a test case.



#if DEBUG
      var cmd = "select s.S_SHOPID, s.S_VALUE as FOO, s1.S_VALUE as BAR, s2.S_VALUE as SNAFU " +
                "from SYSTEMSETTING s " +
                "left join SYSTEMSETTING s1 on s.S_SHOPID = s1.S_SHOPID " +
                "left join SYSTEMSETTING s2 on s.S_SHOPID = s2.S_SHOPID " +
                "where s.S_SYSTEM_ID = 9202 " +
                "and s1.S_SYSTEM_ID = 9200 " +
                "and s2.S_SYSTEM_ID = 9201 " +
                "and s.S_VALUE = 'Y' " +
                "and s1.S_VALUE <> '' " +
                "and s2.S_VALUE <> ''";
      using (FbCommand fbCmd = new FbCommand(cmd)) {
        using (DataTable myDT = new DataTable()) {
          using (FbDataAdapter da = new FbDataAdapter()) {
            da.SelectCommand = fbCmd;
            fbCmd.Connection = DbConnection;

            try {
              LogFile.Log("Before Data Adapter.Fill() call. Managed Thread ID: " + System.Threading.Thread.CurrentThread.ManagedThreadId.ToString(), true);
              da.Fill(myDT);
              LogFile.Log("After Data Adapter.Fill() call. Managed Thread ID: " + System.Threading.Thread.CurrentThread.ManagedThreadId.ToString(), true);
              foreach (DataRow row in myDT.Rows) {
                LogFile.Log("Row Logged");
              }
            }
            catch (Exception e) {
              LogFile.Log("******--- ERROR ---******", true);
              LogFile.Log("Managed Thread ID: " + System.Threading.Thread.CurrentThread.ManagedThreadId.ToString());
              LogFile.Log("Error Message: " + e.Message);
              LogFile.Log("Error Message: " + e.StackTrace);
            }
          }
        }
      }
      LogFile.Log("After Select via SQL Test. Managed Thread ID: " + System.Threading.Thread.CurrentThread.ManagedThreadId.ToString(), true);
#endif


--------------------------------------------------------------------------------
Tuesday 21 March 2017 01:20:07.308 PM
--------------------------------------------------------------------------------
  :Before Select via SQL Test. Managed Thread ID: 4
  :FirebirdSql.Data.FirebirdClient version: 5.8.0.0
--------------------------------------------------------------------------------
Tuesday 21 March 2017 01:20:07.308 PM
--------------------------------------------------------------------------------
  :Before Data Adapter.Fill() call. Managed Thread ID: 4
--------------------------------------------------------------------------------
Tuesday 21 March 2017 01:20:07.313 PM
--------------------------------------------------------------------------------
  :******--- ERROR ---******
  :Managed Thread ID: 4
  :Error Message: Collection was modified; enumeration operation may not execute.
  :Error Message:    at System.ThrowHelper.ThrowInvalidOperationException(ExceptionResource resource)
   at System.Collections.Generic.List`1.Enumerator.MoveNextRare()
   at System.Linq.Enumerable.<TakeIterator>d__24`1.MoveNext()
   at System.Linq.Buffer`1..ctor(IEnumerable`1 source)
   at System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source)
   at FirebirdSql.Data.Client.Managed.XdrStream.Read(Byte[] buffer, Int32 offset, Int32 count) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Managed\XdrStream.cs:line 249
   at FirebirdSql.Data.Client.Managed.XdrStream.ReadBytes(Int32 count) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Managed\XdrStream.cs:line 336
   at FirebirdSql.Data.Client.Managed.XdrStream.ReadOpaque(Int32 length) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Managed\XdrStream.cs:line 348
   at FirebirdSql.Data.Client.Managed.GdsConnection.ProcessOperation(Int32 operation, XdrStream xdr) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Managed\GdsConnection.cs:line 362
   at FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadSingleResponse() in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Managed\Version10\GdsDatabase.cs:line 638
   at FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadResponse() in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Managed\Version10\GdsDatabase.cs:line 593
   at FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadGenericResponse() in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Managed\Version10\GdsDatabase.cs:line 605
   at FirebirdSql.Data.Client.Managed.Version11.GdsStatement.Prepare(String commandText) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Managed\Version11\GdsStatement.cs:line 77
   at FirebirdSql.Data.FirebirdClient.FbCommand.Prepare(Boolean returnsSet) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:line 1148
   at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand(CommandBehavior behavior, Boolean returnsSet) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:line 1171
   at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:line 523
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at PNDataService.DbConnectionManager.InitializeEvents(String errorstatus, Boolean resumedFromDownTime) in C:\Dev VS\PNDATASERVICEVS4.5\DbConnectionManager.cs:line 987
--------------------------------------------------------------------------------
Tuesday 21 March 2017 01:20:07.329 PM
--------------------------------------------------------------------------------
  :After Select via SQL Test. Managed Thread ID: 4




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

        

Using http://www.firebirdfaq.org/faq29/ as a reference.

1) If I understand this website, the CREATE GENERATOR is initiated only once?

2) Likewise the CREATE TRIGGER is initiated only once?

3) When is the T1_BI used (CREATE TRIGGER T1_BI FOR T1)?

4) I see the 'id' field in table t1.  I see upper case 'ID' in the
TRIGGER.  Are these two the same?

1) The filename was zzFirebirdTest.fdb.  The end result is
ZZFIREBIRDTEST.FDB.

Here is solution converting the UPPERCASE back to the original:

    string stPATHFILENAME = stPathFilename.ToUpper();
    System.IO.File.Move(@stPATHFILENAME, @stPathFilename);

On Sun, Mar 19, 2017 at 6:07 AM, Mark Rotteveel <ma...@la...> wrote:
> On 19-3-2017 11:56, Jiří Činčura wrote:
>>> Firebird Embedded on windows does not check for username and password,
>>> so you can leave them out. For a normal Firebird server, username is
>>> case insensitive, but password - of course - is case sensitive.
>>
>> But the grants are still followed. So username/role is important,
>> password not much.
>>
>
> You are right, forgot about that :)
>
> --
> Mark Rotteveel
>
> ------------------------------------------------------------------------------
> 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
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

1) I think it would be

    string stOpenConn = new FbConnectionStringBuilder {
        Database = stPathFilename,
        UserID = stUserID,
        Password = stPassword,
        ServerType = FbServerType.Embedded,
        ClientLibrary = stCLIENT_LIBRARY
    }.ToString();
    using (FbConnection fbConn = new FbConnection(stOpenConn)) {
        try {
            fbConn.Open();

On Thu, Mar 23, 2017 at 8:30 AM, Clyde Eisenbeis <ct...@gm...> wrote:
> 1) It's not obvious to me where to put the 'using' with 'try'.  Could
> you provide an example using the code in my first email?
>
> 2) Is this what you recommend?
>
> where stSql = "CREATE TABLE  TableOrg (  fstPriority VARCHAR(10),
> fstInfo VARCHAR(x) CHARACTER SET UNICODE_FSS, fiKeyID INTEGER PRIMARY
> KEY )".
>
> What do I use for 'x'?  This should be variable.
>
> 3)  BLOB SUB_TYPE TEXT is non-Unicode.  The field 'fstInfo' needs to
> handle German.
>
> On Thu, Mar 23, 2017 at 2:11 AM, Jiří Činčura <ji...@ci...> wrote:
>>> 1) Is it correct to have multiple fbCmd.ExecuteNonQuery() commands ...
>>> followed by one fbTransaction.Commit()?
>>
>> Yes. Also use `using` block for disposable resource.
>>
>>> 2) I want to be able to handle German vowels, such as umlauts, for
>>> fstInfo.  I don't think VARCHAR is the correct choice as it is
>>> non-unicode.
>>
>> You can use CHARACTER SET clause. Best is probably to use UTF8.
>>
>>> 3) I also want variable lengths, without a max, for fstInfo.  What do
>>> I use in place of the "100"?
>>
>> Then you have to use BLOB SUB_TYPE TEXT.
>>
>> --
>> Mgr. Jiří Činčura
>> https://www.tabsoverspaces.com/
>>
>> ------------------------------------------------------------------------------
>> 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
>> Fir...@li...
>> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

1) It's not obvious to me where to put the 'using' with 'try'.  Could
you provide an example using the code in my first email?

2) Is this what you recommend?

where stSql = "CREATE TABLE  TableOrg (  fstPriority VARCHAR(10),
fstInfo VARCHAR(x) CHARACTER SET UNICODE_FSS, fiKeyID INTEGER PRIMARY
KEY )".

What do I use for 'x'?  This should be variable.

3)  BLOB SUB_TYPE TEXT is non-Unicode.  The field 'fstInfo' needs to
handle German.

On Thu, Mar 23, 2017 at 2:11 AM, Jiří Činčura <ji...@ci...> wrote:
>> 1) Is it correct to have multiple fbCmd.ExecuteNonQuery() commands ...
>> followed by one fbTransaction.Commit()?
>
> Yes. Also use `using` block for disposable resource.
>
>> 2) I want to be able to handle German vowels, such as umlauts, for
>> fstInfo.  I don't think VARCHAR is the correct choice as it is
>> non-unicode.
>
> You can use CHARACTER SET clause. Best is probably to use UTF8.
>
>> 3) I also want variable lengths, without a max, for fstInfo.  What do
>> I use in place of the "100"?
>
> Then you have to use BLOB SUB_TYPE TEXT.
>
> --
> Mgr. Jiří Činčura
> https://www.tabsoverspaces.com/
>
> ------------------------------------------------------------------------------
> 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
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Unable to connect bundled embedded database on macOS
----------------------------------------------------

                 Key: DNET-744
                 URL: http://tracker.firebirdsql.org/browse/DNET-744
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 4.8.1.0
         Environment: macOS Sierra, Firebird 2.5.6 embedded, Mono 4.8
            Reporter: Daniel Martin
            Assignee: Jiri Cincura


When bundling the Firebird database with a mono application, one must not provide a user and a password in the connection string as otherwise the libfbembed.dylib (Firebird binary) attempts to attach to the systems security2.fdb.
The FbConnectionString class forces the client to provide a user and password if LINUX is defined, as trusted auth does no exist on non-windows platforms.

This was locally fixed by checking the FbConnectionString.ServerType property in FbConnectionString.Validate and FbConnectionString.FallIntoTrustedAuth.
See the provided methods below for details.

I'm not sure whether this is the correct solution or if it creates any side effects.

----
internal bool FallIntoTrustedAuth
		{
			// on non-Win the UserID/Password is checked in Validate method
			get { return ServerType != FbServerType.Embedded && string.IsNullOrEmpty(UserID) && string.IsNullOrEmpty(Password); } // Embedded does not require a password
		}
---
		public void Validate()
		{
			if (!ContextConnection)
			{
				if (
#if (LINUX)  // on Linux Trusted Auth isn't available
					(ServerType != FbServerType.Embedded && (string.IsNullOrEmpty(this.UserID) || // Embedded does not require a password
					string.IsNullOrEmpty(this.Password))) ||
#endif
(string.IsNullOrEmpty(Database) && !_isServiceConnectionString) ||
					(string.IsNullOrEmpty(DataSource) && ServerType != FbServerType.Embedded) ||
					(string.IsNullOrEmpty(Charset)) ||
					(Port == 0) ||
					(!Enum.IsDefined(typeof(FbServerType), ServerType)) ||
					(MinPoolSize > MaxPoolSize)
				   )
				{
					throw new ArgumentException("An invalid connection string argument has been supplied or a required connection string argument has not been supplied.");
				}
				if (Dialect < 1 || Dialect > 3)
				{
					throw new ArgumentException("Incorrect database dialect it should be 1, 2, or 3.");
				}
				if (PacketSize < 512 || PacketSize > 32767)
				{
					throw new ArgumentException(string.Format(CultureInfo.CurrentCulture, "'Packet Size' value of {0} is not valid.{1}The value should be an integer >= 512 and <= 32767.", PacketSize, Environment.NewLine));
				}
				if (DbCachePages < 0)
				{
					throw new ArgumentException(string.Format(CultureInfo.CurrentCulture, "'Db Cache Pages' value of {0} is not valid.{1}The value should be an integer >= 0.", DbCachePages, Environment.NewLine));
				}
				if (Pooling && NoDatabaseTriggers)
				{
					throw new ArgumentException("Cannot use Pooling and NoDBTriggers together.");
				}

				CheckIsolationLevel();
			}
		}
---

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

        

> 1) Is it correct to have multiple fbCmd.ExecuteNonQuery() commands ...
> followed by one fbTransaction.Commit()?

Yes. Also use `using` block for disposable resource.

> 2) I want to be able to handle German vowels, such as umlauts, for
> fstInfo.  I don't think VARCHAR is the correct choice as it is
> non-unicode.

You can use CHARACTER SET clause. Best is probably to use UTF8.
 
> 3) I also want variable lengths, without a max, for fstInfo.  What do
> I use in place of the "100"?

Then you have to use BLOB SUB_TYPE TEXT.

-- 
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/

To create a table:
-----------------------------
    int iTablesCount = liststTableNames.Count();
    try {
        string stOpenConn = new FbConnectionStringBuilder {
            Database = stPathFilename,
            UserID = stUserID,
            Password = stPassword,
            ServerType = FbServerType.Embedded,
            ClientLibrary = stCLIENT_LIBRARY
        }.ToString();
        FbConnection fbConn = new FbConnection(stOpenConn);
        fbConn.Open();

        FbTransaction fbTransaction = fbConn.BeginTransaction();
        for (int ii = 0; ii < iTablesCount; ii++) {
            string stSql = "CREATE TABLE " + liststTableNames[ii] + "(
" + liststFieldDefinitions[ii] + ")";
            FbCommand fbCmd = new FbCommand(stSql, fbConn, fbTransaction);
            fbCmd.ExecuteNonQuery();
        }
        fbTransaction.Commit();
-----------------------------
where stSql = "CREATE TABLE  TableOrg (  fstPriority VARCHAR(10),
fstInfo VARCHAR(100), fiKeyID INTEGER PRIMARY KEY )".

1) Is it correct to have multiple fbCmd.ExecuteNonQuery() commands ...
followed by one fbTransaction.Commit()?

2) I want to be able to handle German vowels, such as umlauts, for
fstInfo.  I don't think VARCHAR is the correct choice as it is
non-unicode.

3) I also want variable lengths, without a max, for fstInfo.  What do
I use in place of the "100"?

Memory leak in Firebird 3 on implicit transaction 
--------------------------------------------------

                 Key: DNET-743
                 URL: http://tracker.firebirdsql.org/browse/DNET-743
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 5.8.0.0
         Environment: Firebird: 3.0.1.32609, .NET Provider: 5.8, .NET 4.6, Win 10 x64
            Reporter: Alexander Lipatov
            Assignee: Jiri Cincura


Implicit transactions in Firebird 3 cause a massive memory leak on the server part. 
It is detected only on Firebird 3. 
If transaction is performed manually the memory leak is not happened.

Example:
var connection = new FbConnection(connectionString);
connection.Open();
while (true)
{
    using (var cmd = connection.CreateCommand())
    {
        cmd.CommandText = "SELECT * FROM TABLE_NAME";
        cmd.ExecuteNonQuery();
    }
}

I fixed this issue as follows:
The calls isc_commit_transaction and isc_dsql_free_statement was swapped.


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

        

GdsConnection.Connect() should not always call TryEnableLoopbackFastPath
------------------------------------------------------------------------

                 Key: DNET-742
                 URL: http://tracker.firebirdsql.org/browse/DNET-742
             Project: .NET Data provider
          Issue Type: Improvement
          Components: ADO.NET Provider
    Affects Versions: 5.8.0.0
         Environment: WIndows 7, .Net 4.5
            Reporter: Tudor Costin
            Assignee: Jiri Cincura
            Priority: Minor


Loopback fast path only works when connecting to the same computer. This is rarely going to be the case. It also never works on Windows 7 or below. Not only is it a waste of time to try, but the resulting SocketException will trigger a break into the debugger if it is set to always break on these types of exceptions. This is very annoying for developers using the ADO provider.

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

        

On 19-3-2017 11:56, Jiří Činčura wrote:
>> Firebird Embedded on windows does not check for username and password,
>> so you can leave them out. For a normal Firebird server, username is
>> case insensitive, but password - of course - is case sensitive.
>
> But the grants are still followed. So username/role is important,
> password not much.
>

You are right, forgot about that :)

-- 
Mark Rotteveel

> Firebird Embedded on windows does not check for username and password, 
> so you can leave them out. For a normal Firebird server, username is 
> case insensitive, but password - of course - is case sensitive.

But the grants are still followed. So username/role is important,
password not much.

-- 
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/

On 18-3-2017 16:21, Clyde Eisenbeis wrote:
> Mark,
>
> I'm not sure how to reply via StackOverflow, so I'll email.

Here is fine.

> Thanks!  Your description creates an .fdb file. (I think .fdb is the
> correct format acronym).

You can choose whatever you want for the file extension, but fdb is 
indeed to common choice.

> 1) The filename was zzFirebirdTest.fdb.  The end result is
> ZZFIREBIRDTEST.FDB.  How do I keep TitleCase for the name?

Unfortunately there is no way, Firebird internally uppercases the 
filename on Windows. If you really want to preserve case, you would 
first need to create the database and then rename it.

> 2) UserID = "SYSDBA", Password = "masterkey".  I presume there is no
> risk in using anything I want.  Are they case sensitive?

Firebird Embedded on windows does not check for username and password, 
so you can leave them out. For a normal Firebird server, username is 
case insensitive, but password - of course - is case sensitive.

> 3) Is the pageSize = 4096, a good common practice?

It depends, 4kb is common, but the max is 16kb for current Firebird 
versions. A larger page size allows for larger index keys, other than 
that it depends: large pages means more records fit on a single page, 
and as buffers/caches are defined in pages, you'll have more data in 
cache, on the other hand storing blobs can have more space overhead: 
you'll need less pages per blob, but say you store blob is around 16KB, 
then you need 5 pages of 4KB and you will waste +/- 3500 - 400 bytes 
because it only needs a few bytes (+ bytes for the page header) of the 
last page, while with a 16KB, you'll need 2 pages of 16KB and waste 
about 16000 bytes.

> 4) I'm struggling to find details about FbConnection.CreateDatabase on
> the Firebird Document site.

You'd need to ask Jiri who maintains the project. The documentation on 
the Firebird ADO.net provider is rather sparse in my opinion, but you 
can always check the source: 
https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient

> Apparently the order is ... connection details (string), page size
> (int), force writes (bool), overwrite (bool).

public static void CreateDatabase(string connectionString, int pageSize 
= 4096, bool forcedWrites = true, bool overwrite = false)

> The connection string has reserved words, Database, ServerType, etc.
>
> Is there a site that clarifies all of the reserved words / options /
> defaults?  I'd like to document this info while it is still fresh in
> my mind ... for future projects.

See the Description annotations on FbConnectionStringBuilder

https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/blob/master/Provider/src/FirebirdSql.Data.FirebirdClient/FirebirdClient/FbConnectionStringBuilder.cs

Mark
-- 
Mark Rotteveel

> 4) I'm struggling to find details about FbConnection.CreateDatabase on
> the Firebird Document site.
> 
> Apparently the order is ... connection details (string), page size
> (int), force writes (bool), overwrite (bool).

https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/blob/master/Provider/src/FirebirdSql.Data.FirebirdClient/FirebirdClient/FbConnection.cs#L64
 
> The connection string has reserved words, Database, ServerType, etc.
> 
> Is there a site that clarifies all of the reserved words / options /
> defaults?  I'd like to document this info while it is still fresh in
> my mind ... for future projects.

https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/blob/master/Provider/src/FirebirdSql.Data.FirebirdClient/FirebirdClient/FbConnectionString.cs#L88

-- 
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/