Vertica JDBC driver and setQueryTimeout

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?

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

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

@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/

You can execute SQL command in JDBC session:

Set session runtimecap ‘1 sec’

That would work independent of JDBC driver functionality.