fdw/jdbc: Support and document adding additional jdbc drivers #15793
Labels
complexity: no estimate
feature: fdw
Foreign data wrapper
needs discussion
needs upvotes
Please use the reaction feature on the issue to signal your interest. This helps us prioritize
Problem Statement
CrateDB only includes a PostgreSQL JDBC driver. FDW/JDBC can't be used to connect to other servers like MySQL or MSSQL.
It's not documented how a driver for a different server can be added.
There should also be a way to add drivers for docker/container deployments. Maybe via a dedicated external-libs folder and volume mounts.
Possible Solutions
Some options:
lib/
external-libs/
folder and setup volume mounts for the docker image. See if adding class-loader isolation is necessary to avoid JarHell if the dependency include duplicate classes.Whatever option is taken, we also need to reconsider the "local" protection limitations as pointed out in #15776 (review)
(Worst case option could be something like changing
fdw.allow_local
to supportnever | if-unkown | always
), whereif-unknown
is strict for the PostgreSQL case or if the URL parses as URI, but accepts it if it can't parse the URI safely.)Considered Alternatives
No response
The text was updated successfully, but these errors were encountered: