Re: Oracle nls_date_format

Of the 4 options that Oracle recommends in Matt's link, we implemented #3 :

"Alter you application to use getTimestamp rather than getObject. This
is a good solution when possible, however many applications contain
generic code that relies on getObject, so it isn't always possible."

And that is available with the "Interpret DATE columns as TIMESTAMP" option.

Rob

On 10/19/07, Matthew Dahlman <mdahlman@xxxxxxxxxxxxxx> wrote:
> It's intentional by Oracle to not return the time with the current Oracle
> JDBC driver. It's also highly annoying to lots of folks that Oracle made
> this change in their 9.2 release.
>
> A workaround is to use an older Oracle JDBC driver. Or you can simulate
> using an older driver by adding something like this to your startup
> params:
>
> java -Doracle.jdbc.V8Compatible="true"
>
> There good info here in the section "What is going on with DATE and
> TIMESTAMP?"
> http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq.htm
>
> Regards,
> Matt Dahlman
>
>
> -----Original Message-----
> From: squirrel-sql-users-bounces@xxxxxxxxxxxxxxxxxxxxx
> [mailto:squirrel-sql-users-bounces@xxxxxxxxxxxxxxxxxxxxx] On Behalf Of
> Robert Manning
> Sent: Friday, 19 October, 2007 11:36
> To: Frank Brendel
> Cc: squirrel-sql-users@xxxxxxxxxxxxxxxxxxxxx
> Subject: Re: [Squirrel-sql-users] Oracle nls_date_format
>
> On 10/19/07, Frank Brendel <frank.brendel@xxxxxxxxxxx> wrote:
> > Hi Rob,
> >
> > thanks for your help.
> >
> > >
> > > There is a work-around if you prefer not to use the "correct" data
> > > type (timestamp) to store a time component along with the date.  In
> > > Global Preferences -> DataType Controls -> Date section you can
> > > check "treat DATE as TIMESTAMP" which will cause SQuirreL to
> > > retrieve all java.sql.Date as java.sql.Timestamp instead.  Note
> > > however, that while this works fine for Oracle, I've seen it not
> > > work so well for a database that implements SQL according to the
> > > standard.  So be careful with this setting if you also access
> non-Oracle databases.
> > >
> >
> > I've changed the java code to use java.sql.Date resp.
> > java.sql.Timestamp and it works as you have said. Date gives me
> > '2007-10-19' and Timestamp '2007-10-19 15:35:49.0'.
>
> Oh, no actually I was referring to the Table column type.  Most people
> refuse to convert their table columns from DATES to TIMESTAMP,
> understandably so.  So the "Treat DATE as TIMESTAMP" is used for this
> purpose.   It changes SQuirreL's java code to use getTimestamp() which
> returns java.sql.Timestamp instead of getDate() which returns
> java.sql.Date.
>
> Rob
> Rob
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/
> _______________________________________________
> Squirrel-sql-users mailing list
> Squirrel-sql-users@xxxxxxxxxxxxxxxxxxxxx
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>
>

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/