Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ***************** a.xq:
- let $sorted-collection := jde:sortCollection(jde:retrieve-target-table('1'), scenario:getScenario())
- for $row at $position in /a:root/a:row
- return
- <collection name="sqlserver_srv_1433" url="jdbc:xquery:sqlserver://srv:1433;schema=CNVDTA;table=F0101Z2;xmlforest=true;DatabaseName=JDE_CNV;urltype=.xml"/>
- ********************* jde.xq:
- declare function jde:retrieve-target-table($scenario-id as xs:string?) as node()*
- {
- let $coll-path := scenario:get-environment-collection-path(functx:if-empty($scenario-id, scenario:getScenarioId()))
- let $coll-path-element := element {concat("cp-", $coll-path)} {}
- return typeswitch($coll-path-element)
- (: **** CNV **** :)
- case element(cp-JDE_CNV.CNVDTA.F0101Z2)
- return collection("JDE_CNV.CNVDTA.F0101Z2")/F0101Z2
- case element(cp-JDE_PRIST910.PS910DTA.F0101Z2)
- return collection("JDE_PRIST910.PS910DTA.F0101Z2")/F0101Z2
- (: **** ? **** :)
- default
- return error(QName('http://a.com/error', 'collection-path'), 'You attempted to retrieve an unknown target table collection.')
- };
- ******************** exception:
- javax.xml.xquery.XQException: [DataDirect][XQuery]The element with name "F0101Z2" is already defined in the targetnamespace "".
- at com.ddtek.xquery.xqj.Util.createXQException(Util.java:243)
- at com.ddtek.xquery.xqj.DDXQAbstractExpression.createOrGetExecutionContext(DDXQAbstractExpression.java:519)
- at com.ddtek.xquery.xqj.DDXQAbstractExpression.createOrGetExecutionContext(DDXQAbstractExpression.java:481)
- at com.ddtek.xquery.xqj.DDXQPreparedExpression.<init>(DDXQPreparedExpression.java:37)
- at com.ddtek.xquery.xqj.DDXQConnection.prepareExpression(DDXQConnection.java:243)
- Caused by: com.ddtek.xquery.util.XQueryException: [EX6018][DataDirect][XQuery]The element with name "F0101Z2" is already defined in the targetnamespace "".
- at com.ddtek.xquery.extractor.metadata.ExtractorMetaData$NameSpace.addRootElement(ExtractorMetaData.java:2682)
- at com.ddtek.xquery.extractor.metadata.ExtractorMetaData.lookupTables(ExtractorMetaData.java:914)
- at com.ddtek.xquery.extractor.metadata.ExtractorMetaData.getCollectionsFromStaticContext(ExtractorMetaData.java:245)
- at com.ddtek.xquery.extractor.metadata.ExtractorMetaData.syncStaticContext(ExtractorMetaData.java:197)
- at com.ddtek.xquery.mediator.metadata.MediatorMetaData.syncStaticContext(MediatorMetaData.java:81)
- at com.ddtek.xquery.mediator.ContextFactory.prepareQuery(ContextFactory.java:239)
- at com.ddtek.xquery.xqj.DDXQAbstractExpression.createOrGetExecutionContext(DDXQAbstractExpression.java:512)
- ... 3 more
Advertisement
Add Comment
Please, Sign In to add comment