Menu

#1516 MariaDB default URL

SQuirreL
open
nobody
None
medium
2023-05-16
2023-05-11
No

The default URL for the MariaDB driver is "jdbc:mysql://host:3306/database". This kind of URL fails for the 3.x versions of the driver (which is out since 2021 I think) : "class java.sql.SQLException: Unable to create connection. Check your URL.". It worked for the 2.x versions.

To simplify research: Here is the driver URL: https://mariadb.com/downloads/connectors/connectors-data-access/java8-connector (you can still switch to 2.7.x download)

I suggest to update the default URL to "jdbc:mariadb://host:3306/database", as most new users will use the current driver. Or is it possible to switch the URL depending in the JAR file version?

Best regards and many thanks for this great tool!

Wolfgang

Discussion

  • Gerd Wagner

    Gerd Wagner - 2023-05-14

    You're welcome.

    The MariaDB JDBC URL was corrected and available in the latest snapshot here:
    https://sourceforge.net/projects/squirrel-sql/files/3-snapshots/snapshot-20230514_2117/

    Note: To protected changes done by the user SQuirreL does not change existing driver definitions. That is why in order to see the new example URL you'd have to delete your existing MariaDB driver and then use menu Drivers --> Install Default Driver Definitions.

     

    Last edit: Gerd Wagner 2023-05-14
  • Wolfgang Knauf

    Wolfgang Knauf - 2023-05-16

    Thanks, I can confirm that it works now.

     

Log in to post a comment.