An open-source DBMS platform descended from Interbase.

learn more… | top users | synonyms

2
votes
1answer
29 views

Detect circular relations in a distribution table

I have the following two tables, that will define distribution rates from items on table A to other items on table A (I think I can say B defines a many-to-many relationship for A with itself). ...
0
votes
0answers
19 views

Getting historic Meta data in firebird

I have run a query and then commited it in firebird, but I cant see this query in monitoring tables (like MON$STATEMENTS). What should I do to see last running queries in monitoring tables? which ...
0
votes
1answer
90 views

How to GRANT/REVOKE user permissions for user on Firebird 1.5?

I need to create a user in firebird 1.5 and give him permissions to access only some specific tables. I have managed to create the user, but apparently GRANT/REVOKE operations only work on version 2.1 ...
0
votes
0answers
143 views

Firebird Guardian

Is there an opinion on running Firebird Guardian. According to the FAQ - The Firebird FAQ: On Windows, having guardian running can even be counter-productive as it would run fbserver.exe ...
2
votes
1answer
58 views

Join more than 3 tables in one single query, with many comparisons and no IDs

I use an overlycomplex and poorly designed software at my work, and now I need to produce a report of invoices issued between a period of time. Invoices are held at table ENTR2012, which uses the ...
1
vote
1answer
22 views

Firebird Index Creation Fails

I'm creating an index in a table with the following command: CREATE INDEX IDX_CVE_OBS ON FACTF01 (CVE_OBS); But it returns me the following error: this operation is not defined for system tables. ...
0
votes
0answers
85 views

Firebird linked tables in Access 2010

I have multiple data sources in multiple databases that I have been tasked with correlating for business analytics. I currently have ODBC connections to two (one Pervasive, one Firebird) that I can ...
1
vote
0answers
41 views

ExecuteNonQuery struck and control never come back to next line in vb.net with firebird

I am using vb.net with firebird 2.5. I have a grid which has 100,000 records have to insert/update in the database but as I run loop it stuck in ExecuteNonQuery statement. few lines work but after ...
0
votes
1answer
93 views

How to stop Firebird SuperClassic (run as application) in Win 7?

I run Firebird 2.5.3 SuperClassic as application in Windows 7 64-bit with this command: fb_inet_server -a -m Now, how can I stop/shutdown it from command prompt? I know that I could right-click its ...
1
vote
0answers
142 views

Can't restart or stop Firebird 1.5 on linux

I have an ubuntu server running firebird 1.5. It was working fine, but recently it started hanging (firebird does not respond anymore). Even when trying to restart or stop the server, it shows an ...
1
vote
1answer
1k views

Firebird 2.5. Windows 8.1. Can't connect to any database! Why?

I'm trying to use a FireBird database engine. OS: Windows 8.1 x64(SmartScreen enabled, UAC enabled, Custom AntiVirus installed(with firewall)) FireBird: Version 2.5, Installed as SuperServer, as ...
1
vote
0answers
121 views

firebird update very slow

I am writing a stored procedure for Firebird 2.5 in which I sometimes need to update a single row in a data table more than once in the same transaction. However, I have noticed that the performance ...
2
votes
1answer
97 views

adjecency list model vs nested sets

I've stumbled upon an article describing nested sets model for storing hierarchical data and was quite intrigued by the supposed performance boost. after implementing this in our database, i've found ...
1
vote
1answer
145 views

How to deploy case-insensitive embedded firebird database?

I'm trying to find out how to create CI firebird embedded database. I've found (here) that there are some character sets each of them has one or many collations. So, UTF8 has UCS_BASIC, UNICODE and ...
1
vote
1answer
1k views

Using ODBC Connection to Access Firebird Database

I have an ODBC connection to a Firebird database that tests successfully. Is there a way to use this ODBC connection within SQL Server 2008 R2 to access the tables? I haven't used Linked Servers ...
0
votes
0answers
97 views

How does the optimizer of Firebird determine join order?

As Most query optimizers determine join order via a dynamic programming algorithm pioneered by IBM's System R database project, I was wondering whether the optimizer of Firebird uses the same ...
2
votes
0answers
306 views

Firebird2.5 error with collation in POSITION

Why does the following query succeed in Firebird 2.1, but fail in Firebird 2.5? select POSITION(_UNICODE_FSS 'alcu' IN _UNICODE_FSS 'Calculation') from "Election" The error is Error: *** ...
1
vote
2answers
1k views

Why do I get this error?

When ever I try to connect with Firebird SQL I get this error, firebird$ isql-fb 'db.FDB' -u SYSDBA -p <PASS> Statement failed, SQLSTATE = 08001 I/O error during "open" operation for file ...
0
votes
1answer
692 views

row_number over partition at Version < Firebird 3

I´m currently at the end. Given facts: ID ID2 FROM TO COSTS 4985 501671 2013-07-25 00:00:00 2013-12-30 00:00:00 17.8 4985 501671 2013-09-05 00:00:00 ...
2
votes
0answers
43 views

Set default fields

