Guest User

Untitled

a guest
Aug 11th, 2013
165
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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
Advertisement
Add Comment
Please, Sign In to add comment