here’s what i did to get dbeaver 7.3.2 + oracle’s JDBC mysql-connector-java-8.0.17.jar work with manticoresearch 3.5.4:
- /etc/manticoresearch/manticore.conf, under searchd:
listen = 127.0.0.1:9306:mysql mysql_version_string = 5.1.0
in dbeaver – new connection using oracle’s JDBC driver as above, under data editor – set ResultFetchSize to 0 to prevent errors like this:
SQL Error  : sphinxql: only 0 and 1 could be used as boolean values near '200'
when i initially tried to get it working with JDBC driver from MariaDB snooping on the payload of the binary communication was helpful:
tcpdump -n -i lo -w - port 9306 | tcpflow -C -r -