[Firebird-devel] [FB-Tracker] Created: (CORE-4519) Restoring a Firebird 2.5 database freezes at "Committing Metadata" in Windows 8.1

2014-08-12 Thread Sandamal Warnakulasuriya (JIRA)
Restoring a Firebird 2.5 database freezes at "Committing Metadata" in Windows 8.1 - Key: CORE-4519 URL: http://tracker.firebirdsql.org/browse/CORE-4519 Project: Firebird

Re: [Firebird-devel] Using isc_dsql_prepare_m instead of isc_dsql_prepare

2014-08-12 Thread Dimitry Sibiryakov
12.08.2014 22:06, Adriano dos Santos Fernandes wrote: > Non-_m (who uses SQLDA) methods are wrappers for the _m methods. Not anymore. *_m methods are limited to 64k result set. SQLDA ones - not. -- WBR, SD. -- Fir

Re: [Firebird-devel] Using isc_dsql_prepare_m instead of isc_dsql_prepare

2014-08-12 Thread Mark Rotteveel
On 12-8-2014 22:06, Adriano dos Santos Fernandes wrote: > On 12/08/2014 17:01, Mark Rotteveel wrote: >> On 12-8-2014 21:24, Adriano dos Santos Fernandes wrote: >>> On 12/08/2014 16:17, Mark Rotteveel wrote: Am I correct to understand, that in the C API isc_dsql_prepare_m will allow me to

Re: [Firebird-devel] Using isc_dsql_prepare_m instead of isc_dsql_prepare

2014-08-12 Thread Adriano dos Santos Fernandes
On 12/08/2014 17:01, Mark Rotteveel wrote: > On 12-8-2014 21:24, Adriano dos Santos Fernandes wrote: >> On 12/08/2014 16:17, Mark Rotteveel wrote: >>> Am I correct to understand, that in the C API isc_dsql_prepare_m will >>> allow me to specify the database information items to request together >>>

Re: [Firebird-devel] Using isc_dsql_prepare_m instead of isc_dsql_prepare

2014-08-12 Thread Mark Rotteveel
On 12-8-2014 21:24, Adriano dos Santos Fernandes wrote: > On 12/08/2014 16:17, Mark Rotteveel wrote: >> Am I correct to understand, that in the C API isc_dsql_prepare_m will >> allow me to specify the database information items to request together >> with the statement prepare, allowing me to circu

Re: [Firebird-devel] Using isc_dsql_prepare_m instead of isc_dsql_prepare

2014-08-12 Thread Adriano dos Santos Fernandes
On 12/08/2014 16:17, Mark Rotteveel wrote: > Am I correct to understand, that in the C API isc_dsql_prepare_m will > allow me to specify the database information items to request together > with the statement prepare, allowing me to circumvent the allocation and > handling of XSQLDA, and instead

[Firebird-devel] Using isc_dsql_prepare_m instead of isc_dsql_prepare

2014-08-12 Thread Mark Rotteveel
Am I correct to understand, that in the C API isc_dsql_prepare_m will allow me to specify the database information items to request together with the statement prepare, allowing me to circumvent the allocation and handling of XSQLDA, and instead gives we a response buffer that I can process the

Re: [Firebird-devel] New Interface

2014-08-12 Thread Dimitry Sibiryakov
12.08.2014 20:41, Mark Rotteveel wrote: >> Don't forget about Java and C#. > I don't think those are directly relevant. I would think that the only > people who would ever use a direct interface from Java and C# are Jiri > and me, all normal application developers will simply use the JDBC > dr

Re: [Firebird-devel] New Interface (OT: Apache MQ)

2014-08-12 Thread Tom Coleman
On Aug 12, 2014, at 1:37 PM, Mark Rotteveel wrote: > On 12-8-2014 18:48, Tom Coleman wrote: >> One bias of mine that I will confess to is that I hate C++. Every time I >> am forced to use it it turns out to be a horrible PITA. The last project I >> wrestled with was an interface from our pro

Re: [Firebird-devel] New Interface

2014-08-12 Thread Mark Rotteveel
On 12-8-2014 19:59, Dimitry Sibiryakov wrote: > 12.08.2014 19:54, Adriano dos Santos Fernandes wrote: >> Later I'll improve it for C and FPC and put in my github. > > Don't forget about Java and C#. I don't think those are directly relevant. I would think that the only people who would ever u

Re: [Firebird-devel] New Interface (OT: Apache MQ)

2014-08-12 Thread Adriano dos Santos Fernandes
On 12/08/2014 14:59, Dimitry Sibiryakov wrote: > 12.08.2014 19:54, Adriano dos Santos Fernandes wrote: >> Later I'll improve it for C and FPC and put in my github. >Don't forget about Java and C#. I'll not forget, if I want to do. Adriano

