Re: Intervals AND JDBC

From: Chris <christianboivin1_at_hotmail.com>
Date: 15 Jan 2002 14:11:04 -0800
Message-ID: <da20daf0.0201151411.7d700f33_at_posting.google.com>


Hi,

Oracle does'nt support interval datatype ...

Chris

equiros_at_artinsoft.com (Eduardo Quiros) wrote in message news:<decf875b.0201101520.43a20481_at_posting.google.com>...
> Hi out there!
>
> I am having a problem trying to access a INTERVAL datatype column in
> an ORACLE 9i database through JDBC. The driver is unable to handle
> that datatype, and throws an exception: java.sql.SQLException:
> ORA-03115: unsupported network datatype or representation.
>
> The driver I'm using is in fact the ORACLE JDBC Driver for 9i, so, I
> really don't know if this is a known bug or what.
>
> This problem is really big for me, since I need to do some mappings
> between Informix & Oracle tables, and the Interval datatype would be a
> very clean solution for it.
>
> Has anybody had this same problem??
>
> I really really need your help!!!
>
> Thanks.
> Eduardo Quiros
Received on Tue Jan 15 2002 - 23:11:04 CET

Original text of this message