[NETBEANS-170] DB-Driver: Add option to automaticly install driver from external source

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: db - Code
• Assignee: Unassigned
• Reporter: Matthias Bläsing
• Created: 26/Nov/17 11:00
• Updated: 01/Aug/20 21:33

Description

With the transition to the apache foundation it gets more difficult to bundle arbitrary libraries.

In this case the libraries are JDBC drivers. For example the mysql JDBC driver had to be removed from distribution as the apache foundation won't redistribute binaries with licenses more restrictive, that the ALv2.

With only one remaining bundle driver (postgresql) the bundled functionality is mostly useless. So the process need to be improved: A rough outline:

• add a driver template mechanism to netbeans
• a driver template holds the information about a driver and the source
• applying the template would request the user if he wants to download the driver and requires the user to agree that the driver is not covered by the same license as netbeans itself
• the downloaded jars will be placed in the userdir and the drivers reference these

The primary source for the drivers should be maven central, as many vendors (including non-OSS) drivers are are present there:

DB	URL
MySQL	http://www.maven.org/#artifactdetails%7Cmysql%7Cmysql-connector-java%7C8.0.8-dmr%7Cjar
MariaDB	http://www.maven.org/#artifactdetails%7Corg.mariadb.jdbc%7Cmariadb-java-client%7C2.2.0%7Cjar
PostgresSQL	http://www.maven.org/#artifactdetails%7Corg.postgresql%7Cpostgresql%7C42.1.4%7Cbundle
H2	http://www.maven.org/#artifactdetails%7Ccom.h2database%7Ch2%7C1.4.196%7Cjar
Derby	http://www.maven.org/#artifactdetails%7Corg.apache.derby%7Cderby%7C10.14.1.0%7Cjar
MSSQL	http://www.maven.org/#artifactdetails%7Ccom.microsoft.sqlserver%7Cmssql-jdbc%7C6.2.2.jre8%7Cjar
Informix	http://www.maven.org/#artifactdetails%7Ccom.ibm.informix%7Cjdbc%7C4.10.9%7Cjar

For the maven based installers the license information can be extracted from the pom.xml and displayed to the user when installing other sources will need different approaches.

Issue Links

• is duplicated by: NETBEANS-1680 SQL Drivers should be downloaded automatically
• is related to: NETBEANS-870 Update bundled Postgres JDBC driver
• relates to: NETBEANS-70 Remove bundled mysql db driver