I am not determine the version of informix database yet,but I have successfully connected to the database by WMDB.
You can see the attachment WMDB.png,it’s the screen shot of WMDB Alias configuration,and the WMDB url is : jdbc:informix-sqli://10.130.14.126:9118/exch:informixserver=on_tcp118;NEWCODESET=JDK-encoding,Ifx-codeset,Ifx-codeset-number:JDK-encoding,Ifx-codeset,Ifx-codeset-number,MS950,big5,GBK,8859-1,819,57352;IFX_USE_STRENC=true;DB_LOCALE=zh_TW.57352;CLIENT_LOCALE=zh_TW.57352;
But when I create a JDBC Adapter connection,I got the “Unable to load locale categories” error.
You can see the error message(errorMSG.png) and the screen shot of JDBC connection configuration(JDBC.png) in attachments also.
As the version of the OS which we installed webMethods8.2.2 is Windows Server 2008 R2 Enterprise,and the server’s default language is english(en_us),so we cannot connect to the informix database which DB_LOCALE=zh_TW.57352 by JDBC.In WMDB Alias configuration,we can set the URL properties “DB_LOCALE=zh_TW.57352;CLIENT_LOCALE=zh_TW.57352” to solve this problem?but in JDBC connection configuration I can’t find where to config it.
Its really good to see that you are able to connect through WmDB but for your information WmDB has been deprecated and SAG recommends to use JDBC Adapter for reasons like better database performance, batch operations, notification features etc.,
When I look at your attached error screen shot I assume that the error is due to the missing JAR files.
1> Did you try placing the appropriate JARS under \IntegrationServer\lib\jars
2> Restart IS and then configure the connection via JDBC adapter.