Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1190673

Summary:	Import from REST JSON - procedure returns empty table.
Product:	[JBoss] JBoss Data Virtualization 6	Reporter:	Matus Makovy <mmakovy>
Component:	Tooling	Assignee:	Barry LaFond <blafond>
Status:	CLOSED CURRENTRELEASE	QA Contact:
Severity:	high	Docs Contact:
Priority:	high
Version:	6.1.0	CC:	atangrin, ldimaggi, mmakovy, tejones, vhalbert
Target Milestone:	---
Target Release:	---
Hardware:	Unspecified
OS:	Windows
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2015-11-17 18:07:04 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:
Embargoed:

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