Re: [Firebird-devel] New Interface (OT: Apache MQ)

2014-08-12 Thread Dimitry Sibiryakov
12.08.2014 19:54, Adriano dos Santos Fernandes wrote: > Later I'll improve it for C and FPC and put in my github. Don't forget about Java and C#. -- WBR, SD. -- Firebird-Devel mailing list, web interface at https

Re: [Firebird-devel] New Interface (OT: Apache MQ)

2014-08-12 Thread Adriano dos Santos Fernandes
On 12/08/2014 14:37, Mark Rotteveel wrote: > On 12-8-2014 18:48, Tom Coleman wrote: >> One bias of mine that I will confess to is that I hate C++. Every time I >> am forced to use it it turns out to be a horrible PITA. The last project I >> wrestled with was an interface from our proprietary l

Re: [Firebird-devel] Error messages how-to

2014-08-12 Thread Dimitry Sibiryakov
12.08.2014 19:37, Dalton Calford wrote: > I would never, ever put a binary such as a database or compiled executable > into a version > control system, but, there is nothing preventing my extracting the DML > (insert into foo .values..) and inserting that into the version > control system

Re: [Firebird-devel] Error messages how-to

2014-08-12 Thread Mark Rotteveel
On 12-8-2014 19:37, Dalton Calford wrote: > If I understand your message, I am still confused by the statement. > > I would never, ever put a binary such as a database or compiled > executable into a version control system, but, there is nothing > preventing my extracting the DML > (insert into foo

Re: [Firebird-devel] Error messages how-to

2014-08-12 Thread Leyne, Sean
Mark, > I think you misunderstand. Historically, the error messages within the build > where stored inside a Firebird database. That database itself was the source > for the generated header with errorcodes and the firebird.msg file. I have never understood, why this database has not been replace

Re: [Firebird-devel] Error messages how-to

2014-08-12 Thread Dalton Calford
Hi Mark, If I understand your message, I am still confused by the statement. I would never, ever put a binary such as a database or compiled executable into a version control system, but, there is nothing preventing my extracting the DML (insert into foo .values..) and inserting that into

Re: [Firebird-devel] New Interface (OT: Apache MQ)

2014-08-12 Thread Mark Rotteveel
On 12-8-2014 18:48, Tom Coleman wrote: > One bias of mine that I will confess to is that I hate C++. Every time I am > forced to use it it turns out to be a horrible PITA. The last project I > wrestled with was an interface from our proprietary language to ApacheMQ, and > the only interface a

Re: [Firebird-devel] Error messages how-to

2014-08-12 Thread Jim Starkey
That wasn't a problem for Interbase because we used a source control system that was also based on the database. We found that having developers who were also database users made them a great deal more sympathetic with customers. We also used the database as this basis for the test system (tcs

Re: [Firebird-devel] Error messages how-to

2014-08-12 Thread Mark Rotteveel
On 12-8-2014 19:22, Dalton Calford wrote: > May I ask why you say a database system is not suitable for CVS? I had > ours on cvs for a few years before moving it to git. > > If you view the operational database as source code, then I can > understand your point, but, I view an operational databas

Re: [Firebird-devel] Error messages how-to

2014-08-12 Thread Dalton Calford
Hi Dimitry, May I ask why you say a database system is not suitable for CVS? I had ours on cvs for a few years before moving it to git. If you view the operational database as source code, then I can understand your point, but, I view an operational database as a compiled end product while the

Re: [Firebird-devel] Error messages how-to

2014-08-12 Thread Ann Harrison
> On Aug 12, 2014, at 1:17 PM, Jim Starkey wrote: > > Sigh. There used to be database based system to create and edit messages and > generate header and message files. Very handy using a database to develop a > database system. Please lets not get into the moral and political issues of re

Re: [Firebird-devel] New Interface

2014-08-12 Thread Tom Coleman
On Aug 12, 2014, at 12:11 PM, Jim Starkey wrote: > I haven't a clue how this can be sorted out. I have a suggestion. Clearly this "New Interface" issue is complex and critical and is going to take some time to sort out. Why not focus on getting FB 3 out the door as a release - API as is - an

Re: [Firebird-devel] New Interface

2014-08-12 Thread Tom Coleman
On Aug 12, 2014, at 2:37 AM, Alex Peshkoff wrote: > On 08/11/14 22:29, Tom Coleman wrote: > >> I interface a proprietary language with Firebird, Oracle, and Sybase/MS-SQL. >> >> There is never any case where I would want to see std:exception. >> >> Could it be time to start thinking about bur

Re: [Firebird-devel] Error messages how-to

2014-08-12 Thread Dimitry Sibiryakov
12.08.2014 18:17, Jim Starkey wrote: > There used to be database based system to create and edit messages and > generate header and message files. Yes, I know that because I am exactly that guy who killed this system because database isn't suitable for CVS. -- WBR, SD. --

Re: [Firebird-devel] New Interface

2014-08-12 Thread Ann Harrison
> On Aug 12, 2014, at 1:11 PM, Jim Starkey wrote: > > > My position is that the external interface (the API) should remain y-valve > and handle oriented, extended as needed. An interface for export engine > semantics, however, has different requirements and can and should be > encapsulated

Re: [Firebird-devel] Error messages how-to

2014-08-12 Thread Jim Starkey
Sigh. There used to be database based system to create and edit messages and generate header and message files. Very handy using a database to develop a database system. > On Aug 12, 2014, at 9:34 AM, Dimitry Sibiryakov wrote: > > Hello, All. > > Is there a simple step-by-step guide

Re: [Firebird-devel] New Interface

2014-08-12 Thread Jim Starkey
Mark, this is how I think we got here. There is a compelling need to export engine semantics of UDFs and other types of plugins. The obvious -- and desireable way -- to do this is with abstract objects. Since there also needed some minor work on primary interface, it seemed logical to unite t

Re: [Firebird-devel] New Interface

2014-08-12 Thread Alex Peshkoff
On 08/12/14 19:43, Tom Coleman wrote: > On Aug 12, 2014, at 2:35 AM, Alex Peshkoff wrote: > >> On 08/11/14 23:57, Tom Coleman wrote: >>> On Aug 11, 2014, at 3:36 PM, Jim Starkey wrote: >>> You may be more interested in why something failed than just that it failed. An error mec

Re: [Firebird-devel] New Interface

2014-08-12 Thread Tom Coleman
On Aug 12, 2014, at 2:35 AM, Alex Peshkoff wrote: > On 08/11/14 23:57, Tom Coleman wrote: >> >> On Aug 11, 2014, at 3:36 PM, Jim Starkey wrote: >> >>> You may be more interested in why something failed than just that it failed. >>> >>> An error mechanism should play nicely with the status vect

Re: [Firebird-devel] New Interface

2014-08-12 Thread Alex Peshkoff
On 08/12/14 13:55, Mark Rotteveel wrote: > On Tue, 12 Aug 2014 13:18:31 +0400, Alex Peshkoff > wrote: >>> On Tue, 12 Aug 2014 10:37:21 +0400, Alex Peshkoff >>> wrote: On 08/11/14 22:29, Tom Coleman wrote: > I interface a proprietary language with Firebird, Oracle, and > Sybase/MS-SQL

Re: [Firebird-devel] Error messages how-to

2014-08-12 Thread Dmitry Yemanov
12.08.2014 18:03, Mark Rotteveel wrote: > Doesn't this miss a "add specific standard (or vendor-specific) SQL state" > somewhere? It's hidden inside item (3) ;-) Dmitry -- Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] Error messages how-to

