The problem comes with the second. (1, 'Bob Jacobs'), (2, 'Bob Jacobs'), (3,
'BOB JACOBS'), and (4, 'bob jacobs') constitute an acceptable set of rows;
(2, 'Bill Hafner') and (2, 'BILL HAFNER') do not. That is, given a value for
CORPORATION_S_KEY, there shouldn't be case-variants for the NAME
On 17 Aug 2014 12:05:08 -0700, vogonjeltzprostet...@yahoo.com
[firebird-support] firebird-support@yahoogroups.com wrote:
This was something I would resort to years ago in Paradox. Suppose I
had
a table CORPORATION with columns S_KEY INTEGER, SUBSIDIARY_NAME CHAR(50)
and a table EMPLOYEE with
Hello
I have a strange problem, which I have no idea at the moment how to solve.
Let me see if I can describe the problem.
1.
I start my program.
When this happens, I connect to a licens DB (using user OCCLICENS), check some
records, disconnects and continue.
Now the program
I can now tell all you guys, that my current antivirus program F-Secure is
causing all this to happen.
If I disable, the problem goes away.
So I have no problem anymore.
Michael
Sorry - it's been a long time since I last posted. My OP was verbose, lengthy
on preamble. I've gotten too accustomed to emailing users. Thanks.-MB
The case-insensitive collation option sounds the most seemless. I might have
to choose character sets more carefully - the DB I tested with was ISO8859_1
for a default, and I couldn't find a CI collation for it (maybe I needed to
look harder). The second is basically a simpler version of what
Migration might be too strong a term - I don't want my Firebird database to
bear too much resemblance to an old Paradox database. The database might serve
similar logical purposes, though. The domain advice is good in general -
char(16) character set octets, for example, would probably be a
Hello.
IBExpert shows the message:
lock conflict on no wait transaction
unsuccessful metada update
object MY_PROCEDURE is in use
How can I see 'who' is using the procedure?
--
Atenciosamente,
Hugo Eyng
Maybe this can help:
SELECT st.mon$statement_id as Statement ID,
st.mon$attachment_id as Attachment ID,
st.mon$transaction_id Transaction ID,
case
when st.mon$state = 0 then 'IDLE'
when st.mon$state = 1 then 'ACTIVE'
end as State,
To avoid such error, try to change the DDL transaction parameter to
WAIT instead of NO WAIT.
Carlos
Firebird Performance in Detail - http://videos.firebirddevelopersday.com
www.firebirdnews.org - www.FireBase.com.br
HEhmcfs Hello.
HEhmcfs IBExpert shows the message:
HEhmcfs lock conflict on no
Hello,
For reliability reasons, I decided to turn on forced writes on a
database running on Linux.
After that I noticed that some massive updates ( 100K records ) took
nearly 5 minutes, whereas with async writes it used to take 10 seconds.
One solution is, of course, disabling sync
Given this scenario my questions are the following:
1) Does it makes sense to activate forced writes on Linux ?
Different versions of Linux file systems provide better protection than others.
Personally, I believe that forced write = ON is necessary for all OS -- but I
suspect that I
On 2014-08-18 14:51, Aldo Caruso aldo.car...@argencasas.com
[firebird-support] wrote:
After that I noticed that some massive updates ( 100K records ) took
nearly 5 minutes, whereas with async writes it used to take 10 seconds.
Of course, we don't know how much work actually took place
Hi Carlos.
Where do I chage it?
Hugo
Em 18/08/2014 15:06, 'Carlos H. Cantu' lis...@warmboot.com.br
[firebird-support] escreveu:
To avoid such error, try to change the DDL transaction parameter to
WAIT instead of NO WAIT.
Carlos
Firebird Performance in Detail -
Usually, if you turn FW = ON on Linux, and your filesystem has barrier
enabled, it will affect performance of batch updates really badly.
You would either accept the performance degradation, or disable one of
them (FW or barrier).
Carlos
Firebird Performance in Detail -
To avoid such error, try to change the DDL transaction parameter to WAIT
instead of NO WAIT.
While this would avoid the error, you will not know when/if your change will be
applied.
A connection can hold an object in use for an indeterminant period of time.
For me, I want to know that the
LSSBcfs While this would avoid the error, you will not know when/if your
change will be applied.
LSSBcfs A connection can hold an object in use for an indeterminant period of
time.
Dmitry said to me sometime ago that procedures changes will be
executed immediately and not get held. I tested and
I agree
Em 18/08/2014 16:29, 'Leyne, Sean' s...@broadviewsoftware.com
[firebird-support] escreveu:
To avoid such error, try to change the DDL transaction parameter to WAIT
instead of NO WAIT.
While this would avoid the error, you will not know when/if your
change will be applied.
A
Hello Carlos.
Thanks.
I am using IBExpert to run an 'CREATE OR ALTER PROCEDURE MY_PROCEDURE.
That´s why I am not understending what can avoid to execute this.
This PROCEDURE just returns a value from a table.
I should be able to drop and insert a PROCEDURE at anytime into the DB.
Should
FB
De: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Enviada em: segunda-feira, 18 de agosto de 2014 16:47
Para: firebird-support@yahoogroups.com
Assunto: Re: [firebird-support] object is in use
Hello Carlos.
Thanks.
I am using IBExpert to run an
Also, FB 2.5.0 has problems with this. If you use this version upgrade to
2.5.1 or above.
De: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Enviada em: segunda-feira, 18 de agosto de 2014 16:47
Para: firebird-support@yahoogroups.com
Assunto: Re: [firebird-support]
By the way, greetings everyone!
This was my first post. I was composing it when by accident I sent it instead
of saving it, so my greetings did not make it into my post. Forgive me, I did
not meant to read ignorant.
Doesn´t work.
The only way I found to alter a stored procedure in FB 2.5.2 , windows
64, SuperClassic is closing all conections and restarting the FB service.
Hugo
Em 18/08/2014 16:55, 'Carlos H. Cantu' lis...@warmboot.com.br
[firebird-support] escreveu:
Try to set the DDL transaction
Hi all,
I have a firebird server (FB 2.1, Superserver) on windows OS with database
file store on an external harddisk. There are about 5 users accessing this
database.
I never try or have NAS, is it possible just to move firebird db file from
external hardisk to NAS?
If this is
26 matches
Mail list logo
