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: Andre van Winssen \(andrew\) <andrew-no-spam-svp_at_info.nl>
Date: Mon, 18 Mar 2002 16:21:14 +0100
Message-ID: <3c9605ea$0$11064$4d4ebb8e@news.nl.uu.net>


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

Original text of this message

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