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:

"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",

Not sure why its not coming thru the jdbc interface.