Mercurial > hg > monetdb-java
diff src/main/java/nl/cwi/monetdb/jdbc/MonetDriver.java.in @ 381:11c30e3b7966
Set the connection properties treat_clob_as_varchar and treat_blob_as_binary to true by default for faster processing (less objects created, less memory needed) when querying CLOB or BLOB column data.
| author | Martin van Dinther <martin.van.dinther@monetdbsolutions.com> |
|---|---|
| date | Thu, 08 Oct 2020 19:45:20 +0200 (2020-10-08) |
| parents | bf521f343172 |
| children |
line wrap: on
line diff
--- a/src/main/java/nl/cwi/monetdb/jdbc/MonetDriver.java.in +++ b/src/main/java/nl/cwi/monetdb/jdbc/MonetDriver.java.in @@ -228,15 +228,15 @@ final public class MonetDriver implement prop.choices = new String[] { "SHA512", "SHA384", "SHA256", "SHA1" }; dpi[5] = prop; - prop = new DriverPropertyInfo("treat_blob_as_binary", "false"); + prop = new DriverPropertyInfo("treat_blob_as_binary", "true"); prop.required = false; - prop.description = "Should blob columns be mapped to Types.VARBINARY instead of default Types.BLOB in ResultSets and PreparedStatements"; + prop.description = "Should blob columns be mapped to Types.VARBINARY instead of Types.BLOB in ResultSets and PreparedStatements"; // recommend for increased performance due to less overhead prop.choices = boolean_choices; dpi[6] = prop; - prop = new DriverPropertyInfo("treat_clob_as_varchar", "false"); + prop = new DriverPropertyInfo("treat_clob_as_varchar", "true"); prop.required = false; - prop.description = "Should clob columns be mapped to Types.VARCHAR instead of default Types.CLOB in ResultSets and PreparedStatements"; // recommend for increased performance due to less overhead + prop.description = "Should clob columns be mapped to Types.VARCHAR instead of Types.CLOB in ResultSets and PreparedStatements"; // recommend for increased performance due to less overhead prop.choices = boolean_choices; dpi[7] = prop;