Re: [firebird-support] Write UDF for 3.0 - Linux 64bit vs Windows 32bit

19.04.2018 15:34, Gabor Boros mlngl...@bgss.hu [firebird-support] wrote: > I found it! :-) Works on Linux too if "... MODULE_NAME > '/opt/firebird/UDF/MY_UDF';" It means that in your firebird.conf you have "UDFAccess = Full" which is not default and a very bad idea from security POV. --

Re: [firebird-support] Write UDF for 3.0 - Linux 64bit vs Windows 32bit

19.04.2018 13:16, Gabor Boros mlngl...@bgss.hu [firebird-support] wrote: > What I am doing wrong? Your function does not match its definition: "RETURNS PARAMETER 1" is not what you think. Use nm to check that TEST_UDF is really exported (remember about case sensitivity) and library is

Re: [firebird-support] Re: aliases.conf ignored?

25.04.2018 14:42, Harald Wolf leaw...@gmx.de [firebird-support] wrote: > What the heck is going wrong here? Process Monitor will show where Firebird look for aliases.conf, if at all. -- WBR, SD.

Re: [firebird-support] UDF "returning" BLOB slow after first call

23.04.2018 16:18, tvd...@ymail.com [firebird-support] wrote: > It seems to be that call to blob_put_segment that becomes slow. At first > usage of the UDF > it's almost instant, and after that it takes 15ms for every invocation. > > What causes this and can I avoid it? Data, returned from

Re: [firebird-support] Re: Firebird UDF Access configuration failing

27.03.2018 11:46, rgilland1...@gmail.com [firebird-support] wrote: > Have read closely the comments on the parameter, and cannot see how it > violates them "If you choose Restrict, *provide _';'_ -separated trees list*, where UDF libraries". -- WBR, SD.

Re: [firebird-support] Re: Firebird UDF Access configuration failing

27.03.2018 12:10, rgilland1...@gmail.com [firebird-support] wrote: > So how should I format the below? > > UdfAccess = Restrict UDF C:\Program Files (x86)\Firebird\Firebird_2_1\UDF Quoting Firebird.conf: > # DatabaseAccess = Restrict C:\DataBase > # DatabaseAccess = Restrict

Re: [firebird-support] Firebird UDF Access configuration failing

27.03.2018 12:49, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > Dimitry, it would be more helpful if you explicitly pointed out the > problem instead of giving vague hints. Yes, but giving a fish to a man used to be considered less helpful than teaching him how to fish.

Re: [firebird-support] Firebird log, error

29.03.2018 15:32, atuncce...@duzen.com.tr [firebird-support] wrote: > What might be causing this, any ideas? NULL pointer to an object most likely. See call stack for details. -- WBR, SD.

Re: [firebird-support] BLOB Not Found error

16.03.2018 15:26, shg_siste...@yahoo.com.ar [firebird-support] wrote: > The same applies if the record wasn't deleted but changed by another > transaction? Yes. From technical POV there is no difference between update and delete in Firebird. -- WBR, SD.

Re: [firebird-support] BLOB Not Found error

16.03.2018 14:47, shg_siste...@yahoo.com.ar [firebird-support] wrote: > Since some days ago I'm getting (it seems very occasionally and randomly) a > "blob not > found" error. > As far as I remember the problem happens during read operations: with > "locate" commands or > inside a "while not

Re: [firebird-support] Network disconnection

19.03.2018 10:34, atuncce...@duzen.com.tr [firebird-support] wrote: > Sometimes, on some computers the application crashes with this error, which > can be seen in > the event log: > > > Faulting application name: duzen_test.exe, version: 1.5.5.9106, time stamp: > 0x2a425e19 > Faulting module

Re: [firebird-support] Impossible to create a new database from a script

17.03.2018 18:07, 'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support] wrote: > Sorry, but I don't understand. The script file is a plain text file. Exactly because if that it has a definite encoding. And you, as its author, must know what encoding you used when

Re: [firebird-support] Trailing spaces behaviour

