Bug 7758

Summary: sql:param cannot be used for empty strings or nulls
Product: Taglibs Reporter: Jin Choi <jsc>
Component: Standard TaglibAssignee: Tomcat Developers Mailing List <dev>
Status: RESOLVED FIXED    
Severity: enhancement    
Priority: P3    
Version: unspecified   
Target Milestone: ---   
Hardware: All   
OS: All   

Description Jin Choi 2002-04-05 06:51:52 UTC
Unless I am missing something, it is not possible to update or insert an empty 
string or null using the sql:param tag, because it explicitly does not allow 
use with an empty value. This is a serious shortcoming! Also, the SQL standard 
differentiates between the empty string and null, although Oracle conflates the 
two, so for ANSI compliant databases, there should also be a way to set null 
parameters with the sql:param tag.
Comment 1 Justyna Horwat 2002-04-14 02:23:14 UTC
Fixed. Null parameter values set to SQL value null.