Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 10g returns DATE as java.sql.Date?

Re: Oracle 10g returns DATE as java.sql.Date?

From: <thomas_okken_at_hotmail.com>
Date: 9 Nov 2005 17:14:11 -0800
Message-ID: <1131585251.022282.307630@g14g2000cwa.googlegroups.com>


Joe Weinstein wrote:
> thomas_okken_at_hotmail.com wrote:
>
> > I noticed that Oracle 10g XE, with the ojdbc14.jar JDBC driver, returns
> > DATE columns as java.sql.Date values. [...]
>
> [...]
>
> prop.put ("oracle.jdbc.V8Compatible", "true");
>
> and you should be safely "back in Kansas". Let me know...
>
> Joe Weinstein at BEA Systems

Works like a charm, both by setting it in the system properties and by setting it in the connection properties. Yay, an Oracle compatibility problem that's *easy* to work around for a change. :-)

Thanks for the tip,

Received on Wed Nov 09 2005 - 19:14:11 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US