Hi Till,
Thanks for the response.
"sort by(Name)" didn't work. I get a IllegalStateException - Illegal path
[ELEMENT [CustAssAcc], [EMAIL PROTECTED]://www.w3.org/2001/XMLSchema], ]
Here is the complete xQuery -
<CustAssAcc>
<ErrorSet>
{
for $e in $this//ErrorSet
return $e
}
</ErrorSet>
<Data>
<DataSet>
{
for $a in ($this//DataItem sort by(AssignedAccount))
return
<DataItem>
{$a/*}
</DataItem>
sort by(AssignedAccount)
}
</DataSet>
</Data>
<Parameters>
{
for $p in $this//Parameters
return $p
}
</Parameters>
<Meta>
{
for $m in $this//Meta
return $m
}
</Meta>
</CustAssAcc>
I tried the "sort by" in two places - (1) after the return (2) part of the
for in clause. Both gave me IllegalStateException. Here is the stacktrace -
java.lang.IllegalStateException: Illegal path [ELEMENT [CustAssAcc],
[EMAIL PROTECTED]://www.w3.org/2001/XMLSchema], ]
at
com.bea.xbean.store.XqrlImpl.doNext(Lcom.bea.xbean.store.Cursor$Selections;)
Z(XqrlImpl.java:199)
at
com.bea.xbean.store.XqrlImpl.next(Lcom.bea.xbean.store.Cursor$Selections;)Z(
XqrlImpl.java:66)
at
com.bea.xbean.store.Cursor$Selections.setCursor(Lcom.bea.xbean.store.Cursor;
I)Z(Cursor.java:3260)
at
com.bea.xbean.store.Cursor.selectPath(Ljava.lang.String;Lcom.bea.xml.XmlOpti
ons;)V(Cursor.java:2903)
at
com.bea.xbean.values.XmlObjectBase.selectPath(Ljava.lang.String;Lcom.bea.xml
.XmlOptions;)[Lcom.bea.xml.XmlObject;(XmlObjectBase.java:395)
at
com.bea.xbean.values.XmlObjectBase.selectPath(Ljava.lang.String;)[Lcom.bea.x
ml.XmlObject;(XmlObjectBase.java:379)
at
portlets.CustAssignAccnt.CustAssignAccntController.reloadPage(Lportlets.Cust
AssignAccnt.CustAssignAccntController$BeginForm;)V(CustAssignAccntController
.jpf:207)
at
portlets.CustAssignAccnt.CustAssignAccntController.begin(Lportlets.CustAssig
nAccnt.CustAssignAccntController$BeginForm;)Lcom.bea.wlw.netui.pageflow.Forw
ard;(CustAssignAccntController.jpf:97)
at
jrockit.reflect.NativeMethodInvoker.invoke0(Ljava.lang.Object;ILjava.lang.Ob
ject;[Ljava.lang.Object;)Ljava.lang.Object;(Unknown Source)
at
jrockit.reflect.NativeMethodInvoker.invoke(Ljava.lang.Object;[Ljava.lang.Obj
ect;)Ljava.lang.Object;(Unknown Source)
at
jrockit.reflect.VirtualNativeMethodInvoker.invoke(Ljava.lang.Object;[Ljava.l
ang.Object;)Ljava.lang.Object;(Unknown Source)
at
java.lang.reflect.Method.invoke(Ljava.lang.Object;[Ljava.lang.Object;I)Ljava
.lang.Object;(Unknown Source)
Seems like I am missing something trivial?
- vineet
On 10/28/05 1:31 AM, "Till Westmann" <[EMAIL PROTECTED]> wrote:
> The XQuery engine in WebLogic 8.1 supports the August 2002 version of
> the XQuery spec.
> The "order by" clause was introduced in the November 2002 version.
> In the August 2002 version sorting is done using the "sort by"
> expression.
> (http://www.w3.org/TR/2002/WD-xquery-20020816/#id-sort-expressions)
>
> So this query should produce the desired result:
>
> <DataSet> {
> for $a in $this//DataItem
> return
> <DataItem> {
> $a/*
> } </DataItem>
> sort by (Name)
> } </DataSet>
>
> Cheers,
> Till
>
> -----Original Message-----
> From: Vineet Bhatia [mailto:[EMAIL PROTECTED]
> Sent: Thursday, October 27, 2005 9:23 AM
> To: [email protected]
> Subject: XQuery Order by support in xmlbeans
>
> Is this supported in XMLBeans weblogic 8.1 sp4?
>
> <DataSet>
> {
> for $a in //DataItem
> order by $a/Name
> return
> <DataItem>
> {$a/*}
> </DataItem>
> }
> </DataSet>
>
> I didn't get any help from BEA's xmlbeans forum.
> I want to sort the xmlbean by $a/Name.
> This works on saxon's xquery implementation.
>
> Thanks in advance.
> - vineet
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
