Re: [Firebird-devel] Some aspects of the optimizer hints

2014-01-07 Thread Mark Rotteveel
On Mon, 6 Jan 2014 11:38:32 -0500, Ann Harrison a...@qbeast.net wrote: The FIRST keyword was added to Firebird's SQL in version 1.0 or 1.1 - in 2000 0r 2001, but the use of FIRST in InterBase goes back much further. It was part of GDML - and it's purpose was to signal that the query should be

Re: [Firebird-devel] Some aspects of the optimizer hints

2014-01-07 Thread Mark Rotteveel
On Tue, 07 Jan 2014 12:28:11 +0400, Alex peshk...@mail.ru wrote: So, historically, no, it's neither a workaround nor a hack. Parsing SQL comments ... that sounds like a hack to me. Adding yet another non-standard keyword when one already exists and does what you want doesn't appeal all that

Re: [Firebird-devel] Some aspects of the optimizer hints

2014-01-07 Thread Mark Rotteveel
FOR) for 'helping' the optimizer decide on a plan by providing exemplar values for parameters. Mark -- Mark Rotteveel -- Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear

Re: [Firebird-devel] Firebird Interbase Database engine hacks or rtfm

2014-01-08 Thread Mark Rotteveel
On Wed, 08 Jan 2014 19:13:02 +0400, Alex peshk...@mail.ru wrote: On 01/07/2014 01:11 PM, marius adrian popa wrote: Notes on database security assesment http://www.slideshare.net/qqlan/firebird-interbase-database-engine-hacks-or-rtfm I see 2 kinds of samples - mixed DDL/DML statements and

Re: [Firebird-devel] Firebird Interbase Database engine hacks or rtfm

2014-01-08 Thread Mark Rotteveel
On Wed, 08 Jan 2014 19:41:16 +0400, Alex peshk...@mail.ru wrote: On 01/08/2014 07:22 PM, Sergey Mereutsa wrote: Hello Alex, ... skipped ... A I.e. on my mind the presentation is about nothing. The presentation is about If you have armed gun - you can shut your leg :) I think, the main

Re: [Firebird-devel] SYSDBA (Chicken/egg)

2014-02-27 Thread Mark Rotteveel
On Thu, 27 Feb 2014 21:32:20 +1300, Helen Borrie hele...@tpg.com.au wrote: With Fb 3 alpha 2 on Windows, is there any way to get SYSDBA into the security database, other than installing everything on Linux first, initializing it there and file-copying the security db to the Windows box? As far

Re: [Firebird-devel] ICU configuration

2014-02-27 Thread Mark Rotteveel
On Thu, 27 Feb 2014 10:31:21 +, Lester Caine les...@lsces.co.uk wrote: There is currently a discussion on the PHP developer list re - Unicode. PHP has used ICU via extensions for some time, but always used the distributed versions. The current thoughts relate to making the core of PHP

Re: [Firebird-devel] SYSDBA (Chicken/egg)

2014-02-27 Thread Mark Rotteveel
On 27-2-2014 19:49, Helen Borrie wrote: At 12:59 a.m. 28/02/2014, Mark Rotteveel wrote: On Thu, 27 Feb 2014 21:32:20 +1300, Helen Borrie hele...@tpg.com.au wrote: With Fb 3 alpha 2 on Windows, is there any way to get SYSDBA into the security database, other than installing everything on Linux

Re: [Firebird-devel] isc_random

2014-03-04 Thread Mark Rotteveel
translated error-messages is a good reason to stop using error numbers. Some errors can occur in multiple places, in that case having a single definition is better. Mark -- Mark Rotteveel -- Subversion Kills Productivity. Get

Re: [Firebird-devel] MySQL versus Firebird

2014-03-11 Thread Mark Rotteveel
On Tue, 11 Mar 2014 12:59:32 +0400, Dmitry Kovalenko dmitry.lipe...@gmail.com wrote: you can check the google cache Why should i spend my time to investigate (!) how to access it ??? Does it have something important for Firebird ? Something new ? Or what ? Allow me behead him.

Re: [Firebird-devel] UDF's in Firebird 3.0

2014-03-14 Thread Mark Rotteveel
On Thu, 13 Mar 2014 14:33:19 -0300, Weverton Gomes wever...@gmail.com wrote: Hi, I have just started testing FB 3.0 Alpha 2 (32 bits) and I'm getting in trouble using the same UDF's I already use in FB 2.5. I'm getting the known message: Invalid token. invalid request BLR at offset 35.

Re: [Firebird-devel] New API and SQL_VARYING

