letting dbeaver talk with manticoresearch

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 -

2 thoughts on “letting dbeaver talk with manticoresearch

  1. 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?

    1. i’ve run it under windows, there dbeaver gave me ability directly from GUI to download and install needed jar

Leave a Reply

Your email address will not be published. Required fields are marked *

(Spamcheck Enabled)