Merge pull request #1183 from lowcoder-org/fix/mssql_null_value

FalkWolsky · web-flow · commit fec96d2fe96a · 2024-09-26T17:39:04.000+02:00
Fix null value error on mssql datasource
diff --git a/server/api-service/lowcoder-plugins/sqlBasedPlugin/src/main/java/org/lowcoder/plugin/sql/GeneralSqlExecutor.java b/server/api-service/lowcoder-plugins/sqlBasedPlugin/src/main/java/org/lowcoder/plugin/sql/GeneralSqlExecutor.java
@@ -232,7 +232,9 @@ private List<Object> getGeneratedIds(ResultSet generatedKeys) throws SQLExceptio
 
     private void bindParam(int bindIndex, Object value, PreparedStatement preparedStatement, String bindKeyName) throws SQLException {
         if (value == null) {
-            preparedStatement.setNull(bindIndex, Types.NULL);
+            ParameterMetaData parameterMetaData = preparedStatement.getParameterMetaData();
+            int paramType = parameterMetaData.getParameterType(bindIndex);
+            preparedStatement.setNull(bindIndex, paramType);
             return;
         }
         if (value instanceof Integer intValue) {
