| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Local setup of WBI JDBC adapter |
« View previous topic :: View next topic » |
| Author |
Message
|
| 4integration |
 Posted: Sat Mar 17, 2007 3:02 pm Post subject: Local setup of WBI JDBC adapter |
 |
|
Disciple
Joined: 04 Sep 2006
Posts: 197
Location: Gothenburg, Sweden
|
Hello,
I am trying to setup the WBI for JDBC adapter on my local machine which also have WMB, WMQ,...etc
When starting the JDBC adapter I get the error:
| Code: |
[Time: 2007/03/17 23:55:54.320] [System: ConnectorAgent] [SS: JDBC_WMSConnector] [Thread: wbia_main (#1562240050)] [Type: Trace] [Mesg: :Creating ClientTransportManger for connector JDBC_WMSConnector for delivery transport JMS. An
d isAgentSlave = false]
[Time: 2007/03/17 23:55:54.330] [System: ConnectorAgent] [SS: JDBC_WMSConnector] [Thread: wbia_main (#1562240050)] [Type: Trace] [Mesg: : Created the thread ClientPacketSyncDrvFormatterJDBC_WMSConnector for maintaining connection
to the controller ]
[Time: 2007/03/17 23:55:54.360] [System: ConnectorAgent] [SS: JDBC_WMSConnector] [Thread: wbia_main (#1562240050)] [Type: Trace] [Mesg: :The Connection String is crossworlds.queue.manager]
javax.jms.JMSException: MQJMS2005: failed to create MQQueueManager for 'crossworlds.queue.manager'
at com.ibm.mq.jms.services.ConfigEnvironment.newException(ConfigEnvironment.java:586)
at com.ibm.mq.jms.MQConnection.createQM(MQConnection.java:2082)
at com.ibm.mq.jms.MQConnection.createQMNonXA(MQConnection.java:1496)
at com.ibm.mq.jms.MQQueueConnection.<init>(MQQueueConnection.java:150)
at com.ibm.mq.jms.MQQueueConnection.<init>(MQQueueConnection.java:60)
at com.ibm.mq.jms.MQQueueConnectionFactory.createQueueConnection(MQQueueConnectionFactory.java:171)
at com.ibm.mq.jms.MQQueueConnectionFactory.createQueueConnection(MQQueueConnectionFactory.java:112)
at CxCommon.Messaging.jms.JMSTransportUtil.initQueueConnection(JMSTransportUtil.java:208)
at CxCommon.Messaging.jms.SessionMgr.createSession(SessionMgr.java:266)
at CxCommon.Messaging.jms.SessionMgr.getAgentSession(SessionMgr.java:119)
at CxCommon.Messaging.ClientPacketSyncDrvFormatter.<init>(ClientPacketSyncDrvFormatter.java:173)
at CxCommon.Messaging.ClientTransportManager.<init>(ClientTransportManager.java:192)
at CxCommon.Messaging.ClientTransportManager.<init>(ClientTransportManager.java:214)
at AppSide_Connector.AgentBusinessObjectManager.setupTransport(AgentBusinessObjectManager.java:323)
at AppSide_Connector.AgentBusinessObjectManager.<init>(AgentBusinessObjectManager.java:267)
at AppSide_Connector.AppEnd.run(AppEnd.java:1516)
at AppSide_Connector.AppEnd.init(AppEnd.java:394)
at AppSide_Connector.AppEnd.<init>(AppEnd.java:140)
at AppSide_Connector.AppEnd.main(AppEnd.java:1145)
at AppEndWrapper.main(AppEndWrapper.java:28)
[Time: 2007/03/17 23:55:54.691] [System: ConnectorAgent] [SS: JDBC_WMSConnector] [Thread: wbia_main (#1562240050)] [Type: Trace] [Mesg: :Can NOT create JMS connection to queue manager -- crossworlds.queue.manager]
[Time: 2007/03/17 23:55:54.701] [System: ConnectorAgent] [SS: JDBC_WMSConnector] [Thread: wbia_main (#1562240050)] [Type: Error] [MsgID: 9052] [Mesg: Unable to get a MQ series Queue Manager or Queue Connection. Reason: failed to c
reate connection --javax.jms.JMSException: MQJMS2005: failed to create MQQueueManager for 'crossworlds.queue.manager'.] |
Do you have any good hints how to solve this?
_________________
Best regards
4 Integration |
|
| Back to top |
|
 |
| RocknRambo |
| Posted: Sat Mar 17, 2007 5:50 pm Post subject: |
|
|
Partisan
Joined: 24 Sep 2003
Posts: 355
|
| Quote: |
The Connection String is crossworlds.queue.manager]
javax.jms.JMSException: MQJMS2005: failed to create MQQueueManager for 'crossworlds.queue.manager' |
verify the qmgr specified in the .cfg file exists and started
-RR |
|
| Back to top |
|
|
| 4integration |
| Posted: Sun Mar 18, 2007 1:11 am Post subject: |
|
|
Disciple
Joined: 04 Sep 2006
Posts: 197
Location: Gothenburg, Sweden
|
Can you describe a bit more detailed, please.
The queue manager is started.
According to the user guide there are only one configuration parameter (if I understand it correct). That is the "jms.MessageBrokerName" parameter in the config file.
It says that if the broker is local use the default value "crossworlds.queue.manager" and if remote use the following pattern QueueMgrName:Channel:HostName:PortNumber and I have also tried that (using
| Quote: |
| WBRK6_DEFAULT_QUEUE_MANAGER:java.channel:segotwd9616.mydomain:1414 |
I start the connector with the command:
| Quote: |
| start_JDBC.bat JDBC_WMS WBRK6_DEFAULT_BROKER -cC:\v008789\Tools\IBM\WebSphereAdapters\connectors\JDBC_WMS\JDBC_WMSConnector.cfg |
(I had to rename the JAR from CWJDBC.jar to CWJDBC_WMS.jar to be loaded without modifying the startup script which would have be another way)
The broker is named: WBRK6_DEFAULT_BROKER
The Configuration manager's name: WBRK6_DEFAULT_CONFIGURATION_MANAGER
The queue managers name: WBRK6_DEFAULT_QUEUE_MANAGER
The queue manager's listening port: 1414
_________________
Best regards
4 Integration |
|
| Back to top |
|
|
| 4integration |
| Posted: Sun Mar 18, 2007 1:52 am Post subject: |
|
|
Disciple
Joined: 04 Sep 2006
Posts: 197
Location: Gothenburg, Sweden
|
Hi again,
It seems that I got one step further by using the value "WBRK6_DEFAULT_QUEUE_MANAGER" for parameter "jms.MessageBrokerName".
Now it crashes but I think it can not get connection to database or such..
| Quote: |
[Time: 2007/03/18 10:40:20.754] [System: ConnectorAgent] [SS: JDBC_WMSConnector] [Thread: wbia_main (#1562206135)] [Type: Trace] [Mesg: :Creating ClientTransportManger for connector JDBC_WMSConnector for delivery transport JMS. An
d isAgentSlave = false]
[Time: 2007/03/18 10:40:20.794] [System: ConnectorAgent] [SS: JDBC_WMSConnector] [Thread: wbia_main (#1562206135)] [Type: Trace] [Mesg: : Created the thread ClientPacketSyncDrvFormatterJDBC_WMSConnector for maintaining connection
to the controller ]
[Time: 2007/03/18 10:40:20.854] [System: ConnectorAgent] [SS: JDBC_WMSConnector] [Thread: wbia_main (#1562206135)] [Type: Trace] [Mesg: :The Connection String is WBRK6_DEFAULT_QUEUE_MANAGER]
[Time: 2007/03/18 10:40:21.234] [System: ConnectorAgent] [SS: JDBC_WMSConnector] [Thread: wbia_main (#1562206135)] [Type: Trace] [Mesg: :WBIA.JDBC_PLWMS2.ADMININQUEUE -- is validated.]
[Time: 2007/03/18 10:40:21.244] [System: ConnectorAgent] [SS: JDBC_WMSConnector] [Thread: wbia_main (#1562206135)] [Type: Trace] [Mesg: :WBIA.JDBC_PLWMS2.ADMINOUTQUEUE -- is validated.]
[Time: 2007/03/18 10:40:21.244] [System: ConnectorAgent] [SS: JDBC_WMSConnector] [Thread: wbia_main (#1562206135)] [Type: Trace] [Mesg: :WBIA.JDBC_PLWMS2.DELIVERYQUEUE -- is validated.]
[Time: 2007/03/18 10:40:21.254] [System: ConnectorAgent] [SS: JDBC_WMSConnector] [Thread: wbia_main (#1562206135)] [Type: Trace] [Mesg: :WBIA.JDBC_PLWMS2.REQUESTQUEUE -- is validated.]
[Time: 2007/03/18 10:40:21.254] [System: ConnectorAgent] [SS: JDBC_WMSConnector] [Thread: wbia_main (#1562206135)] [Type: Trace] [Mesg: :WBIA.JDBC_PLWMS2.RESPONSEQUEUE -- is validated.]
[Time: 2007/03/18 10:40:21.254] [System: ConnectorAgent] [SS: JDBC_WMSConnector] [Thread: wbia_main (#1562206135)] [Type: Trace] [Mesg: :WBIA.JDBC_PLWMS2.SYNCHRONOUSREQUESTQUEUE -- is validated.]
[Time: 2007/03/18 10:40:21.254] [System: ConnectorAgent] [SS: JDBC_WMSConnector] [Thread: wbia_main (#1562206135)] [Type: Trace] [Mesg: :WBIA.JDBC_PLWMS2.SYNCHRONOUSRESPONSEQUEUE -- is validated.]
[Time: 2007/03/18 10:40:21.254] [System: ConnectorAgent] [SS: JDBC_WMSConnector] [Thread: wbia_main (#1562206135)] [Type: Trace] [Mesg: :WBIA.JDBC_PLWMS2.FAULTQUEUE -- is validated.]
[Time: 2007/03/18 10:40:21.304] [System: ConnectorAgent] [SS: JDBC_WMSConnector] [Thread: wbia_main (#1562206135)] [Type: Trace] [Mesg: :Receive listener started. Listening on queue:WBIA.JDBC_PLWMS2.ADMININQUEUE, sending fault mes
sages on queue:null]
[Time: 2007/03/18 10:40:21.315] [System: ConnectorAgent] [SS: JDBC_WMSConnector] [Thread: ClientPacketSyncDrvFormatterJDBC_WMSConnector (#1568661431)] [Type: Trace] [Mesg: :ClientPacketSynDrvFormatter thread to maintain connection
to controller is started]
[Time: 2007/03/18 10:40:21.315] [System: ConnectorAgent] [SS: JDBC_WMSConnector] [Thread: ClientPacketSyncDrvFormatterJDBC_WMSConnector (#1568661431)] [Type: Trace] [Mesg: :waiting for agent to be initialized ...]
[Time: 2007/03/18 10:40:21.325] [System: ConnectorAgent] [SS: JDBC_WMSConnector] [Thread: ClientPacketSyncDrvFormatterJDBC_WMSConnector (#1568661431)] [Type: Trace] [Mesg: :Receive listener started. Listening on queue:WBIA.JDBC_PL
WMS2.REQUESTQUEUE, sending fault messages on queue:WBIA.JDBC_PLWMS2.FAULTQUEUE]
[Time: 2007/03/18 10:40:21.325] [System: ConnectorAgent] [SS: JDBC_WMSConnector] [Thread: ClientPacketSyncDrvFormatterJDBC_WMSConnector (#1568661431)] [Type: Trace] [Mesg: :initDone 4]
[Time: 2007/03/18 10:40:21.325] [System: ConnectorAgent] [SS: JDBC_WMSConnector] [Thread: ClientPacketSyncDrvFormatterJDBC_WMSConnector (#1568661431)] [Type: Info] [MsgID: 17064] [Mesg: Connector Agent state is active.]
[Time: 2007/03/18 10:40:21.615] [System: ConnectorAgent] [SS: JDBC_WMSConnector] [Thread: wbia_main (#1562206135)] [Type: Info] [MsgID: 17007] [Mesg: Press q to quit connector.]
[Time: 2007/03/18 10:40:21.615] [System: ConnectorAgent] [SS: JDBC_WMSConnector] [Thread: appPolling (#1565089719)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 17008] [Mesg: Polling every 0 milliseconds.] ]
[Time: 2007/03/18 10:40:21.615] [System: ConnectorAgent] [SS: JDBC_WMSConnector] [Thread: appPolling (#1565089719)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 17009] [Mesg: Polling for subscription events.] ]
[Time: 2007/03/18 10:40:21.615] [System: ConnectorAgent] [SS: JDBC_WMSConnector] [Thread: appPolling (#1565089719)] [Type: Trace] [Mesg: Thread:appPolling:executing poll call]
[Time: 2007/03/18 10:40:21.615] [System: ConnectorAgent] [SS: JDBC_WMSConnector] [Thread: appPolling (#1565089719)] [Type: Trace] [Mesg: :Polling App Connector.]
[Time: 2007/03/18 10:40:21.615] [System: ConnectorAgent] [SS: JDBC_WMSConnector] [Thread: appPolling (#1565089719)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90018] [Mesg: Entering pollForEvents] ]
[Time: 2007/03/18 10:40:21.615] [System: ConnectorAgent] [SS: JDBC_WMSConnector] [Thread: appPolling (#1565089719)] [Type: Error] [MsgID: 20058] [Mesg: EventTableName not set.]
[Time: 2007/03/18 10:40:21.615] [System: ConnectorAgent] [SS: JDBC_WMSConnector] [Thread: appPolling (#1565089719)] [Type: Trace] [Mesg: :checkStatus]
[Time: 2007/03/18 10:40:21.615] [System: ConnectorAgent] [SS: JDBC_WMSConnector] [Thread: appPolling (#1565089719)] [Type: Error] [MsgID: 17058] [Mesg: Application call to method poll() returned failure. The application could not
be contacted.]
[Time: 2007/03/18 10:40:21.625] [System: ConnectorAgent] [SS: JDBC_WMSConnector] [Thread: appPolling (#1565089719)] [Type: Trace] [Mesg: :deactivate]
[Time: 2007/03/18 10:40:21.625] [System: ConnectorAgent] [SS: JDBC_WMSConnector] [Thread: appPolling (#1565089719)] [Type: Trace] [Mesg: :Deactivating]
[Time: 2007/03/18 10:40:21.635] [System: ConnectorAgent] [SS: JDBC_WMSConnector] [Thread: appPolling (#1565089719)] [Type: Info] [MsgID: 17064] [Mesg: Connector Agent state is inactive.]
[Time: 2007/03/18 10:40:21.635] [System: ConnectorAgent] [SS: JDBC_WMSConnector] [Thread: appPolling (#1565089719)] [Type: Trace] [Mesg: :Deactivated]
[Time: 2007/03/18 10:40:21.635] [System: ConnectorAgent] [SS: JDBC_WMSConnector] [Thread: appPolling (#1565089719)] [Type: Trace] [Mesg: :terminate]
[Time: 2007/03/18 10:40:21.635] [System: ConnectorAgent] [SS: JDBC_WMSConnector] [Thread: appPolling (#1565089719)] [Type: Trace] [Mesg: :Termination requested]
[Time: 2007/03/18 10:40:21.635] [System: ConnectorAgent] [SS: JDBC_WMSConnector] [Thread: appPolling (#1565089719)] [Type: Info] [MsgID: 17066] [Mesg: Application state is disconnected]
[Time: 2007/03/18 10:40:21.635] [System: ConnectorAgent] [SS: JDBC_WMSConnector] [Thread: appPolling (#1565089719)] [Type: Trace] [Mesg: Thread:appPolling:executing terminate call]
[Time: 2007/03/18 10:40:21.665] [System: ConnectorAgent] [SS: JDBC_WMSConnector] [Thread: appPolling (#1565089719)] [Type: Trace] [Mesg: :Terminating App Connector.]
[Time: 2007/03/18 10:40:21.665] [System: ConnectorAgent] [SS: JDBC_WMSConnector] [Thread: appPolling (#1565089719)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90018] [Mesg: Entering Terminate] ]
[Time: 2007/03/18 10:40:21.665] [System: ConnectorAgent] [SS: JDBC_WMSConnector] [Thread: appPolling (#1565089719)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90018] [Mesg: Entering cleanup] ]
[Time: 2007/03/18 10:40:21.665] [System: ConnectorAgent] [SS: JDBC_WMSConnector] [Thread: appPolling (#1565089719)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 36016] [Mesg: PrepStmtCache Stats : Connection :oracle.jdbc.driver.T4C
Connection@22a6df97 , PrepStmtCacheLength : 0] ]
[Time: 2007/03/18 10:40:21.665] [System: ConnectorAgent] [SS: JDBC_WMSConnector] [Thread: appPolling (#1565089719)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 36017] [Mesg: PrepStmtCache Stats : Number of addedStmts :0 , Number o
f Stmts from Cache : 0] ]
[Time: 2007/03/18 10:40:21.715] [System: ConnectorAgent] [SS: JDBC_WMSConnector] [Thread: appPolling (#1565089719)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90019] [Mesg: Exiting cleanup] ]
[Time: 2007/03/18 10:40:21.715] [System: ConnectorAgent] [SS: JDBC_WMSConnector] [Thread: appPolling (#1565089719)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90019] [Mesg: Exiting Terminate] ]
[Time: 2007/03/18 10:40:21.715] [System: ConnectorAgent] [SS: JDBC_WMSConnector] [Thread: appPolling (#1565089719)] [Type: Trace] [Mesg: :checkStatus]
[Time: 2007/03/18 10:40:21.715] [System: ConnectorAgent] [SS: JDBC_WMSConnector] [Thread: appPolling (#1565089719)] [Type: Trace] [Mesg: :Terminated App Connector]
[Time: 2007/03/18 10:40:21.715] [System: ConnectorAgent] [SS: JDBC_WMSConnector] [Thread: appPolling (#1565089719)] [Type: Info] [MsgID: 17066] [Mesg: Application state is disconnected]
[Time: 2007/03/18 10:40:21.715] [System: ConnectorAgent] [SS: JDBC_WMSConnector] [Thread: Restart Thread - JDBC_WMSConnector- retry #1 (#1572675511)] [Type: Trace] [Mesg: :setClientDomainState]
[Time: 2007/03/18 10:40:21.725] [System: ConnectorAgent] [SS: JDBC_WMSConnector] [Thread: Restart Thread - JDBC_WMSConnector- retry #1 (#1572675511)] [Type: Fatal Error] [MsgID: 17518] [Mesg: Exhausted the configured number of 0 r
estart retries for serial connector agent JDBC_WMSConnector. Shutting down.]
Press any key to continue . . . |
_________________
Best regards
4 Integration |
|
| Back to top |
|
|
| 4integration |
| Posted: Sun Mar 18, 2007 9:45 am Post subject: |
|
|
Disciple
Joined: 04 Sep 2006
Posts: 197
Location: Gothenburg, Sweden
|
Found and solved...
The error occurred because I have not created event tables so I set them to null and passed the startup parameter -fno to prevent polling
_________________
Best regards
4 Integration |
|
| 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
|
|
|
|
