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 » Failed to find attribute with name Null

Post new topic  Reply to topic
 Failed to find attribute with name Null « View previous topic :: View next topic » 
Author Message
uberpowered
PostPosted: Fri May 05, 2006 4:38 am    Post subject: Failed to find attribute with name Null Reply with quote

Newbie

Joined: 05 May 2006
Posts: 7

I'm noob in WBI.
I have DB with stored procedure wich returns resultset
I need adapter to create a message filled with results of this resultset
I created BO with child object containing required fields, but it seems that adapter just ignores it and keep generating "Failed to find attribute with name Null" error.
Back to top
View user's profile Send private message
Kram
PostPosted: Fri May 05, 2006 5:26 am    Post subject: Reply with quote

Voyager

Joined: 02 Mar 2006
Posts: 87

Can you post your result set???
_________________
Regards,
Ram
Back to top
View user's profile Send private message
uberpowered
PostPosted: Fri May 05, 2006 5:37 am    Post subject: Reply with quote

Newbie

Joined: 05 May 2006
Posts: 7

That's my stored procedure:
CREATE PROCEDURE I_PRIME_MB_GetCard

AS

SELECT CardNumber, CardAccount,Serno,Product,ExpiryDate,CardStatus,CreateDate,Balance,CreditLimit,CurrencyCode,CardTypeId,CardBelongTypeID,HolderName,EmbossingName FROM test_table WHERE test_table.CustomerID=1234
GO
Back to top
View user's profile Send private message
Kram
PostPosted: Fri May 05, 2006 7:06 am    Post subject: Reply with quote

Voyager

Joined: 02 Mar 2006
Posts: 87

does it return any record ....

There is some value comming as Null you might want to check that?
_________________
Regards,
Ram
Back to top
View user's profile Send private message
uberpowered
PostPosted: Fri May 05, 2006 10:45 pm    Post subject: Reply with quote

Newbie

Joined: 05 May 2006
Posts: 7

When there is only one row returned, without using child BOs everything's fine. But with multiple rows I use child BO, and there is that error.
It seems that Adapter can't see atributes of child object...

"[Time: 2006/05/06 11:58:21.559] [System: ConnectorAgent] [SS: JDBCMBConnector] [Thread: PRIMEIN_QUEUEJmsThreadPool.thread1 (#727529146)] [Type: Trace]
[Mesg: :[Type: Trace] [MsgID: 37024] [Mesg: Column Name versus Attribue Name in Hashtable for Resultset : 2222222 ] ]
[Time: 2006/05/06 11:58:21.575] [System: ConnectorAgent] [SS: JDBCMBConnector] [Thread: PRIMEIN_QUEUEJmsThreadPool.thread1 (#727529146)] Failed to find attribute with name Null in business object definition for I_PRIME_MB_GetCardBO."
Back to top
View user's profile Send private message
uberpowered
PostPosted: Sat May 06, 2006 4:54 am    Post subject: Reply with quote

Newbie

Joined: 05 May 2006
Posts: 7

!!!!!!!!!!!!!!!!!SOLVED!!!!!!!!!!!!!!
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 » Failed to find attribute with name Null
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.