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 » WMQI-JDBC adapter Exceptions

Post new topic  Reply to topic
 WMQI-JDBC adapter Exceptions « View previous topic :: View next topic » 
Author Message
gobi_nathan
PostPosted: Mon Mar 03, 2003 2:51 am    Post subject: WMQI-JDBC adapter Exceptions Reply with quote

Acolyte

Joined: 08 Jan 2003
Posts: 69
Hi ,

I am trying to create the multiple business object (Parent-child ) relationships using Webshpere MQ Integrator and Webshpere adapter for JDBC.

when i run the adapter it is able to retrive the parent object and throws the Null pointer exception when access the child object.It says no key found for object CHILD.


Following is trace from the connector.If anyone come across this problem,please give me the solution.


---------------------------------------------------------------------------


[Time: 2003/03/03 16:04:48.243] [System: ConnectorAgent] [SS: ORCLConnector] [Th
read: appPolling (#3513371)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 35000]
[Mesg: Entering doVerbFor()] ]
[Time: 2003/03/03 16:04:48.243] [System: ConnectorAgent] [SS: ORCLConnector] [Th
read: appPolling (#3513371)] [Type: Trace] [Mesg: :<StartHeader>
<Version = 3.0>
<EndHeader>
<StartBO:PARENT>
BusinessObject = PARENT
Verb = Retrieve
Locale = en_US
PID = 1
PDESC = CxIgnore
<StartChild>
Chil = 0
<EndChild>
ObjectEventId = CxIgnore
<EndBO:PARENT>]
[Time: 2003/03/03 16:04:48.274] [System: ConnectorAgent] [SS: ORCLConnector] [Th
read: appPolling (#3513371)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 34012]
[Mesg: Entering method fetchConnection.] ]
[Time: 2003/03/03 16:04:48.415] [System: ConnectorAgent] [SS: ORCLConnector] [Th
read: appPolling (#3513371)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 36004]
[Mesg: Obtained connection.] ]
[Time: 2003/03/03 16:04:48.415] [System: ConnectorAgent] [SS: ORCLConnector] [Th
read: appPolling (#3513371)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 39015]
[Mesg: Number of DB Connections in Use 3] ]
[Time: 2003/03/03 16:04:48.415] [System: ConnectorAgent] [SS: ORCLConnector] [Th
read: appPolling (#3513371)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 34013]
[Mesg: Exiting method fetchConnection.] ]
[Time: 2003/03/03 16:04:48.430] [System: ConnectorAgent] [SS: ORCLConnector] [Th
read: appPolling (#3513371)] [Type: Trace] [Mesg: :Entering method retrieve() in
JDBCSPRetriever]
[Time: 2003/03/03 16:04:48.430] [System: ConnectorAgent] [SS: ORCLConnector] [Th
read: appPolling (#3513371)] [Type: Trace] [Mesg: :Exiting method retrieve()in J
DBCSPRetriever]
[Time: 2003/03/03 16:04:48.430] [System: ConnectorAgent] [SS: ORCLConnector] [Th
read: appPolling (#3513371)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 34012]
[Mesg: Entering method retrieve.] ]
[Time: 2003/03/03 16:04:48.430] [System: ConnectorAgent] [SS: ORCLConnector] [Th
read: appPolling (#3513371)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 34013]
[Mesg: Exiting method retrieve.] ]
[Time: 2003/03/03 16:04:48.446] [System: ConnectorAgent] [SS: ORCLConnector] [Th
read: appPolling (#3513371)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 35002]
[Mesg: Entering doRetrieve()] ]
[Time: 2003/03/03 16:04:48.446] [System: ConnectorAgent] [SS: ORCLConnector] [Th
read: appPolling (#3513371)] [Type: Trace] [Mesg: :No verb object for SP]
[Time: 2003/03/03 16:04:48.446] [System: ConnectorAgent] [SS: ORCLConnector] [Th
read: appPolling (#3513371)] [Type: Trace] [Mesg: :Entering method execSP()]
[Time: 2003/03/03 16:04:48.446] [System: ConnectorAgent] [SS: ORCLConnector] [Th
read: appPolling (#3513371)] [Type: Trace] [Mesg: :No SP to execute.Exiting meth
od execSP()]
[Time: 2003/03/03 16:04:48.462] [System: ConnectorAgent] [SS: ORCLConnector] [Th
read: appPolling (#3513371)] [Type: Trace] [Mesg: :No Sp Info for ForRetrieve!]

[Time: 2003/03/03 16:04:48.477] [System: ConnectorAgent] [SS: ORCLConnector] [Th
read: appPolling (#3513371)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 34012]
[Mesg: Entering method retrieve.] ]
[Time: 2003/03/03 16:04:48.477] [System: ConnectorAgent] [SS: ORCLConnector] [Th
read: appPolling (#3513371)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 34013]
[Mesg: Exiting method retrieve.] ]
[Time: 2003/03/03 16:04:48.477] [System: ConnectorAgent] [SS: ORCLConnector] [Th
read: appPolling (#3513371)] [Type: Trace] [Mesg: :Select P_ID,P_DESC from PAREN
T where P_ID=1]
[Time: 2003/03/03 16:04:48.493] [System: ConnectorAgent] [SS: ORCLConnector] [Th
read: appPolling (#3513371)] [Type: Trace] [Mesg: :Values that are being set on
the PreparedStatement: ]
[Time: 2003/03/03 16:04:48.493] [System: ConnectorAgent] [SS: ORCLConnector] [Th
read: appPolling (#3513371)] [Type: Trace] [Mesg: :1]
[Time: 2003/03/03 16:04:48.493] [System: ConnectorAgent] [SS: ORCLConnector] [Th
read: appPolling (#3513371)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90009]
[Mesg: Setting attribute PID with Value 1] ]
[Time: 2003/03/03 16:04:48.493] [System: ConnectorAgent] [SS: ORCLConnector] [Th
read: appPolling (#3513371)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90009]
[Mesg: Setting attribute PDESC with Value P_DESC] ]
[Time: 2003/03/03 16:04:48.509] [System: ConnectorAgent] [SS: ORCLConnector] [Th
read: appPolling (#3513371)] [Type: Trace] [Mesg: :No verb object for SP]
[Time: 2003/03/03 16:04:48.509] [System: ConnectorAgent] [SS: ORCLConnector] [Th
read: appPolling (#3513371)] [Type: Trace] [Mesg: :Entering method execSP()]
[Time: 2003/03/03 16:04:48.509] [System: ConnectorAgent] [SS: ORCLConnector] [Th
read: appPolling (#3513371)] [Type: Trace] [Mesg: :No SP to execute.Exiting meth
od execSP()]
[Time: 2003/03/03 16:04:48.509] [System: ConnectorAgent] [SS: ORCLConnector] [Th
read: appPolling (#3513371)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 35008]
[Mesg: Entering doRecursiveRetrieve()] ]
[Time: 2003/03/03 16:04:48.524] [System: ConnectorAgent] [SS: ORCLConnector] [Th
read: appPolling (#3513371)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 35006]
[Mesg: Entering doContainerRetrieve()] ]
[Time: 2003/03/03 16:04:48.524] [System: ConnectorAgent] [SS: ORCLConnector] [Th
read: appPolling (#3513371)] [Type: Trace] [Mesg: :No Sp Info for ForRetrieve!]

[Time: 2003/03/03 16:04:48.524] [System: ConnectorAgent] [SS: ORCLConnector] [Th
read: appPolling (#3513371)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 39008]
[Mesg: Entering setPrimaryKeys()] ]
[Time: 2003/03/03 16:04:48.524] [System: ConnectorAgent] [SS: ORCLConnector] [Th
read: appPolling (#3513371)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 34012]
[Mesg: Entering method retrieve.] ]
[Time: 2003/03/03 16:04:48.540] [System: ConnectorAgent] [SS: ORCLConnector] [Th
read: appPolling (#3513371)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 34013]
[Mesg: Exiting method retrieve.] ]
[Time: 2003/03/03 16:04:48.540] [System: ConnectorAgent] [SS: ORCLConnector] [Th
read: appPolling (#3513371)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 39009]
[Mesg: Exiting setPrimaryKeys()] ]
[Time: 2003/03/03 16:04:48.540] [System: ConnectorAgent] [SS: ORCLConnector] [Th
read: appPolling (#3513371)] [Type: Trace] [Mesg: :No verb object for SP]
[Time: 2003/03/03 16:04:48.540] [System: ConnectorAgent] [SS: ORCLConnector] [Th
read: appPolling (#3513371)] [Type: Trace] [Mesg: :Entering method execSP()]
[Time: 2003/03/03 16:04:48.555] [System: ConnectorAgent] [SS: ORCLConnector] [Th
read: appPolling (#3513371)] [Type: Trace] [Mesg: :No SP to execute.Exiting meth
od execSP()]
[Time: 2003/03/03 16:04:48.555] [System: ConnectorAgent] [SS: ORCLConnector] [Th
read: appPolling (#3513371)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 34012]
[Mesg: Entering method retrieve.] ]
[Time: 2003/03/03 16:04:48.555] [System: ConnectorAgent] [SS: ORCLConnector] [Th
read: appPolling (#3513371)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 34013]
[Mesg: Exiting method retrieve.] ]
[Time: 2003/03/03 16:04:48.555] [System: ConnectorAgent] [SS: ORCLConnector] [Th
read: appPolling (#3513371)] [Type: Trace] [Mesg: :logMsg]
[Time: 2003/03/03 16:04:48.571] [System: ConnectorAgent] [SS: ORCLConnector] [Th
read: appPolling (#3513371)] [Type: Error] [MsgID: 35018] [Mesg: No Key values f
ound in the Object CHILD]
[Time: 2003/03/03 16:04:48.571] [System: ConnectorAgent] [SS: ORCLConnector] [Th
read: appPolling (#3513371)] [Type: Trace] [Mesg: :logMsg]
[Time: 2003/03/03 16:04:48.571] [System: ConnectorAgent] [SS: ORCLConnector] [Th
read: appPolling (#3513371)] [Type: Error] [MsgID: 17109] [Mesg: Exception caugh
t in the method BusObjJavaInterface::poll. Reason: java.lang.NullPointerExceptio
n]
[Time: 2003/03/03 16:04:48.571] [System: ConnectorAgent] [SS: ORCLConnector] [Th
read: appPolling (#3513371)] [Type: Trace] [Mesg: :checkStatus]
[Time: 2003/03/03 16:04:48.602] [System: ConnectorAgent] [SS: ORCLConnector] [Th
read: appPolling (#3513371)] [Type: Trace] [Mesg: :logMsg]
[Time: 2003/03/03 16:04:48.602] [System: ConnectorAgent] [SS: ORCLConnector] [Th
read: appPolling (#3513371)] [Type: Error] [MsgID: 17050] [Mesg: The call to met
hod poll() in the application connector failed.]











-Thanks,
Gobi.
Back to top
View user's profile Send private message
jc_squire
PostPosted: Mon Mar 03, 2003 4:39 pm    Post subject: Reply with quote

Centurion

Joined: 14 Apr 2002
Posts: 105
Location: New Zealand
Did you use the ODA?

If using the ODA you can identify the key fields between the parent and child objects.

I don't have access to the adapter any longer so can't check it out but it is quite simple if you use the ODA.

Regards
_________________
J C Squire
IBM Certified Specialist - MQSeries
Back to top
View user's profile Send private message
JYama
PostPosted: Tue Mar 04, 2003 12:04 am    Post subject: Reply with quote

Master

Joined: 27 Mar 2002
Posts: 281
Check 'Foreign Key' property in the BO definition.

Yama
Back to top
View user's profile Send private message
gobi_nathan
PostPosted: Tue Mar 04, 2003 1:13 am    Post subject: Reply with quote

Acolyte

Joined: 08 Jan 2003
Posts: 69
Yes..i am using Business object designer to generate the BO.

Following is the BO of the Child table



<?xml version="1.0" encoding="UTF-8"?>
<xs:schema elementFormDefault="qualified" targetNamespace="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/CHILD" xmlns:bx="http://www.ibm.com/websphere/crossworlds/2002/BOSchema" xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:annotation>
<xs:documentation>Mar 3, 2003 3:46:27 PM India Standard Time; English (United States)</xs:documentation>
</xs:annotation>
<xs:element name="CHILD">
<xs:annotation>
<xs:appinfo>
<bx:boDefinition version="1.0.0">
<bx:appSpecificInfo>TN=CHILD;SCN=</bx:appSpecificInfo>
</bx:boDefinition>
</xs:appinfo>
</xs:annotation>
<xs:complexType>
<xs:sequence>
<xs:element default="" minOccurs="0" name="CID">
<xs:annotation>
<xs:documentation/>
<xs:appinfo>
<bx:boAttribute>
<bx:appSpecificInfo>CN=C_ID</bx:appSpecificInfo>
<bx:attributeInfo isKey="true"/>
</bx:boAttribute>
</xs:appinfo>
</xs:annotation>
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="10"/>
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element default="" minOccurs="0" name="PID">
<xs:annotation>
<xs:documentation/>
<xs:appinfo>
<bx:boAttribute>
<bx:appSpecificInfo>CN=P_ID;FK=PARENT.P_ID</bx:appSpecificInfo>
<bx:attributeInfo isForeignKey="true"/>
</bx:boAttribute>
</xs:appinfo>
</xs:annotation>
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="10"/>
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element default="" minOccurs="0" name="ObjectEventId" type="xs:string">
<xs:annotation>
<xs:documentation/>
</xs:annotation>
</xs:element>
</xs:sequence>
<xs:attribute default="0.0.0" name="version" type="xs:token"/>
<xs:attribute default="false" name="delta" type="xs:boolean"/>
<xs:attribute default="" name="locale" type="xs:string"/>
<xs:attribute name="verb" use="required">
<xs:simpleType>
<xs:restriction base="xs:NMTOKEN">
<xs:enumeration value="Create"/>
<xs:enumeration value="Delete"/>
<xs:enumeration value="Retrieve"/>
<xs:enumeration value="RetrieveByContent"/>
<xs:enumeration value="Update"/>
</xs:restriction>
</xs:simpleType>
</xs:attribute>
</xs:complexType>
</xs:element>


----------------------------------------------------------------------------


Following is the xml schema file generated for parent object



<?xml version="1.0" encoding="UTF-8"?>
<xs:schema elementFormDefault="qualified" targetNamespace="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/PARENT" xmlns:CHILD="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/CHILD" xmlns:bx="http://www.ibm.com/websphere/crossworlds/2002/BOSchema" xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:annotation>
<xs:documentation>Mar 3, 2003 3:46:27 PM India Standard Time; English (United States)</xs:documentation>
</xs:annotation>
<xs:import namespace="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/CHILD" schemaLocation="CHILD.xsd"/>
<xs:element name="PARENT">
<xs:annotation>
<xs:appinfo>
<bx:boDefinition version="1.0.0">
<bx:appSpecificInfo>TN=PARENT;SCN=</bx:appSpecificInfo>
</bx:boDefinition>
</xs:appinfo>
</xs:annotation>
<xs:complexType>
<xs:sequence>
<xs:element default="" minOccurs="0" name="PID">
<xs:annotation>
<xs:documentation/>
<xs:appinfo>
<bx:boAttribute>
<bx:appSpecificInfo>CN=P_ID</bx:appSpecificInfo>
<bx:attributeInfo isKey="true"/>
</bx:boAttribute>
</xs:appinfo>
</xs:annotation>
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="10"/>
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element default="" minOccurs="0" name="PDESC">
<xs:annotation>
<xs:documentation/>
<xs:appinfo>
<bx:boAttribute>
<bx:appSpecificInfo>CN=P_DESC</bx:appSpecificInfo>
</bx:boAttribute>
</xs:appinfo>
</xs:annotation>
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="100"/>
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element minOccurs="0" name="CHILD">
<xs:annotation>
<xs:documentation/>
<xs:appinfo>
<bx:boAttribute>
<bx:appSpecificInfo>CONTAINMENT=OWNERSHIP</bx:appSpecificInfo>
<bx:childObjectInfo version="1.0.0"/>
</bx:boAttribute>
</xs:appinfo>
</xs:annotation>
<xs:complexType>
<xs:sequence>
<xs:element maxOccurs="unbounded" ref="CHILD:CHILD"/>
</xs:sequence>
<xs:attribute default="1" name="size" type="xs:positiveInteger"/>
</xs:complexType>
</xs:element>
<xs:element default="" minOccurs="0" name="ObjectEventId" type="xs:string">
<xs:annotation>
<xs:documentation/>
</xs:annotation>
</xs:element>
</xs:sequence>
<xs:attribute default="0.0.0" name="version" type="xs:token"/>
<xs:attribute default="false" name="delta" type="xs:boolean"/>
<xs:attribute default="" name="locale" type="xs:string"/>
<xs:attribute name="verb" use="required">
<xs:simpleType>
<xs:restriction base="xs:NMTOKEN">
<xs:enumeration value="Create"/>
<xs:enumeration value="Delete"/>
<xs:enumeration value="Retrieve"/>
<xs:enumeration value="RetrieveByContent"/>
<xs:enumeration value="Update"/>
</xs:restriction>
</xs:simpleType>
</xs:attribute>
</xs:complexType>
</xs:element>
</xs:schema>


-----------------------

If anyone able to find the error,please give me the solution


Thanks in advance,

Gobi.
</xs:schema>
Back to top
View user's profile Send private message
gobi_nathan
PostPosted: Wed Mar 05, 2003 12:08 am    Post subject: Reply with quote

Acolyte

Joined: 08 Jan 2003
Posts: 69
hi ,

You are correct.I have changed the foreignkey replationship in the BO.It is working now.

thanks all,
Gobi
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 Message Broker (ACE) Support » WMQI-JDBC adapter Exceptions
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.