20.03.2018 15:34, Alexander Tabakov a.taba...@eklektica.com [firebird-support] wrote: > > Is this by design :) Yes, it is by SQL standard. -- WBR, SD.

Re: [firebird-support] Impossible to create a new database from a script

17.03.2018 14:50, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > >   DEFAULT CHARACTER SET ISO8859_1 > >   COLLATION ES_ES; > > > > What character set is the script file using? Is it using UTF-8 or > WIN1252? You are currently probably connecting using NONE. > > If the script

Re: [firebird-support] Execute Block: too many inserts

01.03.2018 19:43, ho...@agencybusys.com [firebird-support] wrote: > What is the best way to accomplish very large batches? If data is plain (without BLOBs) then using of external tables is the fastest way. -- WBR, SD.

Re: [firebird-support] Execute Block: too many inserts

01.03.2018 20:37, ho...@agencybusys.com [firebird-support] wrote: > I suspect it would be true if the source data was already in a table on the > server, but > mine is newly entered data by a user on a network client. In this case I'd suggest to use prepared statement in single transaction.

Re: [firebird-support] Dynamic PSQL (Execute Statement) in Stored Procedure With "SELECT / INTO"

25.04.2018 22:33, blackfalconsoftw...@outlook.com [firebird-support] wrote: > It seems that no matter how I try to implement the "INTO" clause against the > return > variable, when I run the procedure from my DB-Manager it yields an error... INTO belongs to EXECUTE STATEMENT clause, not to

Re: [firebird-support] Simultaneously host database from multiple engines

