Stack Overflow
Stack Overflow

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.

Firebird (Wikipedia) is an open-source SQL relational database management system (RDBMS) using the client-server model. It is cross-platform, running on Linux, Unix, and Windows.

It is written in C++, and is ultimately derived from the Borland InterBase 6.0 source code. Firebird is open-source, released under a non-copyleft MPL-like license. It is totally libre and free, for both open-source and commercial applications, but of course you can contribute back with code and donations to the Firebird Foundation.

Firebird and its predecessors have been in use for more than 30 years, which makes it a very mature and stable product.

Resources

Useful links

3750 questions
12
votes
4 answers

What are the advantages of VistaDB

I have seen the references to VistaDB over the years and with tools like SQLite, Firebird, MS SQL et. al. I have never had a reason to consider it. What are the benefits of paying for VistaDB vs using another technology? Things I have thought…
Andrew Burns
  • 13,917
  • 9
  • 40
  • 42
12
votes
7 answers

Firebird connection with java

I have installed Firebird 2.1 on windows Xp and using firebirdsql.jdbc-2.1.6 driver to connect with java. Code: Class.forName("org.firebirdsql.jdbc.FBDriver"); connection = DriverManager.getConnection( …
Rakesh Goyal
  • 3,117
  • 8
  • 39
  • 69
12
votes
3 answers

How do I get a list of tables from a Firebird database?

So I've got a couple of Firebird databases I need to convert. I've managed to connect to them using python code and the kinterbasdb library, but I can't find a way to get a list of all the tables in the database. Is there a command that will give me…
Beacon80
  • 349
  • 1
  • 4
  • 14
11
votes
2 answers

How change a column type in Firebird 3

Since Firebird 3, I can't modify a column type. Before I use this kind of update: update RDB$RELATION_FIELDS set RDB$FIELD_SOURCE = 'MYTEXT' where (RDB$FIELD_NAME = 'JXML') and (RDB$RELATION_NAME = 'XMLTABLE') because I get ISC error 335545030…
user3179515
  • 513
  • 1
  • 4
  • 9
11
votes
1 answer

Firebird Transaction Count Exceeded

We have an implementation running a Firebird database where we get this error: "Implementation Limit Exceeded - Transactions count exceeded. Perform a backup and restore to make the database operable again." We know how to fix this by making the…
ceebreenk
  • 1,031
  • 2
  • 14
  • 29
11
votes
3 answers

DataTable.Load(FbDataReader) does not load everything into DataTable

There is a closely related question here: .NET DataTable skips rows on Load(DataReader) I have a SQL Query that returns 169 results. The result looks like this: CustomerID Customer Name TerminalID Creation Date 1 First Customer 12345 …
waka
  • 3,362
  • 9
  • 35
  • 54
11
votes
2 answers

Firebird - get all modified fields inside a trigger

I need to get all the values which changed in a row and post modifications on other 'audit' table. Can I accomplish this, without writing the conditions for each element from the row? I know the SQL from http://www.firebirdfaq.org/faq133/ which…
RBA
  • 12,337
  • 16
  • 79
  • 126
11
votes
12 answers

Parameters in query with in clause?

I want to use parameter for query like this : SELECT * FROM MATABLE WHERE MT_ID IN (368134, 181956) so I think about this SELECT * FROM MATABLE WHERE MT_ID IN (:MYPARAM) but it doesn't work... Is there a way to do this ? I actually use IBX and…
Hugues Van Landeghem
  • 6,755
  • 3
  • 34
  • 59
11
votes
4 answers

How to input an array parameter of values to Firebird Stored Procedure?

I would like to input an array parameter of IDs to Firebird Stored Procedure. :INPUT_LIST_ID = [1, 2, 12, 45, 75, 45] I'm need to execute this SQL command: SELECT * FROM CITY WHERE ID_CITY IN (:INPUT_LIST_ID) Is it possible? Thanks!
dataol
  • 999
  • 3
  • 19
  • 42
11
votes
3 answers

JDBC connection with auto reconnect

I am using JDBC to connect to a database server. The connection is over a wireless network and can be dodgy at times. At the moment when the connection is lost I need to close and restart the application. Does anyone have some examples of code where…
bumperbox
  • 10,166
  • 6
  • 43
  • 66
11
votes
3 answers

Firebird JDBC driver connection character encoding

I have a JSF application running on tomcat6 in Fedora 17 using firebird as the database and all the registers coming from the database to the application are coming with a encoding problem. The language is Brazilian portuguese so I need é's and ã's…
Vitor Hugo
  • 1,106
  • 1
  • 15
  • 35
10
votes
8 answers

How to SELECT a PROCEDURE in Firebird 2.5

I'm using Firebird Embedded v2.5. How to use procedures in query (SELECT) ? My procedure: SET TERM ^ ; CREATE PROCEDURE FN_TEST( Y INTEGER ) RETURNS( X INTEGER) AS BEGIN X = Y + 1; END^ SET TERM ; ^ I want to list some field of table modified by…
Emil
  • 101
  • 1
  • 1
  • 3
10
votes
3 answers

"connection rejected by remote interface" connecting to Firebird 3 with PDO

Try code below, but cause exception - SQLSTATE[HY000] [335544421] connection rejected by remote interface: try { $dbh = new PDO("firebird:dbname=localhost/3050:empty", "SYSDBA", "masterkey"); $dbh->setAttribute(PDO::ATTR_ERRMODE,…
DaddyRatel
  • 729
  • 3
  • 13
  • 30
10
votes
2 answers

How to check in which server mode (e.g. SuperClassic or Superserver) a Firebird database is running?

The latest Firebird 2.5.x database can run in either Classic, SuperClassic, or SuperServer mode. How can I check in which of these modes an installed database is running?
Jan Derk
  • 2,552
  • 27
  • 22
10
votes
1 answer

Firebird default character set

SQL select command SELECT a.RDB$CHARACTER_SET_NAME FROM RDB$DATABASE a returns NULL. What character set is used when not specified any when creating new database? Is there difference between various versions of Firebird (1.0, 2.0, 2.5.1 etc.)?
truthseeker
  • 1,220
  • 4
  • 25
  • 58
1 2
3
…
99 100