direction and being patient with my posts as I
worked through my problem.
Derek
-Original Message-
From: Wolfgang Rckelein [mailto:[EMAIL PROTECTED]
Sent: May 19, 2004 10:40 AM
To: Tag Libraries Users List
Subject: Re: [JSTL] How do I enter a null value with sql:param?
Keith wrote
, so it is unnecessary to identify its type.
Derek
-Original Message-
From: Derek Mahar
Sent: May 20, 2004 2:08 PM
To: Tag Libraries Users List
Subject: RE: [JSTL] How do I enter a null value with sql:param?
Thank you. I appreciate your attention and quick response.
After reading JDBC
Subject: RE: [JSTL] How do I enter a null value with sql:param?
Thank you. I appreciate your attention and quick response.
After reading JDBC Specification Section 13.2.2.3, Setting NULL Parameters, I
understand now why Kris suggested that the JSTL specification add the sqlType
:08 PM
To: Tag Libraries Users List
Subject: RE: [JSTL] How do I enter a null value with sql:param?
Thank you. I appreciate your attention and quick response.
After reading JDBC Specification Section 13.2.2.3, Setting NULL
Parameters, I understand now why Kris suggested
.
Thank you again for this jTDS reference!
Derek
-Original Message-
From: Kris Schneider [mailto:[EMAIL PROTECTED]
Sent: May 20, 2004 3:21 PM
To: Tag Libraries Users List
Subject: RE: [JSTL] How do I enter a null value with sql:param?
I'm merely aware of its existence. I've never used
[EMAIL PROTECTED]
Sent: Thu, 20 May 2004 16:02:02 -0400
Subject: RE: [JSTL] How do I enter a null value with sql:param?
Wow! I just installed the jTDS JDBC driver for Microsoft SQL Server, and it does
*not*
produce the NULL parameter problem that I encountered using Microsoft's SQL Server
JDBC
in the
implementation of sql:param where it treats null as a string
argument rather than as an SQL null argument.
Derek
-Original Message-
From: Kris Schneider [mailto:[EMAIL PROTECTED]
Sent: May 18, 2004 9:10 PM
To: Tag Libraries Users List
Subject: Re: [JSTL] How do I enter a null value
: May 18, 2004 9:10 PM
To: Tag Libraries Users List
Subject: Re: [JSTL] How do I enter a null value with sql:param?
sql:param value=${null}/
Derek Mahar wrote:
How do I enter a null value into a table column with sql:param? The
JSTL 1.1 specification states for sql:param that, If value
Correction: the table name should have read tblTest rather than
tblTestDerek.
-Original Message-
From: Derek Mahar
Sent: May 19, 2004 9:45 AM
To: Tag Libraries Users List
Subject: RE: [JSTL] How do I enter a null value with sql:param?
Your solution is equivalent to Case 2 that I listed
Derek Mahar wrote:
Your solution is equivalent to Case 2 that I listed in my original
message. The Microsoft SQL Server JDBC driver complains with a
JspException:
javax.servlet.ServletException: javax.servlet.jsp.JspException:
INSERT INTO tblTest(a) VALUES (?)
: [Microsoft][SQLServer 2000
]/msg06748.html
Keith
-- Original Message ---
From: Wolfgang Röckelein [EMAIL PROTECTED]
To: Tag Libraries Users List [EMAIL PROTECTED]
Sent: Wed, 19 May 2004 16:05:14 +0200
Subject: Re: [JSTL] How do I enter a null value with sql:param?
Derek Mahar wrote:
Your solution
It certainly could be a driver issue, but you've gotta pass null instead of
null to find out ;-). The Standard taglib uses the following to set SQL
parameters:
PreparedStatement.setObject(int parameterIndex, Object x)
It should be pretty easy to write a simple JDBC test to see how your driver
Keith wrote:
This was on the Users list and was my problem. But mine had to do specifically with the
sql:dateParam and the Oracle JDBC driver. The regular sql:param worked fine for me
when I passed it a null value.
Link to the starting thread in the archive:
http://www.mail-archive.com/[EMAIL
Libraries Users List
Subject: RE: [JSTL] How do I enter a null value with sql:param?
It's really not equivalent. Your Case 2 was:
c:set var=nullValue value=null/
Which sets nullValue to the String literal null. I suggested the
equivalent
of:
c:set var=nullValue value=${null}/
Which will set
PROTECTED]
Sent: May 19, 2004 10:28 AM
To: Tag Libraries Users List; [EMAIL PROTECTED]
Subject: Re: [JSTL] How do I enter a null value with sql:param?
It certainly could be a driver issue, but you've gotta pass null instead of null to
find out ;-). The Standard taglib uses the following to set SQL
nothing about how it handles a null object
reference.
Derek
-Original Message-
From: Keith [mailto:[EMAIL PROTECTED]
Sent: May 19, 2004 10:28 AM
To: [EMAIL PROTECTED]
Subject: Re: [JSTL] How do I enter a null value with sql:param?
This was on the Users list and was my problem
/[EMAIL PROTECTED]/msg06989.html
Derek
-Original Message-
From: Keith [mailto:[EMAIL PROTECTED]
Sent: May 19, 2004 10:28 AM
To: [EMAIL PROTECTED]
Subject: Re: [JSTL] How do I enter a null value with sql:param?
This was on the Users list and was my problem. But mine had to do specifically
for pointing me in the right direction and being patient with my posts as I
worked through my problem.
Derek
-Original Message-
From: Wolfgang Röckelein [mailto:[EMAIL PROTECTED]
Sent: May 19, 2004 10:40 AM
To: Tag Libraries Users List
Subject: Re: [JSTL] How do I enter a null value
sql:param value=${null}/
Derek Mahar wrote:
How do I enter a null value into a table column with sql:param? The
JSTL 1.1 specification states for sql:param that, If value is null,
the parameter is set to the SQL value NULL. However, no matter what
value I pass to sql:param, I'm unable to set a
19 matches
Mail list logo