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 Index » WebSphere Interchange Server + Adapters » WBIA JDBC Adapter - call to method poll() failed

Post new topic  Reply to topic
 WBIA JDBC Adapter - call to method poll() failed « View previous topic :: View next topic » 
Author Message
wardster
PostPosted: Thu May 18, 2006 12:28 am    Post subject: WBIA JDBC Adapter - call to method poll() failed Reply with quote

Newbie

Joined: 17 May 2006
Posts: 5
Hi
we are using the JDBC adapter to try and pick up a CREATE event from the event table, construct the relevant BO and submit it to a queue.

We are getting the following error

[Time: 2006/05/18 08:51:04.884] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: appPolling (#1308167738)] [Type: Error] [MsgID: 17109] [Mesg: Exception caught in the method BusObjJavaInterface::poll. Reason: java.lang.StringIndexOutOfBoundsException: String index out of range: -1] [Time: 2006/05/18 08:51:04.884] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: appPolling (#1308167738)] [Type: Error] [MsgID: 17050] [Mesg: The call to method poll() in the application connector failed.]

The event is picked up from the table and its status updated to 3.

The Trace seems to imply that everything is OK - with the last thing in the trace being Mesg: :getTypeForDeliveryTransport = JMS, before the trace shows a 10 second wait and the next bit of polling

Code:
[Time: 2006/05/18 08:51:04.853] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: appPolling (#1308167738)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90018] [Mesg: Entering pollForEvents] ]
[Time: 2006/05/18 08:51:04.853] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: appPolling (#1308167738)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90018] [Mesg: Entering fetchConnection] ]
[Time: 2006/05/18 08:51:04.853] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: appPolling (#1308167738)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 36011] [Mesg: Auto Commit is true] ]
[Time: 2006/05/18 08:51:04.853] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: appPolling (#1308167738)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 36004] [Mesg: Obtained connection.] ]
[Time: 2006/05/18 08:51:04.853] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: appPolling (#1308167738)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 39015] [Mesg: Number of DB Connections in Use 1] ]
[Time: 2006/05/18 08:51:04.853] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: appPolling (#1308167738)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90019] [Mesg: Exiting fetchConnection] ]
[Time: 2006/05/18 08:51:04.853] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: appPolling (#1308167738)] [Type: Trace] [Mesg: :select event_id, connector_id, object_key, object_name, object_verb, event_priority, event_time, event_status, event_comment from dbo.xworlds_events where event_status = ? and connector_id = ?  order by event_id]
[Time: 2006/05/18 08:51:04.868] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: appPolling (#1308167738)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90018] [Mesg: Entering retrieveEvents] ]
[Time: 2006/05/18 08:51:04.868] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: appPolling (#1308167738)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 32016] [Mesg: Polling for eventID,name of BO,verb:"60","{2}","{3}"] ]
[Time: 2006/05/18 08:51:04.884] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: appPolling (#1308167738)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 32016] [Mesg: Polling for eventID,name of BO,verb:"100053","JDBCjobSummary","Create"] ]
[Time: 2006/05/18 08:51:04.884] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: appPolling (#1308167738)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90019] [Mesg: Exiting retrieveEvents] ]
[Time: 2006/05/18 08:51:04.884] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: appPolling (#1308167738)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90018] [Mesg: Entering updateEventStatus] ]
[Time: 2006/05/18 08:51:04.884] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: appPolling (#1308167738)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 37021] [Mesg: Database Commited Successfully] ]
[Time: 2006/05/18 08:51:04.884] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: appPolling (#1308167738)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 37022] [Mesg: DBManager Operation success] ]
[Time: 2006/05/18 08:51:04.884] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: appPolling (#1308167738)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90019] [Mesg: Exiting updateEventStatus] ]
[Time: 2006/05/18 08:51:04.884] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: appPolling (#1308167738)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90018] [Mesg: Entering releaseConnection] ]
[Time: 2006/05/18 08:51:04.884] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: appPolling (#1308167738)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90019] [Mesg: Exiting releaseConnection] ]
[Time: 2006/05/18 08:51:04.884] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: appPolling (#1308167738)] [Type: Trace] [Mesg: :checkStatus]
[Time: 2006/05/18 08:51:04.884] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: appPolling (#1308167738)] [Type: Trace] [Mesg: :getTypeForDeliveryTransport = JMS]

[Time: 2006/05/18 08:51:14.884] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: appPolling (#1308167738)] [Type: Trace]


Does anyone have any ideas? We haven't had this working yet so aren't clear what SHOULD happen next! Presumably we should be seeing a query to select the BO out of the database next? Or is the adapter trying to check the JMS connection before it does this and failing there?

Hope someone can shed some light!

Thanks

Cfg file included below for luck (its a bit big!)

[code:1:d2d1db21c6]
<?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>delglb01.cfg</cw:name>
<cw:installID>mL/Qkr/py/E=</cw:installID>
</cw:ConfigurationInfo>
- <cw:header>
<cw:name>delglb01</cw:name>
<cw:version>4.3.0</cw:version>
</cw:header>
- <cw:properties>
- <cw:std_properties>
- <tns:property>
<tns:name>AdapterHelpName</tns:name>
<tns:type>String</tns:type>
<tns:subtype />
<tns:value xml:space="preserve" />
<tns:description>Used to find a connector-specific property Extended Help file</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:subtype>QueueName</tns:subtype>
<tns:value xml:space="preserve">TESTCONNECTOR/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:subtype>QueueName</tns:subtype>
<tns:value xml:space="preserve">TESTCONNECTOR/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>AgentTraceLevel</tns:name>
<tns:type>Integer</tns:type>
<tns:subtype />
<tns:value xml:space="preserve">5</tns:value>
<tns:description>Trace level for 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>ApplicationName</tns:name>
<tns:type>String</tns:type>
<tns:subtype />
<tns:value xml:space="preserve">TestConnector</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>BiDi.Transformation</tns:name>
<tns:type>Boolean</tns:type>
<tns:subtype />
<tns:value xml:space="preserve">false</tns:value>
<tns:description>Enable bidi transformation</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:subtype />
<tns:value xml:space="preserve">WAS</tns:value>
<tns:description>Broker type</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>CharacterEncoding</tns:name>
<tns:type>String</tns:type>
<tns:subtype />
<tns:value xml:space="preserve">ascii7</tns:value>
<tns:description>The connector agent will use the character 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>CommonEventInfrastructure</tns:name>
<tns:type>Boolean</tns:type>
<tns:subtype />
<tns:value xml:space="preserve">false</tns:value>
<tns:description>Specify if Common Event Infrastructure (CEI) should be invoked at runtime</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:subtype />
<tns:value xml:space="preserve" />
<tns:description>Indicates if 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>DeliveryQueue</tns:name>
<tns:type>String</tns:type>
<tns:subtype>QueueName</tns:subtype>
<tns:value xml:space="preserve">TESTCONNECTOR/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>DeliveryTransport</tns:name>
<tns:type>String</tns:type>
<tns:subtype />
<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>DuplicateEventElimination</tns:name>
<tns:type>Boolean</tns:type>
<tns:subtype />
<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>FaultQueue</tns:name>
<tns:type>String</tns:type>
<tns:subtype>QueueName</tns:subtype>
<tns:value xml:space="preserve">TESTCONNECTOR/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>jms.FactoryClassName</tns:name>
<tns:type>String</tns:type>
<tns:subtype>AbsoluteClassName</tns:subtype>
<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:subtype />
<tns:value xml:space="preserve">crossworlds.queue.manager</tns:value>
<tns:description>The broker name to use for the JMS provider. format is QueueMgrName:[channel:HostName:PortNo]</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:subtype />
<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.Password</tns:name>
<tns:type>String</tns:type>
<tns:subtype />
<tns:value xml:space="preserve">x9Ns8AcppAc=1</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>jms.UserName</tns:name>
<tns:type>String</tns:type>
<tns:subtype />
<tns:value xml:space="preserve">MQUser</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>Locale</tns:name>
<tns:type>String</tns:type>
<tns:subtype />
<tns:value xml:space="preserve">en_GB</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:subtype>FileName</tns:subtype>
<tns:value xml:space="preserve">JDBCConnector.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:subtype />
<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>PollFrequency</tns:name>
<tns:type>Integer</tns:type>
<tns:subtype />
<tns:value xml:space="preserve">10000</tns:value>
<tns:description>Interval at which the agent will poll</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:subtype />
<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>RepositoryDirectory</tns:name>
<tns:type>String</tns:type>
<tns:subtype>Directory</tns:subtype>
<tns:value xml:space="preserve">C:\IBM\WebSphereAdapters\repository</tns:value>
<tns:description>Repository location</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>RequestQueue</tns:name>
<tns:type>String</tns:type>
<tns:subtype>QueueName</tns:subtype>
<tns:value xml:space="preserve">TESTCONNECTOR/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:subtype>QueueName</tns:subtype>
<tns:value xml:space="preserve">TESTCONNECTOR/RESPONSEQUEUE</tns:value>
<tns:description>Connector uses this queue as a default response queue for replying to requests</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>RestartRetryCount</tns:name>
<tns:type>Integer</tns:type>
<tns:subtype />
<tns:value xml:space="preserve">3</tns:value>
<tns:description>Number of times the agent will try to restart</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>RestartRetryInterval</tns:name>
<tns:type>Integer</tns:type>
<tns:subtype />
<tns:value xml:space="preserve">1</tns:value>
<tns:description>The interval at which the agent will try to restart</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:subtype />
<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>SynchronousRequestQueue</tns:name>
<tns:type>String</tns:type>
<tns:subtype>QueueName</tns:subtype>
<tns:value xml:space="preserve">TESTCONNECTOR/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>SynchronousRequestTimeout</tns:name>
<tns:type>Integer</tns:type>
<tns:subtype />
<tns:value xml:space="preserve">0</tns:value>
<tns:description>Time in milliseconds 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:subtype>QueueName</tns:subtype>
<tns:value xml:space="preserve">TESTCONNECTOR/SYNCHRONOUSRESPONSEQUEUE</tns:value>
<tns:description>Logical queue that delivers the response message from a connector to the jms provider in reply 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>TivoliMonitorTransactionPerformance</tns:name>
<tns:type>Boolean</tns:type>
<tns:subtype />
<tns:value xml:space="preserve">false</tns:value>
<tns:description>Specify if Tivoli Monitoring for Transaction Performance (ITMTP) should be invoked at runtime</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:subtype />
<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>WsifSynchronousRequestTimeout</tns:name>
<tns:type>Integer</tns:type>
<tns:subtype />
<tns:value xml:space="preserve">0</tns:value>
<tns:description>Time in minutes that WAS Hub 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>XMLNameSpaceFormat</tns:name>
<tns:type>String</tns:type>
<tns:subtype />
<tns:value xml:space="preserve">long</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>IBM-CW-TEMPLATE-NAME-INTERNAL</tns:name>
<tns:type>String</tns:type>
<tns:subtype />
<tns:value xml:space="preserve">None</tns:value>
<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:OriginalAppPropName />
</tns:property>
- <tns:property>
<tns:name>ApplicationPassword</tns:name>
<tns:type>String</tns:type>
<tns:subtype />
<tns:value xml:space="preserve">sa</tns:value>
<tns:description>database password?</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:OriginalAppPropName>IBM-CW-APP-PROPERTY-NEW</tns:OriginalAppPropName>
</tns:property>
- <tns:property>
<tns:name>ApplicationUserName</tns:name>
<tns:type>String</tns:type>
<tns:subtype />
<tns:value xml:space="preserve">sa</tns:value>
<tns:description>database UID</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:OriginalAppPropName>IBM-CW-APP-PROPERTY-NEW</tns:OriginalAppPropName>
</tns:property>
- <tns:property>
<tns:name>ArchiveProcessed</tns:name>
<tns:type>Boolean</tns:type>
<tns:subtype />
<tns:value xml:space="preserve">true</tns:value>
<tns:description>archive processed msgs</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:OriginalAppPropName>IBM-CW-APP-PROPERTY-NEW</tns:OriginalAppPropName>
</tns:property>
- <tns:property>
<tns:name>ArchiveTableName</tns:name>
<tns:type>String</tns:type>
<tns:subtype />
<tns:value xml:space="preserve">xworlds_archive_events</tns:value>
<tns:description>name of archive queue table</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:OriginalAppPropName>IBM-CW-APP-PROPERTY-NEW</tns:OriginalAppPropName>
</tns:property>
- <tns:property>
<tns:name>AutoCommit</tns:name>
<tns:type>Boolean</tns:type>
<tns:subtype />
<tns:value xml:space="preserve">true</tns:value>
<tns:description>Transactions automatically commited?</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:OriginalAppPropName>IBM-CW-APP-PROPERTY-NEW</tns:OriginalAppPropName>
</tns:property>
- <tns:property>
<tns:name>CheckforEventTableInInit</tns:name>
<tns:type>Boolean</tns:type>
<tns:subtype />
<tns:value xml:space="preserve">true</tns:value>
<tns:description>check event etc. tables exist at connector init</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:OriginalAppPropName>IBM-CW-APP-PROPERTY-NEW</tns:OriginalAppPropName>
</tns:property>
- <tns:property>
<tns:name>ChildUpdatePhyDelete</tns:name>
<tns:type>Boolean</tns:type>
<tns:subtype />
<tns:value xml:space="preserve">false</tns:value>
<tns:description>physically delete child table data for BO</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:OriginalAppPropName>IBM-CW-APP-PROPERTY-NEW</tns:OriginalAppPropName>
</tns:property>
- <tns:property>
<tns:name>CloseDBConnection</tns:name>
<tns:type>Boolean</tns:type>
<tns:subtype />
<tns:value xml:space="preserve">true</tns:value>
<tns:description>leave DB connection open between calls</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:OriginalAppPropName>IBM-CW-APP-PROPERTY-NEW</tns:OriginalAppPropName>
</tns:property>
- <tns:property>
<tns:name>ConnectorID</tns:name>
<tns:type>String</tns:type>
<tns:subtype />
<tns:value xml:space="preserve">JDBCConnector</tns:value>
<tns:description>Unique ID for the connector</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:OriginalAppPropName>IBM-CW-APP-PROPERTY-NEW</tns:OriginalAppPropName>
</tns:property>
- <tns:property>
<tns:name>DatabaseURL</tns:name>
<tns:type>String</tns:type>
<tns:subtype />
<tns:value xml:space="preserve">jdbc:microsoft:sqlserver://delglb01:1433;databaseName=GLB;USER ID=sa;PWD=sa</tns:value>
<tns:description>Name of the DB Server</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:OriginalAppPropName>IBM-CW-APP-PROPERTY-NEW</tns:OriginalAppPropName>
</tns:property>
- <tns:property>
<tns:name>DateFormat</tns:name>
<tns:type>String</tns:type>
<tns:subtype />
<tns:value xml:space="preserve">yyyy-mm-dd hh:mm:ss.SSS</tns:value>
<tns:description>date fmt the connector expects to receive and return</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:OriginalAppPropName>IBM-CW-APP-PROPERTY-NEW</tns:OriginalAppPropName>
</tns:property>
- <tns:property>
<tns:name>DriverConnectionProperties</tns:name>
<tns:type>String</tns:type>
<tns:subtype />
<tns:value xml:space="preserve" />
<tns:description>Additional JDBC driver connection properties</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:OriginalAppPropName>IBM-CW-APP-PROPERTY-NEW</tns:OriginalAppPropName>
</tns:property>
- <tns:property>
<tns:name>DriverSupportForLong</tns:name>
<tns:type>Boolean</tns:type>
<tns:subtype />
<tns:value xml:space="preserve">true</tns:value>
<tns:description>use long integers by default</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:OriginalAppPropName>IBM-CW-APP-PROPERTY-NEW</tns:OriginalAppPropName>
</tns:property>
- <tns:property>
<tns:name>EventKeyDel</tns:name>
<tns:type>String</tns:type>
<tns:subtype />
<tns:value xml:space="preserve">semicolon (;)</tns:value>
<tns:description>delimiter character(s) for object key column of event table</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:OriginalAppPropName>IBM-CW-APP-PROPERTY-NEW</tns:OriginalAppPropName>
</tns:property>
- <tns:property>
<tns:name>EventOrderBy</tns:name>
<tns:type>String</tns:type>
<tns:subtype />
<tns:value xml:space="preserve">event_id</tns:value>
<tns:description>column from event table to order by</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:OriginalAppPropName>IBM-CW-APP-PROPERTY-NEW</tns:OriginalAppPropName>
</tns:property>
- <tns:property>
<tns:name>EventQueryType</tns:name>
<tns:type>String</tns:type>
<tns:subtype />
<tns:value xml:space="preserve">Fixed</tns:value>
<tns:description>Fixed=Use default event table query. Dynamic=auto-determine cols to select If query table is customised (slower)</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:OriginalAppPropName>IBM-CW-APP-PROPERTY-NEW</tns:OriginalAppPropName>
</tns:property>
- <tns:property>
<tns:name>EventTableName</tns:name>
<tns:type>String</tns:type>
<tns:subtype />
<tns:value xml:space="preserve">xworlds_events</tns:value>
<tns:description>name of DB event table</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:OriginalAppPropName>IBM-CW-APP-PROPERTY-NEW</tns:OriginalAppPropName>
</tns:property>
- <tns:property>
<tns:name>JDBCDriverClass</tns:name>
<tns:type>String</tns:type>
<tns:subtype />
<tns:value xml:space="preserve">com.microsoft.jdbc.sqlserver.SQLServerDriver</tns:value>
<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:OriginalAppPropName>IBM-CW-APP-PROPERTY-NEW</tns:OriginalAppPropName>
</tns:property>
- <tns:property>
<tns:name>MaximumDatabaseConnections</tns:name>
<tns:type>Integer</tns:type>
<tns:subtype />
<tns:value xml:space="preserve">5</tns:value>
<tns:description>No of simultaneous DB Connections allowed</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:OriginalAppPropName>IBM-CW-APP-PROPERTY-NEW</tns:OriginalAppPropName>
</tns:property>
- <tns:property>
<tns:name>PingQuery</tns:name>
<tns:type>String</tns:type>
<tns:subtype />
<tns:value xml:space="preserve">xworlds_events</tns:value>
<tns:description>sample query to test connection to DB</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:OriginalAppPropName>IBM-CW-APP-PROPERTY-NEW</tns:OriginalAppPropName>
</tns:property>
- <tns:property>
<tns:name>PollQuantity</tns:name>
<tns:type>String</tns:type>
<tns:subtype />
<tns:value xml:space="preserve">5</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:OriginalAppPropName>IBM-CW-APP-PROPERTY-NEW</tns:OriginalAppPropName>
</tns:property>
- <tns:property>
<tns:name>PreparedStatementCacheSize</tns:name>
<tns:type>Integer</tns:type>
<tns:subtype />
<tns:value xml:space="preserve">40</tns:value>
<tns:description>Max No of prepared statements to be cached for each connection in JDBC connection pool</tns:description>
<tns:updateMethod>agent restart</tns:updateMethod>
- <tns:location>
<tns:reposController>false</tns:reposController>
<tns:reposAgent>true</tns:reposAgent>
<tns:localConfig>true</tns:localConf
Back to top
View user's profile Send private message
Kram
PostPosted: Thu May 18, 2006 6:00 am    Post subject: Reply with quote

Voyager

Joined: 02 Mar 2006
Posts: 87
Check if the BO structure is same as the table schema... looks like something is out of order ... or check if you have an infninite looping situation... where the parent BO is a child of the child BO
_________________
Regards,
Ram
Back to top
View user's profile Send private message
wardster
PostPosted: Thu May 18, 2006 6:11 am    Post subject: Reply with quote

Newbie

Joined: 17 May 2006
Posts: 5
Thanks very much for your help Ram

We recreated with a table with two columns, IntegerKey and IntegerValue. Both int size 4. And the business object ended up as below. So no child parent relationship (unless I misyunderstand you) and the schema matches the BO. Makes me wonder if there is something more fundemental we are missing!?

- <xsd:element name="WBIATestIntegerTable">
- <xsd:annotation>
- <xsd:appinfo>
- <bx:boDefinition version="3.0.0">
<bx:appSpecificInfo>TN=IntegerTable;SCN=</bx:appSpecificInfo>
</bx:boDefinition>
</xsd:appinfo>
</xsd:annotation>
- <xsd:complexType>
- <xsd:sequence>
- <xsd:element name="IntegerKey" type="xsd:int" minOccurs="0">
- <xsd:annotation>
- <xsd:appinfo>
- <bx:boAttribute>
<bx:appSpecificInfo>CN=IntegerKey</bx:appSpecificInfo>
<bx:attributeInfo isForeignKey="false" isKey="true" />
</bx:boAttribute>
</xsd:appinfo>
</xsd:annotation>
</xsd:element>
- <xsd:element name="IntegerValue" type="xsd:int" minOccurs="1">
- <xsd:annotation>
- <xsd:appinfo>
- <bx:boAttribute>
<bx:appSpecificInfo>CN=IntegerValue</bx:appSpecificInfo>
<bx:attributeInfo isForeignKey="false" isKey="false" />
</bx:boAttribute>
</xsd:appinfo>
</xsd:annotation>
</xsd:element>
<xsd:element name="ObjectEventId" type="xsd:string" minOccurs="0" />
</xsd:sequence>
Back to top
View user's profile Send private message
wbi_prof
PostPosted: Tue Oct 17, 2006 9:39 am    Post subject: The call to method poll() connector failed Reply with quote

Newbie

Joined: 17 Oct 2006
Posts: 3
I am getting the same error.

[Time: 2006/10/17 12:10:29.737] [System: ConnectorAgent] [SS: JDBC1Connector] [T
hread: appPolling (#667705515)] [Type: Error] [MsgID: 17109] [Mesg: Exception ca
ught in the method BusObjJavaInterface::poll. Reason: java.lang.StringIndexOutOf
BoundsException: String index out of range: -1]
[Time: 2006/10/17 12:10:29.737] [System: ConnectorAgent] [SS: JDBC1Connector] [T
hread: appPolling (#667705515)] [Type: Error] [MsgID: 17050] [Mesg: The call to
method poll() in the application connector failed.]

Were you able to resolve this ? Please let me know.
Back to top
View user's profile Send private message
RocknRambo
PostPosted: Tue Oct 17, 2006 11:19 am    Post subject: Reply with quote

Partisan

Joined: 24 Sep 2003
Posts: 355
I would check the Event Tbl, Is there a trigger to populate the event tbl or you manually entering values for the connect polling ?

check the event tbl - its contents and schema defn


-RR
Back to top
View user's profile Send private message
wbi_prof
PostPosted: Tue Oct 17, 2006 12:31 pm    Post subject: The call to method poll() failed. Reply with quote

Newbie

Joined: 17 Oct 2006
Posts: 3
There is a trigger to populate the event table. The connector picks up the event and then updates the status to 3 and fails.

please see the log:

[Time: 2006/10/17 16:05:28.593] [System: ConnectorAgent] [SS: JDBCConnector] [Th
read: appPolling (#1271318159)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 9001
8] [Mesg: Entering pollForEvents] ]
[Time: 2006/10/17 16:05:28.593] [System: ConnectorAgent] [SS: JDBCConnector] [Th
read: appPolling (#1271318159)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 9001
8] [Mesg: Entering retrieveEvents] ]
[Time: 2006/10/17 16:05:28.687] [System: ConnectorAgent] [SS: JDBCConnector] [Th
read: appPolling (#1271318159)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 3201
6] [Mesg: Polling for eventID,name of BO,verb:"35680","InstitutionalAsset","Create"] ]
[Time: 2006/10/17 16:05:28.687] [System: ConnectorAgent] [SS: JDBCConnector] [Th
read: appPolling (#1271318159)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 9001
9] [Mesg: Exiting retrieveEvents] ]
[Time: 2006/10/17 16:05:28.687] [System: ConnectorAgent] [SS: JDBCConnector] [Th
read: appPolling (#1271318159)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 9001
8] [Mesg: Entering updateEventStatus] ]
[Time: 2006/10/17 16:05:28.874] [System: ConnectorAgent] [SS: JDBCConnector] [Th
read: appPolling (#1271318159)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 3702
1] [Mesg: Database Commited Successfully] ]
[Time: 2006/10/17 16:05:28.874] [System: ConnectorAgent] [SS: JDBCConnector] [Th
read: appPolling (#1271318159)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 3702
2] [Mesg: DBManager Operation success] ]
[Time: 2006/10/17 16:05:28.874] [System: ConnectorAgent] [SS: JDBCConnector] [Th
read: appPolling (#1271318159)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 9001
9] [Mesg: Exiting updateEventStatus] ]
[Time: 2006/10/17 16:05:28.874] [System: ConnectorAgent] [SS: JDBCConnector] [Th
read: appPolling (#1271318159)] [Type: Error] [MsgID: 17109] [Mesg: Exception ca
ught in the method BusObjJavaInterface::poll. Reason: java.lang.StringIndexOutOf
BoundsException: String index out of range: -1]
[Time: 2006/10/17 16:05:28.874] [System: ConnectorAgent] [SS: JDBCConnector] [Th
read: appPolling (#1271318159)] [Type: Trace] [Mesg: :checkStatus]
[Time: 2006/10/17 16:05:28.874] [System: ConnectorAgent] [SS: JDBCConnector] [Th
read: appPolling (#1271318159)] [Type: Error] [MsgID: 17050] [Mesg: The call to
method poll() in the application connector failed.]
[Time: 2006/10/17 16:05:28.874] [System: ConnectorAgent] [SS: JDBCConnector] [Th
read: appPolling (#1271318159)] [Type: Trace] [Mesg: :getTypeForDeliveryTranspor
t = JMS]

We are stuck on this for past two days.The same error is given on another Database instance . I checked the BO definition, adapter config etc. everything seems to be fine.

I am connecting to Oracle 10 g database, JDBC 2.6.0 and adapter framework 2.6.0.
Back to top
View user's profile Send private message
RocknRambo
PostPosted: Tue Oct 17, 2006 6:41 pm    Post subject: Reply with quote

Partisan

Joined: 24 Sep 2003
Posts: 355
Is this the trace from the Level-5 of the Adapter ?

Quote:
[Mesg: Polling for eventID,name of BO,verb:"35680","InstitutionalAsset","Create"] ]



what is the Object_key ? can you paste the event_tbl contents (can be achieved by stopping the adapter and firing the trigger)


-RR
Back to top
View user's profile Send private message
wbi_prof
PostPosted: Wed Oct 18, 2006 6:17 am    Post subject: The call to method poll() failed. Reply with quote

Newbie

Joined: 17 Oct 2006
Posts: 3
Thanks for your response. The event table data is :

EVENT_ID - 31484
CONNECTOR_ID - OUTBOUND
OBJECT_KY - 170
OBJECT_NAME - InstitutionalAssetLoan
OBJECT_VERB - Update
EVENT_PRIORITY - 1
EVENT_TIME - 10/17/2006 7:36:21 PM
EVENT_STATUS - 0
EVENT_COMMENT - Loan Update

The object key is the primar key in Loan table .
I tried disabling the trigger and manually populate the event table but it gives the same error.
No idea what's going wrong...
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Interchange Server + Adapters » WBIA JDBC Adapter - call to method poll() failed
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.