search

TablePlus / TablePlus-Windows

TablePlus Windows issue tracker
https://tableplus.com
185 stars 3 forks source link

DB2 connect from URL #623

Open RobinLenaerts-r0627775 opened 11 months ago

RobinLenaerts-r0627775 commented 11 months ago

Please answer the questions below, it helps us to track the issue.

  1. Which driver are you using and version of it (Ex: PostgreSQL 10.0): v11.5.4 com.ibm.db2.jcc.db2driver

  2. Which TablePlus build number are you using (the number on the welcome screen, Ex: build 81): build 240

  3. The steps to reproduce this issue: add connection > import from url > use url like it is listed here: https://tableplus.com/blog/2019/09/jdbc-url-formats.html

I get error: "invalid URL"

Would it be possible to provide an explanation of how to use the "import from url" function correctly?

Thanks :)

sonswift commented 11 months ago

Hi @RobinLenaerts-r0627775, here is a minimal example of Connection URL. Hope this help

With SSH

<driver>+<ssh>://<ssh_username>:<ssh_password>@<ssh_host>:<ssh_port>/<database_user>@<database_host>:<database_port>/<database_name>

Without SSH

<driver>://<database_user>@<data_host>:<database_port>/<database_name>

driver: Eg: postgresql, mysql

RobinLenaerts-r0627775 commented 11 months ago

Thanks for the quick response!

But I'm afraid I'm not quite there. This just auto-fills in the form to add a connection instead of creating a connection, so is this even possible with jdbc drivers? And if so, where do they need to be installed?