vonfiguring jdbc local
once we used odbc to connect to ids we where able to enter dblocale and client locale in the odbc string now via jdbc the rules are differnt and we can not get proper connection to the db does anyone know where to change it
You need to pass them as connection properties.
for example
"jdbc:informix-sqli://123.45.67.89:1533/testDB:
INFORMIXSERVER=myserver;user=rdtest;password=test;DB_LOCALE=ja_jp.sjis;CLIENT_LOCALE=ja_jp.ujis"
Refer to Informix JDBC Programmers guide for further
details.
http://publib.boulder.ibm.com/infocenter/idshelp/v10/topic/com.ibm.jdbc.doc/jdbc
.htm
--- OZ SHIMONY <ozs@cbs.gov.il> wrote:
>
> once we used odbc to connect to ids we where able to
> enter dblocale and client
> locale in the odbc string
>
> now via jdbc the rules are differnt and we can not
> get proper connection to
> the db
> does anyone know where to change it
>
>
>
*******************************************************************************
>
> Forum Note: Use "Reply" to post a response in the
> discussion forum.
>
>
thank you very much it works fine in regular connections my problem is that i want this connection to work via "office connect 4" which works fine via office 2000 but in office 2003 gives me only the first record by the way when dealing with a DB who does not need locales configuring there are no problems at all