Hi.
I have a environment with 150 connections over my database.
My application needs to use "Wait On Locks".
A recent change in my application (client / server architeture) starts
to get in some deadlocks.
I found this article
https://ib-aid.com/en/how-to-track-deadlocks-in-firebird/ but the
I think this isn't only my "pain".
I good solution here will be a configuration for legacy systems, like
Authentication legacy.
Em seg., 2 de mar. de 2020 às 06:13, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] escreveu:
>
>
> On 28-02-2020 20:11, Roberto Viewe
20:11, Roberto Vieweg jjw.roberto.fireb...@gmail.com
> [firebird-support] wrote:
> > Ps.: I have a very big old-application written in Delphi 7, with a lot
> > of TSQLQuery with hardcoded count queries mapped to TIntegerField. So
> > is impossible to do a migration righ
Is possible to use the SET BIND feature
(https://github.com/FirebirdSQL/firebird/blob/master/doc/sql.extensions/README.set_bind.md)
from Firebird 3 to remap the datatype of a count statement from BIGINT
to INTEGER?
If yes, can you provide details and example how to do this?
Ps.: I have a very
So, you're saying that is not possible to set the locale to the server
without reinstall the SO in the desired locale?
Em sex., 14 de fev. de 2020 às 17:09, Dimitry Sibiryakov
s...@ibphoenix.com [firebird-support]
escreveu:
>
> 14.02.2020 20:46, Roberto Vieweg jjw.roberto.fireb...@gma
Dimitry, hi again.
I tried to set the locale on a Firebird super server installation.
I edited the /etc/init.d/firebird service script, and a added this to it:
export LANG="pt_BR.utf8"
Then I reload and restart the service with:
systemctl daemon-reload
systemctl restart firebird
After this, I
Sibiryakov
s...@ibphoenix.com [firebird-support]
escreveu:
>
> 12.02.2020 18:22, Roberto Vieweg jjw.roberto.fireb...@gmail.com
> [firebird-support] wrote:
> > How can I set the locale of firebird process in linux?
> > I'm using Firebird 2.5 classic.
>
>Use (x)inet
How can I set the locale of firebird process in linux?
My linux currently are configured using en_US locale, but I need to
set pt_BR to firebird without changing then entire locale of my linux
env.
I'm using Firebird 2.5 classic.
);
Thread.sleep(1000); // holy sleep
mgr.validateDatabase(FBMaintenanceManager.VALIDATE_READ_ONLY);
Em seg., 25 de nov. de 2019 às 11:20, Roberto Vieweg <
jjw.roberto.fireb...@gmail.com> escreveu:
> I was trying to shutdown a Firebird 2.1 using the Jaybird 3.x to validate
> the database
> On 25-11-2019 13:52, Roberto Vieweg jjw.roberto.fireb...@gmail.com
> [firebird-support] wrote:
> > I'm trying to use Jaybird to validate a database before start the
> > update process of my database definition.
> >
> > This validation is necessary to prevent
I'm trying to use Jaybird to validate a database before start the
update process of my database definition.
This validation is necessary to prevent the update of a corrupted database.
rd-support] escreveu:
>
>
> On 2019-11-21 18:59, Roberto Vieweg jjw.roberto.fireb...@gmail.com
> [firebird-support] wrote:
> > I have my java application running as a linux Systemd service (Fedora
> > 29 server).
> >
> > My application perform a backup each day,
I have my java application running as a linux Systemd service (Fedora
29 server).
My application perform a backup each day, but the process are throwing
an exception:
java.sql.SQLException: Unable to complete network request to host
"127.0.0.1". [SQLState:08006, ISC error code:335544721]
I'm developing a new updater for my application that uses a Firebird database.
My old version was using the gbak tool for backup and restore the
database (in a secondary FDB). If the backup and restore was finishing
with success, I acsume that the database integrity is OK.
The problem is that
I am using Firebird server on a Debian 9 stretch on a Virtual Box machine and
FlameRobin client on another Windows 7 VM for testing.
There is no firewall activated.
I can access the database locally using isql-fb.
I have installed Firebird 3.0 via Debian oficial packages:
# apt-get install
Basics of Statistics - Mathematics: Mean (Average), Median, Mode and Range
I want to calculate Mean (Average), Median, Mode and Range in Firebird 2.5 and
3.0.
I know that Firebird internal function for Mean (Average) is AVG(), but what
are the internal functions for Median, Mode and Range in
Hi,
Some of our clients are suffering with the CORE-4546
http://tracker.firebirdsql.org/browse/CORE-4546 issue and I need to know
if I can simply downgrade from 2.5.3 to 2.5.2.
Roberto Schneiders
Monde Sistemas
(19) 3478-8880
www.monde.com.br
Is there any problem or should I take any special care on having Firebird 2.5.x
or 3.0.x data files (FDB) on the same partion of Samba 4 (or Samba 4.1) in a
directory for databases not shared, of course?
My second hard drive is mounted on an ext4 partition using the attributes
.
Roberto Camargo.
From: cedriz monteagudo dice_in_trou...@yahoo.com
To: firebird-support@yahoogroups.com firebird-support@yahoogroups.com
Sent:
Subject: Re: [firebird-support] Can a Firebird database be hosted on a hosting
site?
Thanks to all those
I agree: more complicated, a lot. And still less dynamic and powerfull.
--
Em sáb, 28 de dez de 2013 18:02 MSK Svein Erling Tysvær escreveu:
Hi Bhavbhuti!
Let's split this into two parts.
Running
EXECUTE BLOCK returns (Mystatement varchar(4096)) AS
DECLARE
for better understanding.
Regards,
Roberto Camargo.
From: av...@telusplanet.net av...@telusplanet.net
To: firebird-support@yahoogroups.com
Sent: Thursday, December 26, 2013 7:24 PM
Subject: [firebird-support] RE: group by and sub-selects
Hi--
Thanks
db has referencial integrity).
Then, the data will be very usefull to make this analisys.
Roberto Camargo.
From: Roberto anhangu...@yahoo.com
To: firebird-support@yahoogroups.com firebird-support@yahoogroups.com
Sent: Friday, December 27, 2013 6:57 AM
Subject
. And may be you would have an easyer way to get your
solution. From my point of view, C# is more user friendly - I know some C
programmers don´t like C#.
If I am wrong, excuse me.
Friendly,
Roberto Camargo.
From: sgcou...@telus.net sgcou...@telus.net
Does Firebird 2.5 work on IPv6? If so, does it need any special setting on
firebird.conf?
Does Firebird 2.5 work on IPv6? If so, does it need any special setting on
firebird.conf?
The example below is from PostgreSQL. Is there an easy way to do it in Firebird
2.5 or 3.0?
I need prime numbers to analyse bio data:
with primes (num) as (
select generate_series(2,1)
)
SELECT num
FROM primes p1
WHERE num not in (
SELECT p1.num
FROM primes p2
WHERE p2.num
How could I convert the following php script from mysql to firebird?
//Get records from database
$result = mysql_query(SELECT * FROM people;);
//Add all records to an array
$rows = array();
while($row = mysql_fetch_array($result))
{
Compare to Firebird databases via system tables (rdb$) is basically a bunch of
WHILEs and FORs.
For compare scripts on Debian Linux, use DIFF:
apt-get install diffutils diffutils-doc
Study the programs: diff, diff3, sdiff and cmp.
Roberto
Em 13/10/2012 14:30, tomsee7 tomconl...@gmail.com
I am using FB 2.5.1 on Windows 7 64 bits.
It works perfectly on FlameRobin 0.9.3.2219 Unicode (x64):
---
Create Database test.fdb Default Character Set utf8;
Create Table test15 External 'c:\mytable15.txt'
(
code1 Integer,
code2 Integer,
namechar(20),
born
Firebird 2.5.1
Select Current_TimeStamp - Cast('00:20:00' as Time) From rdb$database;
Select Current_TimeStamp - Cast('00:20:00' as TimeStamp) From rdb$database;
Dynamic SQL Error
expression evaluation not supported
unknown ISC error 336397244
How can I correctly substract just some minutes from
31 matches
Mail list logo