INNOV-AI

Innovation and Research from Réunion Island, France

Back   Home

Generate a MQL query to update a database connection @ CONNECT - Connections @ MentDB Weak

> Start the server
> (or start the server for the first time (embedded mode - H2 Database))
> (or start the server for the first time (remote mode - MySQL 8 Database))
> Open the MentDB Weak Editor

Click on 'CONNECT' tab, open 'Database', right click on 'MENTDB' and select 'Generate update'

MQL INPUT
json load "tmpCm" "{}";
json iobject "tmpCm" / "driver" "org.h2.Driver" STR;
json iobject "tmpCm" / "defaultSchema" "public" STR;
json iobject "tmpCm" / "subType" "H2" STR;
json iobject "tmpCm" / "loginTimeout" "10000" STR;
json iobject "tmpCm" / "jdbc" "jdbc:h2:./data/mentdb_h2" STR;
json iobject "tmpCm" / "k" "MENTDB" STR;
json iobject "tmpCm" / "type" "db" STR;
json iobject "tmpCm" / "properties" "{}" OBJ;
json iobject "tmpCm" /properties "DATABASE_TO_LOWER" "TRUE" STR;
json iobject "tmpCm" /properties "password" "pwd" STR;
json iobject "tmpCm" /properties "MODE" "MYSQL" STR;
json iobject "tmpCm" /properties "user" "root" STR;
cm set "MENTDB" {json doc "tmpCm"};
start: 2026-01-17   end: 2026-01-30   v_start: 401   v_end: