up vote 1 down vote favorite
share [g+] share [fb]

I have a j2ee application hosted on jboss and linux platform.

When I try to access the application , I see following error in server.log file.

ORA-12705: invalid or unknown NLS parameter value specified

When I point the same jboss instance to a different schema, the application works fine.

I tried to go through few forum and found that the NLS parameter settings are fine.

Can anyone help.

Jboss version = 4.0.2 DB version = oracle 10.2

output of locale command on linux

$ locale LANG=en_US.UTF-8 LC_CTYPE="en_US.UTF-8" LC_NUMERIC="en_US.UTF-8" LC_TIME="en_US.UTF-8" LC_COLLATE="en_US.UTF-8" LC_MONETARY="en_US.UTF-8" LC_MESSAGES="en_US.UTF-8" LC_PAPER="en_US.UTF-8" LC_NAME="en_US.UTF-8" LC_ADDRESS="en_US.UTF-8" LC_TELEPHONE="en_US.UTF-8" LC_MEASUREMENT="en_US.UTF-8" LC_IDENTIFICATION="en_US.UTF-8" LC_ALL=

link|improve this question
50% accept rate
When you say "When I point the same jboss instance to a different schema" do you really mean a different instance? – DCookie Oct 5 '09 at 18:42
And, what is the value of your NLS_LANG environment variable? – DCookie Oct 5 '09 at 18:46
@DCookie. NLS_LANG environment variable is not set. Also to answer your previous query I point the same app instance to a different database schema. – viky Oct 6 '09 at 5:54
I'm not talking about your app instance. I find it hard to believe you can have this kind of problem connecting as a different user/schema to a particular database instance. This seems to be a client/server issue, not a user/schema issue. – DCookie Oct 6 '09 at 14:50
@DCookie. Thats the exact problem. if I point the same jboss app instance to a different schema on the same db it works fine. – viky Oct 7 '09 at 6:03
feedback

1 Answer

up vote 0 down vote

You can try this:

  1. Make sure en_US.UTF-8 is installed. It should appear in the list generated by "locale -a". If it isn't you'll need to install it.
  2. export LC_ALL=en_US.UTF-8
  3. export NLS_LANG=AMERICAN_AMERICA.UTF8
link|improve this answer
@DCookie. I can try this, But if these settings are important to have my app work. how does it work when pointed to a different schema. – viky Oct 9 '09 at 12:11
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.