(1) execQuery() and sort by - no exception, XML is empty <CustAssAcc><Data><DataSet/></Data><Parameters/><Meta/></CustAssAcc>
(2) execQuery() and no sort by - Same as (1) The xquery works when I tested it with saxon parser. - vineet On 10/31/05 1:53 PM, "Mike Carey" <[EMAIL PROTECTED]> wrote: > Very interesting - that should be an illegal selectPath query, shouldn't > it. > (I wonder why it's not properly noticed and blocked. Good catch, let's > see > what happens now.) > > -----Original Message----- > From: Till Westmann > Sent: Monday, October 31, 2005 10:51 AM > To: [email protected] > Subject: Re: XQuery Order by support in xmlbeans > > Hi Vineet, > > I'm not sure what the problem is, but there are some things I'd like > you to try: > > 1) From the stack trace it seems that you are using > XmlObject.selectPath to run the query. > Could you try running it using execQuery? > > 2) What happens if you run the exact same query without the sort by > expressions? > Does everything work fine? > > Cheers/thanks, > Till > > On Oct 28, 2005, at 6:55 AM, Vineet Bhatia wrote: > >> 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] >> > > > --------------------------------------------------------------------- > 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] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