Is there a way to inform the database that some fields are default (have always the same value) so that I don't need include them in all my queries? Suppose: Select ... where f1=a, f2=b, f3=c, f4=d ...
1
vote
1answer
211 views

Firebird query performance with text search, also some numbers

I have situation as follows: I'm having a table OFERTY of 10k+ records, and when I select * from it, I get PLAN (OFERTY NATURAL) Executing... Done. 656 fetches, 0 marks, 0 reads, 0 writes. 0 inserts, ...
1
vote
1answer
158 views

Set up Firebird with shared storage?

I am new to firebird and confused with SuperServer SuperClassic thing. But what i wonder is how should i set up this scenario on Linux? Single shared storage that store database file on SAN 4 ...
0
votes
1answer
670 views

Firebird-Time Interval- between 2 Dates

I try to select the period of employment for the members in a Company. Example: Date of join: 01.01.2001 Today: 27.02.2014 Now, I want this: 13 years, 1 month and 27 days I have a Statement which ...
1
vote
1answer
290 views

What is the difference between Interbase and Firebird?

I'm interested in a broad overview of how they are diverging and why.
1
vote
2answers
574 views

Is it possible to Install two (2) Firebird instances of different names & ports (gds_db port 3050 & fbsvc port 3051) running as service?

Is it possible to Install two (2) Firebird instances of different names & ports (gds_db port 3050 & fbsvc port 3051) running as service !? I mean the two running as service not application ...
1
vote
1answer
344 views

Firebird database recovery and protection

I'm sure many companies are running critical Firebird database servers in production 24/7. Other than regular backups, what backup/recovery/protection techniques are available? I am also interested in ...
0
votes
1answer
223 views

sort a large table by its primary key and save it back

So I have a large table (>50 million rows) with an auto incremented primary key column, which is filled by a script running on multiple cores. Now, when I do a SELECT, entries are returned 'out of ...
1
vote
2answers
1k views

Improve performance with the WHERE NOT IN sub-select clause

In the following query, I have to count transactions for each customer. [EDIT]However, I have to exclude from the result set entirely, customers that have a transaction older than one year. ...
2
votes
1answer
136 views

Minimizing Page Fetches

I have a complicated database structure and am trying to use it to retrieve Records based on multiple selection criteria from several tables. As a general rule, is it better to attempt to use ...
1
vote
0answers
249 views

Firebird database performance after server upgrade/restart

Got a 350 GB database (more than 40M records plus 0 - 1000 BLOBs for each record in another table). After upgrading Firebird to version 2.1.5 (mainly because of filesystem cache issue) database became ...
1
vote
1answer
1k views

how to set a column to fetch the date now?

hi i have a sample table named datenow and used the following to create my table on flamerobin to have a column that gets the date today automatically when an entry is added. CREATE TABLE "DATENOW" ( ...
2
votes
1answer
205 views

how to build table relationships in a firebird database?

I am a beginner in Delphi and I have a Firebird database with 2 tables namely masterlist and daily collection. I used Zeos 7.0.3 to access my Firebird database. My masterlist contains the following ...
1
vote
1answer
2k views

How do I check if a constraint exists on Firebird?

I'm about to publish a script which will update a lot of Firebird databases all at once. Some will not have this constraint, so I would like to check for the existence of a constraint before I try to ...
1
vote
2answers
474 views

Storing a transaction sensitive constant in Firebird

I'd like to store a number in my Firebird database that indicates the revision of its structure. The number is supposed to be updated only when the structure has successfully been altered by some ...
5
votes
1answer
3k views

Firebird monitoring tables

I am working with a Firebird 2.1.1 database and I started reading about the Monitoring tables. I am trying to see somehow in real-time what queries does each client performs in the database. I had ...
6
votes
2answers
3k views

Fixing corrupted Firebird database

I have a 200 GB Firebird database (created with Firebird 2.1.3, currently running 2.1.5), and it appears to be corrupted. When I try to do a backup I get: database file appears corrupt <> ...
9
votes
2answers
269 views

Minimizing Indexed Reads with Complex Criteria

I'm optimizing a Firebird 2.5 database of work tickets. They're stored in a table declared as such: CREATE TABLE TICKETS ( TICKET_ID id PRIMARY KEY, JOB_ID id, ACTION_ID id, STATUS str256 ...
6
votes
3answers
947 views

Creating an index in both asc and desc directions

Over the past few weeks I've been raging against an old Firebird database. This database is crappy for all sorts of reasons, but one thing I noticed was that every single field of every single table ...
5
votes
2answers
3k views

No luck trying out Firebird 3.0

Today I though I'd give Firebird 3.0 a shot, but for some reason I can't seem to get it installed - at least not in a way that I can connect from a JDBC application. What I did was to follow this ...
14
votes
1answer
285 views

Term for a one-row table?

Is there a specific term to describe a relation with a cardinality of one? I'm thinking particularly of RDBMS "special" one-row tables, for example, DUAL (Oracle), SYSIBM.SYSDUMMY1 (DB2, Derby) and ...