Hello! I use JdbcTemplate in spring boot. Try to execute update request with null

When setNull is called, there is a <code class="notra

Got number of type instead null about datasource-proxy HOT 1 CLOSED

RomaIvanovOfficial commented on June 21, 2024

Got number of type instead null

from datasource-proxy.

Comments (1)

ttddyy commented on June 21, 2024

When setNull is called, there is a SetNullParameterValueConverter that handles formatting the null value.
For example, setNull(index,Types.VARCHAR) is converted to NULL(VARCHAR).
This is the default implementation.

When setXyz(index, null) is called, the following logic converts to the display value as null.

datasource-proxy/src/main/java/net/ttddyy/dsproxy/listener/logging/AbstractQueryLogEntryCreator.java

Lines 128 to 141 in 9601ff0

 protected String getParameterValueToDisplay(ParameterSetOperation param) { 

 String value; 

 if (ParameterSetOperation.isSetNullParameterOperation(param)) { 

 // for setNull 

 value = getDisplayValueForSetNull(param); 

 } else if (ParameterSetOperation.isRegisterOutParameterOperation(param)) { 

 // for registerOutParameter 

 value = getDisplayValueForRegisterOutParameter(param); 

 } else { 

 value = getDisplayValue(param); 

 } 

 return value; 

 }

You may have a custom converter, log entry creator, etc that simply shows an argument value.
In case it is not the case and the issue still persists, please provide a minimal sample project that reproduces the issue.

from datasource-proxy.

Got number of type instead null about datasource-proxy HOT 1 CLOSED

Comments (1)

Related Issues (20)

Recommend Projects

React

Vue.js

Typescript

TensorFlow

Django

Laravel

D3

Recommend Topics

javascript

web

server

Machine learning

Visualization

Game

Recommend Org

Facebook

Microsoft

Google

Alibaba

D3

Tencent

	protected String getParameterValueToDisplay(ParameterSetOperation param) {

	String value;
	if (ParameterSetOperation.isSetNullParameterOperation(param)) {
	// for setNull
	value = getDisplayValueForSetNull(param);
	} else if (ParameterSetOperation.isRegisterOutParameterOperation(param)) {
	// for registerOutParameter
	value = getDisplayValueForRegisterOutParameter(param);
	} else {
	value = getDisplayValue(param);
	}
	return value;
	}