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

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,

• Thomas