Commitfec96d2

authored

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

Fix null value error on mssql datasource

2 parents0b77a49 +bec926d commitfec96d2Copy full SHA for fec96d2

File tree

-1

lines changed

server/api-service/lowcoder-plugins/sqlBasedPlugin/src/main/java/org/lowcoder/plugin/sql
- GeneralSqlExecutor.java

-1

lines changed

Lines changed: 3 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -232,7 +232,9 @@ private List<Object> getGeneratedIds(ResultSet generatedKeys) throws SQLExceptio`
`232`	`232`
`233`	`233`	`privatevoidbindParam(intbindIndex,Objectvalue,PreparedStatementpreparedStatement,StringbindKeyName)throwsSQLException {`
`234`	`234`	`if (value ==null) {`
`235`		`-preparedStatement.setNull(bindIndex,Types.NULL);`
	`235`	`+ParameterMetaDataparameterMetaData =preparedStatement.getParameterMetaData();`
	`236`	`+intparamType =parameterMetaData.getParameterType(bindIndex);`
	`237`	`+preparedStatement.setNull(bindIndex,paramType);`
`236`	`238`	`return;`
`237`	`239`	`}`
`238`	`240`	`if (valueinstanceofIntegerintValue) {`

Comments

(0)