SHOW:
|
|
- or go back to the newest paste.
| 1 | ***************** a.xq: | |
| 2 | ||
| 3 | let $sorted-collection := jde:sortCollection(jde:retrieve-target-table('1'), scenario:getScenario())
| |
| 4 | for $row at $position in /a:root/a:row | |
| 5 | return | |
| 6 | ||
| 7 | <collection name="sqlserver_srv_1433" url="jdbc:xquery:sqlserver://srv:1433;schema=CNVDTA;table=F0101Z2;xmlforest=true;DatabaseName=JDE_CNV;urltype=.xml"/> | |
| 8 | ||
| 9 | ********************* jde.xq: | |
| 10 | ||
| 11 | declare function jde:retrieve-target-table($scenario-id as xs:string?) as node()* | |
| 12 | {
| |
| 13 | let $coll-path := scenario:get-environment-collection-path(functx:if-empty($scenario-id, scenario:getScenarioId())) | |
| 14 | let $coll-path-element := element {concat("cp-", $coll-path)} {}
| |
| 15 | ||
| 16 | return typeswitch($coll-path-element) | |
| 17 | (: **** CNV **** :) | |
| 18 | case element(cp-JDE_CNV.CNVDTA.F0101Z2) | |
| 19 | return collection("JDE_CNV.CNVDTA.F0101Z2")/F0101Z2
| |
| 20 | case element(cp-JDE_PRIST910.PS910DTA.F0101Z2) | |
| 21 | return collection("JDE_PRIST910.PS910DTA.F0101Z2")/F0101Z2
| |
| 22 | (: **** ? **** :) | |
| 23 | default | |
| 24 | return error(QName('http://a.com/error', 'collection-path'), 'You attempted to retrieve an unknown target table collection.')
| |
| 25 | }; | |
| 26 | ||
| 27 | ||
| 28 | ||
| 29 | ||
| 30 | ******************** exception: | |
| 31 | ||
| 32 | javax.xml.xquery.XQException: [DataDirect][XQuery]The element with name "F0101Z2" is already defined in the targetnamespace "". | |
| 33 | ||
| 34 | at com.ddtek.xquery.xqj.Util.createXQException(Util.java:243) | |
| 35 | ||
| 36 | at com.ddtek.xquery.xqj.DDXQAbstractExpression.createOrGetExecutionContext(DDXQAbstractExpression.java:519) | |
| 37 | ||
| 38 | at com.ddtek.xquery.xqj.DDXQAbstractExpression.createOrGetExecutionContext(DDXQAbstractExpression.java:481) | |
| 39 | ||
| 40 | at com.ddtek.xquery.xqj.DDXQPreparedExpression.<init>(DDXQPreparedExpression.java:37) | |
| 41 | ||
| 42 | at com.ddtek.xquery.xqj.DDXQConnection.prepareExpression(DDXQConnection.java:243) | |
| 43 | ||
| 44 | Caused by: com.ddtek.xquery.util.XQueryException: [EX6018][DataDirect][XQuery]The element with name "F0101Z2" is already defined in the targetnamespace "". | |
| 45 | ||
| 46 | at com.ddtek.xquery.extractor.metadata.ExtractorMetaData$NameSpace.addRootElement(ExtractorMetaData.java:2682) | |
| 47 | ||
| 48 | at com.ddtek.xquery.extractor.metadata.ExtractorMetaData.lookupTables(ExtractorMetaData.java:914) | |
| 49 | ||
| 50 | at com.ddtek.xquery.extractor.metadata.ExtractorMetaData.getCollectionsFromStaticContext(ExtractorMetaData.java:245) | |
| 51 | ||
| 52 | at com.ddtek.xquery.extractor.metadata.ExtractorMetaData.syncStaticContext(ExtractorMetaData.java:197) | |
| 53 | ||
| 54 | at com.ddtek.xquery.mediator.metadata.MediatorMetaData.syncStaticContext(MediatorMetaData.java:81) | |
| 55 | ||
| 56 | at com.ddtek.xquery.mediator.ContextFactory.prepareQuery(ContextFactory.java:239) | |
| 57 | ||
| 58 | at com.ddtek.xquery.xqj.DDXQAbstractExpression.createOrGetExecutionContext(DDXQAbstractExpression.java:512) | |
| 59 | ||
| 60 | ... 3 more |