View difference between Paste ID: MYR53bhP and R6V0f5S7
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_us09sqldev_1433" url="jdbc:xquery:sqlserver://sql_server:1433;schema=CNVDTA;table=F0101Z2;xmlforest=true;DatabaseName=JDE_CNV;urltype=.xml"/>
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
	  (: **** ? **** :)
21
	  default
22
	  	return error(QName('http://a.com/error', 'collection-path'), 'You attempted to retrieve an unknown target table collection.')
23
};
24
25
26
27
28
******************** exception:
29
30
javax.xml.xquery.XQException: [DataDirect][XQuery]The element with name "F0101Z2" is already defined in the targetnamespace "".
31
32
	at com.ddtek.xquery.xqj.Util.createXQException(Util.java:243)
33
34
	at com.ddtek.xquery.xqj.DDXQAbstractExpression.createOrGetExecutionContext(DDXQAbstractExpression.java:519)
35
36
	at com.ddtek.xquery.xqj.DDXQAbstractExpression.createOrGetExecutionContext(DDXQAbstractExpression.java:481)
37
38
	at com.ddtek.xquery.xqj.DDXQPreparedExpression.<init>(DDXQPreparedExpression.java:37)
39
40
	at com.ddtek.xquery.xqj.DDXQConnection.prepareExpression(DDXQConnection.java:243)
41
42
Caused by: com.ddtek.xquery.util.XQueryException: [EX6018][DataDirect][XQuery]The element with name "F0101Z2" is already defined in the targetnamespace "".
43
44
	at com.ddtek.xquery.extractor.metadata.ExtractorMetaData$NameSpace.addRootElement(ExtractorMetaData.java:2682)
45
46
	at com.ddtek.xquery.extractor.metadata.ExtractorMetaData.lookupTables(ExtractorMetaData.java:914)
47
48
	at com.ddtek.xquery.extractor.metadata.ExtractorMetaData.getCollectionsFromStaticContext(ExtractorMetaData.java:245)
49
50
	at com.ddtek.xquery.extractor.metadata.ExtractorMetaData.syncStaticContext(ExtractorMetaData.java:197)
51
52
	at com.ddtek.xquery.mediator.metadata.MediatorMetaData.syncStaticContext(MediatorMetaData.java:81)
53
54
	at com.ddtek.xquery.mediator.ContextFactory.prepareQuery(ContextFactory.java:239)
55
56
	at com.ddtek.xquery.xqj.DDXQAbstractExpression.createOrGetExecutionContext(DDXQAbstractExpression.java:512)
57
58
	... 3 more