JAVA_TOOL_OPTIONS incorrectly picked up

user8632123

Hi everyone,

in order to get appropriate locale settings I try to configure sqlci by "set JAVA_TOOL_OPTIONS='-Duser.lang=de -Duser.country=DE -Duser.timezone=Europe/Berlin -Dfile.encoding=ISO-8859-1'". As expected sqlci responds by "Picked up JAVA_TOOL_OPTIONS: '-Duser.lang=de -Duser.country=DE -Duser.timezone=Europe/Berlin -Dfile.encoding=ISO-8859-1'". Not trusting things I prefer to check using the script

script

  var System  = Java.type("java.lang.System");

  System.out.println( System.getProperty("user.lang"));

  System.out.println( System.getProperty("user.language"));

  System.out.println(  System.getProperty("user.region"));

  System.out.println(  System.getProperty("user.country"));

  System.out.println(  System.getProperty("user.timezone"));

  System.out.println(  System.getProperty("file.encoding"));

/

The output is:

de -Duser.country=DE -Duser.timezone=Europe/Berlin -Dfile.encoding=ISO-8859-1

de

null

DE

Europe/Berlin

Cp1252

See what has happened? The various properties should have been broken along white space boundaries, but instead everything is pushed into user.lang. On the other hand file.encoding is definitely wrong.

I tried with java 1.8.0_261. I do have other jdks on my system, but sqlci seems to have her own ideas of which one to choose.

Can anything be done about the java options? I would be thankful for every idea.

Yours,

user8632123.

user13708755

Isn't this caused by the single quotes you have in the variable definition? I have been using the JAVA_TOOL_OPTIONS environment variable with SQLcl without any issue for years.

user13708755

Isn't this caused by the single quotes you have in the variable definition? I have been using the JAVA_TOOL_OPTIONS environment variable with SQLcl without any issue for years.

user8632123

Alright. No quotes at all, and it works. I hadn't thought of that! Thanks!