Re: JDBC and Locale

Posted in 2000

Dirk Gunsthoevel — Fri, 25 Aug 2000 08:51:42 +0200 — source: Informix-list mailing list archive (1991-1998)

Hi there :> Are you sure the locale lv_lv is actually supported? From my jdbc driver documentation I dont think so... Regards Dirk sirdna3411@my-deja.com wrote: > > 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.