Bug 780588 (SOA-3028)

Summary: JBEDS Salesforce Connector gives NPE when the resultset is empty
Product: [JBoss] JBoss Enterprise SOA Platform 5 Reporter: dsteigne
Component: EDSAssignee: Van Halbert <vhalbert>
Status: CLOSED NEXTRELEASE QA Contact:
Severity: high Docs Contact:
Priority: high    
Version: 5.1.0 GA   
Target Milestone: ---   
Target Release: 5.2.0 ER1   
Hardware: Unspecified   
OS: Unspecified   
URL: http://jira.jboss.org/jira/browse/SOA-3028
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2011-10-21 20:45:15 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Attachments:
Description Flags
Salesforce_ModelProjectSet.zip none

Description dsteigne 2011-04-15 16:52:46 UTC 
Help Desk Ticket Reference: https://c.na7.visual.force.com/apex/Case_View?id=500A00000079YsF
Steps to Reproduce: Import my attached ModelProjectSet into JBoss Developer Studio, Deploy and Execute the VDB:

This returns results:
 select * from salesforce.User_ where id='00580000001fWlwAAE'

This gives the NPE:
 select * from salesforce.User_ where id='0036000000wGvmiAAC'
project_key: SOA

When querying a Relational Model created from the Salesforce importer and the criteria returns zero rows, instead of an empty resultset a Null Pointer Exception is given.
Comment 1 dsteigne 2011-04-15 16:53:32 UTC 
Attachment: Added: Salesforce_ModelProjectSet.zip
Comment 2 Van Halbert 2011-04-17 01:24:46 UTC 
Link: Added: This issue Cloned to SOA-3029
Comment 4 David Le Sage 2011-08-31 05:44:38 UTC 
Release Notes Docs Status: Added: Documented as Resolved Issue
Writer: Added: dlesage
Release Notes Text: Added: https://issues.jboss.org/browse/SOA-3028

When the user attempted to query a relational model created from the Salesforce importer and the criteria returned zero rows, a Null Pointer Exception was encountered.  A coding change has fixed this problem.  As a result, an empty resultset is now given instead.
Comment 5 Paul Nittel 2011-10-21 20:45:15 UTC 
Tested and closed.