Firebird SQL Script support

已回答

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 ´.

 

0

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

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

@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

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

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

请先登录再写评论。