I've added <span style="font-size:11.0pt;font-family:"Calibri","sans-serif";
mso-ascii-theme-font:minor-latin;mso-fareast-font-family:Calibri;mso-fareast-theme-font:
minor-latin;mso-hansi-theme-font:minor-latin;mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font:minor-bidi;mso-ansi-language:EN-US;mso-fareast-language:
EN-US;mso-bidi-language:AR-SA">MONDRIAN-689 for this.</span><br><br><div class="gmail_quote">On Thu, Jan 7, 2010 at 2:28 PM, Julian Hyde <span dir="ltr"><<a href="mailto:jhyde@pentaho.com">jhyde@pentaho.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div>
<div><span><font color="#000080" size="2" face="Lucida Sans">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.</font></span></div>
<div><span><font color="#000080" size="2" face="Lucida Sans"></font></span> </div>
<div><span><font color="#000080" size="2" face="Lucida Sans">Also, it would allow us to implement cancel in the XMLA
olap4j driver. (So I'm Cc:ing the olap4j devel list.)</font></span></div>
<div><span><font color="#000080" size="2" face="Lucida Sans"></font></span> </div>
<div><span><font color="#000080" size="2" face="Lucida Sans">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.</font></span></div>
<div><span><font color="#000080" size="2" face="Lucida Sans"></font></span> </div>
<div><span><font color="#000080" size="2" face="Lucida Sans">Julian</font></span></div><br>
<blockquote style="border-left:#000080 2px solid;padding-left:5px;margin-left:5px;margin-right:0px" dir="ltr">
<div dir="ltr" lang="en-us" align="left">
<hr>
<font size="2" face="Tahoma"><b>From:</b> <a href="mailto:mondrian-bounces@pentaho.org" target="_blank">mondrian-bounces@pentaho.org</a>
[mailto:<a href="mailto:mondrian-bounces@pentaho.org" target="_blank">mondrian-bounces@pentaho.org</a>] <b>On Behalf Of </b>Matt
Campbell<br><b>Sent:</b> Thursday, January 07, 2010 6:37 AM<br><b>To:</b>
Mondrian developer mailing list<br><b>Subject:</b> [Mondrian] Cancel
Support<br></font><br></div><div><div></div><div class="h5">
<div></div><br>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.<br>
<div class="gmail_quote">
<div lang="EN-US" vlink="purple" link="blue">
<div>
<p style="margin-bottom:12pt" class="MsoNormal"><br><b><span style="font-size:10pt">Request:</span></b> <br><br><span style="color:teal;font-size:10pt"><?xml version="1.0"?></span>
<br><span style="color:blue;font-size:10pt"><</span><span style="color:maroon;font-size:10pt">SOAP-ENV:Envelope</span><span style="color:red;font-size:10pt"> xmlns:SOAP-ENV</span><span style="color:blue;font-size:10pt">="</span><a href="http://schemas.xmlsoap.org/soap/envelope/" target="_blank"><span style="font-size:10pt">http://schemas.xmlsoap.org/soap/envelope/</span></a><span style="color:blue;font-size:10pt">"</span><span style="color:red;font-size:10pt"> xmlns:xsi</span><span style="color:blue;font-size:10pt">="</span><a href="http://www.w3.org/2001/XMLSchema-instance" target="_blank"><span style="font-size:10pt">http://www.w3.org/2001/XMLSchema-instance</span></a><span style="color:blue;font-size:10pt">"</span><span style="color:red;font-size:10pt"> xmlns:xsd</span><span style="color:blue;font-size:10pt">="</span><a href="http://www.w3.org/2001/XMLSchema" target="_blank"><span style="font-size:10pt">http://www.w3.org/2001/XMLSchema</span></a><span style="color:blue;font-size:10pt">"></span> <br>
<span style="font-size:10pt"> <span style="color:blue"><</span><span style="color:maroon">SOAP-ENV:Header</span><span style="color:blue">></span></span> <br><span style="font-size:10pt">
<span style="color:blue"><</span><span style="color:maroon">XA:Session</span><span style="color:red">
xmlns:XA</span><span style="color:blue">="</span>urn:schemas-microsoft-com:xml-analysis<span style="color:blue">"</span><span style="color:red">
mustUnderstand</span><span style="color:blue">="</span>1<span style="color:blue">"</span><span style="color:red"> SessionId</span><span style="color:blue">="</span>841406E4-B4BD-4208-AB47-AACDF5E8A720<span style="color:blue">"/></span></span> <br>
<span style="font-size:10pt"> <span style="color:blue"></</span><span style="color:maroon">SOAP-ENV:Header</span><span style="color:blue">></span></span> <br><span style="font-size:10pt"> <span style="color:blue"><</span><span style="color:maroon">SOAP-ENV:Body</span><span style="color:blue">></span></span> <br>
<span style="font-size:10pt">
<span style="color:blue"><</span><span style="color:maroon">Execute</span><span style="color:red">
xmlns</span><span style="color:blue">="</span>urn:schemas-microsoft-com:xml-analysis<span style="color:blue">"</span><span style="color:red">
SOAP-ENV:encodingStyle</span><span style="color:blue">="</span></span><a href="http://schemas.xmlsoap.org/soap/encoding/" target="_blank"><span style="font-size:10pt">http://schemas.xmlsoap.org/soap/encoding/</span></a><span style="color:blue;font-size:10pt">"></span> <br>
<span style="font-size:10pt">
<span style="color:blue"><</span><span style="color:maroon">Command</span><span style="color:blue">></span></span> <br><span style="font-size:10pt">
<b><span style="color:blue"><</span><span style="color:maroon">Cancel</span><span style="color:red"> xmlns</span><span style="color:blue">="</span></b></span><a href="http://schemas.microsoft.com/analysisservices/2003/engine" target="_blank"><b><span style="font-size:10pt">http://schemas.microsoft.com/analysisservices/2003/engine</span></b></a><b><span style="color:blue;font-size:10pt">"></span></b> <br>
<b><span style="font-size:10pt">
<span style="color:blue"><</span><span style="color:maroon">SessionID</span><span style="color:blue">></span>841406E4-B4BD-4208-AB47-AACDF5E8A720<span style="color:blue"></</span><span style="color:maroon">SessionID</span><span style="color:blue">></span></span></b> <br>
<b><span style="font-size:10pt">
<span style="color:blue"></</span><span style="color:maroon">Cancel</span><span style="color:blue">></span></span></b> <br><span style="font-size:10pt">
<span style="color:blue"></</span><span style="color:maroon">Command</span><span style="color:blue">></span></span> <br><span style="font-size:10pt">
<span style="color:blue"><</span><span style="color:maroon">Properties</span><span style="color:blue">></span></span> <br><span style="font-size:10pt">
<span style="color:blue"><</span><span style="color:maroon">PropertyList</span><span style="color:blue">/></span></span> <br><span style="font-size:10pt">
<span style="color:blue"></</span><span style="color:maroon">Properties</span><span style="color:blue">></span></span> <br><span style="font-size:10pt">
<span style="color:blue"></</span><span style="color:maroon">Execute</span><span style="color:blue">></span></span> <br><span style="font-size:10pt"> <span style="color:blue"></</span><span style="color:maroon">SOAP-ENV:Body</span><span style="color:blue">></span></span> <br>
<span style="color:blue;font-size:10pt"></</span><span style="color:maroon;font-size:10pt">SOAP-ENV:Envelope</span><span style="color:blue;font-size:10pt">></span> <br><br><b><span style="font-size:10pt">Response:</span></b> <br>
<br><span style="color:blue;font-size:10pt"><</span><span style="color:maroon;font-size:10pt">soap:Envelope</span><span style="color:red;font-size:10pt"> xmlns:soap</span><span style="color:blue;font-size:10pt">="</span><a href="http://schemas.xmlsoap.org/soap/envelope/" target="_blank"><span style="font-size:10pt">http://schemas.xmlsoap.org/soap/envelope/</span></a><span style="color:blue;font-size:10pt">"></span> <br>
<span style="font-size:10pt"> <span style="color:blue"><</span><span style="color:maroon">soap:Body</span><span style="color:blue">></span></span> <br><span style="font-size:10pt">
<span style="color:blue"><</span><span style="color:maroon">ExecuteResponse</span><span style="color:red">
xmlns</span><span style="color:blue">="</span>urn:schemas-microsoft-com:xml-analysis<span style="color:blue">"></span></span> <br><span style="font-size:10pt">
<span style="color:blue"><</span><span style="color:maroon">return</span><span style="color:blue">></span></span> <br><span style="font-size:10pt">
<span style="color:blue"><</span><span style="color:maroon">root</span><span style="color:red"> xmlns</span><span style="color:blue">="</span>urn:schemas-microsoft-com:xml-analysis:empty<span style="color:blue">"/></span></span> <br>
<span style="font-size:10pt">
<span style="color:blue"></</span><span style="color:maroon">return</span><span style="color:blue">></span></span> <br><span style="font-size:10pt">
<span style="color:blue"></</span><span style="color:maroon">ExecuteResponse</span><span style="color:blue">></span></span> <br><span style="font-size:10pt"> <span style="color:blue"></</span><span style="color:maroon">soap:Body</span><span style="color:blue">></span></span> <br>
<span style="color:blue;font-size:10pt"></</span><span style="color:maroon;font-size:10pt">soap:Envelope</span><span style="color:blue;font-size:10pt">></span>
<br><br></p></div></div></div></div></div></blockquote></div>
<br>_______________________________________________<br>
Mondrian mailing list<br>
<a href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</a><br>
<a href="http://lists.pentaho.org/mailman/listinfo/mondrian" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
<br></blockquote></div><br>