Hans,
I looked into the SQL problem and consulted with the JDBC specification
lead, Jonathan Bruce. Jonathan said that what JSTL is doing is correct:
when setObject(index, null) is passed in a null value this should be
converted by the driver to an SQL null.
This behavior is in fact enforced
for whoever may take over for me in the future if they
don't
know about the problem.
Thanks!
Keith
-- Original Message ---
From: Justyna Horwat [EMAIL PROTECTED]
To: Tag Libraries Users List [EMAIL PROTECTED]
Sent: Fri, 16 Apr 2004 09:54:13 -0700
Subject: Re: More SQL Date
Justyna Horwat wrote:
Hans,
I looked into the SQL problem and consulted with the JDBC specification
lead, Jonathan Bruce. Jonathan said that what JSTL is doing is correct:
when setObject(index, null) is passed in a null value this should be
converted by the driver to an SQL null.
This
about the problem.
Thanks!
Keith
-- Original Message ---
From: Justyna Horwat [EMAIL PROTECTED]
To: Tag Libraries Users List [EMAIL PROTECTED]
Sent: Fri, 16 Apr 2004 09:54:13 -0700
Subject: Re: More SQL Date problems
Hans,
I looked into the SQL problem and consulted
Subject: Re: More SQL Date problems
Keith,
That's why they have the compatibility tests to avoid the very problem
that you are seeing with the Oracle driver. This is definitely a bug in
Oracle's driver implementation that needs to be fixed.
Justyna
Keith wrote:
So this is something
Message ---
From: Justyna Horwat [EMAIL PROTECTED]
To: Tag Libraries Users List [EMAIL PROTECTED]
Sent: Fri, 16 Apr 2004 09:54:13 -0700
Subject: Re: More SQL Date problems
Hans,
I looked into the SQL problem and consulted with the JDBC
specification lead, Jonathan Bruce. Jonathan said
about the problem.
Thanks!
Keith
-- Original Message ---
From: Justyna Horwat [EMAIL PROTECTED]
To: Tag Libraries Users List [EMAIL PROTECTED]
Sent: Fri, 16 Apr 2004 09:54:13 -0700
Subject: Re: More SQL Date problems
Hans,
I looked into the SQL problem and consulted
)
at java.lang.Thread.run(Thread.java:534)
-- Original Message ---
From: Martin van Dijken [EMAIL PROTECTED]
To: Tag Libraries Users List [EMAIL PROTECTED]
Sent: Wed, 31 Mar 2004 08:58:24 +0200
Subject: RE: More SQL Date problems
Hmm Keith,
Can you specify the url you're
Wolfgang Röckelein wrote:
Hi,
at JDBC level there are two different possibilities to set a parameter
value to null: with setNull and setting to null. Depending on the driver
sometimes only on of these methods work, and when it does not work, you
see the java.sql.SQLException: Invalid column
in the database. :p
Is there any chance of this problem being fixed in the case of the Oracle JDBC driver?
Keith
-- Original Message ---
From: Hans Bergsten [EMAIL PROTECTED]
To: Tag Libraries Users List [EMAIL PROTECTED]
Sent: Wed, 31 Mar 2004 12:18:19 -0800
Subject: Re: More SQL Date
I just got that prohibited content email myself. All I'm sending is plaintext email.
Is that something from the mailing list doing it? Snipped Hans' original message out
and
am resending...
Thanks a lot, Hans! Yeah, I had seen a workaround like that would work. I groaned when
I
realized
Keith wrote:
Now I'm thorougly confused. I could've sworn this was working before (as I claimed in my
first email to the group.
fmt:parseDate value=${param.dob} var=parsed_dob pattern=dd-MM- /
sql:transaction
sql:update
INSERT INTO resource_registry ( dob )
VALUES (?
19:30:44 -0800
Subject: Re: More SQL Date problems
Keith wrote:
Now I'm thorougly confused. I could've sworn this was working before (as I claimed
in my
first email to the group.
fmt:parseDate value=${param.dob} var=parsed_dob pattern=dd-MM- /
sql:transaction
sql:update
INSERT
:41 -0800
Subject: Re: More SQL Date problems
Keith wrote:
Ahhh, ok. I assumed it was the JSTL stuff throwing the error. I've not done much
programming in actual Java, which is why I'm using the JSTL library.
The field is set to accept a NULL value in the database. There's already data
not had
any headaches with it.
Martin
-Oorspronkelijk bericht-
Van: Keith [mailto:[EMAIL PROTECTED]
Verzonden: woensdag 31 maart 2004 5:55
Aan: Tag Libraries Users List
Onderwerp: Re: More SQL Date problems
Yeah, I'd read about not using that bridge driver. I'm using Oracle 9i
Release 2
15 matches
Mail list logo