29.06.2018 5:04, s3057...@yahoo.com [firebird-support] wrote: > I have memory from a long time ago that Firebird used to refuse to connect if > it detected > that the server was hosted by some other Firebird instance. Is this check > broken, or is > this now permissible (or is my memory

Re: [firebird-support] Problems with database shadows

14.10.2018 12:33, Köditz, Martin martin.koed...@it-syn.de [firebird-support] wrote: > I’m trying to create a shadow file. But it doesn’t work. > > I have executed this command: > create shadow 1 '/srv/firebird/master.shd'; Did you commit? -- WBR, SD.

Re: [firebird-support] Firebird 3.0.4 unicode_ci_ai index problems

15.10.2018 15:00, Luis Forra luis.fo...@gmail.com [firebird-support] wrote: > What I'm doing wrong ? CI AI indexes are much bigger because of ICU implementation of index key derivation. You must increase page size of your database to return index depth to norm. -- WBR, SD.

Re: [firebird-support] Apparently timeout on queries

16.10.2018 14:02, Marcelo Guimaraes mfguimar...@gmail.com [firebird-support] wrote: > . the same query executing alone on the environment, manipulating 5 millions > of records, > return is in about 20 minutes; > > Anybody have passed for a situation like that or know what are causing it?

Re: [firebird-support] Firebird ins't updating date/time automatically

24.10.2018 16:30, elifla...@gmail.com [firebird-support] wrote: > I've tried it before, but it doesn't work too. I need to restart Firebird > service to work. AFAIR, the problem is caused by MSVC runtime. -- WBR, SD.

Re: [firebird-support] Firebird ins't updating date/time automatically

24.10.2018 16:43, elifla...@gmail.com [firebird-support] wrote: > And what can I do to fix it? Google how C/C++ application can detect timezone changes and apply this method into Firebird sources. Then build patched Firebird and if it works - submit a pull request. -- WBR, SD.

Re: [firebird-support] SP space chacarter problem in FB2.5

23.10.2018 17:31, Germán Balbi bal...@yahoo.com [firebird-support] wrote: > in the netx SP send the follow parameters Read Firebird Language Reference to find out the difference between CHAR and VARCHAR data types. -- WBR, SD.

Re: [firebird-support] Re: Code signed version of Firebird SQL executables?

28.10.2018 22:54, dco...@sympatico.ca [firebird-support] wrote: > Can that also be done through the services API? Yes. Whatever you can do with command-line utils, you can do via services. The only exception is fb_lock_print. -- WBR, SD.

Re: [firebird-support] Code signed version of Firebird SQL executables?

27.10.2018 21:58, dco...@sympatico.ca [firebird-support] wrote: > The obvious alternative would be for us to sign gbak.exe with our own > certificate, but > since it's not our code, that doesn't seem at all appropriate. A little less obvious alternative is to use Services API in your

Re: [firebird-support] Firebird vs. PostgreSQL

08.11.2018 0:27, Dalton Calford dalton.calf...@gmail.com [firebird-support] wrote: > > Master-Slave is already in HQbird for 2.5 and 3.0, and will be in > community Firebird 4.0 > > Master-Master is the next step for 5.0. > > Great news! > > >  (6) High Available Clustering > >  agree, it

Re: [firebird-support] Converting dates and the ISO-8601 format

09.11.2018 13:38, i...@synapsesoftware.co.uk [firebird-support] wrote: > I really dont know how to format the results so that they appear "normal" for > my region - > ie the dd/mm/ format. I also am not sure where the problem originates. Formatting of dates is a client-side job. You

Re: [firebird-support] Concerns about Firebird database to get perform with less downtime.

13.11.2018 10:58, Marcelo Guimaraes mfguimar...@gmail.com [firebird-support] wrote: > The sweep and collect indexes statics are some action I know I can do, but > what more? Mostly it is more than enough. Manual sweep is not necessary if you don't turn off auto-sweep. Backup-restore

Re: [firebird-support] Concerns about Firebird database to get perform with less downtime.

13.11.2018 13:22, Marcelo Guimaraes mfguimar...@gmail.com [firebird-support] wrote: > Here they have some problems with old transactions, so I also need to do > something with > them, like force rollback or commit. But how I do that? Fix the application which run the transactions. --

Re: ODP: [firebird-support] Converting dates and the ISO-8601 format

12.11.2018 15:10, i...@synapsesoftware.co.uk [firebird-support] wrote: > Yes but in the scenario you describe - all computers are on the same network. > I need to be > able to connect to a remote server. I have mobile devices that need to > communicate with > the database (over a mobile

Re: [firebird-support] Re: Server crash when no more space for the database

07.11.2018 14:16, hv...@users.sourceforge.net [firebird-support] wrote: > The last lines i see inyour message is: After that several bugchecks wer reported. You should have whole message in your mail box. > (Message over 64 KB, truncated) AFAIU it is limitation of web-interface. --

Re: [firebird-support] Firebird vs. PostgreSQL

07.11.2018 16:28, Michal Kurczabinski michk...@gmail.com [firebird-support] wrote: > Firebird also doesn't support data partitioning, extended window functions On the other hand transactions in PostgreSQL are strange: they automatically rolled back on any statement error. -- WBR, SD.

Re: [firebird-support] Firebird vs. PostgreSQL

07.11.2018 17:11, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: > Wow is this true? https://www.tutorialspoint.com/postgresql/postgresql_transactions.htm "Transactions can be started using BEGIN TRANSACTION or simply BEGIN command. Such transactions usually persist until

Re: [firebird-support] Custom error message from procedure/trigger code in Firebird 3.x dialect 3

07.10.2018 18:06, jonatan.laurit...@yahoo.dk [firebird-support] wrote: > how can I report custom errors from the SQL procedures and triggers Read Language Reference for full EXCEPTION syntax. -- WBR, SD.

Re: [firebird-support] Re: Firebird 3.x error “Attem pt to execute an unprepared d ynamic SQL statement” in Delphi IBX exception handling?

07.10.2018 18:43, jonatan.laurit...@yahoo.dk [firebird-support] wrote: > So - there should be problem how TIBStoredProc handles the error messages. This is not the only bug in this component. Don't use it ever. -- WBR, SD.

Re: [firebird-support] Re: Sequential auto incremental numbering

03.09.2018 8:29, 'Christian Giesen' ch...@xt.co.za [firebird-support] wrote: > 2.I have implemented an AFTER INSERT trigger on the INVOICE table as follows: You trigger can work in single user environment only. BTW, it is better to be BEFORE INSERT and avoid updating of just inserted record.

Re: [firebird-support] What I am missing in the transaction ?

24.09.2018 19:09, m_brahi...@yahoo.fr [firebird-support] wrote: > I start a read transaction T1 where I check with a SELECT to see if  the > record exists and > commit the T1 > If the record doesn't exist the client show a message to the user and ignore > the T2 > if record exists I start the

Re: ODP: [firebird-support] Question about multithread: readonly query ina single transaction

19.09.2018 13:26, Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support] wrote: > Is something like this safe? Yes. But it has no performance difference from the case when everything happen in single thread. -- WBR, SD.

Re: [firebird-support] Configure a timeout to rollback transactions of dead connections

16.11.2018 20:01, eadbha...@yahoo.com.mx [firebird-support] wrote: > We have been suffering blackout problems lately. Our Firebird database server > stays on but > all client computers with applications just die. Due to this, some database > records end up > being "locked up" by the server and

Re: [firebird-support] concat a integer variable to a varchar

05.01.2019 9:34, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: >> RTFM Language Reference. In SQL queries PSQL variables must be used with >> colon. > you could have phrased that a little bit more > friendly and less hostile. English is not my mother-tong you know. What

Re: [firebird-support] concat a integer variable to a varchar

05.01.2019 12:02, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > RTFM == Read The Fucking Manual, which - to me - is similar to saying > "You're an idiot and why the fuck are you bothering us with this simple > question.". In my time "F" stayed for "Following" but the world

Re: [firebird-support] Falling at second hurdle ...

17.01.2019 20:11, Lester Caine les...@lsces.co.uk [firebird-support] wrote: > So what can I do next to get this to work? You can read Release Notes for Firebird 3.0, chapter "Compatibility Issues" including "Embedded Connections" and "Initializing Security Database". Also reading text of

Re: [firebird-support] How to insert characters for barcode code 128 to table via code?

16.01.2019 3:12, trsk...@yahoo.com [firebird-support] wrote: > how to insert it via code? char buffer[8]; XSQLDA* sqlda; . sqlda->sqlvar[1].sqldata = buffer; memcpy(buffer, YourBarCode, 8); isc_dsql_execute(., sqlda); -- WBR, SD.

Re: [firebird-support] udf dll

12.12.2018 16:45, Robert Tulloch tult...@hughes.net [firebird-support] wrote: > Interesting last message. Binaries are not allowed in this list. Use Ctrl-C to copy error message text and Ctrl-V to paste it into mail directly. If you use Windows command-line console, "select" and "copy"

Re: [firebird-support] udf dll

12.12.2018 19:26, Robert Tulloch tult...@hughes.net [firebird-support] wrote: > Not using firebird at all. In this case you are in wrong support list. -- WBR, SD.

Re: [firebird-support] Re: very slow firebird embedded connection on a web application

12.12.2018 20:03, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > What optimization advantages are you thinking of? Result set buffering can significantly speed up fetch. -- WBR, SD.

Re: [firebird-support] udf dll

12.12.2018 18:05, Robert Tulloch tult...@hughes.net [firebird-support] wrote: > Error message when run from program in IDE > First chance exception at $7C812FD3 . Exception class EIBInterBaseError with > message > 'Unable to complete network request to host "ws1". > Error writing data to the

Re: [firebird-support] Problems with creating new users (no permission for INSERT access to TABLE PLG$VIEW_USERS)

18.12.2018 12:04, 'Bryan Cole' bryan.c...@teraview.com [firebird-support] wrote: > [mypc]$ isql-fb -u test -p test -r rdb$admin localhost:mydatabase > Database: localhost:mydatabase, User: TEST At first, role rdb$admin wasn't granted to this user and applied how you can see in second

Re: [firebird-support] Problems with creating new users (no permission for INSERT access to TABLE PLG$VIEW_USERS)

18.12.2018 14:25, 'Bryan Cole' bryan.c...@teraview.com [firebird-support] wrote: > Database: localhost:employee, User: TEST Do you see "Role: RDB$ADMIN" here? It must be. -- WBR, SD.

Re: [firebird-support] Problems with creating new users (no permission for INSERT access to TABLE PLG$VIEW_USERS)

18.12.2018 14:44, 'Bryan Cole' bryan.c...@teraview.com [firebird-support] wrote: > I understand I'm doing it wrong. I don't understand what I need to do > different. I've read all the documentation (really!). > > If you could give me a working example, that would be awesome. >isql -u sysdba

Re: [firebird-support] Problems with creating new users (no permission for INSERT access to TABLE PLG$VIEW_USERS)

18.12.2018 16:55, 'Bryan Cole' bryan.c...@teraview.com [firebird-support] wrote: > I'm using the default which I believe is SRP. Make sure by select from MON$ATTACHMENTS. -- WBR, SD.

Re: [firebird-support] Problems with creating new users (no permission for INSERT access to TABLE PLG$VIEW_USERS)

18.12.2018 19:17, 'Bryan Cole' bryan.c...@teraview.com [firebird-support] wrote: > [root@bryan bin]# ./isql -user test -pass test -role > RDB$ADMIN > localhost:employee Didn't you forget about a special meaning of $ in bash command line? -- WBR, SD.

Re: [firebird-support] Firebird 2.5 ppa repository for Ubuntu 18.04

20.12.2018 3:03, my...@techsol.org [firebird-support] wrote: > Is there a more up to date repository for Firebird 2.5 for Ubuntu 18.04 LTS > that any one > can point me to? Firebird 2.5 is in official Ubuntu 18.04 repositories. Just use 'apt-get install firebird-2.5'. It may be a bit

Re: [firebird-support] Using FB 3.04 with Delphi 10.2

20.12.2018 12:00, Alan J Davies alan.dav...@aldis-systems.co.uk [firebird-support] wrote: > Is there a setting or something similar in FB to allow this? Yes. Read "Compatibility Issues" chapter in Release Notes (or better read whole of them). -- WBR, SD.

Re: [firebird-support] Firebird 2.5 ppa repository for Ubuntu 18.04

20.12.2018 18:40, my...@techsol.org [firebird-support] wrote: > Thank you.  Do you happen to know the PPA address of those repositories for > Ubuntu 16.04? > I haven't upgraded my development workstation to 18.04 yet (will do that in > the new year).

Re: [firebird-support] COMMENT ON charset

20.12.2018 19:10, Aldo Caruso aldo.car...@argencasas.com [firebird-support] wrote: >    The sql script is coded in UTF-8 You must inform server about it using SET NAMES before CONNECT or -ch switch. -- WBR, SD.

Re: [firebird-support] Can Firebird timeout / SO_KEEPALIVE options preserve connection in faulty VPN?

14.12.2018 9:05, jonatan.laurit...@yahoo.dk [firebird-support] wrote: > After each 7 or 10 minutes the Firebird connection gets lost. My question is > - can I > configure the connection to reduce lost connection? You should find the reason of the disconnects first of all. For different

Re: [firebird-support] Firebird optmizer cop-out

05.12.2018 12:37, Rudi Feijó rudi.fe...@multidadosti.com.br [firebird-support] wrote: > Could anyone explain me further how the user can go about to effectively > pick or influence the optimizers decision? Join order can be forced by using outer join. Using of indexes can be disabled by

Re: [firebird-support] Firebird optmizer cop-out

05.12.2018 19:25, Rudi Feijó rudi.fe...@multidadosti.com.br [firebird-support] wrote: > One last question, does the optimizer actively learns and auto-improves from > queries if we > set the PLAN manually? No. No AI inside. Optimizer is using database statistics, including index

Re: [firebird-support] RAM usage of Firebird Server 3.0

20.11.2018 13:46, ch.kaufm...@splash-software.ch [firebird-support] wrote: > But when I check the server only a few percent of RAM is used. Where can I > find some more > hints about tuning firebird.conf file so the resources of my server will be > used? Resources are not used until they

Re: [firebird-support] concat a integer variable to a varchar

04.01.2019 11:26, leaw...@gmx.de [firebird-support] wrote: > that does not work - Unknown Column error -206 RTFM Language Reference. In SQL queries PSQL variables must be used with colon. -- WBR, SD.

Re: [firebird-support] How safe is the restart of Firebird 3.0 Windows service/Nix daemon?

04.01.2019 14:34, jonatan.laurit...@yahoo.dk [firebird-support] wrote: > I need to alter procedures on running Firebird 3.0 database and I need to > disconnect all > the users for doing that (there is 'procedure in use' control exception You just must perform ALTER in WAIT transaction. If

Re: [firebird-support] Re: Possible problem garbage collector in 32bit 2.5.8

04.01.2019 19:50, dam...@wxs.nl [firebird-support] wrote: > Because some customers have a bad habit when switching of computers, I > register abnormal > termination of my program. I can also detect power failures etc with this > feature. But it > seems normal. But the databases definitely

Re: [firebird-support] Firebird Embedded with .NET Core on macOS

10.01.2019 22:49, Anil anil.muja...@gmail.com [firebird-support] wrote: > I'm trying to make it work in embedded mode with .NET Core application on > macOS. The same > scenario (just a dummy console project) works without issues on Windows. AFAIK you cannot just copy files into your

Re: [firebird-support] How to troubleshoot "connection rejected by remote interface" error? Something has got wrong...

09.01.2019 14:14, jonatan.laurit...@yahoo.dk [firebird-support] wrote: > This is Firebird 2.1 on Linux machine Classic or superserver? -- WBR, SD.

Re: [firebird-support] Re: out-of-memory failure with BLOB

09.01.2019 15:04, eric.gueguin...@gmail.com [firebird-support] wrote: > Why blob are not released in this case, why keep blob id ? If you learn Firebird API, you'll see that BLOB's content is requested to client separately. Server cannot predict that this BLOB won't be requested by client

Re: [firebird-support] out-of-memory failure with BLOB

09.01.2019 11:51, eric.gueguin...@gmail.com [firebird-support] wrote: > After suspend, allocated memory should be release no ? No. Blobs whos ID was sent to client cannot be released until transaction end. -- WBR, SD.

Re: [firebird-support] Re: out-of-memory failure with BLOB

09.01.2019 21:41, sdnetw...@gmail.com [firebird-support] wrote: > maybe could be release when it's read by the client May be. But what is read once can be read twice. Because of that you must be very careful with temporary blobs and don't keep transactions opened more than necessary. --

Re: [firebird-support] Using Union and Join (of two tables residing in different databases) in a Query

11.09.2018 10:43, 'Stellarancia.com' ni...@stellarancia.com [firebird-support] wrote: > Do you have any suggestion as to how to solve this problem? Put both tables into one database. -- WBR, SD.

Re: [firebird-support] GBAK and NBAK restore

13.09.2018 11:14, hugo.lar...@yahoo.com [firebird-support] wrote: > I appreciate any advice on this issue. I'd suggest you using of replication instead of backups. It can significantly reduce size of transferred data. You also can use ETL tools that are able not to export old/unchanged

Re: [firebird-support] GBAK and NBAK restore

13.09.2018 13:48, hugo.lar...@yahoo.com [firebird-support] wrote: > Unfortunately 2.5 does not have replication. There are third-party tools for replication and ETL as well. -- WBR, SD.

Re: ODP: [firebird-support] Using Union and Join (of two tables residing in different databases)in a Query

14.09.2018 20:08, 'Stellarancia.com' ni...@stellarancia.com [firebird-support] wrote: > My problem is that I've numerous programs that utilize one firebird file > each. All these programs can work with the same database. In contrast to DBF, Firebird server can be used by many programs

Re: [firebird-support] ISQL connects with any credentials?

17.09.2018 16:04, Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support] wrote: > I just noticed that on my server I can connect to ANY database using ANY > credentials, even with user names that don't exist. And for existing > user name, it doesn't matter what password I specify - I

Re: [firebird-support] how to resolve this deadlock

12.09.2018 2:45, 'Hamish Moffatt' ham...@risingsoftware.com [firebird-support] wrote: > Unfortunately your journal / batch update solution doesn't help in my case. What's wrong with it in your case? -- WBR, SD.

Re: [firebird-support] Question about multithread: readonly query in a single transaction

17.09.2018 15:50, Marco Andreolli dra...@gmail.com [firebird-support] wrote: > Is it safe run multiple (only select) query in separated thread using the > same transaction? It is safe but it is pointless. > I should use a different transaction? or even different connection? It depends on

Re: [firebird-support] Question about multithread: readonly query in a single transaction

18.09.2018 12:33, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: > is this true? I read many times that this is not safe. Starting from Firebird 2.5 (at least) every API call uses YEntry guard that lock entryMutext in corresponding attachment. You can look into

Re: [firebird-support] Question about multithread: readonly query in a single transaction

18.09.2018 16:51, Marco Andreolli dra...@gmail.com [firebird-support] wrote: > For example if I would like execute two query at the same time, in parallel > mode without > serialization, I have to use two connection!!! Yes. Two connections is the only way to make two queries run in parallel.

Re: [firebird-support] Question about delay in fetch operation

28.01.2019 17:07, Rudi Feijó rudi.fe...@multidadosti.com.br [firebird-support] wrote: > Im using firebird 3, tried with the latest stable release, and the latest > snapshot from today. Did you try it in embedded mode? -- WBR, SD.

Re: [firebird-support] String conversion to timestamp fails during insertion in 12 hour format

26.03.2019 16:05, joje j...@codework-solutions.com [firebird-support] wrote: > Why is it conversion fails in 12 hour format while successful in 24 hour > format? Firebird can recognize only chosen (ANSI standard preferable) timestamp formats and doesn't take system locale into account. --

Re: [firebird-support] Re: Character set ISO8859_1 is not installed

04.04.2019 8:35, b...@tbwb.nl [firebird-support] wrote: > I am using CentOS 7, and installed firebird with > > yum install firebird Use strace to find out where it is looking for fbintl/ICU and why they cannot be found. -- WBR, SD.

Re: [firebird-support] How to return a result set of unknown number of columns from an Execute Block?

04.04.2019 15:22, Paul Read fireb...@nsolve.com [firebird-support] wrote: > > *Is there a way to return from an execute block a result set with an unknown > number of > columns?* No, there is no way. -- WBR, SD.

Re: [firebird-support] Ubuntu 18.04 Firebird 3.03 Server Connection String: Local Works, URL-Style Fails

05.04.2019 12:22, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote: > 2. While following connection strings fails: > Ubuntu_Machine:/home/ubuntu_user/Documents/Sample.FDB > localhost:/home/ubuntu_user/Documents/Sample.FDB > 127.0.0.1:/home/ubuntu_user/Documents/Sample.FDB It looks

Re: [firebird-support] Install a DB Firebird on a web site

28.03.2019 19:39, 'Stellarancia.com' ni...@stellarancia.com [firebird-support] wrote: > My question wanted to be: a direct connection is possible (IP:alias) > through a router? Yes, it is possible but this is a) insecure; b) may be slow. If your application is not ready to work over

