Bug 781158 (SOA-3659)

project_key: SOA

Using the PartsVirtual.xmi model that used in the unit test for the teiid sequencer.

1)  attached is the test.log that prints when ModelSequencerTest.shouldSequencePartsSupplierVirtualRelationalModel test is run.   It shows the transformation thats defined for SupplierInfo

2)  published the model to a SOA server, used the jdbc.war, using jndi name java:ModeShapeDS, issue query: select * from [transform:withSql]         and it returned zero rows.

3)  used the FireFox json plugin to view Supplier info:  http://localhost:8080/modeshape-rest/eds/default/items/sequenced/teiid/models/teiid/PartsVirtual/SupplierInfo
(see attachment)  and its there:

{code}
"transform:selectSql": "SELECT PartSupplier_Oracle.SUPPLIER_PARTS.SUPPLIER_ID, PartSupplier_Oracle.SUPPLIER_PARTS.PART_ID, PartSupplier_Oracle.SUPPLIER_PARTS.QUANTITY, PartSupplier_Oracle.SUPPLIER_PARTS.SHIPPER_ID, PartsSupplier_SQLServer.SUPPLIER.SUPPLIER_NAME, PartsSupplier_SQLServer.SUPPLIER.SUPPLIER_STATUS, PartsSupplier_SQLServer.SUPPLIER.SUPPLIER_CITY, PartsSupplier_SQLServer.SUPPLIER.SUPPLIER_STATE FROM PartSupplier_Oracle.SUPPLIER_PARTS, PartsSupplier_SQLServer.SUPPLIER WHERE PartSupplier_Oracle.SUPPLIER_PARTS.SUPPLIER_ID = PartsSupplier_SQLServer.SUPPLIER.SUPPLIER_ID",
{code}

Not sure why its not coming thru the jdbc interface.