[Feature Request]: When making rdbms connections, show signal of driver install/not give option to download

[usbrandon]

What would you like to happen?

When creating a new database connection, we should show a marker indicating the presence of the required driver to connect or not. No need to wait for them to try to connect to get a stacktrace.

Much like DBeaver, we can give folks a dialog that allows them to download the driver to the appropriate location for the database selected.

Example: Driver detected after selecting from the database type list.

Example: Driver not detected. Provide a download button and dialog to guide downloading the new driver. Se DBeaver that does this well.

Issue Priority

Priority: 3

Issue Component

Component: Database

[usbrandon]

https://github.com/dbeaver/dbeaver/blob/26c1d8372852556c4428f2fefe5733b3fe780466/plugins/org.jkiss.dbeaver.registry/src/org/jkiss/dbeaver/registry/driver/DriverClassLoader.java#L43

Looks like they keep a library of known classes.

[usbrandon]

They download the drivers from Maven. https://dbeaver.com/docs/wiki/Database-drivers/

[usbrandon]

Here is where they read the XML from Maven to get driver details.
https://github.com/dbeaver/dbeaver/blob/85ca6582673a63c727e812ca4fa1e030484df449/plugins/org.jkiss.dbeaver.ui.editors.connection/src/org/jkiss/dbeaver/ui/dialogs/driver/EditMavenArtifactDialog.java#L283

[hansva]

thanks for the extra information @usbrandon !

[usbrandon]

This short page of documentation explains exactly how they use Maven artifacts to power downloading the drivers to the desired location to make them work. It is very streamlined.
https://github.com/dbeaver/cloudbeaver/wiki/Adding-new-database-drivers

They have an XML file with a URL like this:

<file type="jar" path="maven:/org.postgresql:postgresql:RELEASE[42.2.25]" bundle="!drivers.postgresql"/>
                    <file type="jar" path="drivers/postgresql" bundle="drivers.postgresql"/>

Is there a java library that hop could use to resolve the maven location and download the jar to whatever relevant database plugin lib folder?

[hansva]

First part has been added now, "Show if a driver is present"
@nadment, will you handle the downloading of drivers ? Probably it should be able to download a list of jars as some drivers require more than one file. Or should I do that?

[nadment]

This is not an easy task to download drivers files

• some drivers have several files (sometimes optional)
• some with a DLL depending on the architecture (x86, x86_64...)
• manage the proxy
• a lot of Maven references to keep up to date.

Using DBeaver I don't always find it practical and obvious, the manuel installation often seems to be easier