Bug 7758 - sql:param cannot be used for empty strings or nulls
Summary: sql:param cannot be used for empty strings or nulls
Status: RESOLVED FIXED
Alias: None
Product: Taglibs
Classification: Unclassified
Component: Standard Taglib (show other bugs)
Version: unspecified
Hardware: All All
: P3 enhancement (vote)
Target Milestone: ---
Assignee: Tomcat Developers Mailing List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2002-04-05 06:51 UTC by Jin Choi
Modified: 2004-11-16 19:05 UTC (History)
0 users


Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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.