Re: JDBC Timestamp comparison

From: Joe Weinstein <joeNOSPAM_at_bea.com>
Date: Wed, 21 Sep 2005 09:10:22 -0700
Message-ID: <433185EE.405@bea.com>

suresh wrote:

> I am trying to compare timestamp with CURRENT_TIMESTAMP and oracle is
> throwing this error ORA-01866: the datetime class is invalid.
>
> My query,
>
> select * from message_log where log_timestamp >= CURRENT_TIMESTAMP
> -12/24
>
> where log_timestamp is of TIMESTAMP datatype.
>
> This works fine with sqlplus but it doesn't work from JDBC. Also this
> seems to be some driver issue because it works in another environment
> where oracle oci client is installed. I am using weblogic 7.0 on
> solaris server.
>
> Any one has any clue.
>
> Thanks,
> Suresh

Hi. Can you show me the actual JDBC code? What JDBC driver are you using?
thanks,
Joe Weinstein at BEA

(followups could be posted to the BEW jdbc newsgroup) Received on Wed Sep 21 2005 - 11:10:22 CDT