Re: ODP: [firebird-support] Re: Strange behavior on very large table

02.03.2019 10:50, Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support] wrote: > You have quite big fill 94%, that there is a chence that new page must be > allocated – but > here still you have free slots. It may be a sign of record fragmentation which is bad from performance

Re: [firebird-support] Turn on WireCompression on Firebird 3

04.03.2019 10:44, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > there other server tweaks to improve the performance for my case? First of all you must define "your case" and find bottleneck by using system monitoring tools. Usual reason for Firebird being slow in virtual

Re: ODP: [firebird-support] Turn on WireCompression on Firebird 3

04.03.2019 18:11, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > > In this case you must done something really wrong. > > Claiming some must have done something really wrong without clear > evidence is not really constructive. Yes, but without real data it is impossible to

Re: ODP: [firebird-support] Turn on WireCompression on Firebird 3

04.03.2019 17:39, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > As I mentioned in my first post I run that query for 15 times for each sever > FB,PG,mysql. Are all of them installed and run on the same virtual host? -- WBR, SD.

Re: ODP: [firebird-support] Turn on WireCompression on Firebird 3

04.03.2019 17:57, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > yes In this case you must done something really wrong. -- WBR, SD. ++

Re: [firebird-support] FB3 stability ...

25.02.2019 12:34, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > No clue why you'd get that error randomly Because it is not a real error. CORE-4964 hides errors caused by failing connection to security database. Some of them were fixed in post releases. -- WBR, SD.