2014-03-21 Thread Mark Rotteveel
On Fri, 21 Mar 2014 14:18:07 +0100, Dimitry Sibiryakov s...@ibphoenix.com wrote: Hello, All. In new API data length returned for SQL_VARYING still two bytes smaller than real buffer requirement. Does it have a justification other than make everything the same way as it was in old

Re: [Firebird-devel] New API and SQL_VARYING

2014-03-21 Thread Mark Rotteveel
On Fri, 21 Mar 2014 16:23:38 +0100, Dimitry Sibiryakov s...@ibphoenix.com wrote: 21.03.2014 14:29, Mark Rotteveel wrote: AFAIK the length is the maximum length (in bytes) of the field, not of the buffer. What do you call field length? In ODS (AFAIK) VARCHAR is kept with these two

Re: [Firebird-devel] Created: (CORE-4368) Provide name of TABLE / VIEW when some statement violates CHECK.

2014-03-28 Thread Mark Rotteveel
On Fri, 28 Mar 2014 16:28:40 +0100, Dimitry Sibiryakov s...@ibphoenix.com wrote: 28.03.2014 16:23, Adriano dos Santos Fernandes wrote: The only problem would be old server accessed with new client and message file. Exactly because of this old messages must not be changed this way, new

Re: [Firebird-devel] Bad constant specification in common.h

2014-04-11 Thread Mark Rotteveel
On Thu, 10 Apr 2014 23:10:23 -0400, Claudio Valderrama C. cva...@usa.net wrote: However, do we support MSVC 2003 and earlier? In this case, we would need Please don't. I would think by now the absolute minimum should be MSVC 2010. Visual Studio (and related libraries like MS VC) have an

Re: [Firebird-devel] -IProvider::attachDatabase failed when loading mapping cache

2014-04-11 Thread Mark Rotteveel
On Fri, 11 Apr 2014 15:36:28 +0400, Alex Peshkoff peshk...@mail.ru wrote: Sooner of all - new code added. I just replaced Firebird 3 Alpha 2 with the latest snapshot and I also get this error on attach in Flamerobin, and when I run tests in Jaybird they simply hang in receiving the response

Re: [Firebird-devel] Bad constant specification in common.h

2014-04-12 Thread Mark Rotteveel
On Fri, 11 Apr 2014 12:54:33 -0400, Claudio Valderrama C. cva...@usa.net wrote: But we still carry code that depends on VS2003 to decide whether to enable Win9x support, no joke. That sounds like code that is long overdue for removal... Mark

Re: [Firebird-devel] Bad constant specification in common.h

2014-04-12 Thread Mark Rotteveel
On Sat, 12 Apr 2014 09:53:07 +0300, marius adrian popa map...@gmail.com wrote: That is needed only for Nikolay Samofatov builds http://firebird.1100200.n4.nabble.com/VS2003-support-in-HEAD-tt1125352.html#none That was over five years ago; and I don't think Firebird should continue to support

Re: [Firebird-devel] Planning the post v3 development

2014-04-28 Thread Mark Rotteveel
are implementation-defined. I'd suggest that instead the maximum precision of DECIMAL and NUMERIC should be increased. Mark -- Mark Rotteveel -- Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE Instantly run your

Re: [Firebird-devel] Planning the post v3 development

2014-04-29 Thread Mark Rotteveel
On Mon, 28 Apr 2014 15:36:45 -0300, Adriano dos Santos Fernandes adrian...@gmail.com wrote: On 28/04/2014 15:30, Dmitry Yemanov wrote: 2. Add JAVA, .NET PROCEDURE and FUNCTION (not just C++) You can do it in v3 as soon as someone writes the required interfacing plugins (external engines).

Re: [Firebird-devel] Planning the post v3 development

2014-04-29 Thread Mark Rotteveel
On Tue, 29 Apr 2014 11:58:57 +0400, Dmitry Yemanov firebi...@yandex.ru wrote: Who should initiate that dedicated listener deamon/user after a server restart? Should the server attach all the databases itself to check whether one needs a startup? What about databases unknown to the server

Re: [Firebird-devel] Jobs/Scheduler

2014-04-29 Thread Mark Rotteveel
daemons. IMHO an embedded instance shouldn't do that. Only a normal server install, if necessary through a separate daemon process (/windows service) that is started separately. -- Mark Rotteveel -- Accelerate Dev Cycles

Re: [Firebird-devel] Feature request discussion (Reply to Planning the post v3 development)

