Stack Overflow
Stack Overflow

Questions tagged [firebird-3.0]

For questions specific to Firebird 3.0. It is advisable to also tag with firebird.

Firebird 3.0 is a previous release of the Firebird database server. The latest release is .

Notable new features

  • Unified executable
  • Improved SMP support for SuperServer
  • Encrypted wire protocol
  • Per-database configuration
  • Multiple security databases
  • Improved SQL user management
  • BOOLEAN data type
  • IDENTITY support
  • PSQL packages
  • PSQL functions
  • DDL triggers
  • SQL Window (or analytical) functions

Resources

See also

211 questions
2
votes
1 answer

Connect from FB3.0 to FB2.5

I had 2 servers that were using Firebird 2.5. Each of the servers had a separate database and one of them was connecting to the other one to retrieve some data. One of the servers switched to Firebird 3.0 and now it can't connect to the 2.5 server.…
bogdica19
  • 33
  • 1
  • 3
2
votes
1 answer

Parameter in SELECT statement's fields list - error: Data type unknown

I have a problem with Firebird (embedded) database. I would like to set a parameter values in the select statement. For example: SELECT name, surname, :string AS myText FROM myTable where :string is a parameter. The above code works in SQLite and…
Mirosław Rychter
  • 33
  • 3
2
votes
1 answer

Jaybird JDBC 3.0 - Connection Timing Out

I'm connecting to a Firebird 3.0 database using the Jaybird JDBC 3.0.3 driver. I'm connecting from within the ColdFusion Administrator -> Data Sources area. In the past, using JDBC 2.0 driver I created my data source as follows. JDBC URL:…
Phil
  • 4,029
  • 9
  • 62
  • 107
2
votes
1 answer

Display all Dates in a given month and year in firebird select procedure

I am making a program for Time and Attendance. I have a table with this fields ATTEND_PK INTEGER NOT NULL, EMP VARCHAR, ATTEND_DATETIME TIMESTAMP, USER_PK SMALLINT, ATTEND_UPDATETIME TIMESTAMP); here is the sample data | ATTEND_PK | …
Don Juan
  • 155
  • 1
  • 10
2
votes
1 answer

FDPhysFBDriverLink behaving weirdly with VendorLib Path

I'm starting my first application with FireDAC and Firebird 3.0 and I'm having this weird problem with FDPhysFBDriverLink. Setting it up requires you to set VendorHome and VendorLib to get the driver link working... When I set them, the driver keeps…
Nickolas de Luca Alberton
  • 320
  • 1
  • 3
  • 17
2
votes
1 answer

"connection rejected by remote interface" in C# program connecting to Firebird 3

After migrating from Firebird 2.5 to 3.0 this error "connection rejected by remote interface" shows up when I try to test the connection of the database using C# program. Here is the code for testing the connection, I use this code when I try to…
Don Juan
  • 155
  • 1
  • 10
2
votes
1 answer

Using UUID PK or FK in Firebird with Jooq

I have a table in Firebird with a PK column CREATE TABLE TEST ( ID CHAR(16) CHARACTER SET OCTETS NOT NULL, CONSTRAINT PK_TEST PRIMARY KEY (ID) ); OCTETS encoding are treated as bytes. I create a converter public class UUIDConverter implements…
Gerardo Suárez Trejo
  • 23
  • 4
2
votes
1 answer

Alter a Column from INTEGER To BIGINT

In my database I have several fields with INTEGER Type. I need to change some of them to BIGINT. So my question is, can I just use the following command? ALTER TABLE MyTable ALTER COLUMN MyIntegerColumn TYPE BIGINT; Are the contained data be…
Andreas
  • 421
  • 4
  • 14
2
votes
1 answer

How to create a database owned by an user other than SYSDBA?

When I issue an isql command: create database "localhost:testdb.fdb" user milenio password "secret"; I get the following error: Statement failed, SQLSTATE = 28000 no permission for CREATE access to DATABASE testdb.fdb what am I missing? How do I…
palevi
  • 111
  • 5
2
votes
2 answers

SELECT WHERE column1 = 1 AND column2 = MAX(column2)

I have table like this |Column 1 |Column 2|Column 3| | 1| 1| 1| | 2| 1| 2| | 3| 1| 3| | 4| 2| 1| | 5| 1| 4| | 6| 2| 2| | 7| …
Parpil
  • 129
  • 2
  • 10
1
vote
1 answer

Why does my query return null when subquery condition is false

I have these three tables in my Firebird database: CREATE TABLE CLIENT_CODE_MASTER ( ID INTEGER GENERATED ALWAYS AS IDENTITY NOT NULL PRIMARY KEY, CLIENT_CODE VARCHAR(100) UNIQUE NOT NULL, CLIENT_ACTIVE BOOLEAN, MAX_DD_LIMIT…
Prabal Kajla
  • 125
  • 12
1
vote
2 answers

Count days since 3rd event from today

I have a table Events in LibreOffice Base with 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 like to create a…
hiigaran
  • 285
  • 1
  • 10
1
vote
2 answers

Differences in "procedure locking" based on the way the client is connecting to the database

I have created a test procedure like that: CREATE OR ALTER PROCEDURE tmp_fab RETURNS (dummy INTEGER) AS BEGIN dummy = 1; suspend; END Then a first client ("client A") uses the procedure by executing the following SQL: SELECT * FROM…
Fabrizio
  • 7,603
  • 6
  • 44
  • 104
1
vote
1 answer

How to get the max value of 3 fields

I have a table with integer fields like this: Field1 Field2 Field3 6 1 2 3 6 2 7 4 2 5 6 1 1 6 2 5 7 1 First, I want to look for the max value in field3. It's 2. Now, I want to look for the max value in field2, but only in…
TomCat500
  • 153
  • 3
  • 11
1
vote
1 answer

How to check if running in autonomous transaction?

In a trigger, I need to do some stuffs only when the code is not running from autonomous transaction. Is there a way to detect if the code is running in the context of an autonomous transaction?
Fabrizio
  • 7,603
  • 6
  • 44
  • 104
1 2 3
…
14 15