Re: [firebird-support] optimal free disk space

25.02.2019 13:57, shg_siste...@yahoo.com.ar [firebird-support] wrote: > Do you think having 20GB of free disk space may be a problem? No.Problem is drive's speed and badly designed application that you use. First problem you can solve with SSD and Firebird 4, second problem requires a

Re: [firebird-support] Can I restrict sysdba to login from localhost?

13.03.2019 9:06, cyc...@gmail.com wrote: > Can I restrict the sysdba to be able to login to firebird server on localhost > only? No. But you can remove SYSDBA account at all and let it use trusted auth or embeded mode. -- WBR, SD.

Re: [firebird-support] Can I restrict sysdba to login from localhost?

13.03.2019 11:07, Rustam rusta...@ukr.net wrote: > I suppose, you can create ON CONNECT trigger and verify 'current_user' and > client remote > IP address against '127.0.0.1' (from MON$ATTACHMENTS table). No, SYSDBA is able to bypass them. -- WBR, SD.

Re: [firebird-support] Can I restrict sysdba to login from localhost?

13.03.2019 15:17, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: > >>No, SYSDBA is able to bypass them. > > Can i ask how and why? SYSDBA can use -no-db-triggers switch and connect without ON CONNECT triggers fire. AFAIU this thread is about preventing of someone

