| Author |
Message
|
| mqmaniac |
 Posted: Thu Aug 03, 2006 4:48 pm Post subject: JDBCConnector Configurating Queue Manager. |
 |
|
Master
Joined: 27 Dec 2005
Posts: 201
|
Hello Everyone..
I am trying to Configure a Crosswordls JDBC Connector.
I am trying to integrate the JDBC adapter with the Message Broker and created Mesage Sets and Flows.I am supplying a JMS message to the JDBC adapter.
In my previous post I was able to create a (DB2) ASBO.
Now I am planning to configure a connector to pick a JMS message from a Queue and Create an ASBO and update a database Table.
I am confused about how to include the QUEUE MANAGER and QUEUE NAMES in the Connector Configurator as I dont see them listed.
I have selected the JDBCConnector Template to create the Connector. |
|
| Back to top |
|
 |
| vennela |
| Posted: Fri Aug 04, 2006 7:11 am Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
| There should be a connector specific properties pane |
|
| Back to top |
|
|
| mqmaniac |
| Posted: Fri Aug 04, 2006 9:28 am Post subject: |
|
|
Master
Joined: 27 Dec 2005
Posts: 201
|
Hi Vennela..
I see the Connector specific pane BUT do not see queue manager and queue attibutes to fill in..
Am I looking at the wrong Adapter!.Or should I include Name Value Pairs for MQ server? |
|
| Back to top |
|
|
| vennela |
| Posted: Fri Aug 04, 2006 9:31 am Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
| The transport property should be JMS. I think by default it is set to IDL. |
|
| Back to top |
|
|
| mqmaniac |
| Posted: Fri Aug 04, 2006 10:25 am Post subject: |
|
|
Master
Joined: 27 Dec 2005
Posts: 201
|
Thats what all the documentation I have searched says..BUT I have
"WMQI-JMS".
What kind of adapter provides this..I am confused!!! |
|
| Back to top |
|
|
| vennela |
| Posted: Fri Aug 04, 2006 10:30 am Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
That's as far as I can go. I have never worked with MB and Adapters.
Somebody might step in and figure out what the problem is |
|
| Back to top |
|
|
| vk |
| Posted: Mon Aug 07, 2006 5:07 am Post subject: |
|
|
Partisan
Joined: 20 Sep 2005
Posts: 302
Location: Houston
|
| Quote: |
| I see the Connector specific pane BUT do not see queue manager and queue attibutes to fill in.. |
Queue manager names and queue names are not specified in the connector specific pane, but in the Standard properties panes.
Transport property should be JMS as Vennela said.
Can you post your Standard and Connector Specific properties?
Regards,
VK. |
|
| Back to top |
|
|
| RocknRambo |
| Posted: Mon Aug 07, 2006 7:42 am Post subject: |
|
|
Partisan
Joined: 24 Sep 2003
Posts: 355
|
well!... the property in connector standard properties - 'jms.MessageBrokerName' , is where you specify the Qmgr name and if MB is ur broker, choose the 'wmqi' for the property - BrokerType, in the this should be avail in all adapters as of common framework.
-RR |
|
| Back to top |
|
|
| mqmaniac |
| Posted: Mon Aug 07, 2006 1:51 pm Post subject: |
|
|
Master
Joined: 27 Dec 2005
Posts: 201
|
| vk wrote: |
| Quote: |
| I see the Connector specific pane BUT do not see queue manager and queue attibutes to fill in.. |
Queue manager names and queue names are not specified in the connector specific pane, but in the Standard properties panes.
Transport property should be JMS as Vennela said.
Can you post your Standard and Connector Specific properties?
Regards,
VK. |
Thanks for the replies..
The standard properties Pane do not have Queue Manager or Queue Names.I am pasting the .CFG file.
Its an XML file..I am really confused what kind of Adapter am I using..
I am told its a Crosswordls JDBC..BUT do not have any MQ attributes...
SHOULD I WRITE ANY JAVA CODE to include MQ Attributes???
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<cw:ContainerConfig xmlns:cw="http://www.ibm.com/websphere/crossworlds/2002/ComponentSchemas" xmlns:tns="http://www.ibm.com/websphere/crossworlds/2002/HierarchicalProperties"><cw:ConnectorConfig><cw:ConfigurationInfo><cw:name>JDBCConnector.cfg</cw:name><cw:installID></cw:installID></cw:ConfigurationInfo><cw:header><cw:name>JDBCConnector</cw:name><cw:version>4.2.0</cw:version></cw:header><cw:properties><cw:std_properties><tns:property><tns:name>AgentTraceLevel</tns:name><tns:type>Integer</tns:type><tns:value xml:space="preserve">5</tns:value><tns:description>Trace level for the connector agent</tns:description><tns:updateMethod>dynamic</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted></tns:property><tns:property><tns:name>ApplicationName</tns:name><tns:type>String</tns:type><tns:value xml:space="preserve">JDBCConnector</tns:value><tns:description>The name of the application</tns:description><tns:updateMethod>component restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted></tns:property><tns:property><tns:name>BrokerType</tns:name><tns:type>String</tns:type><tns:value xml:space="preserve">WMQI</tns:value><tns:description>Broker type</tns:description><tns:updateMethod>connector restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted></tns:property><tns:property><tns:name>CharacterEncoding</tns:name><tns:type>String</tns:type><tns:value xml:space="preserve">ascii7</tns:value><tns:description>The connector agent will use the characte encoding</tns:description><tns:updateMethod>component restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted></tns:property><tns:property><tns:name>Locale</tns:name><tns:type>String</tns:type><tns:value xml:space="preserve">en_US</tns:value><tns:description>The locale of the connector agent</tns:description><tns:updateMethod>component restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted></tns:property><tns:property><tns:name>MessageFileName</tns:name><tns:type>String</tns:type><tns:value xml:space="preserve">InterchangeSystem.txt</tns:value><tns:description>Application specific portion of the connector agent will use this message file for error message generation</tns:description><tns:updateMethod>component restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted></tns:property><tns:property><tns:name>PollEndTime</tns:name><tns:type>Time</tns:type><tns:value xml:space="preserve">HH:MM</tns:value><tns:description>Time at which the connector agent polling will stop</tns:description><tns:updateMethod>component restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted></tns:property><tns:property><tns:name>PollStartTime</tns:name><tns:type>Time</tns:type><tns:value xml:space="preserve">HH:MM</tns:value><tns:description>Time at which the connector agent polling will start</tns:description><tns:updateMethod>component restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted></tns:property><tns:property><tns:name>PollFrequency</tns:name><tns:type>Integer</tns:type><tns:value xml:space="preserve">10000</tns:value><tns:description>Interval at which the agent will poll</tns:description><tns:updateMethod>dynamic</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted></tns:property><tns:property><tns:name>RepositoryDirectory</tns:name><tns:type>String</tns:type><tns:value xml:space="preserve">C:\crossworlds\Repository</tns:value><tns:description>Location where repository is located</tns:description><tns:updateMethod>Agent restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted></tns:property><tns:property><tns:name>DeliveryTransport</tns:name><tns:type>String</tns:type><tns:value xml:space="preserve">JMS</tns:value><tns:description>The transport for data flowing between connector and server for subscription delivery</tns:description><tns:updateMethod>component restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted></tns:property><tns:property><tns:name>ContainerManagedEvents</tns:name><tns:type>String</tns:type><tns:value xml:space="preserve"></tns:value><tns:description>To indicate whether container managed events are enabled.</tns:description><tns:updateMethod>component restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted></tns:property><tns:property><tns:name>RFH2MessageDomain</tns:name><tns:type>String</tns:type><tns:value xml:space="preserve">mrm</tns:value><tns:description>The domain to be set in JMS header.</tns:description><tns:updateMethod>component restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted></tns:property><tns:property><tns:name>DuplicateEventElimination</tns:name><tns:type>Boolean</tns:type><tns:value xml:space="preserve">false</tns:value><tns:description>To enable GED feature</tns:description><tns:updateMethod>component restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted></tns:property><tns:property><tns:name>WireFormat</tns:name><tns:type>String</tns:type><tns:value xml:space="preserve">CwXML</tns:value><tns:description>Message format on the transport</tns:description><tns:updateMethod>agent restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted></tns:property><tns:property><tns:name>SynchronousRequestTimeout</tns:name><tns:type>Integer</tns:type><tns:value xml:space="preserve">0</tns:value><tns:description>Time in minutes that connector will wait for a response to a synchronous request.</tns:description><tns:updateMethod>component restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted></tns:property><tns:property><tns:name>SynchronousResponseQueue</tns:name><tns:type>String</tns:type><tns:value xml:space="preserve">JDBCCONNECTOR/SYNCHRONOUSRESPONSEQUEUE</tns:value><tns:description>Logical queue that delivers response message from connector to jms provider in reply to synchronous request.</tns:description><tns:updateMethod>component restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted></tns:property><tns:property><tns:name>SynchronousRequestQueue</tns:name><tns:type>String</tns:type><tns:value xml:space="preserve">JDBCCONNECTOR/SYNCHRONOUSREQUESTQUEUE</tns:value><tns:description>Logical queue that delivers request message from jms provider to connector framework that requires synchronous response.</tns:description><tns:updateMethod>component restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted></tns:property><tns:property><tns:name>AdminInQueue</tns:name><tns:type>String</tns:type><tns:value xml:space="preserve">JDBCCONNECTOR/ADMININQUEUE</tns:value><tns:description>The logical queue that will be used by the broker to write admin messages to the connector</tns:description><tns:updateMethod>component restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted></tns:property><tns:property><tns:name>AdminOutQueue</tns:name><tns:type>String</tns:type><tns:value xml:space="preserve">JDBCCONNECTOR/ADMINOUTQUEUE</tns:value><tns:description>The logical queue that will be used by the connector to write admin messages to the broker</tns:description><tns:updateMethod>component restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted></tns:property><tns:property><tns:name>DeliveryQueue</tns:name><tns:type>String</tns:type><tns:value xml:space="preserve">JDBCCONNECTOR/DELIVERYQUEUE</tns:value><tns:description>The logical queue that will be used by the connector to send business data to the broker.</tns:description><tns:updateMethod>component restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted></tns:property><tns:property><tns:name>FaultQueue</tns:name><tns:type>String</tns:type><tns:value xml:space="preserve">JDBCCONNECTOR/FAULTQUEUE</tns:value><tns:description>The queue that will be used by the connector to write fault messages.</tns:description><tns:updateMethod>component restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted></tns:property><tns:property><tns:name>RequestQueue</tns:name><tns:type>String</tns:type><tns:value xml:space="preserve">JDBCCONNECTOR/REQUESTQUEUE</tns:value><tns:description>The logical queue that will be used by the broker to send business data to the connectors</tns:description><tns:updateMethod>component restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted></tns:property><tns:property><tns:name>ResponseQueue</tns:name><tns:type>String</tns:type><tns:value xml:space="preserve">JDBCCONNECTOR/RESPONSEQUEUE</tns:value><tns:description>Connector uses this queue as a default response queue for replying to request.</tns:description><tns:updateMethod>component restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted></tns:property><tns:property><tns:name>jms.NumConcurrentRequests</tns:name><tns:type>Integer</tns:type><tns:value xml:space="preserve">10</tns:value><tns:description>Max number of concurrent service call requests that can be sent to connector.</tns:description><tns:updateMethod>component restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted></tns:property><tns:property><tns:name>jms.FactoryClassName</tns:name><tns:type>String</tns:type><tns:value xml:space="preserve">CxCommon.Messaging.jms.IBMMQSeriesFactory</tns:value><tns:description>The class name to instantiate for a JMS provider.</tns:description><tns:updateMethod>component restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted></tns:property><tns:property><tns:name>jms.MessageBrokerName</tns:name><tns:type>String</tns:type><tns:value xml:space="preserve">crossworlds.queue.manager</tns:value><tns:description>The broker name to use for the JMS provider</tns:description><tns:updateMethod>component restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted></tns:property><tns:property><tns:name>jms.UserName</tns:name><tns:type>String</tns:type><tns:value xml:space="preserve"></tns:value><tns:description>User name for JMS</tns:description><tns:updateMethod>component restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted></tns:property><tns:property><tns:name>jms.Password</tns:name><tns:type>String</tns:type><tns:value xml:space="preserve">ERROR??????</tns:value><tns:description>Password for the JMS user</tns:description><tns:updateMethod>component restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>true</tns:isEncrypted></tns:property><tns:property><tns:name>RestartRetryCount</tns:name><tns:type>Integer</tns:type><tns:value xml:space="preserve">3</tns:value><tns:description>Number of times the agent will try to restart</tns:description><tns:updateMethod>dynamic</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted></tns:property><tns:property><tns:name>RestartRetryInterval</tns:name><tns:type>Integer</tns:type><tns:value xml:space="preserve">1</tns:value><tns:description>The interval at which the agent will try to restart</tns:description><tns:updateMethod>dynamic</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted></tns:property><tns:property><tns:name>XMLNameSpaceFormat</tns:name><tns:type>String</tns:type><tns:value xml:space="preserve">short</tns:value><tns:description>Supports short and long name spaces in the bo's xml doc on the wire.</tns:description><tns:updateMethod>agent restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted></tns:property></cw:std_properties><cw:user_properties><tns:property><tns:name>ApplicationPassword</tns:name><tns:type>String</tns:type><tns:value xml:space="preserve">ibm</tns:value><tns:description></tns:description><tns:updateMethod>agent restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted><tns:isRequired>false</tns:isRequired><tns:IsDeprecated>false</tns:IsDeprecated><tns:IsOverridden>false</tns:IsOverridden><tns:CustomerFlag>true/false</tns:CustomerFlag></tns:property><tns:property><tns:name>ArchiveProcessed</tns:name><tns:type>Boolean</tns:type><tns:value xml:space="preserve">True</tns:value><tns:description></tns:description><tns:updateMethod>agent restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted><tns:isRequired>false</tns:isRequired><tns:IsDeprecated>false</tns:IsDeprecated><tns:IsOverridden>false</tns:IsOverridden><tns:CustomerFlag>true/false</tns:CustomerFlag></tns:property><tns:property><tns:name>ArchiveTableName</tns:name><tns:type>String</tns:type><tns:value xml:space="preserve">xworlds_archive_events</tns:value><tns:description></tns:description><tns:updateMethod>agent restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted><tns:isRequired>false</tns:isRequired><tns:IsDeprecated>false</tns:IsDeprecated><tns:IsOverridden>false</tns:IsOverridden><tns:CustomerFlag>true/false</tns:CustomerFlag></tns:property><tns:property><tns:name>AutoCommit</tns:name><tns:type>Boolean</tns:type><tns:value xml:space="preserve">False</tns:value><tns:description></tns:description><tns:updateMethod>agent restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted><tns:isRequired>false</tns:isRequired><tns:IsDeprecated>false</tns:IsDeprecated><tns:IsOverridden>false</tns:IsOverridden><tns:CustomerFlag>true/false</tns:CustomerFlag></tns:property><tns:property><tns:name>CheckForEventTableInInit</tns:name><tns:type>Boolean</tns:type><tns:value xml:space="preserve">True</tns:value><tns:description></tns:description><tns:updateMethod>agent restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted><tns:isRequired>false</tns:isRequired><tns:IsDeprecated>false</tns:IsDeprecated><tns:IsOverridden>false</tns:IsOverridden><tns:CustomerFlag>true/false</tns:CustomerFlag></tns:property><tns:property><tns:name>ChildUpdatePhyDelete</tns:name><tns:type>Boolean</tns:type><tns:value xml:space="preserve">False</tns:value><tns:description></tns:description><tns:updateMethod>agent restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted><tns:isRequired>false</tns:isRequired><tns:IsDeprecated>false</tns:IsDeprecated><tns:IsOverridden>false</tns:IsOverridden><tns:CustomerFlag>true/false</tns:CustomerFlag></tns:property><tns:property><tns:name>CloseDBConnection</tns:name><tns:type>Boolean</tns:type><tns:value xml:space="preserve">False</tns:value><tns:description></tns:description><tns:updateMethod>agent restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted><tns:isRequired>false</tns:isRequired><tns:IsDeprecated>false</tns:IsDeprecated><tns:IsOverridden>false</tns:IsOverridden><tns:CustomerFlag>true/false</tns:CustomerFlag></tns:property><tns:property><tns:name>ConnectorID</tns:name><tns:type>String</tns:type><tns:value xml:space="preserve">NONE</tns:value><tns:description></tns:description><tns:updateMethod>agent restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted><tns:isRequired>false</tns:isRequired><tns:IsDeprecated>false</tns:IsDeprecated><tns:IsOverridden>false</tns:IsOverridden><tns:CustomerFlag>true/false</tns:CustomerFlag></tns:property><tns:property><tns:name>DatabaseURL</tns:name><tns:type>String</tns:type><tns:value xml:space="preserve">jdbc:db2:DELTA</tns:value><tns:description></tns:description><tns:updateMethod>agent restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted><tns:isRequired>false</tns:isRequired><tns:IsDeprecated>false</tns:IsDeprecated><tns:IsOverridden>false</tns:IsOverridden><tns:CustomerFlag>true/false</tns:CustomerFlag></tns:property><tns:property><tns:name>DateFormat</tns:name><tns:type>String</tns:type><tns:value xml:space="preserve">MM/dd/yyyy HH:mm:ss</tns:value><tns:description></tns:description><tns:updateMethod>agent restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted><tns:isRequired>false</tns:isRequired><tns:IsDeprecated>false</tns:IsDeprecated><tns:IsOverridden>false</tns:IsOverridden><tns:CustomerFlag>true/false</tns:CustomerFlag></tns:property><tns:property><tns:name>DriverConnectionProperties</tns:name><tns:type>String</tns:type><tns:description></tns:description><tns:updateMethod>agent restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted><tns:isRequired>false</tns:isRequired><tns:IsDeprecated>false</tns:IsDeprecated><tns:IsOverridden>false</tns:IsOverridden><tns:CustomerFlag>true/false</tns:CustomerFlag></tns:property><tns:property><tns:name>MaximumDatabaseConnections</tns:name><tns:type>String</tns:type><tns:value xml:space="preserve">5</tns:value><tns:description></tns:description><tns:updateMethod>agent restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted><tns:isRequired>false</tns:isRequired><tns:IsDeprecated>false</tns:IsDeprecated><tns:IsOverridden>false</tns:IsOverridden><tns:CustomerFlag>true/false</tns:CustomerFlag></tns:property><tns:property><tns:name>PingQuery</tns:name><tns:type>String</tns:type><tns:description></tns:description><tns:updateMethod>agent restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted><tns:isRequired>false</tns:isRequired><tns:IsDeprecated>false</tns:IsDeprecated><tns:IsOverridden>false</tns:IsOverridden><tns:CustomerFlag>true/false</tns:CustomerFlag></tns:property><tns:property><tns:name>PollQuantity</tns:name><tns:type>String</tns:type><tns:value xml:space="preserve">1</tns:value><tns:description>The number of items to poll from application</tns:description><tns:updateMethod>agent restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted><tns:isRequired>false</tns:isRequired><tns:IsDeprecated>false</tns:IsDeprecated><tns:IsOverridden>false</tns:IsOverridden><tns:CustomerFlag>true/false</tns:CustomerFlag></tns:property><tns:property><tns:name>PreserveUIDSeq</tns:name><tns:type>Boolean</tns:type><tns:value xml:space="preserve">True</tns:value><tns:description></tns:description><tns:updateMethod>agent restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted><tns:isRequired>false</tns:isRequired><tns:IsDeprecated>false</tns:IsDeprecated><tns:IsOverridden>false</tns:IsOverridden><tns:CustomerFlag>true/false</tns:CustomerFlag></tns:property><tns:property><tns:name>QueryTimeOut</tns:name><tns:type>String</tns:type><tns:value xml:space="preserve">False</tns:value><tns:description></tns:description><tns:updateMethod>agent restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted><tns:isRequired>false</tns:isRequired><tns:IsDeprecated>false</tns:IsDeprecated><tns:IsOverridden>false</tns:IsOverridden><tns:CustomerFlag>true/false</tns:CustomerFlag></tns:property><tns:property><tns:name>RDBMS.initsession</tns:name><tns:type>String</tns:type><tns:description></tns:description><tns:updateMethod>agent restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted><tns:isRequired>false</tns:isRequired><tns:IsDeprecated>false</tns:IsDeprecated><tns:IsOverridden>false</tns:IsOverridden><tns:CustomerFlag>true/false</tns:CustomerFlag></tns:property><tns:property><tns:name>RDBMSVendor</tns:name><tns:type>String</tns:type><tns:value xml:space="preserve">Oracle</tns:value><tns:description></tns:description><tns:updateMethod>agent restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted><tns:isRequired>false</tns:isRequired><tns:IsDeprecated>false</tns:IsDeprecated><tns:IsOverridden>false</tns:IsOverridden><tns:CustomerFlag>true/false</tns:CustomerFlag></tns:property><tns:property><tns:name>RetryCountAndInterval</tns:name><tns:type>String</tns:type><tns:value xml:space="preserve">3,20</tns:value><tns:description></tns:description><tns:updateMethod>agent restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted><tns:isRequired>false</tns:isRequired><tns:IsDeprecated>false</tns:IsDeprecated><tns:IsOverridden>false</tns:IsOverridden><tns:CustomerFlag>true/false</tns:CustomerFlag></tns:property><tns:property><tns:name>ReturnDummyBOForSP</tns:name><tns:type>String</tns:type><tns:value xml:space="preserve">False</tns:value><tns:description></tns:description><tns:updateMethod>agent restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted><tns:isRequired>false</tns:isRequired><tns:IsDeprecated>false</tns:IsDeprecated><tns:IsOverridden>false</tns:IsOverridden><tns:CustomerFlag>true/false</tns:CustomerFlag></tns:property><tns:property><tns:name>SchemaName</tns:name><tns:type>String</tns:type><tns:description></tns:description><tns:updateMethod>agent restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted><tns:isRequired>false</tns:isRequired><tns:IsDeprecated>false</tns:IsDeprecated><tns:IsOverridden>false</tns:IsOverridden><tns:CustomerFlag>true/false</tns:CustomerFlag></tns:property><tns:property><tns:name>UniqueIDTableName</tns:name><tns:type>String</tns:type><tns:value xml:space="preserve">xworlds_uid</tns:value><tns:description></tns:description><tns:updateMethod>agent restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted><tns:isRequired>false</tns:isRequired><tns:IsDeprecated>false</tns:IsDeprecated><tns:IsOverridden>false</tns:IsOverridden><tns:CustomerFlag>true/false</tns:CustomerFlag></tns:property><tns:property><tns:name>UseDefaults</tns:name><tns:type>String</tns:type><tns:value xml:space="preserve">False</tns:value><tns:description></tns:description><tns:updateMethod>agent restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted><tns:isRequired>false</tns:isRequired><tns:IsDeprecated>false</tns:IsDeprecated><tns:IsOverridden>false</tns:IsOverridden><tns:CustomerFlag>true/false</tns:CustomerFlag></tns:property><tns:property><tns:name>UseDefaultsForCreatingChildBOs</tns:name><tns:type>Boolean</tns:type><tns:value xml:space="preserve">False</tns:value><tns:description></tns:description><tns:updateMethod>agent restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted><tns:isRequired>false</tns:isRequired><tns:IsDeprecated>false</tns:IsDeprecated><tns:IsOverridden>false</tns:IsOverridden><tns:CustomerFlag>true/false</tns:CustomerFlag></tns:property><tns:property><tns:name>UseDefaultsWhenPolling</tns:name><tns:type>String</tns:type><tns:value xml:space="preserve">True</tns:value><tns:description>Allows to control setting defaults on BO, on a poll.</tns:description><tns:updateMethod>agent restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted><tns:isRequired>false</tns:isRequired><tns:IsDeprecated>false</tns:IsDeprecated><tns:IsOverridden>false</tns:IsOverridden><tns:CustomerFlag>true/false</tns:CustomerFlag></tns:property><tns:property><tns:name>UseDefaultsForRetrieve</tns:name><tns:type>Boolean</tns:type><tns:value xml:space="preserve">False</tns:value><tns:description></tns:description><tns:updateMethod>agent restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted><tns:isRequired>false</tns:isRequired><tns:IsDeprecated>true</tns:IsDeprecated><tns:IsOverridden>false</tns:IsOverridden><tns:CustomerFlag>true/false</tns:CustomerFlag></tns:property><tns:property><tns:name>DriverSupportForLong</tns:name><tns:type>Boolean</tns:type><tns:value xml:space="preserve">True</tns:value><tns:description></tns:description><tns:updateMethod>agent restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted><tns:isRequired>false</tns:isRequired><tns:IsDeprecated>false</tns:IsDeprecated><tns:IsOverridden>false</tns:IsOverridden><tns:CustomerFlag>true/false</tns:CustomerFlag></tns:property><tns:property><tns:name>EventKeyDel</tns:name><tns:type>String</tns:type><tns:value xml:space="preserve">;</tns:value><tns:description></tns:description><tns:updateMethod>agent restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted><tns:isRequired>false</tns:isRequired><tns:IsDeprecated>false</tns:IsDeprecated><tns:IsOverridden>false</tns:IsOverridden><tns:CustomerFlag>true/false</tns:CustomerFlag></tns:property><tns:property><tns:name>EventOrderBy</tns:name><tns:type>String</tns:type><tns:description></tns:description><tns:updateMethod>agent restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted><tns:isRequired>false</tns:isRequired><tns:IsDeprecated>false</tns:IsDeprecated><tns:IsOverridden>false</tns:IsOverridden><tns:CustomerFlag>true/false</tns:CustomerFlag></tns:property><tns:property><tns:name>EventQueryType</tns:name><tns:type>String</tns:type><tns:value xml:space="preserve">Fixed</tns:value><tns:description></tns:description><tns:updateMethod>agent restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted><tns:isRequired>false</tns:isRequired><tns:IsDeprecated>false</tns:IsDeprecated><tns:IsOverridden>false</tns:IsOverridden><tns:CustomerFlag>true/false</tns:CustomerFlag></tns:property><tns:property><tns:name>EventTableName</tns:name><tns:type>String</tns:type><tns:value xml:space="preserve">xworlds_events</tns:value><tns:description></tns:description><tns:updateMethod>agent restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted><tns:isRequired>false</tns:isRequired><tns:IsDeprecated>false</tns:IsDeprecated><tns:IsOverridden>false</tns:IsOverridden><tns:CustomerFlag>true/false</tns:CustomerFlag></tns:property><tns:property><tns:name>JDBCDriverClass</tns:name><tns:type>String</tns:type><tns:value xml:space="preserve">COM.ibm.db2.jdbc.app.DB2Driver</tns:value><tns:description></tns:description><tns:updateMethod>agent restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted><tns:isRequired>false</tns:isRequired><tns:IsDeprecated>false</tns:IsDeprecated><tns:IsOverridden>false</tns:IsOverridden><tns:CustomerFlag>true/false</tns:CustomerFlag></tns:property><tns:property><tns:name>ApplicationUserName</tns:name><tns:type>String</tns:type><tns:value xml:space="preserve">kishore</tns:value><tns:description></tns:description><tns:updateMethod>agent restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted><tns:isRequired>false</tns:isRequired><tns:IsDeprecated>false</tns:IsDeprecated><tns:IsOverridden>false</tns:IsOverridden><tns:CustomerFlag>true/false</tns:CustomerFlag></tns:property><tns:property><tns:name>IBM-CW-TEMPLATE-NAME-INTERNAL</tns:name><tns:type>String</tns:type><tns:value xml:space="preserve">JDBCConnectorTemplate</tns:value><tns:description></tns:description><tns:updateMethod>connector restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted><tns:isRequired>false</tns:isRequired><tns:IsDeprecated>false</tns:IsDeprecated><tns:IsOverridden>false</tns:IsOverridden><tns:CustomerFlag>true/false</tns:CustomerFlag></tns:property></cw:user_properties></cw:properties><cw:supportedBusinessObjects><cw:boDetails><cw:name>DELTACUSTOMER</cw:name><cw:msgId>DELTA</cw:msgId></cw:boDetails></cw:supportedBusinessObjects><cw:LOGGING><cw:LOG_FILE>C:\Delta\JDBCConnector_log</cw:LOG_FILE><cw:MIRROR_LOG_TO_STDOUT>FALSE</cw:MIRROR_LOG_TO_STDOUT><cw:MAX_LOG_FILE_SIZE>UNLIMITED</cw:MAX_LOG_FILE_SIZE><cw:NUMBER_OF_ARCHIVE_LOGS>0</cw:NUMBER_OF_ARCHIVE_LOGS></cw:LOGGING><cw:TRACING><cw:TRACE_FILE>C:\Delta\JDBCConnector_Trace</cw:TRACE_FILE><cw:MIRROR_TRACE_TO_STDOUT>FALSE</cw:MIRROR_TRACE_TO_STDOUT><cw:MAX_TRACE_FILE_SIZE>UNLIMITED</cw:MAX_TRACE_FILE_SIZE><cw:NUMBER_OF_ARCHIVE_TRACES>0</cw:NUMBER_OF_ARCHIVE_TRACES></cw:TRACING><cw:MESSAGING/><cw:ConfigurationState state="active" cw:isConfigured="true"/></cw:ConnectorConfig></cw:ContainerConfig>
[/img][/url] |
|
| Back to top |
|
|
| Ratan |
| Posted: Mon Aug 07, 2006 2:24 pm Post subject: |
|
|
Grand Master
Joined: 18 Jul 2002
Posts: 1245
|
I see
JDBCCONNECTOR/SYNCHRONOUSREQUESTQUEUE
and other queues in your CFG file.
What is it that you are actually looking for?
_________________
-Ratan |
|
| Back to top |
|
|
| mqmaniac |
| Posted: Mon Aug 07, 2006 2:48 pm Post subject: |
|
|
Master
Joined: 27 Dec 2005
Posts: 201
|
Thanks for the Reply..
I am confused on where to Enter the Queue Mnager Name? |
|
| Back to top |
|
|
| vk |
| Posted: Mon Aug 07, 2006 7:25 pm Post subject: |
|
|
Partisan
Joined: 20 Sep 2005
Posts: 302
Location: Houston
|
| Quote: |
| <tns:property><tns:name>jms.MessageBrokerName</tns:name><tns:type>String</tns:type><tns:value xml:space="preserve">crossworlds.queue.manager</tns:value><tns:description>The broker name to use for the JMS provider</tns:description><tns:updateMethod>component restart</tns:updateMethod><tns:location><tns:reposController>false</tns:reposController><tns:reposAgent>true</tns:reposAgent><tns:localConfig>true</tns:localConfig></tns:location><tns:isEncrypted>false</tns:isEncrypted></tns:property> |
This is the section of the configuration file where you specify the queue manager name. The default queue manager name is crossworlds.queue.manager. You can change this to any value. You can also see all the 8 queue name properties in the configuration file.
Do you have WebSphere Business Integration Toolkit installed? You can open the CFG file in Connector Configurator which is part of the Toolset. Then it will be more readable.
Regards,
VK. |
|
| Back to top |
|
|
| mqmaniac |
| Posted: Thu Aug 10, 2006 3:10 pm Post subject: |
|
|
Master
Joined: 27 Dec 2005
Posts: 201
|
| Should I create this Queue manager{cr crossworlds.queue.manager} or Will it be done by the Adapter Itself? |
|
| Back to top |
|
|
| vennela |
| Posted: Fri Aug 11, 2006 7:38 am Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
| Adapters themselves will not need any QMGR. The brokers (either ICS or Message Broker) will use a QMGR. |
|
| Back to top |
|
|
|
|