2014-05-01 Thread Mark Rotteveel
that with the exception of a random number generator, the default for UDF should be DETERMINISTIC (Over 99% of UDFs are not volatile). Given the way an optimizer could use this hint, it is better to be on the side of caution and require explicit declaration of DETERMINISTIC. Mark -- Mark Rotteveel

Re: [Firebird-devel] Feature request discussion (Reply to Planning the post v3 development)

2014-05-01 Thread Mark Rotteveel
On 30-4-2014 11:50, Molnár Attila wrote: *TRIGGER : NEW/OLD values accessible by column name, and column number (PSQL)* - e.g.: NEW['id'], NEW[0] Just an aside: in SQL indexes are 1-based, not 0-based. Mark -- Mark Rotteveel

[Firebird-devel] Running firebird.exe as application

2014-05-06 Thread Mark Rotteveel
been unable to find anything regarding the commandline options of firebird.exe and I only thought of -m as it is also added to the commandline of the service executable. So: what is the meaning of -m, and why is it necessary? Mark -- Mark Rotteveel

Re: [Firebird-devel] Running firebird.exe as application

2014-05-06 Thread Mark Rotteveel
be SharedDatabase=true by default (or always), this would also allow gsec to work without an explicit -database option when the server is running. Mark -- Mark Rotteveel -- Is your legacy SCM system holding you back? Join Perforce

[Firebird-devel] Cleaning up transaction info

2014-05-06 Thread Mark Rotteveel
changes to disallow access to the system tables this last step no longer works. This leads me to the questions: 1) When are prepared or rolled back transactions removed from RDB$TRANSACTIONS? Or are they kept indefinitely? 2) Is there an alternative to removing this information? Mark -- Mark

Re: [Firebird-devel] Cleaning up transaction info

2014-05-07 Thread Mark Rotteveel
On Wed, 7 May 2014 09:38:16 +0300, Vlad Khorsun hv...@users.sourceforge.net wrote: This leads me to the questions: 1) When are prepared or rolled back transactions removed from RDB$TRANSACTIONS? Or are they kept indefinitely? Its never removed. And i see no problem with it. I assume

Re: [Firebird-devel] Cleaning up transaction info

2014-05-07 Thread Mark Rotteveel
On Wed, 7 May 2014 05:00:43 -0400, Claudio Valderrama C. cva...@usa.net wrote: This leads me to the questions: 1) When are prepared or rolled back transactions removed from RDB$TRANSACTIONS? Or are they kept indefinitely? 2) Is there an alternative to removing this information? Mark, I had

Re: [Firebird-devel] Cleaning up transaction info

2014-05-07 Thread Mark Rotteveel
) and one for older versions). Does anyone know if blob equality checks work with Type 7 blobs (and if so: starting at which Firebird version)? Mark -- Mark Rotteveel -- Is your legacy SCM system holding you back? Join

Re: [Firebird-devel] Cleaning up transaction info

2014-05-08 Thread Mark Rotteveel
On Wed, 7 May 2014 18:44:13 -0400, Claudio Valderrama C. cva...@usa.net wrote: As the value of RDB$TRANSACTION_STATE is modified, I assume this code (or something very similar) is actually called, but then the `else` branch shown above. What does TRA_prepare2 mean here? Note that the specific

Re: [Firebird-devel] Multiple WHEN handlers

2014-05-09 Thread Mark Rotteveel
On Fri, 09 May 2014 11:15:36 +0200, Dimitry Sibiryakov s...@ibphoenix.com wrote: Hello, All. Must multiple error handlers be allowed for the same block? I.e. something like this: BEGIN WHEN SQLCODE -803 DO WHEN GDSCODE isc_key_violation DO WHEN ANY DO . END

Re: [Firebird-devel] Cleaning up transaction info

2014-05-10 Thread Mark Rotteveel
On Sat, 10 May 2014 10:53:05 +0300, Vlad Khorsun hv...@users.sourceforge.net wrote: I will see if I can come up with a solution for Firebird 3 without needing RDB$TRANSACTIONS to be unprotected, but doesn't - potentially - degenerate to iterating over a list of thousands if not millions of

Re: [Firebird-devel] Cleaning up transaction info

2014-05-10 Thread Mark Rotteveel
On Sat, 10 May 2014 13:46:46 +0300, Vlad Khorsun hv...@users.sourceforge.net wrote: Surprise : after you got list of tx numbers it can be used to query RDB$TRANSACTIONS for additional info. But then I could just as well query RDB$TRANSACTIONS directly. I don't know the Firebird

Re: [Firebird-devel] IResultSet Error when connecting to Firebird 3 build 31141

