Vertica Driver - Database Ports Above 32767 Not Supported

KurtK

I'm using Vertica in a Docker image with Docker Compose. When doing this it exposes Vertica to the host machine on a Random port. However, it appears that the Vertica driver is unable to connect to Vertica if it's on a port above 32767. When a port such as 32768 is supplied it will revert it to 5433 before connecting which fails as Vertica is not listening on that port.

 

Is there a reason that this is not supported? Can the driver be updated to support this?

NorbertK

My guess is because it's above the maximum value that 2 bytes (signed) can store.

KurtK

That's my guess as well. Docker assigns a dynamically exposed port in the ephemeral port range which is going to be frequently above 2-byte limit so it would be really great if the driver could be updated to use a data type with a higher limit to accommodate these port values which in my opinion should be valid.

NorbertK

Interestingly, the 6.0 documentation shows that higher ports (48073 and higher) must be open. I believe UDP/TCP still use up to 65535. Which specific driver are you using?

KurtK

I'm using the Vertica JDBC driver. I believe I tried both 6 and the latest 7 driver release but I can get you the specific version numbers tomorrow morning.

KurtK

I'm trying to connect to Vertica using the latest JDBC driver: vertica-jdbc-7.2.0-0.jar

 

It's still not allowing me to connect via a port number that greater than 32767. When port numbers greater than this are supplied it just tried to connect on 5433.

KurtK

Ping...Can anyone help address this issue?