Informix JDBC 2.11 and locale
Hi, all.
I used demo programs from JDBC installation, from folder
<installroot>\\demo\\basic.
When running command
java CreateDB
jdbc:informix-sqli://myhost:1526:informixserver=ol_ifmx;user=informix;
password=informix
it creates testdb database with default English locale, no matter,
what is the DB_LOCALE and CLIENT_LOCALE settings on server.
----------------------------------------------------------------------
----------------------------------------------------------------------
--------------------------------------------------
Command
java CreateDB
jdbc:informix-sqli://myhost:1526:informixserver=ol_ifmx;user=informix;
password=informix;DB_LOCALE=en_us.850
runs OK, and creates testdb with en_us.850 locale nicely.
----------------------------------------------------------------------
----------------------------------------------------------------------
--------------------------------------------------
Then I try :
java CreateDB
jdbc:informix-sqli://myhost:1526:informixserver=ol_ifmx;user=informix;
password=informix;DB_LOCALE=lv_lv.1257
And I get :
>>>Create Database test.URL =
"jdbc:informix-sqli://myhost:1526:informixserver=ol_ifmx;user=informix
;password=informix;DB_LOCALE=lv_lv.1257"
ERROR: failed to connect!
ERROR: Locale not supported.
java.sql.SQLException: Locale not supported.
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java)
at com.informix.jdbc.IfxSqliConnect.SetPrimEVars(Compiled
Code)
at com.informix.jdbc.IfxSqliConnect.<init>(Compiled Code)
at com.informix.jdbc.IfxDriver.connect(Compiled Code)
at java.sql.DriverManager.getConnection(Compiled Code)
at
java.sql.DriverManager.getConnection(DriverManager.java:141)
at CreateDB.main(CreateDB.java:60)
----------------------------------------------------------------------
----------------------------------------------------------------------
-------------------------------------------------
What I did wrong?
I want to create and access database with lv_lv locales.
Thanks in advance
Andris