JDBC Storage Plugin and Postgres

[Michael Franzkowiak]

I wanted to give the JDBC Storage Plugin a spin and tried to connect to a
Postgres DB.

I set up the storage plugin using the following config:

{
  "type": "jdbc",
  "driver": "org.postgresql.Driver",
  "url": "jdbc:postgresql://127.0.0.1/mydb",
  "username": "dev",
  "password": null,
  "enabled": true
}

Unfortunately SHOW TABLES does not return anything.

Also I wasn't able to execute a query on the Postgres DB. For any query I
ran (e.g. SELECT some_column FROM mytable) it would just return:

Error: DATA_READ ERROR: The JDBC storage plugin failed while trying setup
the SQL query.
sql SELECT *
FROM "mydb"."mytable"
plugin postgres
Fragment 0:0

Anything I'm doing wrong? Not a drill expert ( yet :) ).