RE: SSJE & locale
Do you have right gls files for lv_lv? There must be $INFORMIXDIR/gls/lc11/lv_lv folder with several files inside. If you do not have this folder on Windoze, you can copy directory from AIX (on which connection works) to Windoze. AFAIK you do not havve to set CLIENT_LOCALE because java treat all strings as unicode. Also, consider trying IBM Data driver because (AFAIK) it alse does not require DB_LOCALE. HTH Hrvoje > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On > Behalf Of rotor > Sent: Monday, November 03, 2008 3:48 PM > To: ids@iiug.org > Subject: RE: SSJE & locale [13866] > > > Have you changed the connection settings in SSJE to reflect > the DB_LOCALE? > Yes, I've tried "Tools"->"Connection > Manager"->"DataBase"->"Advanced"->"DB_LOCALE"->"lv_lv.1257"->"Set", > "CLIENT_LOCALE"->"lv_lv.1257"->"Set"->"Close"->"Test", but > have got an error: > "-79784: Locale not supported." Any other ideas? > > > ************************************************************** > ***************** > Forum Note: Use "Reply" to post a response in the discussion forum. >
> Do you have right gls files for lv_lv? Yes, sure. Another programs works fine. > consider trying IBM Data driver Can you be a little more specific, please? I didn't find such phrase in Google...
Full name is (Bond, James Bond :o)) "IBM Data Server Driver for JDBC and SQLJ" IBM site is "little bit" confusing. You can find help for the driver here: http://publib.boulder.ibm.com/infocenter/idshelp/v111/index.jsp?topic=/com.i bm.jccids.doc/ids_jp_000.html I know that driver comes with Data Studio, and latest version can be found following link at the bottom of this page: http://www-01.ibm.com/software/data/db2/java/ HTH Hrvoje > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On > Behalf Of rotor > Sent: Tuesday, November 04, 2008 10:33 AM > To: ids@iiug.org > Subject: RE: SSJE & locale [13875] > > > Do you have right gls files for lv_lv? > Yes, sure. Another programs works fine. > > consider trying IBM Data driver > Can you be a little more specific, please? I didn't find such > phrase in Google... > > > ************************************************************** > ***************** > Forum Note: Use "Reply" to post a response in the discussion forum. >
On Tue, Nov 4, 2008 at 1:33 AM, rotor <rotor@navigator.lv> wrote: >> Do you have right gls files for lv_lv? > Yes, sure. Another programs works fine. >> consider trying IBM Data driver > Can you be a little more specific, please? I didn't find such phrase in > Google... There are two JDBC drivers that can be used to connect to IDS (if IDS is sufficiently recent). One is the original native Informix JDBC driver that uses the SQLI protocol. T'other is the Java Common Client or JCC driver that can be used to talk to DB2 or IDS via DRDA connections. I assume the advice is to try the JCC driver instead of the Informix JDBC driver. I'm not convinced it is sound advice, but I think that's how it should be interpreted. When you say "another program works fine", are you referring to another Java program? If not, worry about whether the correct properties file is around, or the properties file contains the correct information. (That's nearly waffling by me -- I think it has an 80% or so chance of being correct; treat with suitably large pinches of salt.) -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2008.0513 -- http://dbi.perl.org/ "Blessed are we who can laugh at ourselves, for we shall never cease to be amused." NB: Please do not use this email for correspondence. I don't necessarily read it every week, even.