[Solved] All SQL code being deleted when I try to format

Hi Kyle@stow,

could you please post this screen from your DBeaver installation

Thanks

Guido

@admin hello,I got the same question.here are setting and log.

What can I do to fix this？

Thanks

@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