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: NLS settings & JDBC Thin Driver

Re: NLS settings & JDBC Thin Driver

From: <stvchien0_at_gmail.com>
Date: Sun, 25 Mar 2007 16:10:53 +0800
Message-ID: <5ibc0356kt18akggag7el790h0vupgmd5k@4ax.com>

  Is the NLS_DATE_FORMAT derived from the Java system properties, like user.language & user.region? Anyway for specifying the format directly via the Java system properties too?

  Thanks!

On Sun, 25 Mar 2007 09:23:46 +0200, "Michel Cadot" <micadot{at}altern{dot}org> wrote:

>
><stvchien0_at_gmail.com> a écrit dans le message de news: qp4c03h71j1hv484qlkcl045ctpaf1g3j8_at_4ax.com...
>| Hi,
>|
>| Does anyone have the experience on how the Oracle 10.2.x JDBC Thin
>| Driver decide its NLS session related parameters? It looks to us that
>| it will have its own settings which override the instance-level
>| settings? If we want to set some specific settings (for example,
>| NLS_DATE_FORMAT), is there any way besides setting them up via "alter
>| session"?
>|
>| Thanks in advance!
>|
>| - Steve
>
>The settings are those from the JVM.
>You can set them with -D option.
>For instance, -Duser.language=fr.
>
>Regards
>Michel Cadot
>
Received on Sun Mar 25 2007 - 03:10:53 CDT

Original text of this message

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