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 [1064] [42000]: 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 -
I would like to know how you included/integrated mysql-connector-java with dbeaver.
Did you create a custom driver type?
I installed it on Ubuntu as a deb package, but I have no clue, what I have to provide on the driver edit page besides the .gz I assume, the classname, but which one is it?
i’ve run it under windows, there dbeaver gave me ability directly from GUI to download and install needed jar