[Mondrian] Cancel Support

Matt Campbell mkambol at gmail.com
Thu Jan 28 08:12:24 EST 2010


I've added MONDRIAN-689 for this.

On Thu, Jan 7, 2010 at 2:28 PM, Julian Hyde <jhyde at pentaho.com> wrote:

>  I've not heard of any such efforts. It would definitely be a useful
> feature. Can you please log a jira request as a placeholder.
>
> Also, it would allow us to implement cancel in the XMLA olap4j driver. (So
> I'm Cc:ing the olap4j devel list.)
>
> We'd have to think a bit about session support. The XMLA server uses
> connections from a pool, so the session id would not map directly onto an id
> of the back-end mondrian connection. The session concept would therefore
> have to be introduced in the web layer. We'd have to ensure that connections
> timeout and go away after some period of time (not hold resources forever)
> and ensure that session ids are not recycled. My hunch is that we should
> leverage services from the web container to get session support.
>
> Julian
>
>  ------------------------------
> *From:* mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org]
> *On Behalf Of *Matt Campbell
> *Sent:* Thursday, January 07, 2010 6:37 AM
> *To:* Mondrian developer mailing list
> *Subject:* [Mondrian] Cancel Support
>
>
> Has anyone in the community considered adding query cancel support to
> Mondrian XMLA?  While cancelling is not included in the XMLA spec, Microsoft
> has introduced an extension to support it (see request/response below).  It
> requires some minimal level of session support, since the cancel request
> needs to be able to identify the request somehow.
>
>
> *Request:*
>
> <?xml version="1.0"?>
> <SOAP-ENV:Envelope xmlns:SOAP-ENV="
> http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="
> http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="
> http://www.w3.org/2001/XMLSchema">
>         <SOAP-ENV:Header>
>                 <XA:Session xmlns:XA="
> urn:schemas-microsoft-com:xml-analysis" mustUnderstand="1" SessionId="
> 841406E4-B4BD-4208-AB47-AACDF5E8A720"/>
>         </SOAP-ENV:Header>
>         <SOAP-ENV:Body>
>                 <Execute xmlns="urn:schemas-microsoft-com:xml-analysis"SOAP-ENV:encodingStyle
> ="http://schemas.xmlsoap.org/soap/encoding/">
>                         <Command>
>                                 *<Cancel xmlns="**
> http://schemas.microsoft.com/analysisservices/2003/engine*<http://schemas.microsoft.com/analysisservices/2003/engine>
> *">*
> *                                        <SessionID>
> 841406E4-B4BD-4208-AB47-AACDF5E8A720</SessionID>*
> *                                </Cancel>*
>                         </Command>
>                         <Properties>
>                                 <PropertyList/>
>                         </Properties>
>                 </Execute>
>         </SOAP-ENV:Body>
> </SOAP-ENV:Envelope>
>
> *Response:*
>
> <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
>         <soap:Body>
>                 <ExecuteResponse xmlns="
> urn:schemas-microsoft-com:xml-analysis">
>                         <return>
>                                 <root xmlns="
> urn:schemas-microsoft-com:xml-analysis:empty"/>
>                         </return>
>                 </ExecuteResponse>
>         </soap:Body>
> </soap:Envelope>
>
>
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20100128/27d9ed37/attachment.html 


More information about the Mondrian mailing list