Re: More SQL Date problems

2004-04-16 Thread Lance J. Andersen
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 problems Hans, I looked into the SQ

Re: More SQL Date problems

2004-04-16 Thread Jonathan Bruce
-- 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 with the JDBC specification lea

Re: More SQL Date problems

2004-04-16 Thread Keith
Apr 2004 11:24:32 -0700 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 fixe

Re: More SQL Date problems

2004-04-16 Thread Justyna Horwat
hey 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 problems Hans, I looked into the SQ

Re: More SQL Date problems

2004-04-16 Thread Hans Bergsten
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 behavior

Re: More SQL Date problems

2004-04-16 Thread Keith
using 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 Subj

Re: More SQL Date problems

2004-04-16 Thread Justyna Horwat
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 a

Re: More SQL Date problems

2004-03-31 Thread Keith
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 th

Re: More SQL Date problems

2004-03-31 Thread Keith
d, 31 Mar 2004 12:18:19 -0800 Subject: Re: More SQL Date problems > 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 > > some

Re: More SQL Date problems

2004-03-31 Thread Hans Bergsten
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 ty

Re: More SQL Date problems

2004-03-31 Thread Wolfgang Röckelein
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 type" error you see. I thin

RE: More SQL Date problems

2004-03-31 Thread Keith
a: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: More SQL Date problems

2004-03-30 Thread Martin van Dijken
t and I've 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

Re: More SQL Date problems

2004-03-30 Thread Keith
Sent: Tue, 30 Mar 2004 20:40: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 f

Re: More SQL Date problems

2004-03-30 Thread Hans Bergsten
es Users List <[EMAIL PROTECTED]> Sent: Tue, 30 Mar 2004 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. INSERT INTO resource_registry ( do

Re: More SQL Date problems

2004-03-30 Thread Keith
Message --- From: Hans Bergsten <[EMAIL PROTECTED]> To: Tag Libraries Users List <[EMAIL PROTECTED]> Sent: Tue, 30 Mar 2004 19:30:44 -0800 Subject: Re: More SQL Date problems > Keith wrote: > > Now I'm thorougly confused. I could've sworn thi

Re: More SQL Date problems

2004-03-30 Thread Hans Bergsten
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. INSERT INTO resource_registry ( dob ) VALUES (? ) This works perfectly fine when I put a date in the format specified in the parseDate action. The

More SQL Date problems

2004-03-30 Thread Keith
Now I'm thorougly confused. I could've sworn this was working before (as I claimed in my first email to the group. INSERT INTO resource_registry ( dob ) VALUES (? ) This works perfectly fine when I put a date in the format specified in the parseDate action. The JSP