View difference between Paste ID: AgvqN7Ej and MYR53bhP
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