Hide Forgot
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.
Link: Added: This issue Cloned from MODE-1296
Workflow: Removed: GIT Pull Request workflow Added: jira Release Notes Text: Added: When a vdb or model is checked into ModeShape for sequencing, the transformations will not be sequenced under the correct location and therefore, cannot be queried using the JDBC interface. Security: Added: Public
The changes from MODE-1296 were merged into the 'master' and '3.x' branches, but **NOT** on the branch used for SOA-P EDS 5.2. Please let us know when the change (74af30c336c) should be merged onto the '2.5.x' branch.
Git Pull Request: Removed: https://github.com/ModeShape/modeshape/pull/213 Added: https://github.com/ModeShape/modeshape/pull/213
ModeShape committed the fix to the 2.7 branch, which should be in the post 5.2 release.
Link: Added: This issue is a dependency of SOA-3656
Randall, please go ahead and merge into the 2.5.x branch.
Link: Added: This issue Cloned to SOA-3659
Link: Added: This issue is a dependency of SOA-3659
Link: Removed: This issue Cloned to SOA-3659
Link: Removed: This issue is a dependency of SOA-3656
Merged the fix onto the '2.5.x' branch, as requested. At this point, the fix has been merged onto all active branches.