Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to set NLS_LANGUAGE and NLS_TERRITORY?

444365May 23 2005 — edited May 26 2005

I'm starting the jvm with -Duser.language=de -Duser.region=DE. At runtime i'm getting these properties from the jvm:

System.properties:
User Language: de
User Country: DE

Locales:
Language: de
Country: DE
ISO3Language: deu
ISO3Country: DEU

But the statement "SELECT * FROM NLS_SESSION_PARAMETERS" still gives me at runtime:
NLS_LANGUAGE: AMERICAN
NLS_TERRITORY: AMERICA
NLS_CURRENCY: $
NLS_ISO_CURRENCY: AMERICA
NLS_NUMERIC_CHARACTERS: .,
NLS_CALENDAR: GREGORIAN
NLS_DATE_FORMAT: DD-MON-RR
NLS_DATE_LANGUAGE: AMERICAN
NLS_SORT: BINARY
NLS_TIME_FORMAT: HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT: DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT: HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT: DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY: $
NLS_COMP: BINARY
NLS_LENGTH_SEMANTICS: BYTE
NLS_NCHAR_CONV_EXCP: FALSE

How to set the NLS_LANGUAGE to german?

JVM: 1.5
Oracle: Database Product Version is Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Oracle Data Mining options
JDBC: JDBC Driver Version is ..... 10.1.0.2.0
OS: HP-UX 11.11i 64bit

thx in advance!

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 23 2005

Added on May 23 2005

#java-database-connectivity-jdbc

5 comments

2,106 views