QueryTimeout

[fafafifi123]

Is there a way to specify connection / query timeout while using assertj db ?

[VanRoy]

@willyhalim , Currently you have two ways to do that :

1. You can use properties in JDBC connection URL with AssertJ-DB Source ( For example with Postgresl : https://jdbc.postgresql.org/documentation/head/connect.html )
2. You can use settings of DataSource and use it in Table instead of Source

Tell me if it fit with your requirement.

[fafafifi123]

It seems didnt work , in normal prepared statement i can do something like this

 ps = conn.prepareStatement(query);
            if (queryTimeout > 0) {
                ps.setQueryTimeout(queryTimeout);
                LOGGER.info("set querytimeout {}", queryTimeout);
            }

[VanRoy]

Hi @willyhalim , can you send me some details of your issue / use case ? When the timeout error is raised ? During the connection ? During an assertj-db assertion ? Thanks.