[GitHub] [pinot] kbastani edited a comment on issue #7987: Pinot JDBC Client Connection Exception

[GitBox <gi...@apache.org>]

kbastani edited a comment on issue #7987:
URL: https://github.com/apache/pinot/issues/7987#issuecomment-1015744904


   @Arpita030125 Can you try the following in your JDBC client? (not recommended for production code)
   
   ```java
   final String username = "user";
   final String password = "password";
   
   // Concatenate username and password and use base64 to encode the concatenated string
   String plainCredentials = username + ":" + password;
   String base64Credentials = new String(Base64.getEncoder().encode(plainCredentials.getBytes()));
   
   // Create authorization header
   String authorizationHeader = "Basic " + base64Credentials;
   Properties connectionProperties = new Properties();
   connectionProperties.setProperty("headers.Authorization", authorizationHeader);
   
   // Register new Pinot JDBC driver
   DriverManager.registerDriver(new PinotDriver());
   
   // Get a client connection and set the encoded authorization header
   Connection connection = DriverManager.getConnection(DB_URL, connectionProperties);
   
   // Test that your query successfully authenticates
   Statement statement = connection.createStatement();
   ResultSet rs = statement.executeQuery("SELECT count(*) FROM baseballStats LIMIT 1;");
   
   while (rs.next()) {
       String result = rs.getString("count(*)");
       System.out.println(result);
   }
   ```
   
   I've confirmed that this works in the latest `0.10.0-SNAPSHOT` but will not work in any earlier releases (including 0.9.3). 
   
   @Jackie-Jiang you can close the issue.
     


-- 
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: commits-unsubscribe@pinot.apache.org

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



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org