2014-05-19 Thread Mark Rotteveel
On Mon, 19 May 2014 13:13:44 +0200, Martijn Tonies (Upscene Productions) m.ton...@upscene.com wrote: Hi, I just downloaded that particular build, installed it, but I get the following error when trying to connect to it via a Delphi application: --- Invalid

Re: [Firebird-devel] IDENTITY documentation error?

2014-05-21 Thread Mark Rotteveel
On Wed, 21 May 2014 16:34:06 +0200, Martijn Tonies (Upscene Productions) m.ton...@upscene.com wrote: Hi all, Reading the doc on IDENTITY columns says: == Implementation: Two columns have been inserted in RDB$RELATION_FIELDS: RDB$GENERATOR_NAME and RDB$IDENTITY_TYPE.

Re: [Firebird-devel] DDL Triggers, how to retrieve type?

2014-05-22 Thread Mark Rotteveel
On Thu, 22 May 2014 18:24:12 +0300, Vlad Khorsun hv...@users.sourceforge.net wrote: Yes, it's a bit mask. See the constants: Shouldn't it be present in RDB$TYPES, as all other special numbers ? I think that would be helpful. Mark

Re: [Firebird-devel] DDL Triggers, how to retrieve type?

2014-05-23 Thread Mark Rotteveel
On Fri, 23 May 2014 09:03:35 +0200, Paul Beach pbe...@ibphoenix.com wrote: - Any other suggestion? Drop dialect 1 support. Allow dialect 1 to have access to BIGINT fields. I don't have to work for this to happen, so I don't really have a say... but the question that arises is why?

Re: [Firebird-devel] DDL Triggers, how to retrieve type?

2014-05-23 Thread Mark Rotteveel
On Fri, 23 May 2014 11:43:56 +0200, Dimitry Sibiryakov s...@ibphoenix.com wrote: 23.05.2014 11:29, Alex Peshkoff wrote: It's not absolutely required to have bigint column - it's enough to store bit number, which is less than 64. It makes impossible to use JOIN to retrieve trigger's type

Re: [Firebird-devel] DDL Triggers, how to retrieve type?

2014-05-23 Thread Mark Rotteveel
On Fri, 23 May 2014 12:55:26 +0200, Dimitry Sibiryakov s...@ibphoenix.com wrote: 23.05.2014 12:48, Vlad Khorsun wrote: This useless garbage is required for self-documenting Self-documenting of what? Isn't list in header enough for this purpose?.. No, because looking in the source of

Re: [Firebird-devel] DDL Triggers, how to retrieve type?

2014-05-23 Thread Mark Rotteveel
On Fri, 23 May 2014 13:02:32 +0200, Paul Beach pbe...@ibphoenix.com wrote: Sorry, but IMHO declaring dialect 1 as legacy and announcing dropping of support was already done with Interbase 6.0. The Interbase 6.0 Getting Started Guide explicitly states that moving from Interbase 5 to Interbase 6

Re: [Firebird-devel] DDL Triggers, how to retrieve type?

2014-05-25 Thread Mark Rotteveel
that, not continue supporting something that was considered deprecated 15 years ago. And if that is really too much work, we should consider providing a number of UDFs (not internal functions!) that do the calculations the old way. Mark -- Mark Rotteveel

Re: [Firebird-devel] Feature request discussion (Reply to Planning the post v3 development)

2014-05-27 Thread Mark Rotteveel
/tree/client-java/trunk/src/documentation/faq.md ) Mark -- Mark Rotteveel -- The best possible search technologies are now affordable for all companies. Download your FREE open source Enterprise Search Engine today! Our

Re: [Firebird-devel] dockerize Firebird ?

2014-06-16 Thread Mark Rotteveel
On 12-6-2014 16:16, Philippe Makowski wrote: Hi, Docker 1.0 is there, any one interested in getting Firebird officially Dockerized? and to work on ? http://www.zdnet.com/docker-makes-ready-to-run-container-apps-available-730343/ What would be necessary to do that? Mark -- Mark

Re: [Firebird-devel] dockerize Firebird ?

2014-06-16 Thread Mark Rotteveel
On 16-6-2014 18:54, W O wrote: Yes, that's my question too. Which are the advantages of dockerize Firebird? Actually my question was what needed to be done to 'dockerize' Firebird ;) -- Mark Rotteveel -- HPCC Systems

Re: [Firebird-devel] UDR example?

2014-06-19 Thread Mark Rotteveel
in src/native/jaygds/source/ ). But as I said AFAIK it isn't up to date with the latest API. Mark -- Mark Rotteveel -- HPCC Systems Open Source Big Data Platform from LexisNexis Risk Solutions Find What Matters Most

