I work with TOS free edition under windows OS since 4.1.2.
Now i am migrating to 6.0 and to LINUX DEBIAN OS. Migration from 4.1.2 to 6.0 was made under windows version and is ok. After that i have exported my projet and imported it under LINUX version. I have a problem with NLS parameters (i user ORACLE database). in .bash_profile there are export commands to initialise NLS_LANGUAGE and NLS_DATE_FORMAT. I've verified, variables are ok. But when i am in TOS and i query NLS session parameters table, the values are not set to the same values.
In fact TOS doesn't use linux session parameters. Why ? How can i do ?
Thank you for any information.
Solved! Go to Solution.
On Linux, JDBC connection doesnt pickup NLS from NLS variable but either by deriving the "locale" of the system / https://linux.die.net/man/1/locale or if you want your system to be in a different locality comparing to your DB connection you will need to specify it at either JVM instantiation
java -Duser.language=FR -Duser.country=FR (can be done at RUN => Advanced Settings)
LC_ALL=en_US.UTF-8 java (will be tricky with Talend)
Generally speaking, you should have a look there https://docs.oracle.com/javase/8/docs/api/java/util/Locale.html
I will test -d parameteres in the ini file from TALEND as soon as i have the update rights on the file. I'll tell you the reasult.