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

Re: More SQL Date problems

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

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

Re: More SQL Date problems

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

Re: More SQL Date problems

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

Re: More SQL Date problems

2004-04-16 Thread Jonathan Bruce
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

Re: More SQL Date problems

2004-04-16 Thread Lance J. Andersen
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

RE: More SQL Date problems

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

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

Re: More SQL Date problems

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

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

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. fmt:parseDate value=${param.dob} var=parsed_dob pattern=dd-MM- / sql:transaction sql:update INSERT INTO resource_registry ( dob ) VALUES (?

Re: More SQL Date problems

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

Re: More SQL Date problems

2004-03-30 Thread Keith
: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

RE: More SQL Date problems

2004-03-30 Thread Martin van Dijken
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