Re: [Firebird-devel] Cursor stability in READ COMMITTED transactions

2014-06-28 Thread Mark Rotteveel
of significant changes is implementation-defined. — If the cursor is asensitive, then the visibility of significant changes is implementation-dependent. -- Mark Rotteveel -- Open source business process management suite

Re: [Firebird-devel] Cursor stability in READ COMMITTED transactions

2014-06-28 Thread Mark Rotteveel
to use READ COMMITTED SNAPSHOT as the default when READ COMMITTED is used. Mark -- Mark Rotteveel -- Open source business process management suite built on Java and Eclipse Turn processes into business applications

Re: [Firebird-devel] Cursor stability in READ COMMITTED transactions

2014-06-28 Thread Mark Rotteveel
the database to downgrade (eg a snapshot transaction should never be sensitive, so the statement will be downgraded to insensitive). Mark -- Mark Rotteveel -- Open source business process management suite built on Java and Eclipse

Re: [Firebird-devel] Cursor stability in READ COMMITTED transactions

2014-06-28 Thread Mark Rotteveel
-- Mark Rotteveel -- 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

Re: [Firebird-devel] Cursor stability in READ COMMITTED transactions

2014-06-28 Thread Mark Rotteveel
On 28-6-2014 09:51, Dmitry Yemanov wrote: 28.06.2014 11:34, Mark Rotteveel wrote: Looking at the SQL standard, sensitivity should really be a property of the statement (or more correctly: its cursor), not of the transaction. True, but having all cursors insensitive by default per the given

Re: [Firebird-devel] Cursor stability in READ COMMITTED transactions

2014-06-28 Thread Mark Rotteveel
On 28-6-2014 09:49, Dmitry Yemanov wrote: 28.06.2014 11:01, Mark Rotteveel wrote: If a cursor is open, and the SQL-transaction in which the cursor was opened makes a significant change to SQL-data At the first glance, this is what we called cursor stability and have fixed in FB3

[Firebird-devel] Using contents of status vector

2014-06-28 Thread Mark Rotteveel
heuristic (eg if the errorcode is isc_dsql_error then use the next error code, or always use the last one). Mark -- Mark Rotteveel -- Open source business process management suite built on Java and Eclipse Turn processes

Re: [Firebird-devel] Cursor stability in READ COMMITTED transactions

2014-06-28 Thread Mark Rotteveel
On 28-6-2014 10:36, Dimitry Sibiryakov wrote: 28.06.2014 9:46, Mark Rotteveel wrote: On 25-6-2014 15:21, Dimitry Sibiryakov wrote: This is right only for those who set up READ COMMITTED transaction isolation level which is not default. That is not true, READ_COMMITTED is the default

Re: [Firebird-devel] Using contents of status vector

2014-06-28 Thread Mark Rotteveel
to a meaningful error. Mark -- Mark Rotteveel -- 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

Re: [Firebird-devel] Using contents of status vector

2014-06-29 Thread Mark Rotteveel
codes (and individual messages) as an exception cause. See http://sourceforge.net/p/firebird/code/59791/#diff-6 Mark -- Mark Rotteveel -- Open source business process management suite built on Java and Eclipse Turn

[Firebird-devel] Meaning of incarnation

2014-07-01 Thread Mark Rotteveel
as well, but I am not getting any closer to its meaning. Currently Jaybird always sends 0 (and I believe other wire protocol implementations do as well). Mark -- Mark Rotteveel -- Open source business process

Re: [Firebird-devel] Meaning of incarnation

2014-07-01 Thread Mark Rotteveel
to find what the parameter level does). Mark -- Mark Rotteveel -- Open source business process management suite built on Java and Eclipse Turn processes into business applications with Bonita BPM Community Edition Quickly

Re: [Firebird-devel] DDL permissions

2014-07-05 Thread Mark Rotteveel
based on the name), I'd propose: * dyn_no_priv (335545094): 42000 (syntax error or access rule violation) * dsql_cant_grant_option (336397330) : 42000 (syntax error or access rule violation), I had hoped there was a closer one, but there doesn't appear to be. Mark -- Mark Rotteveel

Re: [Firebird-devel] DDL permissions

2014-07-05 Thread Mark Rotteveel
On 5-7-2014 08:30, Mark Rotteveel wrote: For 2 (entirely based on the name), I'd propose: * dyn_no_priv (335545094): 42000 (syntax error or access rule violation) * dsql_cant_grant_option (336397330) : 42000 (syntax error or access rule violation), I had hoped there was a closer one

