| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| IB 10.0.0.6 informix jdbc 'Unable to load locale categories' |
« View previous topic :: View next topic » |
| Author |
Message
|
| patarik |
 Posted: Mon Dec 19, 2016 4:21 am Post subject: IB 10.0.0.6 informix jdbc 'Unable to load locale categories' |
 |
|
Newbie
Joined: 12 May 2016
Posts: 6
|
Hi,
I get following error when I try to get JDBC connection in Java compute node.
| Code: |
Unable to load locale categories., SQLState value: IX000, vendor's error code: -23101, stack trace: [com.informix.jdbc.IfxSqliConnect.<init>(Unknown Source)
com.informix.jdbcx.IfxXAReusableConnection.<init>(Unknown Source)
com.informix.jdbcx.IfxXAPooledConnection.<init>(Unknown Source)
com.informix.jdbcx.IfxXADataSource.getXAConnection(Unknown Source)
com.ibm.broker.jdbctype4.jdbcdbasemgr.JDBCType4Connection.createXAConnection(JDBCType4Connection.java:244)
com.ibm.broker.jdbctype4.jdbcdbasemgr.JDBCType4DatabaseManager.getThreadOwnedConnections(JDBCType4DatabaseManager.java:320)
com.ibm.broker.jdbctype4.localtrxn.JDBCType4SinglePhaseTrxnHandler.getConnection(JDBCType4SinglePhaseTrxnHandler.java:261)
com.ibm.broker.jdbctype4.localtrxn.JDBCType4SinglePhaseTrxnHandler.getConnection(JDBCType4SinglePhaseTrxnHandler.java:153)
com.ibm.broker.jdbctype4.connfact.JDBCType4ConnectionFactory.getConnection(JDBCType4ConnectionFactory.java:163)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:95)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:56)
java.lang.reflect.Method.invoke(Method.java:620)
com.ibm.broker.plugin.MbNode.getJDBCType4Connection(MbNode.java:1533)
|
my settings for JDBCProvider are
| Code: |
connectionUrlFormat='jdbc:informix-sqli://[serverName]:[portNumber]/[databaseName]:informixserver=[connectionUrlFormatAttr1];user=[user];password=[password]'
connectionUrlFormatAttr1='ids_db_db'
connectionUrlFormatAttr2=''
connectionUrlFormatAttr3=''
connectionUrlFormatAttr4=''
connectionUrlFormatAttr5=''
databaseName='real_db_name'
databaseSchemaNames='useProvidedSchemaNames'
databaseType='Informix'
databaseVersion='default_Database_Version'
description='default_Description'
environmentParms='CLIENT_LOCALE=sk_sk.8859-2;IFX_USE_STRENC=Y;DB_LOCALE=sk_sk.8859-2'
jarsURL='/var/mqsi/config/SOME_NODE/shared-classes'
jdbcProviderXASupport='true'
maxConnectionPoolSize='0'
portNumber='7777'
securityIdentity='ZPIS'
serverName='serverxx'
type4DatasourceClassName='com.informix.jdbcx.IfxXADataSource'
type4DriverClassName='com.informix.jdbc.IfxDriver'
|
(real values for server,port,db name,informixserver are changed)
Strange thing is that connection on db works if I set jdbcProviderXASupport to false. Then the selects to db work but updates are not committed.
When th jdbcProviderXASupport is set to true. I get informix error -23101.
It is strange behaviour, what can be wrong? Why I get this error. (values for DB_LOCALE are correct, I can connect with them with SQL client do DB server)
The flow connects also to IBM MQ 8. (But it work ok, reading and writing to MQ queues is correct)[/code] |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Wed Dec 21, 2016 5:53 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
Perhaps you could show the actual code you use.
_________________
chmod -R ugo-wx / |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
