diff src/main/java/org/monetdb/client/JdbcClient.java @ 723:7200f7942b16

For JdbcClient enlarge the fetchsize at connection moment. This allows statements such as: call sys.eval('SELECT * from sys.keywords order by 1 desc;'); to be executed succesfully. Before this change it would list only the first 250 rows and fail message: Error [M0M10] resultBlocks[1] should have been fetched by now
author Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
date Thu, 19 Jan 2023 19:55:10 +0100 (2023-01-19)
parents aeb268156580
children a80c21fe7bb2
line wrap: on
line diff
--- a/src/main/java/org/monetdb/client/JdbcClient.java
+++ b/src/main/java/org/monetdb/client/JdbcClient.java
@@ -289,7 +289,8 @@ public class JdbcClient {	/* cannot (yet
 		}
 
 		// build the extra arguments of the JDBC connect string
-		String attr = "?";
+		// increase the fetchsize from the default 250 to 10000
+		String attr = "?fetchsize=10000&";
 		CmdLineOpts.OptionContainer oc = copts.getOption("language");
 		final String lang = oc.getArgument();
 		if (oc.isPresent())