MQSeries.net :: View topic

Sarags · Posted: Fri Sep 15, 2006 6:54 am Post subject:

Hi all,

I'm new to the WBI Adapter Framework. I want to insert data in oracle database. for that i configured JDBC connector.
The connector has to pick the data from the JDBCConnector/REQUESTQueue. The Connector picks the msg from the queue and it shows the following error

[Time: 2006/09/06 14:29:55.062] [System: ConnectorAgent] [SS: JDBCConnector] [Th
read: JDBCCONNECTOR/REQUESTQUEUEJmsThreadPool.thread3 (#1138578540)] [Type: Trac
e] [Mesg: :Receiver.processMsg(msg) received message:
JMS Message class: jms_text
JMSType: mcd://mrm/I7JIF28002001/BOEMPLOYEE?format=CwXML
JMSDeliveryMode: 1
JMSExpiration: 0
JMSPriority: 0
JMSMessageID: ID:414d51205742524b365f44454641554cf692fe4420005b0e
JMSTimestamp: 1157567376620
JMSCorrelationID:null
JMSDestination: null
JMSReplyTo: queue://WBRK6_DEFAULT_QUEUE_MANAGER/JDBCCONNECTOR/RESPONSEQUE
UE

<?xml version="1.0"?><NS1:BOEMPLOYEE xmlns:NS1="http://www.ibm.com/websphere/cro
ssworlds/2002/BOSche
Another 252 character(s) omitted]
[Time: 2006/09/06 14:29:55.062] [System: ConnectorAgent] [SS: JDBCConnector] [Th
read: JDBCCONNECTOR/REQUESTQUEUEJmsThreadPool.thread3 (#1138578540)] [Type: Trac
e] [Mesg: :Converting the Bomo to String -- <?xml version="1.0"?><NS1:BOEMPLOYEE
xmlns:NS1="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/BOEMPLOYEE" x
mlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XM
LSchema-instance" version="1.0.0" delta="0" verb="Create"><q1><EMPNO>222</EMPNO>
<ENAME>RAAGA</ENAME><ESAL>1.06000000000000E+004</ESAL></q1></NS1:BOEMPLOYEE>]
[Time: 2006/09/06 14:29:55.281] [System: Server] [Thread: JDBCCONNECTOR/REQUESTQ
UEUEJmsThreadPool.thread3 (#1138578540)] [Type: Error] [MsgID: 0] [Mesg: String
index out of range: -1][Time: 2006/09/06 14:29:55.281] [System: ConnectorAgent] [SS: JDBCConnector] [Th
read: JDBCCONNECTOR/REQUESTQUEUEJmsThreadPool.thread3 (#1138578540)] [Type: Erro
r] [MsgID: 9068] [Mesg: The received message cannot be converted to BO Message.
The message is not valid and is NOT processed. The response will be sent to the
ReplyToQueue if it is set. Otherwise, the message will be sent to the fault queu
e. Message ID: ID:414d51205742524b365f44454641554cf692fe4420005b0e]
[Time: 2006/09/06 14:29:55.297] [System: ConnectorAgent] [SS: JDBCConnector] [Th
read: JDBCCONNECTOR/REQUESTQUEUEJmsThreadPool.thread3 (#1138578540)] [Type: Trac
e] [Mesg: :Sending response message:
JMS Message class: jms_text
JMSType: mcd://mrm/I7JIF28002001/BOEMPLOYEE?format=CwXML
JMSDeliveryMode: 1
JMSExpiration: 0
JMSPriority: 0
JMSMessageID: ID:414d51205742524b365f44454641554cf692fe4420005b0e
JMSTimestamp: 1157567376620
JMSCorrelationID:ID:414d51205742524b365f44454641554cf692fe4420005b0e
JMSDestination: null
JMSReplyTo: queue://WBRK6_DEFAULT_QUEUE_MANAGER/JDBCCONNECTOR/RESPONSEQUE
UE
JMSRedelivered: false
Status:-1
RequestType:Response
Description:The received message cannot be converted to BO. The message is not
valid.
<null>]

Thanks
Sarags