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: rOracle JDBC drivers and setting NLS_DATE_FORMAT in a logon trigger doesn't work

Re: rOracle JDBC drivers and setting NLS_DATE_FORMAT in a logon trigger doesn't work

From: Joe <yohan1701_at_nospam.space.com>
Date: Mon, 18 Mar 2002 14:40:34 -0500
Message-ID: <MPG.17000cbf7fcc4b439897b4@news.bellglobal.com>


psst did you hear what "Andre van Winssen \(andrew\)" <andrew-no-spam- svp_at_info.nl> said
> yes, this works .. in Oracle. But our javacode attempts to be
> database independent, so localizations (like NLS) must be as
> transparant for the application as possible.
>
> thanks for the input.
>
> Andre
>

couldn't you use a PreparedStatement set the date with a parameter. Since date are longs your has to driver will do the conversion for you so it shouldn't matter what format the date is stored in.

-- 
Joe

"I bent my wookie" - Ralph Wiggum
Received on Mon Mar 18 2002 - 13:40:34 CST

Original text of this message

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