Does JDBC driver support multiple hostnames?

apednekar · July 16, 2020, 8:15am

I did not find this in the JDBC driver docs so asking here:

Does Opendistro JDBC driver support having multiple comma seperated hostnames in the connection string ?

For example, this is what we do with postgres:
jdbc:postgresql://host1:5488,host2:5488/orders?prepareThreshold=0

virajph · August 21, 2020, 10:25pm

Moving the question from General Feedback to SQL. We will get back to you at the earliest.

penghuo · September 21, 2020, 5:56pm

No, it only support single host:port pair.
You could find the JDBC doc in here.

github.com

opendistro-for-elasticsearch/sql/blob/main/sql-jdbc/README.md

## Open Distro for ElasticSearch - JDBC

This is the driver for JDBC connectivity to a cluster running with Open Distro for Elasticsearch SQL support.

## Specifications

The driver is compatible with JDBC 4.2 specification and requires a minimum of Java 8.

## Using the driver

The driver comes in the form of a single jar file. To use it, simply place it on the classpath of the
Java application that needs to use it.

If using with JDBC compatible BI tools, refer to the tool documentation on configuring a new JDBC driver. Typically,
all that's required is to make the tool aware of the location of the driver jar and then use it to setup database (i.e
Elasticsearch) connections.

### Connection URL and other settings

To setup a connection, the driver requires a JDBC connection URL. The connection URL is of the form:

This file has been truncated. show original

Topic		Replies	Views
Opendistro Sql JDBC driver SQL	10	3294	July 8, 2020
Opendistro jdbc issue SQL	3	738	July 14, 2020
Open Distro JDBC with Dbeaver SQL	4	3802	March 11, 2020
Jdbc data access issue SQL	10	1582	July 14, 2020
Queries regarding sql-jdbc SQL	1	1346	October 31, 2019

Does JDBC driver support multiple hostnames?

Related topics