Firebird SQL Script support

Answered
Avatar
Ms
Created

Hello,

I recently aquired a DataGrip license and love that tool.

I mainly work with Firebird and added the JDBC driver. Unfortunately I cannot run scripts that contain constructs like

set term ^;

execute block…

begin

end^

As within these blocks (also procedures, functions, triggers) “;” is used in the code and does not mark the end of the complete command, “set term.” is used to set the termination sign, in this case ^.

Is there a way to make this work? We are testing a lot of scripts of our software here ´.

 

Votes

0

Share

6 comments
Avatar
Miguel Monteiro
Created

Are you unable to run the script or it just shows the error? As of now Firebird dialect support is still a feature request - https://youtrack.jetbrains.com/issue/DBE-3650/Firebird-Dialect-Support

0
Avatar
Ms
Created

Unfortunately the script is nit executed. I know about the post and would love to see Firebirdncompletely supported but currently itcwould already help if I could make DG just route the Statement to the Firebird Server as is. Can I disable checks?

0
Avatar
vasily chernov
Created

@Ms, I assume you're trying to execute something like:
 

SET TERM ^ ;
create procedure p1
as
begin
insert into t1 values(10);
end^


Could you try to set For selection execute as Exactly as one statement, select your code block and execute? 

0
Avatar
Ms
Created

I use the setting above and tried the following statement (that I verified with Database Workbench to execute correctly):

SET TERM ^ ;
create or alter procedure p1
as
begin
 insert into sys_setting(code) values('test');
end^

Unfortunately this leads to an error:

I guess that executing scripts is different from executung regular sql statements. Delphi has special script classes at least for firebird scripts as they cannot be executed through query classes that can also execute a single insert oder update.

It would really be great if executing scripts would be possible.

0
Avatar
vasily chernov
Created

I see. I think it hasn't supported yet. 

Please, follow the issue https://youtrack.jetbrains.com/issue/DBE-20371/Firebird-SQL-Script-support to get updates

0
Avatar
Guilherme Souza
Created

I have the same problem, unfortunatelly have to use DBeaver just to run scripts.

There's also another issue, it doesn't show the miliseconds in the timestamp columns, it shows ie "2024-05-25 12:00:00" when DBeaver shows “2024-05-25 12:00:00.123” ← 123 = example of miliseconds.

0

Please sign in to leave a comment.