Re: [Firebird-devel] dockerize Firebird ?

2014-07-05 Thread Mark Rotteveel
working knowledge of 1) linux and 2) firebird on linux does this. Mark -- Mark Rotteveel -- Open source business process management suite built on Java and Eclipse Turn processes into business applications with Bonita BPM

[Firebird-devel] Protocol versions

2014-07-12 Thread Mark Rotteveel
Is there any documentation on the changes between protocol versions, or do I need to reverse engineer this? Mark -- Mark Rotteveel -- Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists

[Firebird-devel] op_insert implementation removed in FB 3?

2014-07-12 Thread Mark Rotteveel
!= XDR_FREE) { gds__log(xdr_packet: operation %d not recognized\n, p-p_operation); } #endif return P_FALSE(xdrs, p); Was this functionality always broken, or has this been forgotten in the implementation of Firebird 3? Mark -- Mark

Re: [Firebird-devel] op_insert implementation removed in FB 3?

2014-07-12 Thread Mark Rotteveel
On 12-7-2014 20:36, Dmitry Yemanov wrote: 12.07.2014 21:22, Mark Rotteveel wrote: Was this functionality always broken, or has this been forgotten in the implementation of Firebird 3? It was deprecated and not supported by the new API. Too bad, it would have been nice to have this ;) Mark

Re: [Firebird-devel] op_insert implementation removed in FB 3?

2014-07-12 Thread Mark Rotteveel
On 12-7-2014 20:49, Adriano dos Santos Fernandes wrote: Em 12-07-2014 15:40, Mark Rotteveel escreveu: On 12-7-2014 20:36, Dmitry Yemanov wrote: 12.07.2014 21:22, Mark Rotteveel wrote: Was this functionality always broken, or has this been forgotten in the implementation of Firebird 3

Re: [Firebird-devel] op_insert implementation removed in FB 3?

2014-07-14 Thread Mark Rotteveel
bother with the other cursor operations. Mark -- Mark Rotteveel -- Want fast and easy access to all the code in your enterprise? Index and search up to 200,000 lines of code with a free copy of Black Duck#174; Code Sight

Re: [Firebird-devel] C++ and the API

2014-07-15 Thread Mark Rotteveel
On Tue, 15 Jul 2014 15:49:05 +0200, Dimitry Sibiryakov s...@ibphoenix.com wrote: 15.07.2014 15:41, Dmitry Yemanov wrote: This one is surely a phantom: Sure it is. It even refuses to open (leave alone absence of links from official www server).

Re: [Firebird-devel] Design notes newer protocol versions

2014-07-19 Thread Mark Rotteveel
On 19-7-2014 11:52, Mark Rotteveel wrote: Are there any design notes on protocol version 11, 12 and 13. With version 11 I am running into problems with hanging connections after executing DDL which seems to indicate that I expect more responses than I receive. I haven't been able to find

Re: [Firebird-devel] setCursorName in IResultSet rather than IStatement

2014-07-24 Thread Mark Rotteveel
that has an open cursor should raise an invalid cursor state exception. As far as I understand it, you can't have an IResultSet unless the result set is open, so setting the cursor name on an IResultSet is not very logical. Mark -- Mark Rotteveel

Re: [Firebird-devel] setCursorName in IResultSet rather than IStatement

2014-07-24 Thread Mark Rotteveel
? A cursor name should remain set for the lifetime of the statement, unless it is explicitly set to a different value. Mark -- Mark Rotteveel -- Want fast and easy access to all the code in your enterprise? Index

Re: [Firebird-devel] setCursorName in IResultSet rather thanIStatement

2014-07-24 Thread Mark Rotteveel
result sets). Mark -- Mark Rotteveel -- Want fast and easy access to all the code in your enterprise? Index and search up to 200,000 lines of code with a free copy of Black Duck Code Sight - the same software that powers

Re: [Firebird-devel] setCursorName in IResultSet rather than IStatement

2014-07-24 Thread Mark Rotteveel
On 24-7-2014 18:49, Dimitry Sibiryakov wrote: 24.07.2014 18:39, Mark Rotteveel wrote: A cursor name should remain set for the lifetime of the statement, unless it is explicitly set to a different value. Ok. If there is two statements: one with cursor name and other using WHERE CURRENT

Re: [Firebird-devel] setCursorName in IResultSet rather thanIStatement

2014-07-24 Thread Mark Rotteveel
-- Mark Rotteveel -- Want fast and easy access to all the code in your enterprise? Index and search up to 200,000 lines of code with a free copy of Black Duck Code Sight - the same software that powers the world's largest code

