JDBC and Locale

Posted in 2000

sirdna3411@my-deja.com — Thu, 24 Aug 2000 11:28:03 GMT — source: Informix-list mailing list archive (1991-1998)

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=informi x 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=informi x;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=informi x;DB_LOCALE=lv_lv.1257 And I get : >>>Create Database test.URL = "jdbc:informix- sqli://myhost:1526:informixserver=ol_ifmx;user=informix;password=informi x;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 Sent via Deja.com http://www.deja.com/ Before you buy.