Port definition in dbTypes is inconsistent

[npetzall]

Some have and some expects PORT to be included in

description=MariaDB

connectionSpec=jdbc:mariadb://<host>:<port>/<db>
host=hostname host where database resides with optional port
db=database name

description=MySQL

connectionSpec=jdbc:mysql://<host>/<db>
host=hostname[:port] host where database resides with optional port
db=database name

[npetzall]

@rafalkasa
Looking over the dbTypes.
Some have the split some doesn't in most cases where they don't it's
<host>:<port> except for Teradata which is just plain weird.

# Example of connectionSpec: jdbc:teradata://TD.DB.ROOT1.NET/DATABASE=DB1,DBS_PORT=1025
connectionSpec=jdbc:teradata://<db>/DATABASE=<s>,DBS_PORT=<port>
db=database name
s=?????
port=?????

db is mapped to host and s is mapped to database. I'm guessing this might be related to schema, catalog but I'm unsure. @ClintEstwood might have input.

So to not screw everything up we could replace <host>(where host[:port]) and <host>:<port> with <hostAndPort>, we compute the value. Using a default separator of ":". If port is empty no separator will be used and <hostAndPort> == <host>. You'll still able to use <host> and <port>.
Separator can be overridden in dbType with hostPortSeparator.

I'm just assuming not all jdbc drivers would like jdbc:mariadb://localhost:/test when port is left for default of jdbc-driver.

[npetzall]

@rafalkasa is a viable solution? Should I go ahead.