Mercurial > hg > monetdb-java
diff tests/Bug_IsValid_Timeout_Bug_6782.java @ 343:48ee2ca98975
Added test and fix for bug 6782, ie set the connection's query timeout explicitly at the end of isValid method.
The previous value must be set whenever the an exception is thrown or not during the method.
author | Pedro Ferreira <pedro.ferreira@monetdbsolutions.com> |
---|---|
date | Tue, 05 Nov 2019 14:50:16 +0100 (2019-11-05) |
parents | |
children | 54137aeb1f92 |
line wrap: on
line diff
new file mode 100644 --- /dev/null +++ b/tests/Bug_IsValid_Timeout_Bug_6782.java @@ -0,0 +1,38 @@ +/* + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + * Copyright 1997 - July 2008 CWI, August 2008 - 2019 MonetDB B.V. + */ + +import java.sql.*; + +public class Bug_IsValid_Timeout_Bug_6782 { + public static void main(String[] args) throws Exception { + // Class.forName("nl.cwi.monetdb.jdbc.MonetDriver"); // not needed anymore for self registering JDBC drivers + Connection con = DriverManager.getConnection(args[0]); + Statement st = null; + + st = con.createStatement(); + st.setQueryTimeout(5); + System.out.println("getQueryTimeout must give 5: " + st.getQueryTimeout()); + st.close(); + + con.isValid(3); + + st = con.createStatement(); + System.out.println("getQueryTimeout must give 0: " + st.getQueryTimeout()); + + con.isValid(3); + System.out.println("getQueryTimeout must give 0: " + st.getQueryTimeout()); + st.close(); + + st.setQueryTimeout(5); + con.isValid(3); + System.out.println("getQueryTimeout must give 5: " + st.getQueryTimeout()); + st.close(); + + con.close(); + } +}