Re: [Firebird-devel] setCursorName in IResultSet rather than IStatement

2014-07-25 Thread Mark Rotteveel
On Thu, 24 Jul 2014 23:30:15 +0300, Vlad Khorsun hv...@users.sourceforge.net wrote: and most implementations I know with multiple result sets either require or allow only one result set open at a time (and if they allow multiple result sets open, that is usually achieved by fully reading and

Re: [Firebird-devel] setCursorName in IResultSet rather than IStatement

2014-07-25 Thread Mark Rotteveel
On Thu, 24 Jul 2014 23:08:56 -0300, Jim Starkey j...@jimstarkey.net wrote: No, it supported multiple active statements since Groton Database Systems time. And before that, Rdb/ELN. Why do people make up facts to bolster losing arguments? You are responding to Vlad, but given your other

Re: [Firebird-devel] setCursorName in IResultSet rather than IStatement

2014-07-25 Thread Mark Rotteveel
On Fri, 25 Jul 2014 12:49:37 +0400, Alex Peshkoff peshk...@mail.ru wrote: On 07/25/14 03:23, Adriano dos Santos Fernandes wrote: Em 24-07-2014 17:30, Vlad Khorsun escreveu: So, currently we really have no way to call IStatement::openCursor... BTW, isn't openCursor a bad name too,

Re: [Firebird-devel] setCursorName in IResultSet rather than IStatement

2014-07-25 Thread Mark Rotteveel
On Fri, 25 Jul 2014 07:33:48 -0300, Jim Starkey j...@jimstarkey.net wrote: That may have been what you meant, but it wasn't what you said. Context is everything, and I'll repeat the context again: What about more than one simultaneously active result set produced by the same statement ?

Re: [Firebird-devel] New Interface

2014-07-25 Thread Mark Rotteveel
is the difference with JDBC as you see it? JDBC also has createStatement which creates a statement handle that can be used to execute arbitrary SQL statements *without* parameters. Mark -- Mark Rotteveel -- Want fast

Re: [Firebird-devel] New Interface

2014-07-25 Thread Mark Rotteveel
currently doesn't do). Mark -- Mark Rotteveel -- Want fast and easy access to all the code in your enterprise? Index and search up to 200,000 lines of code with a free copy of Black Duck Code Sight - the same software

Re: [Firebird-devel] New Interface

2014-07-29 Thread Mark Rotteveel
about adopting Jaybird as the main Firebird API and telling all other languages well good luck with talking to Java. I think use of the term JDBC in this context is confusing. Mark -- Mark Rotteveel -- Infragistics

Re: [Firebird-devel] New Interface

2014-07-29 Thread Mark Rotteveel
Java), and some also provide a Type 2 (Java + native dependency) driver. Most users prefer a Type 4 because it doesn't require the hassle of correctly loading native dependencies. Mark -- Mark Rotteveel -- Infragistics

Re: [Firebird-devel] New Interface

2014-07-29 Thread Mark Rotteveel
. They are either lousy for money or... And what could be holding back everyone else? Bribes that they could get from Oracle sellers for new big contracts?.. Dmitry, I don't think this contributes to the discussion. Mark -- Mark Rotteveel

Re: [Firebird-devel] New Interface

2014-07-29 Thread Mark Rotteveel
On 29-7-2014 19:20, Mark Rotteveel wrote: You'll find that a lot of JDBC drivers are a so-called Type 4 driver (pure Java), and some also provide a Type 2 (Java + native dependency) driver. Most users prefer a Type 4 because it doesn't require the hassle of correctly loading native

Re: [Firebird-devel] New Interface

2014-07-29 Thread Mark Rotteveel
On 29-7-2014 19:32, Dimitry Sibiryakov wrote: 29.07.2014 19:21, Mark Rotteveel wrote: Dmitry, I don't think this contributes to the discussion. I asked a question about reasons to get off from Delphi and got no answer. Can I a right to be pissed off a little?.. Actually, no. Tom

Re: [Firebird-devel] New Interface

2014-07-29 Thread Mark Rotteveel
. Yes, as far as I know client-side OCI and a Type 4 JDBC driver use the same wire protocol. Mark -- Mark Rotteveel -- Infragistics Professional Build stunning WinForms apps today! Reboot your WinForms applications

Re: [Firebird-devel] New Interface

2014-07-31 Thread Mark Rotteveel
a good binary protocol. Mark -- Mark Rotteveel -- Infragistics Professional Build stunning WinForms apps today! Reboot your WinForms applications with our WinForms controls. Build a bridge from your legacy apps

