For example,įoo:bar abc:xyz creates the credential named abc Defaults to false.Įxtra credentials for connecting to external services, This allows client to use Kerberos authentication without passing Set to true to use the token from an existing Kerberos context. Hostname of the coordinator (after canonicalization if enabled). Trino coordinator Kerberos service principal pattern. Service principal by first resolving the hostname to an IP addressĪnd then doing a reverse DNS lookup for that IP address. Use the canonical hostname of the Trino coordinator for the Kerberos The principal to use when authenticating to the Trino coordinator. The location of the Java TrustStore file to use. Keystore.type security property or jks if none exists. Is trusted by the Trino cluster you connect to. Specifies the path to a PEM or JKS file, which must contain a certificate that Use only when connecting to a Trino cluster that has certificate Set true to specify using HTTPS/TLS for connections. JWT access token for token based authentication. Property nor ApplicationName or source are set, the source If the source parameter has not been set. Property, which is used to set the source name for the Trino query Prefix to append to any specified ApplicationName client info Over ApplicationName and/or applicationNamePrefix. Trace token for correlating requests across systems. Example: localhost:8888Ĭlient tags for selecting resource groups. Session username override, used for impersonation. Username to use for authentication and authorization. While others are specified using properties. These methods may be mixed some parameters may be specified in the URL,
getConnection ( url, properties ) // properties String url = "jdbc:trino://:8443/hive/sales?user=test&password=secret&SSL=true" Connection connection = DriverManager. setProperty ( "SSL", "true" ) Connection connection = DriverManager. setProperty ( "password", "secret" ) properties. setProperty ( "user", "test" ) properties. URL parameters String url = "jdbc:trino://:8080/hive/sales" Properties properties = new Properties () properties. The following JDBC URL formats are supported:
DBVISUALIZER KERBEROS DRIVER
When your driver is loaded, registered and configured, you are ready to connect Once registered, you must also configure the connection information as described Please check your application’s documentation. In a UI or on the command line depend upon the specific application you are GUI-based SQL editors, read this section. If your application does not, such as is the case for some Registering and configuring the driver #ĭrivers are commonly loaded automatically by applications once they are added to May need to manually register and configure the driver. Of users on systems where they will access Trino.Īfter you have downloaded the JDBC driver and added it to yourĬlasspath, you’ll typically need to restart your application in order to Once downloaded, you must add the JAR file to a directory in the classpath To download, where xxx is the version number. Navigate to theĭirectory for the desired version, and select the trino-jdbc-xxx.jar file A list of allĪvailable versions can be found in the Maven Central Repository.
We recommend using the latest version of the JDBC driver. The driver is also available from Maven Central: The Trino JDBC driver has the following requirements:Īll users that connect to Trino with the JDBC driver must be granted access toĭownload trino-jdbc-367.jar and add it to the classpath of your Java application. Both desktop and server-side applications, suchĪs those used for reporting and database development, use the JDBC driver. Users to access Trino using Java-based applications, and other non-JavaĪpplications running in a JVM.