sw vajanyatek created TEIIDDES-2727:
---------------------------------------
Summary: SQL Queries generated via "Generate REST Virtual
Procedures" do not work when executed directly in JBoss Developer Studio
Key: TEIIDDES-2727
URL:
https://issues.jboss.org/browse/TEIIDDES-2727
Project: Teiid Designer
Issue Type: Feature Request
Reporter: sw vajanyatek
The following procedure was generated via right-clicking a view model -->
"Generate REST Virtual Procedures":
{code:sql}
BEGIN
SELECT XMLELEMENT(NAME elems, XMLATTRIBUTES(ss4_view.stockRestProc.pk_stockid_in AS
pk_stockid_in), XMLAGG(XMLELEMENT(NAME elem, XMLFOREST(ss4_view.stock.stockid,
ss4_view.stock.exchangeid, ss4_view.stock.ticker, ss4_view.stock.name,
ss4_view.stock.description, ss4_view.stock.notes)))) AS xml_out FROM ss4_view.stock WHERE
ss4_view.stockRestProc.pk_stockid_in = ss4_view.stock.stockid;
END
{code}
The resulting REST service (../json/stock/{stockid}) produces the expected results and
appears fine. However, executing the following in a sql script connected to the same
teiid server via jdbc produces an exception:
{code:sql}
SELECT XMLELEMENT(NAME elems
, XMLAGG(XMLELEMENT(NAME elem,
XMLFOREST(ss4_view.stock.stockid
, ss4_view.stock.exchangeid
, ss4_view.stock.ticker
, ss4_view.stock.name
, ss4_view.stock.description
, ss4_view.stock.notes)
)
)
) AS xml_out
FROM ss4_view.stock
WHERE 4 = ss4_view.stock.stockid;
{code}
{{org.teiid.net.socket.SingleInstanceCommunicationException:
java.io.OptionalDataException}}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)