Re: [Firebird-devel] New Interface

2014-07-31 Thread Mark Rotteveel
On 31-7-2014 21:45, Mark Rotteveel wrote: On 31-7-2014 17:59, marius adrian popa wrote: ps: as for protocol we can have something better too but that is another discussion (I envision a SOA or rest api with json response https://wiki.postgresql.org/wiki/HTTP_API) That sounds nice

Re: [Firebird-devel] dtype_packed

2014-08-05 Thread Mark Rotteveel
On Mon, 04 Aug 2014 22:06:43 +0200, Dimitry Sibiryakov s...@ibphoenix.com wrote: Hello, All. What is subj? Not an authorative answer, but it seems that dtype_packed is also known in COBOL (and SAP) for a BCD (binary coded decimal). If that also applies to Firebird, I am not sure. Mark

[Firebird-devel] Handling isc_arg_interpreted in a statusvector

2014-08-09 Thread Mark Rotteveel
-- Mark Rotteveel -- Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] So, What's wrong with IBPP?

2014-08-11 Thread Mark Rotteveel
On Mon, 11 Aug 2014 09:18:58 +0100, Tony Whyman tony.why...@mccallumwhyman.com wrote: Firebird already has a C++ Interface that is widely if not universally used by C++ Developers (including myself) to access the Firebird API. This is IBPP. IMHO, it is well designed, stable and fit for purpose.

Re: [Firebird-devel] So, What's wrong with IBPP?

2014-08-11 Thread Mark Rotteveel
On Mon, 11 Aug 2014 11:14:28 +0100, Tony Whyman tony.why...@mccallumwhyman.com wrote: Mark, I expressed concern last week that there was too much heat on the list and got told that passion was good - you can't win :( Passion is good, until it becomes an obstacle. You said Personally I'd

Re: [Firebird-devel] New Interface

2014-08-11 Thread Mark Rotteveel
53e74645.6000...@ibphoenix.com Message-ID: a2df4a7f7c30f812d5f98c4057c3a...@imap.procolix.com X-Sender: m...@lawinegevaar.nl User-Agent: RoundCube Webmail/0.2 On Sun, 10 Aug 2014 12:15:33 +0200, Dimitry Sibiryakov s...@ibphoenix.com wrote: was a lot of languages (including Java and .NET in their

Re: [Firebird-devel] Handling isc_arg_interpreted in a statusvector

2014-08-11 Thread Mark Rotteveel
On Mon, 11 Aug 2014 16:48:48 +0400, Alex Peshkoff peshk...@mail.ru wrote: On 08/09/14 16:40, Mark Rotteveel wrote: Currently jaybird is handling isc_arg_interpreted the same as isc_arg_string and assumes it is a message parameter for the message of the previous error code. However I was just

Re: [Firebird-devel] New Interface

2014-08-11 Thread Mark Rotteveel
53e8afd3.3010...@mail.ru Message-ID: 37c270dc067e4e9904bdcf9108c6f...@imap.procolix.com X-Sender: m...@lawinegevaar.nl User-Agent: RoundCube Webmail/0.2 On Mon, 11 Aug 2014 15:58:11 +0400, Alex Peshkoff peshk...@mail.ru wrote: On 08/11/14 14:52, Mark Rotteveel wrote: IIRC, calling C interfaces

Re: [Firebird-devel] New Interface

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

Re: [Firebird-devel] New Interface

2014-08-12 Thread Mark Rotteveel
On Tue, 12 Aug 2014 13:18:31 +0400, Alex Peshkoff peshk...@mail.ru wrote: On Tue, 12 Aug 2014 10:37:21 +0400, Alex Peshkoff peshk...@mail.ru 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

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

2014-08-12 Thread Mark Rotteveel
On Tue, 12 Aug 2014 17:51:36 +0400, Dmitry Yemanov firebi...@yandex.ru 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)

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

2014-08-12 Thread Mark Rotteveel
important - not being able to (easily) diff or merge changes with a binary file where you can with a text file (or: sql script). Mark -- Mark Rotteveel -- Firebird-Devel mailing list, web interface at https

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

2014-08-12 Thread Mark Rotteveel
now, see: http://sourceforge.net/p/firebird/code/HEAD/tree/firebird/trunk/src/msgs/ Mark -- Mark Rotteveel -- Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] New Interface

2014-08-12 Thread Mark Rotteveel
that IDL, but as I said I don't think that is worth spending time on. [1] : https://code.google.com/p/jnaerator/ -- Mark Rotteveel -- Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists

<    1   2   3   4   5   6   7   8   9   10   >