[GitHub] [arrow] aiguofer commented on issue #34829: [Java] Ability to use a path based host when using the JDBC driver

["aiguofer (via GitHub)" <gi...@apache.org>]

aiguofer commented on issue #34829:
URL: https://github.com/apache/arrow/issues/34829#issuecomment-1512018271

   Hey, sorry been pulled in other directions recently. In our case, we're looking to have a reverse proxy in front of the gRPC server which would simply use the path based approach to know which gRPC server to forward the request to. For example calling `arrow.flight.protocol.FlightService.Handshake` to `mydomain.com/grpc/flight_service` would forward the request to our `FlightServer`, while a `MessageService.SendMessage` request to `mydomain.com/grpc/messaging` would be forwarded to our Messaging service. The path would have no other meaning other than letting the reverse proxy know what service to hit.
   
   I looked over that discussion and it seems like it's leaning towards something like:
   
   ```
   jdbc:arrow-flight-sql://mydomain.com:443/catalog/schema/hierarchy
   ```
   
   I think this still leaves the option of something like:
   
   ```
   jdbc:arrow-flight-sql://mydomain.com/grpc/flight_service:443/catalog/schema/hierarchy
   ```
   
   which is similar to how the BigQuery driver does it.
   
   It's also possible that something like
   ```
   jdbc:arrow-flight-sql://mydomain.com:443/catalog/schema/hierarchy?urlPath=/grpc/flight_service
   ```
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@arrow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org