Mercurial > hg > monetdb-java
diff src/main/java/org/monetdb/jdbc/MonetPreparedStatement.java @ 973:32f246853ec4
Optimisation, call connection.mapClobAsVarChar() and connection.mapBlobAsVarBinary() outside the for-loop, as it does not change.
| author | Martin van Dinther <martin.van.dinther@monetdbsolutions.com> |
|---|---|
| date | Thu, 10 Apr 2025 19:26:59 +0200 (3 weeks ago) |
| parents | 5cc071c5c170 |
| children |
line wrap: on
line diff
--- a/src/main/java/org/monetdb/jdbc/MonetPreparedStatement.java +++ b/src/main/java/org/monetdb/jdbc/MonetPreparedStatement.java @@ -179,6 +179,8 @@ public class MonetPreparedStatement final ResultSet rs = super.getResultSet(); if (rs != null) { // System.out.println("After super.getResultSet();"); + final boolean mapClobAsVarChar = connection.mapClobAsVarChar(); + final boolean mapBlobAsVarBinary = connection.mapBlobAsVarBinary(); final int type_colnr = rs.findColumn("type"); final int digits_colnr = rs.findColumn("digits"); final int scale_colnr = rs.findColumn("scale"); @@ -188,13 +190,11 @@ public class MonetPreparedStatement for (int i = 0; rs.next() && i < size; i++) { monetdbType[i] = rs.getString(type_colnr); javaType[i] = MonetDriver.getJdbcSQLType(monetdbType[i]); - if (javaType[i] == Types.CLOB) { - if (connection.mapClobAsVarChar()) - javaType[i] = Types.VARCHAR; + if (javaType[i] == Types.CLOB && mapClobAsVarChar) { + javaType[i] = Types.VARCHAR; } else - if (javaType[i] == Types.BLOB) { - if (connection.mapBlobAsVarBinary()) - javaType[i] = Types.VARBINARY; + if (javaType[i] == Types.BLOB && mapBlobAsVarBinary) { + javaType[i] = Types.VARBINARY; } digits[i] = rs.getInt(digits_colnr); scale[i] = rs.getInt(scale_colnr);