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 » jdbc adapter : data not updated in the table (backend)!?

Post new topic  Reply to topic
 jdbc adapter : data not updated in the table (backend)!? « View previous topic :: View next topic » 
Author Message
shafi
PostPosted: Tue May 02, 2006 2:02 am    Post subject: jdbc adapter : data not updated in the table (backend)!? Reply with quote

Apprentice

Joined: 19 Mar 2006
Posts: 38

Hi All,

when I am sending the following BO,

"<?xml version="1.0" encoding="utf-8" standalone="no"?>
<xsd:schema elementFormDefault="qualified" targetNamespace="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/thre" xmlns:bx="http://www.ibm.com/websphere/crossworlds/2002/BOSchema" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><xsd:annotation><xsd:documentation>Tue May 02 15:02:31 IST 2006</xsd:documentation></xsd:annotation><xsd:element name="thre"><xsd:annotation><xsd:appinfo><bx:boDefinition version="3.0.0" /></xsd:appinfo></xsd:annotation><xsd:complexType><xsd:sequence><xsd:element name="CreateSP" minOccurs="0"><xsd:annotation><xsd:appinfo><bx:boAttribute><bx:appSpecificInfo>SPN=P_INER;RS=False;OP=P_Emp_ID;P_EMP_NAME;P_EMP_ST_ADDR; P_EMP_CITY;P_EM_ST; P_EMP_COUNTRY;P_EMP_ZI;P_EMP_PHONE;P_EMP_DOB;P_EMP_POSITION;</bx:appSpecificInfo><bx:attributeInfo isForeignKey="false" isKey="false" /></bx:boAttribute></xsd:appinfo></xsd:annotation><xsd:simpleType><xsd:restriction base="xsd:string"><xsd:maxLength value="255" /></xsd:restriction></xsd:simpleType></xsd:element><xsd:element name="EMP_BAND" minOccurs="0"><xsd:annotation><xsd:appinfo><bx:boAttribute><bx:attributeInfo isForeignKey="false" isKey="false" /></bx:boAttribute></xsd:appinfo></xsd:annotation><xsd:simpleType><xsd:restriction base="xsd:string"><xsd:maxLength value="255" /></xsd:restriction></xsd:simpleType></xsd:element><xsd:element name="EMP_CITY" minOccurs="0"><xsd:annotation><xsd:appinfo><bx:boAttribute><bx:attributeInfo isForeignKey="false" isKey="false" /></bx:boAttribute></xsd:appinfo></xsd:annotation><xsd:simpleType><xsd:restriction base="xsd:string"><xsd:maxLength value="255" /></xsd:restriction></xsd:simpleType></xsd:element><xsd:element name="EMP_COUNTRY" minOccurs="0"><xsd:annotation><xsd:appinfo><bx:boAttribute><bx:attributeInfo isForeignKey="false" isKey="false" /></bx:boAttribute></xsd:appinfo></xsd:annotation><xsd:simpleType><xsd:restriction base="xsd:string"><xsd:maxLength value="255" /></xsd:restriction></xsd:simpleType></xsd:element><xsd:element name="EMP_DOB" minOccurs="0"><xsd:annotation><xsd:appinfo><bx:boAttribute><bx:attributeInfo isForeignKey="false" isKey="false" textType="Date" /></bx:boAttribute></xsd:appinfo></xsd:annotation><xsd:simpleType><xsd:restriction base="xsd:string" /></xsd:simpleType></xsd:element><xsd:element name="Emp_ID" minOccurs="0"><xsd:annotation><xsd:appinfo><bx:boAttribute><bx:attributeInfo isForeignKey="false" isKey="true" /></bx:boAttribute></xsd:appinfo></xsd:annotation><xsd:simpleType><xsd:restriction base="xsd:string"><xsd:maxLength value="255" /></xsd:restriction></xsd:simpleType></xsd:element><xsd:element name="EMP_NAME" minOccurs="0"><xsd:annotation><xsd:appinfo><bx:boAttribute><bx:attributeInfo isForeignKey="false" isKey="false" /></bx:boAttribute></xsd:appinfo></xsd:annotation><xsd:simpleType><xsd:restriction base="xsd:string"><xsd:maxLength value="255" /></xsd:restriction></xsd:simpleType></xsd:element><xsd:element name="EMP_PHONE" minOccurs="0"><xsd:annotation><xsd:appinfo><bx:boAttribute><bx:attributeInfo isForeignKey="false" isKey="false" /></bx:boAttribute></xsd:appinfo></xsd:annotation><xsd:simpleType><xsd:restriction base="xsd:string"><xsd:maxLength value="255" /></xsd:restriction></xsd:simpleType></xsd:element><xsd:element name="EMP_POSITION" minOccurs="0"><xsd:annotation><xsd:appinfo><bx:boAttribute><bx:attributeInfo isForeignKey="false" isKey="false" /></bx:boAttribute></xsd:appinfo></xsd:annotation><xsd:simpleType><xsd:restriction base="xsd:string"><xsd:maxLength value="255" /></xsd:restriction></xsd:simpleType></xsd:element><xsd:element name="EMP_ST" minOccurs="0"><xsd:annotation><xsd:appinfo><bx:boAttribute><bx:attributeInfo isForeignKey="false" isKey="false" /></bx:boAttribute></xsd:appinfo></xsd:annotation><xsd:simpleType><xsd:restriction base="xsd:string"><xsd:maxLength value="255" /></xsd:restriction></xsd:simpleType></xsd:element><xsd:element name="EMP_ST_ADDR" minOccurs="0"><xsd:annotation><xsd:appinfo><bx:boAttribute><bx:attributeInfo isForeignKey="false" isKey="false" /></bx:boAttribute></xsd:appinfo></xsd:annotation><xsd:simpleType><xsd:restriction base="xsd:string"><xsd:maxLength value="255" /></xsd:restriction></xsd:simpleType></xsd:element><xsd:element name="EMP_ZIP" minOccurs="0"><xsd:annotation><xsd:appinfo><bx:boAttribute><bx:attributeInfo isForeignKey="false" isKey="false" /></bx:boAttribute></xsd:appinfo></xsd:annotation><xsd:simpleType><xsd:restriction base="xsd:string"><xsd:maxLength value="255" /></xsd:restriction></xsd:simpleType></xsd:element><xsd:element name="ObjectEventId" type="xsd:string" minOccurs="0" /></xsd:sequence><xsd:attribute name="version" type="xsd:token" default="0.0.0" /><xsd:attribute name="delta" type="xsd:boolean" default="false" /><xsd:attribute name="locale" type="xsd:string" default="" /><xsd:attribute name="verb" use="required"><xsd:simpleType><xsd:restriction base="xsd:NMTOKEN"><xsd:enumeration value="Create" /><xsd:enumeration value="Delete" /><xsd:enumeration value="Retrieve" /><xsd:enumeration value="Update" /></xsd:restriction></xsd:simpleType></xsd:attribute></xsd:complexType></xsd:element></xsd:schema>"

