MQSeries.net :: View topic - Unable to connect with AS400 server through Broker 6.1

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Unable to connect with AS400 server through Broker 6.1

Unable to connect with AS400 server through Broker 6.1

« View previous topic :: View next topic »

Author

Message

Shams

Posted: Mon Jul 07, 2014 11:36 am Post subject: Unable to connect with AS400 server through Broker 6.1

Newbie

Joined: 07 Jul 2014
Posts: 1

Hi All,

I am trying to connect to AS400 server through Broker6.1 using jt400.jar.
I am able to connect to the server with IB9 using the same configurable service. Moreover I have successfully connected to the above said server directly using a java class.

Error message I got in Broker6.1 at eventviewer :

Quote:

'datasource URL = jdbc:as400://10.0.0.39;naming=sql;prompt=false;user=usr;password=********;' Detalles de la excepciÃ³n: 'The application requester cannot establish the connection.'

Quote:

(WBRK61_DEFAULT_BROKER.Interop) There was an error in node '<com.ibm.broker.plugin.MbRecoverableException class: @ 519e519e com.ibm.broker.jdbctype4.localtrxn.JDBCType4SinglePhaseTrxnHandlerErrors method: JDBCType4SinglePhaseTrxnHandler :: getConnection source: BIPv610 key : 4362> at com.ibm.broker.jdbctype4.localtrxn.JDBCType4SinglePhaseTrxnHandlerErrors.throwException(JDBCType4SinglePhaseTrxnHandlerErrors.java:213) at com.ibm.broker.jdbctype4.localtrxn.JDBCType4SinglePhaseTrxnHandler.getConnection(JDBCType4SinglePhaseTrxnHandler.java:371) at com.ibm.broker.jdbctype4.connfact.JDBCType4ConnectionFactory.getConnection(JDBCType4ConnectionFactory.java:158) at sun.reflect.NativeMethodAccessorImpl.invoke0 (Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java: 79) at sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java: 43) at java.lang.reflect.Method . invoke (Method.java: 619) at com.ibm.broker.plugin.MbNode.getJDBCType4Connection (MbNode.java: 1560) at com.tcs.flujos.SocketServerCaller_QueryDB.evaluate (SocketServerCaller_QueryDB.java: 45) at com.ibm. broker.javacompute.MbRuntimeJavaComputeNode.evaluate (MbRuntimeJavaComputeNode.java: 180) at com.ibm.broker.plugin.MbNode.evaluate (MbNode.java: 1476) 'There was a problem loading the driver class database:% 3 Details of the exception:% 4

The node was unable to load the JDBC driver class specified.

Contact the administrator of WebSphere Message Brokers.

Configurable service of Broker6.1 :

Quote:

JDBCProviders
GAFROESRVC1
connectionUrlFormat='jdbc:as400://[serverName];naming=sql;prompt=false;user=[user];password=[password];'
connectionUrlFormatAttr1=''
connectionUrlFormatAttr2=''
connectionUrlFormatAttr3=''
connectionUrlFormatAttr4=''
connectionUrlFormatAttr5=''
databaseName='default_Database_Name'
databaseType='default_Database_Type'
databaseVersion='default_Database_Version'
description='default_Description'
environmentParms='default_none'
jarsURL='C:\libs'
portNumber='default_Port_Number'
securityIdentity='GAFUSR99'
serverName='10.0.0.39'
type4DatasourceClassName='com.ibm.as400.access.AS400JDBCXADataSource'
type4DriverClassName='com.ibm.as400.access.AS400JDBCDriver'

I have gone through the following topic in this blog:

Quote:

Configuring JDBCProvider to connect to DB2 v5r4 on AS400 by prasadpav

but could not succeed.

Does Broker6.1 do not support this, or I am missing something?

Any help is much appreciated. Thanks in advance.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Unable to connect with AS400 server through Broker 6.1

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