<div dir="ltr">hi Luc,<div>sure, a couple of years ago I did part of the work to have the XMLA Servlet use any Olap4j driver (attached an example web.xml) and I also did some work with Julian on the connection pooling.</div>
<div><br></div><div style>Julian decided that we should use commons-pool to handle the pool of OlapConnection objects.</div><div style>I initially opted for a much simpler solution which I committed but later Julian decided to change it back to the commons-pool stuff.</div>
<div style><br></div><div style>I found that when the size of the pool reaches the maximum number of connections configured the thread that attempts to obtain the connection freezes waiting to obtain a new connection from the pool.</div>
<div style><br></div><div style>I also found that the connection pool didn't really re-use any existing connections preferring instead to create new ones for each requests (until the situation described above occured).</div>
<div style><br></div><div style>At the time it didn't seem like there was a huge amount of interest on the XMLA servlet and because I never got any other feedback about it I didn't attempt to have my changes committed to trunk again.</div>
<div style><br></div><div style>I am happy to share that code with the community again if you want.</div><div style><br></div><div style><br></div><div style>That said, I have not seen the mondrian / xmlaservlet code for a while, maybe someone has changed things again in the meantime.</div>
<div style><br></div><div style><br></div><div style>Hope this helps.</div><div style>Michele</div><div style><br></div><div style><br></div><div style><br></div><div style><br></div><div style><br></div><div style><br></div>
</div><div class="gmail_extra"><br><br><div class="gmail_quote">On 10 June 2013 16:11, Luc Boudreau <span dir="ltr"><<a href="mailto:lucboudreau@gmail.com" target="_blank">lucboudreau@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div class="im"><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Jun 6, 2013 at 5:45 PM, Michele Rossi <span dir="ltr"><<a href="mailto:m.rossi@iontrading.com" target="_blank">m.rossi@iontrading.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">the connection pooling code that is in there now (based on commons-pool) is totally broken, your XMLA client (Excel 2007?) could get stuck forever waiting to obtain a new OlapConnection connection object</blockquote>
</div><br><br></div></div><div class="gmail_extra">Michele,<br><br></div><div class="gmail_extra">Can you clarify this statement? That is worrying me a little.<span class="HOEnZb"><font color="#888888"><br><br></font></span></div>
<span class="HOEnZb"><font color="#888888"><div class="gmail_extra">Luc<br></div><div class="gmail_extra">
<br></div></font></span></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></div>