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 Message Broker (ACE) Support » JDBC adapter

Post new topic  Reply to topic Goto page Previous  1, 2
 JDBC adapter « View previous topic :: View next topic » 
Author Message
jefflowrey
PostPosted: Thu Mar 27, 2008 4:21 am    Post subject: Reply with quote

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

Then maybe your map is wrong?

Also, set Parse Timing on MQInput to Immediate.
_________________
I am *not* the model of the modern major general.
Back to top
View user's profile Send private message
sirisha.n
PostPosted: Thu Mar 27, 2008 4:43 am    Post subject: Reply with quote

Apprentice

Joined: 25 Feb 2008
Posts: 27

Hi jefflowrey,

i tried as you mentioned.but problem is same like as before.

jefflowrey, if i placer xml through RFHUtil, mapping is successful.and i am getting correct output.

the problem comes into picture if i place xml through JDBC adapter.

thanks
Back to top
View user's profile Send private message
jefflowrey
PostPosted: Thu Mar 27, 2008 4:54 am    Post subject: Reply with quote

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

Put a Trace node before the mapping node.

Put a Trace node after the mapping node.

Compare the results with both cases.

Compare the results of the Trace before the map, with your map!
_________________
I am *not* the model of the modern major general.
Back to top
View user's profile Send private message
sirisha.n
PostPosted: Thu Mar 27, 2008 5:23 am    Post subject: Reply with quote

Apprentice

Joined: 25 Feb 2008
Posts: 27

Hi

Trace nodes are already in place, trace file after mapping does not contain any data as i have in input.

it means it not able to parse.right?

in output trace after mapping has
(0x01000021):MRM = (
(0x03000000):NAME = ''
)

but at input side trace node contains:

(0x01000010):XML = (
(0x05000018):XML = (
(0x06000011): = '1.0'
(0x06000012): = 'UTF-8'
)
(0x06000002): = '
'
(0x01000000):EMPLOYEE:EMPLOYEE = (
(0x03000000):xmlns:EMPLOYEE = 'http://www.ibm.com/websphere/crossworlds/2002/BOSchema/EMPLOYEE'
(0x03000000):xmlns:xsi = 'http://www.w3.org/2001/XMLSchema-instance'
(0x03000000):xsi:schemaLocation = 'http://www.ibm.com/websphere/crossworlds/2002/BOSchema/EMPLOYEE file:EMPLOYEE.xsd'
(0x03000000):version = '3.0.0'
(0x03000000):verb = 'Retrieve'
(0x03000000):locale = 'en_US'
(0x03000000):delta = 'false'
(0x02000000): = '
'
(0x01000000):EMPLOYEE:EMPID = (
(0x02000000): = '55555'
)
(0x02000000): = '
'
(0x01000000):EMPLOYEE:EMPFIRSTNAME = (
(0x02000000): = 'JESUS '
)
(0x02000000): = '
'
(0x01000000):EMPLOYEE:EMPLASTNAME = (
(0x02000000): = 'CALLS'
)
(0x02000000): = '
'
(0x01000000):EMPLOYEE:ObjectEventId = (
(0x02000000): = 'JDBCConnector_96xworlds_events20080327091331.562'
)
(0x02000000): = '
'
)
(0x06000002): = '
'
)

if i debug the flow i geeting "RM Descriptor Not Found".

thanks
Back to top
View user's profile Send private message
jefflowrey
PostPosted: Thu Mar 27, 2008 5:35 am    Post subject: Reply with quote

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

The Adapter is not using the BO correctly.

It is producing an msd folder that says "XML" rather than "MRM".

So your incoming data is not being parsed by the msgset, but by the XML domain.
_________________
I am *not* the model of the modern major general.
Back to top
View user's profile Send private message
sirisha.n
PostPosted: Thu Mar 27, 2008 6:41 am    Post subject: Reply with quote

Apprentice

Joined: 25 Feb 2008
Posts: 27

Hi,

if i made mrm instead of xml at connector side, and i also mentioned message set in connector properties.

now in the input node itself, message not getting parsed.


Back to top
View user's profile Send private message
sirisha.n
PostPosted: Thu Mar 27, 2008 10:52 pm    Post subject: Reply with quote

Apprentice

Joined: 25 Feb 2008
Posts: 27

Hi All,

I resolved the issue by myself.

the solution for the issue is:

JDBC adapter uses CwXML Wired format. so we need to use on both message sets with same wired format.

thanks to you all for giving your support.

Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Goto page Previous  1, 2 Page 2 of 2

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » JDBC adapter
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.