I have an odd problem with db_connect :
My connection is ok
I can see the database and the tables but when i try to query (basic select) i have an error
Error in 'dbxquery' command: External search command exited unexpectedly with non-zero error code 255
My query is simple | dbxquery query="SELECT * FROM sys.sys_config" connection="da" even select 1 from dual doesn't work
| dbxquery query="SELECT * FROM sys.sys_config" connection="da"
select 1 from dual
Database : MySQL 5.7
User : root privileges
DB connect 3.1.1
I have downgraded DB connect (from 3.1.1 to 2.4.1) and now it works
View solution in original post
In my case, JVM options was empty in the settings.
I click reset and save. it work.
OR write follow.