Very Computer

Dear All:

I am using Tomcat 4.1 and Informix IDS 9.3 with IBM Informix JDBC Driver
2.21.

I wrote a servlet that will be loaded when Tomcat's starting.
And that servlet(and other java classes) implements DataSource feature
to create a connection pool.

I noticed that everytime I start Tomcat , the creation of this
connection pool failed and give an error message like the following :

==============================================================================
2002-12-19 17:28:26 StandardWrapper[/gotowatch:default]: Loading
container servlet default
2002-12-19 17:28:26 java.sql.SQLException: Unable to load locale categories.
        at com.informix.jdbc.IfxSqliConnect.<init>(IfxSqliConnect.java:690)
        at java.lang.reflect.Constructor.newInstance(Native Method)
        at com.informix.jdbc.IfxDriver.connect(IfxDriver.java:251)
        at
org.apache.struts.util.GenericDataSource.createConnection(GenericDataSource.java:731)
        at org.apache.struts.util.GenericDataSource.open(GenericDataSource.java:668)
        at com.gotowatch.db.util.DBInitServlet.init(DBInitServlet.java:36)
......
==============================================================================

It seems to me like it is caused by Informix JDBC Driver
(com.informix.jdbc.IfxSqliConnect), right ?
How does this "Unable to load locale categories" mean ?

[ snipped ]

Quote:

> ==============================================================================
> 2002-12-19 17:28:26 StandardWrapper[/gotowatch:default]: Loading
> container servlet default
> 2002-12-19 17:28:26 java.sql.SQLException: Unable to load locale categories.
>    at com.informix.jdbc.IfxSqliConnect.<init>(IfxSqliConnect.java:690)
>    at java.lang.reflect.Constructor.newInstance(Native Method)
>    at com.informix.jdbc.IfxDriver.connect(IfxDriver.java:251)
>    at
> org.apache.struts.util.GenericDataSource.createConnection(GenericDataSource.java:731)
>    at org.apache.struts.util.GenericDataSource.open(GenericDataSource.java:668)
>    at com.gotowatch.db.util.DBInitServlet.init(DBInitServlet.java:36)
> ......
> ==============================================================================

> It seems to me like it is caused by Informix JDBC Driver
> (com.informix.jdbc.IfxSqliConnect), right ?
> How does this "Unable to load locale categories" mean ?

The locale (language) informix wants to load messages for is not supported.
Do you set something language specific in your URL-connect-string ?
If not, what are the values for your environment vars LANG,
CLIENT_LOCALE, DB_LOCALE ?

Regards
Frank

Quote:

> The locale (language) informix wants to load messages for is not supported.
> Do you set something language specific in your URL-connect-string ?
> If not, what are the values for your environment vars LANG,
> CLIENT_LOCALE, DB_LOCALE ?

> Regards
> Frank

Thanks for your reply.
You are right , I've set 2 environment variables that related to locale
setting.
Both of them(DB_LOCALE & CLIENT_LOCALE) are "zh_tw.big5".

Another variable "LANG" is "C".

        Ken

Hi Ken.

I am not familiar with Java.

Only "Unable to load locale categories" means.

-23101 Unable to load locale categories
An invalid locale name was supplied for the locale initialization.
The environment variable to specify the locale category has a wrong
value. Check the value of the corresponding environment variable,
CLIENT_LOCALE or DB_LOCALE. Also check if INFORMIXDIR points to a valid
directory where Informix products are installed.

If a client application receives this error when it requests a database
server connection, check that the client and database locales are
compatible. They are compatible if a valid locale exists on the server

territory) and mod (locale modifier) are from the CLIENT_LOCALE and
codeset is from the database locale (from the DB_LOCALE, if it is set,
or as stored in the database).

Regards.

--
Tsutomu Ogiwara from Tokyo Japan.
ICQ#:168106592

_________________________________________________________________
MSN 8: advanced junk mail protection and 3 months FREE*.
http://join.msn.com/?page=features/junkmail&xAPID=42&PS=47575&PI=7324...
http://www.hotmail.msn.com/cgi-bin/getmsg&HL=1216hotmailtaglines_adva...