SQLinForm SQL FormatterCommunity Discussion Forum
SQLinForm SQL Formatter
I copied the SQLinForm as External SQL Formatter in DBeaver command from the UI and pasted it into the Command Line Box of the external formatter command line setting, but now when I try to format my SQL code, it removes all the code in the current window.
Any idea what I did wrong?
Hi Kyle@stow,
could you please post this screen from your DBeaver installation
Thanks
Guido
@SirThisMan, thanks for your feedback. Looking to the log it seems that the formatter is not allowed to read in the DBeaver directory
Regards
Guido
Not to necro an old thread but the original poster never seemed to respond.
I am having the same issue. When run the formatter, everything in the dBeaver editor disappears.
Originally the dbeaver log was reporting the external formatter process was hanging, so I increased the timeout to 5000. Interestingly, no .log file seems to be generated in the SQLinForm directory.
*edit: I also tried running dbeaver in administrator mode.
Of course as soon as I post I find the issue.
It looks like the issue is with the temp file path being passed to the cli. From the profileX_work.json logfile, I can see that the path is missing a \ between C:\Users and the username.
I.e. C:\usersusername\local\temp\dbeaver-blahblahblah is being passed instead of C:\users\username\local\temp\dbeaver-blahblahblah
I'm guessing this is a dbeaver issue with its ${file} variable generation. As a workaround I created a symbolic link between c:\usersusername and c:\users\username. Not ideal but effective.
@na5772, many thanks for your feedback. This is of great help.
Will also do some investigations
Regards
Guido
