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
1
vote
1 answer

How can I replace NULL in a database query?

The problem is that from the query result in the database: cur1 = con.cursor() result1 = ("SELECT DDATE FROM TABLE(NULL)") cur1.execute(result1) result1 = cur1.fetchone() Result from the query - 43949.0 need put the result in the next query,…
Emil
  • 15
  • 3
1
vote
1 answer

firebirdsql cannot connect to database if path contains hash symbol

I am trying to connect to a Firebird database using firebirdsql in Go (v1.14). db_path := "D:\\DBs\\test.fdb" conn, err := sql.Open("firebirdsql", ("sysdba:master@127.0.0.1:3050/" + db_path) ) err = conn.Ping() if err != nil { …
wiki
  • 1,877
  • 2
  • 31
  • 47
1
vote
3 answers

Localized month names in Firebird

I need to get various parts of a TIMESTAMP field - specifically year, localized month name (in Russian), day of month and hours interval (like '11 - 12'). Currently i came up with this: select extract (year from prt.dtbegin) as f_year, ( case…
Sergei Ousynin
  • 170
  • 2
  • 13
1
vote
0 answers

Hibernate - Encountered failure rolling back failed commit

I have an application with following technologies: Spring 4.2.2 Hibernate 5.1.0 Maven Apache Tomcat 8.0 Firebird 2.2 When I'm running my project it works fine at first. But after some time I am receiving an error during login procedure. In login…
Rocky3582
  • 573
  • 4
  • 7
  • 17
1
vote
1 answer

Firebird permission denied when connecing with FlameRobin but is okay with isql

I'm trying to connect to employee.fdb in Firebird3.0 (localhost) using FlameRobin 0.9.3 on a Ubuntu OS. The connection to Firebird using isql has no issues. I can create users, roles, etc all from the terminal. However, when I attempt to make a…
DanZ
  • 451
  • 2
  • 9
1
vote
1 answer

Wrong plan when inner-joining a view/subquery that has left join

I'm trying to build a query that inner joins a view (which exists for reusability), but apparently the fact that this view has an internal left join is somehow messing up the optimizer, and I can't really understand why (indices statistics are…
GabrielF
  • 2,071
  • 1
  • 17
  • 29
1
vote
1 answer

How to inspect nbak state of a Firebird database

Is there a way in C# to inspect the nbak state of a Firebird database? The state in the database header would be set to nbak_state_diff or nbak_state_normal. But how do I actually read this value?
Kjell Rilbe
  • 1,331
  • 14
  • 39
1
vote
1 answer

Firebird Listener like TableDependency in SQL Server

I am working on a C# (Visual Studio 2019) Form application and I need to fetch some table data from a Firebird database. For SQL Server, I am doing it successfully with TableDependency but in Firebird I am trying to do something similar to listen…
Jugnu Khan
  • 63
  • 3
  • 9
1
vote
2 answers

How to get return value from query with Dapper?

I'm trying to get a return value from an insert query using Dapper. Here's how I try to make it work: // the query with a "returning" statement // note : I have a trigger that sets the Id to a new value using the generator IF Id is null... string…
neggenbe
  • 1,697
  • 2
  • 24
  • 62
1
vote
1 answer

Firebird encode/decode base64

Is there any function for encode/decode base 64 in Firebird? In SQL Server there are a technique using xml: declare @source varbinary(max)=convert(varbinary(max),'AbdalrahmanIbnSewareddahab') SELECT CAST('' AS…
NizamUlMulk
  • 386
  • 1
  • 4
  • 21
1
vote
1 answer

python firebird/fdb file parser

I'm working with a management that export the archive in .fdb bytes, the fdb file is the file used by Firebird. Now I have to create a parser with Python that gets the archive and parse all the archive with the Firebird's specifications so that I'll…
Eric Pavone
  • 13
  • 3
1
vote
1 answer

What does CAST(SUBSTRING()AS INTEGER)=x do?

I am having an exam on SQL which I have rarely ever worked on. While going through the study material I encountered this example: DELETE FROM table_name WHERE CAST (SUBSTRING (attribute_name from x for y) AS INTEGER) =z; Now, I am guessing that…
Nobody
  • 33
  • 8
1
vote
1 answer

Error occurs: "Using GRANT OPTION on procedures not allowed" when creating a PSQL variable

We are using SQL manager for interbase-firebird and also Firebird 3.0.5. We are creating a procedure and that works fine. However from the moment we add a psql variable to the procedure we get below error. When we remove the variable the procedure…
free
  • 153
  • 1
  • 2
  • 18
1
vote
2 answers

How to find if a number can be contained in a specific range in Delphi using Firebird DB?

I have a table that contains prices for specific metalic parts with differents sizes. In order to find the right price I need to find the field where the diameter fits in the range of sizes. It is possible that the range does not exist because of a…
VirussInside
  • 187
  • 17
1
vote
1 answer

Firebird connection ODBC remote when using non-standard TCP port

I have a server with Firebird 2.5.3 and I need read then database on another server over the ODBC connection for use in SSIS project(integration services), so I shared the folder with the .FDB database and set the address in my ODBC connection, but…
user8223022
  • 195
  • 2
  • 15
1 2 3
…
99 100