Oracle JDBC瘦客户端的设置语言

这对我最有效,如中所述 NLS_LANG setting for JDBC thin driver?

 -Duser.language=en -Duser.region=US

使用 DriverManager.getConnection(String url, Properties info)

根据文件:

参数:

url -表单的数据库url

info -作为连接参数的任意字符串标记/值对的列表;通常至少应包含“user”和“password”属性

也许这样的方法可能会奏效:

String url = ...;
Properties info = new Properties();
info.setProperty("user", ...);
info.setProperty("password", ...);
info.setProperty("NLS_LANG", ...);
DriverManager.getConnection(url, info);

根据文件----

Providing Globalization Support

The basic Java Archive (JAR) files, ojdbc5.jar and ojdbc6.jar, contain all the necessary classes to provide complete globalization support for:

    Oracle character sets for CHAR, VARCHAR, LONGVARCHAR, or CLOB data that is not being retrieved or inserted as a data member of an Oracle object or collection type.
    CHAR or VARCHAR data members of object and collection for the character sets US7ASCII, WE8DEC, WE8ISO8859P1, WE8MSWIN1252, and UTF8.

To use any other character sets in CHAR or VARCHAR data members of objects or collections, you must include orai18n.jar in the CLASSPATH environment variable of your application.