Skip to main content

Vertica Driver - Database Ports Above 32767 Not Supported

  • Dec 1, 2015 7:33 PM UTC
  • 6 replies
  • 30 views

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?

6 replies

NorbertK
Forum|alt.badge.img
  • Participating Frequently
  • Dec 2, 2015 2:05 AM UTC

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


KurtK
  • Author
  • New Participant
  • Dec 2, 2015 2:36 AM UTC
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
Forum|alt.badge.img
  • Participating Frequently
  • Dec 2, 2015 2:50 AM UTC

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
  • Author
  • New Participant
  • Dec 2, 2015 3:17 AM UTC
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
  • Author
  • New Participant
  • Dec 2, 2015 4:53 PM UTC

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
  • Author
  • New Participant
  • Dec 3, 2015 10:36 PM UTC

Ping...Can anyone help address this issue?