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 » VerbProcessingFailedException

Post new topic  Reply to topic
 VerbProcessingFailedException « View previous topic :: View next topic » 
Author Message
Dijkstra
PostPosted: Mon Nov 19, 2007 4:53 am    Post subject: VerbProcessingFailedException Reply with quote

Newbie

Joined: 19 Nov 2007
Posts: 2
Hi WBI Guru

I use JDBC Adapter

and have some problem during retrieve hierarchical business objects


the connector track



<Version = 3.0>
<EndHeader>
<StartBO:CH_CHBASE>

BusinessObject = CH_CHBASE
Verb = Retrieve
Locale = en_US

CODE = 1
TYPE = 2
NAME = NAME
<StartChild>
CHILDS = 2

<StartBO:CH_CHCHILD>
BusinessObject = CH_CHCHILD
Verb = CxBlank
Locale = en_US

CODE = 1
BCODE = 1
NAME = CHILD_NAME1
BeforeCreateSP = CxIgnore
CreateSP = CxIgnore
AfterCreateSP = CxIgnore
BeforeRetrieveSP = CxIgnore
RetrieveSP = CxIgnore
AfterRetrieveSP = CxIgnore
BeforeDeleteSP = CxIgnore
DeleteSP = CxIgnore
AfterDeleteSP = CxIgnore
BeforeUpdateSP = CxIgnore
UpdateSP = CxIgnore
AfterUpdateSP = CxIgnore
BeforeRetrieveUpdateSP = CxIgnore
RetrieveUpdateSP = CxIgnore
AfterRetrieveUpdateSP = CxIgnore
BeforeRetrieveByContentSP = CxIgnore
RetrieveByContentSP = CxIgnore
AfterRetrieveByContentSP = CxIgnore
BeforeDeltaUpdateSP = CxIgnore
DeltaUpdateSP = CxIgnore
AfterDeltaUpdateSP = CxIgnore
ObjectEventId = CxIgnore
<EndBO:CH_CHCHILD>

<StartBO:CH_CHCHILD>
BusinessObject = CH_CHCHILD
Verb = CxBlank
Locale = en_US

CODE = 2
BCODE = 1
NAME = CHILD_NAME2
BeforeCreateSP = CxIgnore
CreateSP = CxIgnore
AfterCreateSP = CxIgnore
BeforeRetrieveSP = CxIgnore
RetrieveSP = CxIgnore
AfterRetrieveSP = CxIgnore
BeforeDeleteSP = CxIgnore
DeleteSP = CxIgnore
AfterDeleteSP = CxIgnore
BeforeUpdateSP = CxIgnore
UpdateSP = CxIgnore
AfterUpdateSP = CxIgnore
BeforeRetrieveUpdateSP = CxIgnore
RetrieveUpdateSP = CxIgnore
AfterRetrieveUpdateSP = CxIgnore
BeforeRetrieveByContentSP = CxIgnore
RetrieveByContentSP = CxIgnore
AfterRetrieveByContentSP = CxIgnore
BeforeDeltaUpdateSP = CxIgnore
DeltaUpdateSP = CxIgnore
AfterDeltaUpdateSP = CxIgnore
ObjectEventId = CxIgnore
<EndBO:CH_CHCHILD>
<EndChild>
ObjectEventId = CxIgnore