Re: [firebird-support] keeping the connection

12.03.2019 16:45, wang...@yahoo.com [firebird-support] wrote: > any idea why it got disconnected CISCO router in-between dropped idle TCP connection after configured timeout. -- WBR, SD.

Re: [firebird-support] Database corrptions

22.03.2019 10:05, ma_go...@yahoo.com [firebird-support] wrote: > We use 2.5.8 CS on Oracle Linux 7.6. It has 200+ database and 4000+ > connections. > > Yesterday we had corruptions in many databases around the same moment. > > These are the different messages in the firebird.log after the

Re: [firebird-support] Stored procedure stops functioning correctly after restore under Firebird 3

13.02.2019 16:39, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > My bet is on the addition of the savepoint. Yes, this is the way partial cursor stability is implemented in 3.0: insert-select cannot see changes made inside of the same savepoint, so sub-query in second query

Re: [firebird-support] Stored procedure stops functioning correctly after restore under Firebird 3

13.02.2019 18:29, Kevin Stanton kevin.stan...@rdb-solutions.com [firebird-support] wrote: > I like the idea of creating an empty database and pumping the data over. Is > there a tool > for this? (Actually just found one from Clever Components) I'd recommend to look at FBCopy/FBExport tools.

Re: [firebird-support] Built in RegEx Capability?

11.02.2019 22:18, Lester Caine les...@lsces.co.uk [firebird-support] wrote: > Ideally I need to extract the 'V' element and the 'p' element into their > own fields so I can look up Volume '12' and page '234' or list all the > pdf's for Volume '12' in page order. You could use "Regular

Re: [firebird-support] Formatting currency

20.02.2019 11:57, 'Check_Mail' check_m...@satron.de [firebird-support] wrote: > if I select this and store it in a varchar-variable, I get 1112223.44, with > the point, not > comma. Storing numbers in varchar fields is a big mistake. -- WBR, SD.

<    1   2   3   4   5   6   7   8   >