2014-08-12 Thread Mark Rotteveel
On Tue, 12 Aug 2014 17:51:36 +0400, Dmitry Yemanov wrote: > 12.08.2014 17:34, Dimitry Sibiryakov wrote: >> >> Is there a simple step-by-step guide how to add new error codes and >> corresponding >> messages into the engine and firebird.msg? > > 1) Choose the facility for your error > 2) Bump next

Re: [Firebird-devel] Error messages how-to

2014-08-12 Thread Dmitry Yemanov
12.08.2014 17:56, Dimitry Sibiryakov wrote: >> 1) Choose the facility for your error > > How to choose between JRD and DSQL? When in doubts, go for JRD. Dmitry -- Firebird-Devel mailing list, web interface at https:/

Re: [Firebird-devel] Error messages how-to

2014-08-12 Thread Dimitry Sibiryakov
12.08.2014 15:51, Dmitry Yemanov wrote: > 1) Choose the facility for your error How to choose between JRD and DSQL? -- WBR, SD. -- Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists

Re: [Firebird-devel] Error messages how-to

2014-08-12 Thread Dmitry Yemanov
12.08.2014 17:34, Dimitry Sibiryakov wrote: > > Is there a simple step-by-step guide how to add new error codes and > corresponding > messages into the engine and firebird.msg? 1) Choose the facility for your error 2) Bump next error number in facilities.sql for your facility 3) Add a record into

[Firebird-devel] Error messages how-to

2014-08-12 Thread Dimitry Sibiryakov
Hello, All. Is there a simple step-by-step guide how to add new error codes and corresponding messages into the engine and firebird.msg? -- WBR, SD. -- Firebird-Devel mailing list, web interface at https://l

