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

10 Posts
6 Users
0 Reactions
3,160 Views
Guido
Posts: 295
Admin
(@admin)
Member
Joined: 5 years ago

@na5772, many thanks for your feedback. This is of great help.

Will also do some investigations

Regards

Guido


Reply
Posts: 2
(@na4711)
Member
Joined: 9 months ago

I have the same issue.

 first it was a problem on reading writing in the directory, nothing happened, now with write permission, the SQL disappears.

i put everythin in c:\tmp to avoid problems with directory acces and reading /writing rights

cli.exe is in c:\tmp\

and there is a directory C:\tmp\SQLinForm where profile1_work.json.log is written to.

 

so command line is

"C:\tmp\cli.exe" -dbeaver ${file}

 

log is

08.10.2025 12:40:06
------------------------------
Number of args passed: 2
Args : -dbeaver
Read file failed : C:\tmp\SQLinForm\dbeaver.json${file}
Input FileName: ${file}
Output FileName: ${file}
Profile FileName: C:\tmp\SQLinForm\profile1_work.json
Read file failed : ${file}
Read input file failed
*

i have a symbolic link in the directory 

C:\tmp\SQLinForm\

but whatever i do, making a link called  dbeaver.json${file} which points to 

C:\tmp\SQLinForm

or to 

C:\tmp\SQLinForm\dbeaver.json

or to 

C:\tmp\SQLinForm\dbeaver.json${file}

and no matter where i put a file ${file}

in 

C:\tmp\SQLinForm\

or

C:\tmp\SQLinForm\dbeaver.jsondatei${file}

and pointing the link to this file

or pointing the link to the directory

 

I get the above error. So how has the link to be configured. Name of the link Source / Target of the link

 

by the way: Notepad++ formatter works , so i get the sql formatted.... 

 


Reply
Posts: 11
(@guidomarcel)
Member
Joined: 5 years ago

Hi @na4711,

thanks for your feedback.

Is the formatting working when you do not work with links?

Could you please post a screenshot from c:\tmp directory and from s:\tmp\SQLinForm directory

Regards

Guido


Reply
1 Reply
(@na4711)
Joined: 9 months ago

Member
Posts: 2

funny. we can close (for me ) the ticket. 

i restarted the computer inbetween and i restarted dbeaver .

then, to make screenshots for you, i changed 2-3 times the checkbox "create temp file "

and added the ${file} again

first it didnt work  now it works !

without all the links ! 

 

Ghost in the machine. ...

thanks.  

but it is strange behaviour from debeaver. Version 25.0.4.202505041731 

Screenshot 2025 10 08 141058
Screenshot 2025 10 08 141353

Reply
Page 2 / 2
Share: