search

ArcadeData / arcadedb

ArcadeDB Multi-Model Database, one DBMS that supports SQL, Cypher, Gremlin, HTTP/JSON, MongoDB and Redis. ArcadeDB is a conceptual fork of OrientDB, the first Multi-Model DBMS. ArcadeDB supports Vector Embeddings.
https://arcadedb.com
Apache License 2.0
487 stars 60 forks source link

connecting by sql client (dbeaver and datagrip) not possible #1478

Closed maw2be closed 7 months ago

maw2be commented 7 months ago

ArcadeDB Version:

v24.1.1

OS and JDK Version:

Runs on Linux 6.5.11-4-pve - OpenJDK 64-Bit Server VM 11.0.22 (Temurin-11.0.22+7)

Expected behavior

able to connect

Actual behavior

`SQL Error [42601]: ERROR: Syntax error on executing query: Encountered "n" at line 1, column 84. Was expecting one of:

... ... ... ... ... ... ... ";" ... "," ... ":" ... ":" ... ... "," ... ERROR: Syntax error on executing query: Encountered "n" at line 1, column 84. Was expecting one of: ... ... ... ... ... ... ... ";" ... "," ... ":" ... ":" ... ... "," ... ERROR: Syntax error on executing query: Encountered "n" at line 1, column 84. Was expecting one of: ... ... ... ... ... ... ... ";" ... "," ... ":" ... ":" ... ... "," ... ` ### Steps to reproduce `Try to connect to database using sql client, sslmode: disable, preferQueryMode:simple dbeaver 23.3.4 (both Old and New driver) datagrip 2023.3.4` ``
gramian commented 7 months ago

Could you please add with which client in which version you get these errors, and what steps you did to connect? Thank you!

maw2be commented 7 months ago

Could you please add with which client in which version you get these errors, and what steps you did to connect? Thank you!

dbeaver 23.3.4 (both Old and New driver) datagrip 2023.3.4

steps to connect: creating new connection, changing settings base on documentation from arcadedb website

EDIT: after more play with this on old driver in dbeaver connection is active and can execute sql, but each click in connection tree show this error. In datagrip on console when I try to execute any sql command (create document type abc if not exists) I get small popup 'Nothing to run'

gramian commented 7 months ago

OK, to clarify: when using DBeaver,

  1. You started ArcadeDB with the Postgres option: -Darcadedb.server.plugins="Postgres:com.arcadedb.postgres.PostgresProtocolPlugin"
  2. Added a new connection Postgres (Old) in DBeaver with
    • Host
    • Database
    • Username
    • Password
    • Driver Settings
    • sslMode = disable
    • preferQueryMode = simple
    • "Test Connection" button reports a working connection
maw2be commented 7 months ago

OK, to clarify: when using DBeaver,

  1. You started ArcadeDB with the Postgres option: -Darcadedb.server.plugins="Postgres:com.arcadedb.postgres.PostgresProtocolPlugin"
  2. Added a new connection in DBeaver with
  • Host
  • Database
  • Username
  • Password

  • Driver Settings

    • sslMode = disable
    • preferQueryMode = simple
  • "Test Connection" button reports a working connection

yes, on dbeaver old driver I get test connection ok, when opening connection tree get this error. on datagrip test connection is also ok, but can't run any command

gramian commented 7 months ago

Ah, I see what you mean now. Sorry.

So these "folders" cannot work with ArcadeDB as they would require the original postgres pseudo tables and alike. These do not map to the non-relational model of ArcadeDB. You have to use SQL editor directly for all your requests and browsing a database.