vim-sql-workbench icon indicating copy to clipboard operation
vim-sql-workbench copied to clipboard

Windows sql workbench/j config file

Open kevinxso99 opened this issue 5 years ago • 11 comments

Set SQL Workbench/J to not use JLine (in SQL Workbench/J config file, add the following line: workbench.console.use.jline=false)

Excuse me sir, i just wanna talk about where config file sql workbench in windows 10 os?, Thank you.

kevinxso99 avatar Oct 13 '20 17:10 kevinxso99

You can check out the documentation here: https://www.sql-workbench.eu/manual/install.html#config-dir

cosminadrianpopescu avatar Oct 15 '20 09:10 cosminadrianpopescu

You can check out the documentation here: https://www.sql-workbench.eu/manual/install.html#config-dir

Ok sir, but right now my "sqlworkbench.exe is not executable. Make sure the permissions are set correctly". I don't know what the problem with that i've searching at google and can't get the answer why & what the solution for this problem

May u answer what the solution for this one?

kevinxso99 avatar Oct 16 '20 23:10 kevinxso99

set the g:sw_config_dir, g:sw_exe and g:sw_cache variables

Did you set the 3 variables?

  • g:sw_config_dir
  • g:sw_exe
  • g:sw_cache ?

cosminadrianpopescu avatar Oct 17 '20 05:10 cosminadrianpopescu

Annotation 2020-10-17 210906

set the g:sw_config_dir, g:sw_exe and g:sw_cache variables

Did you set the 3 variables?

  • g:sw_config_dir
  • g:sw_exe
  • g:sw_cache ? yes sir, i'm adding at my init.vim Annotation 2020-10-17 210507 and this error when i start my neovim

kevinxso99 avatar Oct 17 '20 13:10 kevinxso99

Can you try from a cmd to run c:/Users/FX553VD/appdata/local/nvim/sql-workbench/sqlwbconsole.exe?

Because I have the impression that this is your nvim install folder.

You need to install separately the SQL Workbench/J application (basically just unzip the downloaded zip from here) and then point the g:sw_exe variable to the sqlwbconsole.exe in the unzipped folder.

Anyway, just check also the cmd result.

cosminadrianpopescu avatar Oct 17 '20 13:10 cosminadrianpopescu

Can you try from a cmd to run c:/Users/FX553VD/appdata/local/nvim/sql-workbench/sqlwbconsole.exe?

Because I have the impression that this is your nvim install folder.

You need to install separately the SQL Workbench/J application (basically just unzip the downloaded zip from here) and then point the g:sw_exe variable to the sqlwbconsole.exe in the unzipped folder.

Anyway, just check also the cmd result.

Yes sir, this work when i open from cmd Annotation 2020-10-17 213601

kevinxso99 avatar Oct 17 '20 13:10 kevinxso99

Can you try from a cmd to run c:/Users/FX553VD/appdata/local/nvim/sql-workbench/sqlwbconsole.exe?

Because I have the impression that this is your nvim install folder.

You need to install separately the SQL Workbench/J application (basically just unzip the downloaded zip from here) and then point the g:sw_exe variable to the sqlwbconsole.exe in the unzipped folder.

Anyway, just check also the cmd result.

the latest version don't have sqlwbconsole.exe just have cmd extensions sir instead i use version 125 Annotation 2020-10-17 214045

kevinxso99 avatar Oct 17 '20 13:10 kevinxso99

Normally you only have to change .exe with .cmd in the g:sw_exe variable. Can you try to find the sqlwbconsole.exe or sqlwbconsole.cmd in WIndow explorer and right click it, check the executable attribute. If it's not set, set it and try again. If it's already set, let me know and I will see if I can find a Windows to test it.

cosminadrianpopescu avatar Oct 17 '20 19:10 cosminadrianpopescu

this user permission at sqlwbconsole.cmd sir Annotation 2020-10-18 070258 an and this one attribute sqlwbconsole.cmd, i was set attribute r for readonly file but not working sir Annotation 2020-10-18 070405

kevinxso99 avatar Oct 17 '20 23:10 kevinxso99

I am facing same issue.

sqlwbconsole.cmd is not executable. Make sure the permissions are set correctly. Error detected while processing function sw#profiles#update[1]..sw#background#run[8]..sw#server#execute_sql[38]..<SNR>89_log_channel: line 6: E716: Key not present in Dictionary: "0" Error detected while processing function sw#profiles#update[1]..sw#background#run[8]..sw#server#execute_sql: line 43: E900: Invalid channel id Error detected while processing function sw#profiles#update[1]..sw#background#run[8]..sw#server#execute_sql: line 47: E716: Key not present in Dictionary: "0" Error detected while processing function sw#profiles#update[1]..sw#background#run[8]..sw#server#execute_sql: line 47: E15: Invalid expression: g:sw_command_timer && !s:channel_handlers[channel].background Error detected while processing function sw#profiles#update[1]..sw#background#run[9]..sw#server#execute_sql[38]..<SNR>89_log_channel: line 6: E716: Key not present in Dictionary: "0" Error detected while processing function sw#profiles#update[1]..sw#background#run[9]..sw#server#execute_sql: line 43: E900: Invalid channel id Error detected while processing function sw#profiles#update[1]..sw#background#run[9]..sw#server#execute_sql: line 47: E716: Key not present in Dictionary: "0" Error detected while processing function sw#profiles#update[1]..sw#background#run[9]..sw#server#execute_sql: line 47: E15: Invalid expression: g:sw_command_timer && !s:channel_handlers[channel].background

able to run sqlwbconsole.cmd from command prompt

3rdey3 avatar Dec 02 '21 08:12 3rdey3

@3rdey3 what is the g:sw_exe variable value? Is it prompting to the right sqlwbconsole.cmd?

cosminadrianpopescu avatar Jan 04 '22 19:01 cosminadrianpopescu