Vertica JDBC driver and setQueryTimeout

Answers

• Options

  SruthiA Vertica Employee Administrator

  December 2022

  could you please open a support case and share us with example query, scrutinize and screenshot from your JDBC tool showing that query is running longer than timeout you have set?

  -5
• Options

  alehb Vertica Customer

  February 2023

  Thanks for the answer. How I can open the support case?

  -5
• Options

  alehb Vertica Customer

  February 2023 edited February 2023

  Here the code:

  import java.sql.Connection;
  import java.sql.DriverManager;
  import java.sql.SQLException;
  import java.sql.Statement;

  public class EP {

  public static void main(String[] args) throws SQLException {
      try (Connection connection = DriverManager.getConnection("jdbc:vertica://localhost:5433/database", "user", "password");) {
          try (Statement statement = connection.createStatement();) {
              statement.setQueryTimeout(1);
  
              long currentTimeMillis = System.currentTimeMillis();
              statement.execute("SELECT sleep(10)");
              System.err.println(System.currentTimeMillis() - currentTimeMillis);
          }
      }
  }
  

  }

  

  This query executes without timeout error in 10 seconds. We expect to get timeout error after 1 second of execution

  -5
• Options

  SruthiA Vertica Employee Administrator

  February 2023 edited February 2023

  @alehb : Thank you for sharing the code. It is a known issue and the bug is not fixed yet. If you need more information,

  Please open support case via https://sld.microfocus.com/

  0
• Options

  Sergey_Cherepan_1 ✭✭✭

  March 2023

  You can execute SQL command in JDBC session:

  Set session runtimecap ‘1 sec’

  That would work independent of JDBC driver functionality.

  0