, I am getting the following message & I could not see the data added in the backend oracle table.

Time: 2006/05/02 15:07:12.925] [System: ConnectorAgent] [SS: JDBC] [Thread: appPolling (#1269255971)] [Type: Trace] [Mesg: :checkStatus]
[Time: 2006/05/02 15:07:17.922] [System: ConnectorAgent] [SS: JDBC] [Thread: appPolling (#1269255971)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 17008] [Mesg: Polling every 5000 milliseconds.] ]
[Time: 2006/05/02 15:07:17.932] [System: ConnectorAgent] [SS: JDBC] [Thread: appPolling (#1269255971)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 17009] [Mesg: Polling for subscription events.] ]
[Time: 2006/05/02 15:07:17.932] [System: ConnectorAgent] [SS: JDBC] [Thread: appPolling (#1269255971)] [Type: Trace] [Mesg: Thread:appPolling:executing poll call]
[Time: 2006/05/02 15:07:17.932] [System: ConnectorAgent] [SS: JDBC] [Thread: appPolling (#1269255971)] [Type: Trace] [Mesg: :Polling App Connector.]
[Time: 2006/05/02 15:07:17.932] [System: ConnectorAgent] [SS: JDBC] [Thread: appPolling (#1269255971)] [Type: Trace] [Mesg: :checkStatus]
[Time: 2006/05/02 15:07:22.939] [System: ConnectorAgent] [SS: JDBC] [Thread: appPolling (#1269255971)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 17008] [Mesg: Polling every 5000 milliseconds.] ]
[Time: 2006/05/02 15:07:22.939] [System: ConnectorAgent] [SS: JDBC] [Thread: appPolling (#1269255971)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 17009] [Mesg: Polling for subscription events.] ]
[Time: 2006/05/02 15:07:22.939] [System: ConnectorAgent] [SS: JDBC] [Thread: appPolling (#1269255971)] [Type: Trace] [Mesg: Thread:appPolling:executing poll call]
[Time: 2006/05/02 15:07:22.939] [System: ConnectorAgent] [SS: JDBC] [Thread: appPolling (#1269255971)] [Type: Trace] [Mesg: :Polling App Connector.]
[Time: 2006/05/02 15:07:22.939] [System: ConnectorAgent] [SS: JDBC] [Thread: appPolling (#1269255971)] [Type: Trace] [Mesg: :Received BusObj from App Connector.]
[Time: 2006/05/02 15:07:22.939] [System: ConnectorAgent] [SS: JDBC] [Thread: appPolling (#1269255971)] [Type: Trace] [Mesg: :Posting BusObj to Interchange.]
[Time: 2006/05/02 15:07:22.939] [System: ConnectorAgent] [SS: JDBC] [Thread: appPolling (#1269255971)] [Type: Trace] [Mesg: :Business Object before delivering to the ICS :<StartHeader>
<Version = 3.0>
<EndHeader>
<StartBO:thre>
BusinessObject = thre
Verb = Create
Locale = en
CreateSP = CxIgnore
EMP_BAND = CxIgnore
EMP_CITY = CxIgnore
EMP_COUNTRY = CxIgnore
EMP_DOB = CxIgnore
Emp_ID = t7896
EMP_NAME = CxIgnore
EMP_PHONE = CxIgnore
EMP_POSITION = CxIgnore
EMP_ST = CxIgnore
EMP_ST_ADDR = CxIgnore
EMP_ZIP = CxIgnore
ObjectEventId = CxIgnore
<EndBO:thre>]
[Time: 2006/05/02 15:07:22.949] [System: ConnectorAgent] [SS: JDBC] [Thread: appPolling (#1269255971)] [Type: Trace] [Mesg: :Delivering subscription delivery CxCommon.BusinessObject@67c8032]
[Time: 2006/05/02 15:07:22.959] [System: ConnectorAgent] [SS: JDBC] [Thread: appPolling (#1269255971)] [Type: Trace] [Mesg: :class com.crossworlds.DataHandlers.text.cwxml :Setting option 'XMLNameSpaceFormat' to 'short'.]
[Time: 2006/05/02 15:07:23.280] [System: ConnectorAgent] [SS: JDBC] [Thread: appPolling (#1269255971)] [Type: Trace] [Mesg: :deliverBusObj returning 0]
[Time: 2006/05/02 15:07:23.280] [System: ConnectorAgent] [SS: JDBC] [Thread: appPolling (#1269255971)] [Type: Trace] [Mesg: Triggered event thre.Create]
[Time: 2006/05/02 15:07:23.280] [System: ConnectorAgent] [SS: JDBC] [Thread: appPolling (#1269255971)] [Type: Trace] [Mesg: :checkStatus]
[Time: 2006/05/02 15:07:28.297] [System: ConnectorAgent] [SS: JDBC] [Thread: appPolling (#1269255971)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 17008] [Mesg: Polling every 5000 milliseconds.] ]
[Time: 2006/05/02 15:07:28.427] [System: ConnectorAgent] [SS: JDBC] [Thread: appPolling (#1269255971)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 17009] [Mesg: Polling for subscription events.] ]
[Time: 2006/05/02 15:07:28.427] [System: ConnectorAgent] [SS: JDBC] [Thread: appPolling (#1269255971)] [Type: Trace] [Mesg: Thread:appPolling:executing poll call]
[Time: 2006/05/02 15:07:28.427] [System: ConnectorAgent] [SS: JDBC] [Thread: appPolling (#1269255971)] [Type: Trace] [Mesg: :Polling App Connector.]
[Time: 2006/05/02 15:07:28.427] [System: ConnectorAgent] [SS: JDBC] [Thread: appPolling (#1269255971)] [Type: Trace] [Mesg: :checkStatus]
[Time: 2006/05/02 15:07:33.434] [System: ConnectorAgent] [SS: JDBC] [Thread: appPolling (#1269255971)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 17008] [Mesg: Polling every 5000 milliseconds.] ]
[Time: 2006/05/02 15:07:33.444] [System: ConnectorAgent] [SS: JDBC] [Thread: appPolling (#1269255971)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 17009] [Mesg: Polling for subscription events.] ]
[Time: 2006/05/02 15:07:33.444] [System: ConnectorAgent] [SS: JDBC] [Thread: appPolling (#1269255971)] [Type: Trace] [Mesg: Thread:appPolling:executing poll call]
[Time: 2006/05/02 15:07:33.444] [System: ConnectorAgent] [SS: JDBC] [Thread: appPolling (#1269255971)] [Type: Trace] [Mesg: :Polling App Connector.]
[Time: 2006/05/02 15:07:33.444] [System: ConnectorAgent] [SS: JDBC] [Thread: appPolling (#1269255971)] [Type: Trace] [Mesg: :checkStatus]
[Time: 2006/05/02 15:09:48.799] [System: ConnectorAgent] [SS: JDBC] [Thread: JDBCCONNECTOR/REQUESTQUEUEJmsThreadPool.thread1 (#1269075747)] [Type: Trace] [Mesg: :Receiver.processMsg(msg) received message:
JMS Message class: jms_text
JMSType: mcd://xml
JMSDeliveryMode: 1
JMSExpiration: 0
JMSPriority: 0
JMSMessageID: ID:414d5120574d5149422e51756575652ea7e7564420000b01
JMSTimestamp: 1146562788780
JMSCorrelationID:null
JMSDestination: null
JMSReplyTo: null
JMSRedelivered: false
JMS_IBM_PutDate:20060502
JMSXAppID:istrator\Desktop\rfhutil.exe
JMS_IBM_Format:MQSTR
JMS_IBM_PutApplType:11
JMS_IBM_MsgType:8
JMSXUserID:Administrato
JMS_IBM_PutTime:09394878
JMSXDeliveryCount:1
<?xml version="1.0" encoding="UTF-8"?>
<Q1:thre xmlns:Q1="http://www.ibm.com/websphere/crossworlds
Another 612 character(s) omitted]
[Time: 2006/05/02 15:09:48.809] [System: ConnectorAgent] [SS: JDBC] [Thread: JDBCCONNECTOR/REQUESTQUEUEJmsThreadPool.thread1 (#1269075747)] [Type: Trace] [Mesg: :Converting the Bomo to String -- <?xml version="1.0" encoding="UTF-8"?>
<Q1:thre xmlns:Q1="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/thre" version="3.0.0" verb="Create" locale="en" delta="false">
<Q1:CreateSP>CxIgnore</Q1:CreateSP>
<Q1:EMP_BAND>CxIgnore</Q1:EMP_BAND>
<Q1:EMP_CITY>CxIgnore</Q1:EMP_CITY>
<Q1:EMP_COUNTRY>CxIgnore</Q1:EMP_COUNTRY>
<Q1:EMP_DOB>CxIgnore</Q1:EMP_DOB>
<Q1:Emp_ID>t7896</Q1:Emp_ID>
<Q1:EMP_NAME>CxIgnore</Q1:EMP_NAME>
<Q1:EMP_PHONE>CxIgnore</Q1:EMP_PHONE>
<Q1:EMP_POSITION>CxIgnore</Q1:EMP_POSITION>
<Q1:EMP_ST>CxIgnore</Q1:EMP_ST>
<Q1:EMP_ST_ADDR>CxIgnore</Q1:EMP_ST_ADDR>
<Q1:EMP_ZIP>CxIgnore</Q1:EMP_ZIP>
<Q1:ObjectEventId>JDBC_1146562642949_1</Q1:ObjectEventId>
</Q1:thre>]
[Time: 2006/05/02 15:09:48.849] [System: ConnectorAgent] [SS: JDBC] [Thread: JDBCCONNECTOR/REQUESTQUEUEJmsThreadPool.thread1 (#1269075747)] [Type: Trace] [Mesg: :syncDrvCallback.receiverCallback(boMsg) is called on bomo -- CxCommon.Messaging.BusObjMsgObject@7d8fcf2e]
[Time: 2006/05/02 15:09:48.849] [System: ConnectorAgent] [SS: JDBC] [Thread: JDBCCONNECTOR/REQUESTQUEUEJmsThreadPool.thread1 (#1269075747)] [Type: Trace] [Mesg: :DoVerbFor]
[Time: 2006/05/02 15:09:48.849] [System: ConnectorAgent] [SS: JDBC] [Thread: JDBCCONNECTOR/REQUESTQUEUEJmsThreadPool.thread1 (#1269075747)] [Type: Trace] [Mesg: :DoverbFor: Business Object before delivering to the Agent :<StartHeader>
<Version = 3.0>
<EndHeader>
<StartBO:thre>
BusinessObject = thre
Verb = Create
Locale = en
CreateSP = CxIgnore
EMP_BAND = CxIgnore
EMP_CITY = CxIgnore
EMP_COUNTRY = CxIgnore
EMP_DOB = CxIgnore
Emp_ID = t7896
EMP_NAME = CxIgnore
EMP_PHONE = CxIgnore
EMP_POSITION = CxIgnore
EMP_ST = CxIgnore
EMP_ST_ADDR = CxIgnore
EMP_ZIP = CxIgnore
ObjectEventId = JDBC_1146562642949_1
<EndBO:thre>]
[Time: 2006/05/02 15:09:48.859] [System: ConnectorAgent] [SS: JDBC] [Thread: JDBCCONNECTOR/REQUESTQUEUEJmsThreadPool.thread1 (#1269075747)] [Type: Trace] [Mesg: :[9543] DoVerbFor cookie=ConsumeSync name=thre verb=Create]
[Time: 2006/05/02 15:09:48.859] [System: ConnectorAgent] [SS: JDBC] [Thread: JDBCCONNECTOR/REQUESTQUEUEJmsThreadPool.thread1 (#1269075747)] [Type: Trace] [Mesg: Thread:JDBCCONNECTOR/REQUESTQUEUEJmsThreadPool.thread1:executing doverbfor call]
[Time: 2006/05/02 15:09:48.859] [System: ConnectorAgent] [SS: JDBC] [Thread: JDBCCONNECTOR/REQUESTQUEUEJmsThreadPool.thread1 (#1269075747)] [Type: Trace] [Mesg: :Calling App Connector doVerbFor Operation.]
[Time: 2006/05/02 15:09:53.536] [System: ConnectorAgent] [SS: JDBC] [Thread: appPolling (#1269255971)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 17008] [Mesg: Polling every 5000 milliseconds.] ]
[Time: 2006/05/02 15:09:53.536] [System: ConnectorAgent] [SS: JDBC] [Thread: appPolling (#1269255971)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 17009] [Mesg: Polling for subscription events.] ]
[Time: 2006/05/02 15:09:53.536] [System: ConnectorAgent] [SS: JDBC] [Thread: appPolling (#1269255971)] [Type: Trace] [Mesg: Thread:appPolling:executing poll call]
[Time: 2006/05/02 15:09:53.536] [System: ConnectorAgent] [SS: JDBC] [Thread: appPolling (#1269255971)] [Type: Trace] [Mesg: :Polling App Connector.]
[Time: 2006/05/02 15:09:53.536] [System: ConnectorAgent] [SS: JDBC] [Thread: appPolling (#1269255971)] [Type: Trace] [Mesg: :checkStatus]

Can anybody help me in resolving this?

Regards,
Shafi.
Back to top
View user's profile Send private message
vennela
PostPosted: Tue May 02, 2006 6:38 am    Post subject: Reply with quote

Jedi Knight

Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India

The log you posted is from the Input of Output?
Post ICS log, InConnector log and OutConnector log.

Also at what point do you think it is failing
Is the count of BO's on the In/Out connectors incremented.
Do the Collabs cound increment when you send the BO
Does it work for any BO
Does it work with VTC instead of JDBC Connector
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Interchange Server + Adapters » jdbc adapter : data not updated in the table (backend)!?
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.