ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum IndexWebSphere Message Broker SupportIB 10.0.0.6 informix jdbc 'Unable to load locale categories'

Post new topicReply to topic
IB 10.0.0.6 informix jdbc 'Unable to load locale categories' View previous topic :: View next topic
Author Message
patarik
PostPosted: Mon Dec 19, 2016 4:21 am Post subject: IB 10.0.0.6 informix jdbc 'Unable to load locale categories' Reply with quote

Newbie

Joined: 12 May 2016
Posts: 4

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
View user's profile Send private message
mqjeff
PostPosted: Wed Dec 21, 2016 5:53 am Post subject: Reply with quote

Grand Master

Joined: 25 Jun 2008
Posts: 17447

Perhaps you could show the actual code you use.
_________________
chmod -R ugo-wx /
Back to top
View user's profile Send private message
Display posts from previous:
Post new topicReply to topic Page 1 of 1

MQSeries.net Forum IndexWebSphere Message Broker SupportIB 10.0.0.6 informix jdbc 'Unable to load locale categories'
Jump to:



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
Protected by Anti-Spam ACP


Theme by Dustin Baccetti
Powered by phpBB 2001, 2002 phpBB Group

Copyright MQSeries.net. All rights reserved.