Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: rOracle JDBC drivers and setting NLS_DATE_FORMAT in a logon trigger doesn't work
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
"Davide Bianchi" <davide_at_davidebianchi.net> wrote in message
news:8d35ed5d276c297cb81ae683e79a6d86.67471_at_mygate.mailgate.org...
> "Andre van Winssen \(andrew\)" <andrew-no-spam-svp_at_info.nl> wrote in
> message news:3c95e933$0$11068$4d4ebb8e_at_news.nl.uu.net...
>
> > Did anybody ran into the same problem before and found better
> > alternatives for manipulating NLS settings for Java applications
> > without hardcoding alter session stmts?
>
> Usually, I hard-code specific format in the SELECT/INSERT
> statements:
>
> SELECT ..TO_CHAR(thedatefield,'DD-MM-YYYY')...
>
> INSERT... TO_DATE('01-01-2002','DD-MM-YYYY')...
>
> This way I'm absolutely sure about what I put into the db
> and what I get back from it.
> I admit: it's not very nice & clean, but it works.
>
> Davide
>
>
> --
> Posted via Mailgate.ORG Server - http://www.Mailgate.ORG
Received on Mon Mar 18 2002 - 09:21:14 CST