]
Steven Hawkins commented on TEIIDDES-2727:
------------------------------------------
Is the standard JDBC client code being used or is it possible that there are overrides?
If it's just the standard client code then what is the exact version of the server /
client?
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: Bug
Components: VDB & Execution, Web Services Support
Affects Versions: 9.2
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}}