Bug 1190673 - Import from REST JSON - procedure returns empty table.
Summary: Import from REST JSON - procedure returns empty table.
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: JBoss Data Virtualization 6
Classification: JBoss
Component: Tooling
Version: 6.1.0
Hardware: Unspecified
OS: Windows
high
high
Target Milestone: ---
: ---
Assignee: Barry LaFond
QA Contact:
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2015-02-09 12:04 UTC by Matus Makovy
Modified: 2015-11-17 18:07 UTC (History)
5 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2015-11-17 18:07:04 UTC
Type: Bug
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker TEIIDDES-2432 0 Blocker Closed Import from REST JSON - procedure returns empty table. 2015-02-16 12:35:00 UTC

Description Matus Makovy 2015-02-09 12:04:01 UTC
Importing from REST JSON doesn't work. Defined procedure returns empty table.

Steps to reproduce:

1. Create connection profile for some REST WS (JSON)
2. Import using this conn profile
3. Create VDB and execute it
4. Call procedure that was defined during import 


I have a test scenario for this import here:
https://mojo.redhat.com/docs/DOC-990181

I also tried another WS to be sure, that the problem is not in the webservice.
(I tried some iTunes online search)

TD 9.0.1.Final-v20150205

Comment 1 JBoss JIRA Server 2015-02-10 20:52:13 UTC
Ted Jones <tejones> updated the status of jira TEIIDDES-2432 to Resolved

Comment 2 Ted Jones 2015-02-11 16:11:12 UTC
The generated JSON transformation was incorrect. The last commit has fixed it, but there is a display issue with the SQL Result tab when a single row is returned. When the result is first returned it does not display in grid view (text view works the first time). Clicking on another result and back again makes the row display. Also closing and reopening the SQL Results view also resolves it. I am not seeing this with multiple rows, just a single row.

Comment 3 Matus Makovy 2015-02-13 08:17:55 UTC
I think it is a blocker becuase you have no other way to import from REST JSON.

As Ted Jones said, the transformation SQL was not correct and there isn't other way to import from REST JSON.

Comment 5 Matus Makovy 2015-02-16 09:01:58 UTC
verified 
TD 9.0.1.Final-v20150211-1407-B643 (JBDSIS 8.0.0.CR3)

Comment 6 JBoss JIRA Server 2015-02-16 12:35:01 UTC
Matus Makovy <mmakovy> updated the status of jira TEIIDDES-2432 to Closed


Note You need to log in before you can comment on or make changes to this bug.