<EndBO:CH_CHBASE>]
[Time: 2007/11/19 14:39:05.068] [System: ConnectorAgent] [SS: JDBCSupplyConnector] [Thread: appPolling (#842554566)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90018] [Mesg: Entering testDBStatus] ]
[Time: 2007/11/19 14:39:05.068] [System: ConnectorAgent] [SS: JDBCSupplyConnector] [Thread: appPolling (#842554566)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90019] [Mesg: Exiting testDBStatus] ]
[Time: 2007/11/19 14:39:05.068] [System: ConnectorAgent] [SS: JDBCSupplyConnector] [Thread: appPolling (#842554566)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90018] [Mesg: Entering releaseConnection] ]
[Time: 2007/11/19 14:39:05.084] [System: ConnectorAgent] [SS: JDBCSupplyConnector] [Thread: appPolling (#842554566)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90019] [Mesg: Exiting releaseConnection] ]
[Time: 2007/11/19 14:39:05.084] [System: ConnectorAgent] [SS: JDBCSupplyConnector] [Thread: appPolling (#842554566)] [Type: Trace] [Mesg: :
com.crossworlds.cwconnectorapi.exceptions.VerbProcessingFailedException: [Type: Error] [MsgID: 37000] [Mesg: A SQL Exception java.sql.SQLException: ResultSet is closed occurred]
at com.crossworlds.connectors.JDBC.JDBCBOhandler.doVerbFor(JDBCBOhandler.java:1601)
at com.crossworlds.cwconnectorapi.CWConnectorBOHandler.doVerbFor(CWConnectorBOHandler.java:127)
at CxCommon.BusinessObject.doVerbFor(BusinessObject.java:2179)
at com.crossworlds.cwconnectorapi.CWConnectorBusObj.doVerbFor(CWConnectorBusObj.java:126)
at com.crossworlds.connectors.JDBC.JDBCConnectorAgent.pollForEvents(JDBCConnectorAgent.java:1299)
at AppSide_Connector.BusObjJavaInterface.poll(BusObjJavaInterface.java:584)
at AppSide_Connector.AppCalls.poll(AppCalls.java:192)
at AppSide_Connector.AgentBusinessObjectManager.poll(AgentBusinessObjectManager.java:717)
at AppSide_Connector.AppPolling.poll(AppPolling.java:310)
]
[Time: 2007/11/19 14:39:05.084] [System: ConnectorAgent] [SS: JDBCSupplyConnector] [Thread: appPolling (#842554566)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90018] [Mesg: Entering updateEventStatus] ]
[Time: 2007/11/19 14:39:05.146] [System: ConnectorAgent] [SS: JDBCSupplyConnector] [Thread: appPolling (#842554566)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 37021] [Mesg: Database Commited Successfully] ]
[Time: 2007/11/19 14:39:05.146] [System: ConnectorAgent] [SS: JDBCSupplyConnector] [Thread: appPolling (#842554566)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 37022] [Mesg: DBManager Operation success] ]
[Time: 2007/11/19 14:39:05.146] [System: ConnectorAgent] [SS: JDBCSupplyConnector] [Thread: appPolling (#842554566)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90019] [Mesg: Exiting updateEventStatus] ]
[Time: 2007/11/19 14:39:05.178] [System: ConnectorAgent] [SS: JDBCSupplyConnector] [Thread: appPolling (#842554566)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 37021] [Mesg: Database Commited Successfully] ]
[Time: 2007/11/19 14:39:05.178] [System: ConnectorAgent] [SS: JDBCSupplyConnector] [Thread: appPolling (#842554566)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 37022] [Mesg: DBManager Operation success] ]
[Time: 2007/11/19 14:39:05.193] [System: ConnectorAgent] [SS: JDBCSupplyConnector] [Thread: appPolling (#842554566)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90018] [Mesg: Entering deleteEvent] ]
[Time: 2007/11/19 14:39:05.271] [System: ConnectorAgent] [SS: JDBCSupplyConnector] [Thread: appPolling (#842554566)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 37021] [Mesg: Database Commited Successfully] ]
[Time: 2007/11/19 14:39:05.271] [System: ConnectorAgent] [SS: JDBCSupplyConnector] [Thread: appPolling (#842554566)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 37022] [Mesg: DBManager Operation success] ]
[Time: 2007/11/19 14:39:05.271] [System: ConnectorAgent] [SS: JDBCSupplyConnector] [Thread: appPolling (#842554566)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90019] [Mesg: Exiting deleteEvent] ]
[Time: 2007/11/19 14:39:05.271] [System: ConnectorAgent] [SS: JDBCSupplyConnector] [Thread: appPolling (#842554566)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90019] [Mesg: Exiting pollForEvents] ]
[Time: 2007/11/19 14:39:05.271] [System: ConnectorAgent] [SS: JDBCSupplyConnector] [Thread: appPolling (#842554566)] [Type: Trace] [Mesg: :checkStatus]
[Time: 2007/11/19 14:39:06.271] [System: ConnectorAgent] [SS: JDBCSupplyConnector] [Thread: appPolling (#842554566)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 17008] [Mesg: Polling every 1000 milliseconds.] ]
[Time: 2007/11/19 14:39:06.271] [System: ConnectorAgent] [SS: JDBCSupplyConnector] [Thread: appPolling (#842554566)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 17009] [Mesg: Polling for subscription events.] ]
[Time: 2007/11/19 14:39:06.271] [System: ConnectorAgent] [SS: JDBCSupplyConnector] [Thread: appPolling (#842554566)] [Type: Trace] [Mesg: Thread:appPolling:executing poll call]
[Time: 2007/11/19 14:39:06.271] [System: ConnectorAgent] [SS: JDBCSupplyConnector] [Thread: appPolling (#842554566)] [Type: Trace] [Mesg: :Polling App Connector.]
[Time: 2007/11/19 14:39:06.271] [System: ConnectorAgent] [SS: JDBCSupplyConnector]

why my result set is closed ?
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 » VerbProcessingFailedException
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.