I want to access MongoDB collections through MariaDB 10.4.17. Both are installed on my local machine running Windows 10.
| Software | listening port |
|---|---|
| MongoDB | 27017 |
| MariaDB | 15501 |
I installed the MariaDB Connect Engine using
INSTALL SONAME 'ha_connect'; on the MariaDB CLI
The collection I want to access is named receptors and has documents like these
{ "_id" : 1, "taste" : "Umami", "receptor_name" : "mGluR4", "uniprot_id" : "Q14833" } this is the create table statement I used on mariadb
CREATE TABLE receptors ( _id varchar(24) NOT NULL, taste varchar(64) DEFAULT NULL, receptor_name varchar(64) DEFAULT NULL, uniprot_id varchar(64) DEFAULT NULL ) ENGINE=CONNECT DEFAULT CHARSET=utf8mb4 CONNECTION='mongodb://localhost:27017' table_type=MONGO tabname='receptors' data_charset=utf8 The table was created, but when I execute
SELECT * FROM receptors I get this error:
ERROR 1296 (HY000): Got error 174 'Error 126 loading module jvm.dll: The specified module could not be found. ' from CONNECT I fixed it by giving a path to JVM like this
set global connect_jvm_path="C://Program Files//Java//jdk-12.0.1//bin//server" Next error I got is this which I am unable to figure out
ERROR 1296 (HY000): Got error 174 'ERROR: class wrappers/Mongo3Interface not found!' from CONNECT I have the JavaWrappers file here: C:\Program Files\MariaDB 10.4\lib\plugin
It should contain the Mongo3Interface but does not.
I have no idea what I am doing wrong, and the MariaDB documentation isn't much help.