Questions tagged [firebird]
Firebird is a free and open-source, cross-platform, client-server SQL relational database management system, running on Linux, Unix, and Windows. Please mention your exact Firebird version when asking questions.
98
questions
1
vote
1
answer
102
views
Sudden huge RAM usages with FireBird 4.0
Since about 2 weeks I have a sudden memory issue with 1 of our Firebird servers.
For context:
We have servers on 4 physical locations, each with a VM dedicated to Firebird and the connecting ERP pack.
...
0
votes
0
answers
73
views
How to show all hours even no data in Firebird?
I want to write a query that shows all hours (for getting total order) between start date and end date even no data.
Result should be like this:
count
extract(hour)
date
0
1
2020-12-03
10
2
2020-12-...
2
votes
1
answer
843
views
How do I get the date next week in SQL (Firebird)?
I want to get a date using an SQL statement. For instance, if the date is '2018-08-07' output this should return: '2018-08-14' (one week later). Then I'm going to get the total rows between these ...
0
votes
0
answers
139
views
How can i configure server in firebird.conf?
I want to connect an FDB database. However, no permission for all paths for this. And my FDB files are not in a path with permission. That's why I wanna make some changes in firebird.conf for server ...
1
vote
1
answer
118
views
How can i solve Statement failed problem?
I am trying to connect FDB file on Ubuntu.
ubuntu@me:/opt/firebird/bin$ sudo ./isql
Use CONNECT or CREATE DATABASE to specify a database
No entry for terminal type "xterm-256color";
using ...
3
votes
1
answer
896
views
How to enable authentication logs in Firebird 2.5?
I downloaded Firebird 2.5 from the official website and installed on a Linux machine. The install location is /opt/firebird.
I want to be able to view authentication attempt logs for security reasons (...
0
votes
1
answer
48
views
Output days since nth event
I have a table Events in a Firebird database (version 3.0.8) that records how many times an event occurs. Example below:
Date
EventCount
22-04-01
15
22-09-30
10
22-10-01
1
22-10-04
1
I would ...
0
votes
0
answers
645
views
Firebird database - isql command not found
I have a problem with the firebird database. When I use docker run -it jacobalberty / firebird bash my isql command works but when i run docker exec -it firebird bash my isql command no longer works ...
0
votes
1
answer
301
views
SQL to add zeros in front of existing data to meet field length
How to add zeros in front of existing data of NationalityCode field to make the length 5 ?
0
votes
1
answer
57
views
Result set with multiple rows based on max date and not NULL
Staff changed their profiles as shown in this table:
The result of latest information should be like this:
I applied the technique from this question for embedded Firebird of LibreOffice Base, the ...
1
vote
1
answer
158
views
Is it safe to rely on transactions in Firebird 2.5 Embedded DB in case of power outage?
How it's safe to say that the following list of action will never be reflected in DB in case of power outage somewhere in the middle of #2 line, before transaction is committed?
#1 begin transaction
#...
4
votes
1
answer
882
views
Problem with enabling System Audit (Firebird's Trace and Audit Services)
I would like to enable System Audit on my Firebird 2.5.9.27139 (x64) database (Windows 10), to inspect all queries performed on it.
I've already read some docs about what the configuration file should ...
2
votes
1
answer
308
views
Incompatibility between unixODBC and Firebird ODBC driver
I'm currently developing a application based in Rcode, ODBC and Firebird.
For that, first I've installed firebird server and unixODBC (both 64 bits since my machine OS is 64-bits). I tried with 32-...
0
votes
0
answers
225
views
Firebird begin backup and forced writes off, timestamp update delayed
We have a Firebird database that's almost 200 Gbyte in sice, and for performance we have forced writes off. Please don't debate the risks of forced writes, we are aware of them. This is Firebird 3.0.4 ...
0
votes
1
answer
255
views
Firebird isql exclusive mode?
I have a vague recollection that Firebird's isql utility will in some situations make an exclusive connection to the database, meaning that any other connection attempts will be refused.
I fail to ...