Supported DBMS & Versions

A summary of the DBMS supported by NeoSQL, their version coverage, and the JDBC drivers bundled with NeoSQL.

DBMSSupported VersionsBundled JDBC Driver
MariaDB10.x / 11.xmariadb-java-client 3.0.4
MySQL5.x / 8.xmysql-connector-j 8.3.0 (8.x)
mysql-connector-java 5.1.49 (5.x)
Oracle11g / 12c / 19c / 21cojdbc8 23.3.0.23.09
PostgreSQL9.x or laterpostgresql 42.7.3
SQL Server2014 / 2016 / 2017 / 2019 / 2022, Azure SQLmssql-jdbc 12.6.1.jre11
SQLite3.xsqlite-jdbc 3.45.3.0
H22.x (Embedded / Server / In-Memory)h2 2.1.214

Note: To use a version not listed here, register your own .jar file via Add Custom Driver from the JDBC Driver settings on the connection screen (Desktop mode only).

DBMS Connection Guide

Per-DBMS JDBC URL, driver, and default property reference for each database supported by NeoSQL.

MariaDB

FieldValue
Default port3306
JDBC URLjdbc:mariadb://{host}:{port}/{database}
Driverorg.mariadb.jdbc.Driver

Default connection properties:

  • useUnicode=true — Unicode support
  • characterEncoding=utf8 — UTF-8 encoding
  • useSSL=false — Disable SSL
  • allowMultiQueries=true — Allow multiple queries

MySQL

FieldValue
Default port3306
JDBC URLjdbc:mysql://{host}:{port}/{database}
Drivercom.mysql.cj.jdbc.Driver

Default connection properties:

  • serverTimezone=Asia/Seoul — Server timezone setting
  • useSSL=false — Disable SSL

Oracle

Supported versions: 11g / 12c / 19c / 21c

FieldValue
Default port1521
Driveroracle.jdbc.OracleDriver
Driver typeChoose from thin, oci, oci8

Oracle allows you to choose a connection method:

Connection MethodJDBC URL
Service Namejdbc:oracle:thin:@//{host}:{port}/{serviceName}
SIDjdbc:oracle:thin:@{host}:{port}:{SID}

Oracle-specific options:

  • oracleRetrieveRemarks=true — Retrieve table/column comments (may increase query time)
  • oracleRetrieveSynonyms=false — Include public synonyms

PostgreSQL

FieldValue
Default port5432
JDBC URLjdbc:postgresql://{host}:{port}/{database}
Driverorg.postgresql.Driver

SQL Server

FieldValue
Default port1433
JDBC URLjdbc:sqlserver://{host}:{port};database={database}
Drivercom.microsoft.sqlserver.jdbc.SQLServerDriver

Default connection properties:

  • encrypt=true — Connection encryption
  • trustServerCertificate=true — Trust server certificate

Note: SQL Server uses <code>;</code> (semicolon) instead of <code>&</code> as the connection property separator.

SQLite

FieldValue
JDBC URLjdbc:sqlite:{파일 경로}
Driverorg.sqlite.JDBC

SQLite is a file-based database that connects directly to a local file without a separate server.

  • No host, port, username, or password required.
  • Only specify the database file path to connect.

Connection examples:

  • jdbc:sqlite:/Users/user/data/mydb.db — Absolute path
  • jdbc:sqlite:./data/mydb.db — Relative path
  • jdbc:sqlite::memory: — In-memory (volatile)

Note: SQLite is only available in Desktop mode. Since local file system access is required, it is not supported in Web App mode.

H2

FieldValue
Default port9092 (TCP 모드)
Driverorg.h2.Driver

H2 allows you to choose a connection mode:

ModeJDBC URLDescription
TCPjdbc:h2:tcp://{host}:{port}/{database}Remote access over network
Embeddedjdbc:h2:{database}Local file-based access
In-Memoryjdbc:h2:mem:{database}In-memory (volatile)