[Firebird-devel] [FB-Tracker] Created: (CORE-4518) Show in trace new counters have been added to the MON$RECORD_STATS

2014-08-12 Thread Simonov Denis (JIRA)
Show in trace new counters have been added to the MON$RECORD_STATS -- Key: CORE-4518 URL: http://tracker.firebirdsql.org/browse/CORE-4518 Project: Firebird Core Issue Type: Impr

Re: [Firebird-devel] New Interface

2014-08-12 Thread Mark Rotteveel
On Tue, 12 Aug 2014 13:18:31 +0400, Alex Peshkoff wrote: >> On Tue, 12 Aug 2014 10:37:21 +0400, Alex Peshkoff >> wrote: >>> On 08/11/14 22:29, Tom Coleman wrote: I interface a proprietary language with Firebird, Oracle, and Sybase/MS-SQL. There is never any case where I would

Re: [Firebird-devel] New Interface

2014-08-12 Thread Alex Peshkoff
On 08/12/14 12:13, Mark Rotteveel wrote: > <53e9b621.5050...@mail.ru> > Message-ID: > X-Sender: m...@lawinegevaar.nl > User-Agent: RoundCube Webmail/0.2 > > On Tue, 12 Aug 2014 10:37:21 +0400, Alex Peshkoff > wrote: >> On 08/11/14 22:29, Tom Coleman wrote: >>> I interface a proprietary language w

Re: [Firebird-devel] New Interface

2014-08-12 Thread Tony Whyman
Mark, A good post as this sums up the issue. I only hope that the core team are listening as what happens to a project when the developers ignore the users? On 12/08/14 09:13, Mark Rotteveel wrote: The main point of an API is to allow developers to*use* Firebird, so please do not alienate t

Re: [Firebird-devel] New Interface

2014-08-12 Thread Lester Caine
On 12/08/14 09:13, Mark Rotteveel wrote: > <53e9b621.5050...@mail.ru> > Message-ID: > X-Sender: m...@lawinegevaar.nl > User-Agent: RoundCube Webmail/0.2 > > On Tue, 12 Aug 2014 10:37:21 +0400, Alex Peshkoff > wrote: >> On 08/11/14 22:29, Tom Coleman wrote: >>> I interface a proprietary language

Re: [Firebird-devel] New Interface

2014-08-12 Thread Dimitry Sibiryakov
12.08.2014 10:16, Alex Peshkoff wrote: >> Say, I have in application Firebird exception class with following >> members: gdscode, >> >SQLCode, text, origin. How your templates will know what values set to >> >these members >> >before throwing? >> > > May be IBPP sources can help you answer y

Re: [Firebird-devel] New Interface

2014-08-12 Thread Alex Peshkoff
On 08/12/14 12:07, Dimitry Sibiryakov wrote: > 12.08.2014 9:50, Alex Peshkoff wrote: >> Police classes seem to be ideal for exception type control. > I just wonder how these police classes can find out a way to store status > into custom > user-made class. > Say, I have in application Fire

Re: [Firebird-devel] New Interface

2014-08-12 Thread Mark Rotteveel
<53e9b621.5050...@mail.ru> Message-ID: X-Sender: m...@lawinegevaar.nl User-Agent: RoundCube Webmail/0.2 On Tue, 12 Aug 2014 10:37:21 +0400, Alex Peshkoff wrote: > On 08/11/14 22:29, Tom Coleman wrote: >> I interface a proprietary language with Firebird, Oracle, and >> Sybase/MS-SQL. >> >> There

Re: [Firebird-devel] New Interface

2014-08-12 Thread Dimitry Sibiryakov
12.08.2014 9:50, Alex Peshkoff wrote: > Police classes seem to be ideal for exception type control. I just wonder how these police classes can find out a way to store status into custom user-made class. Say, I have in application Firebird exception class with following members: gdscode,

Re: [Firebird-devel] New Interface

2014-08-12 Thread Alex Peshkoff
On 08/11/14 22:40, Adriano dos Santos Fernandes wrote: > On 11/08/2014 15:29, Tom Coleman wrote: >> I interface a proprietary language with Firebird, Oracle, and Sybase/MS-SQL. >> >> There is never any case where I would want to see std:exception. >> >> Could it be time to start thinking about bury

Re: [Firebird-devel] New Interface

2014-08-12 Thread Dimitry Sibiryakov
12.08.2014 8:34, Alex Peshkoff wrote: > I.e. you suggest to have different interface on different borders. > Afraid you will soon say that it makes overall system much cleaner Cleaner - may be no: garbage code will be just swept from core to borders. Faster - yes: one parameter less on each