Thanks for sending the jar, Will. Same problem, though. I also tried grabbing the latest release of the commons httpclient. That also failed to help.<br><br>If no one objects, how about I revert back to using the readURL method for http requests, leaving the existing VFS option for other file reads? When the commons httpclient 4.0 is released we could re-visit this.<br>
<br><br><br><div class="gmail_quote">On Sat, Jul 18, 2009 at 12:51 AM, Will Gorman <span dir="ltr"><<a href="mailto:wgorman@pentaho.com">wgorman@pentaho.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hey Guys,<br>
<br>
We are still using VFS in Kettle and Mondrian, Kettle 3.2.0 ended up<br>
building from source the latest VFS because they haven't released 2.0 of<br>
VFS yet. I'm not sure if that would solve these issues or not.<br>
<br>
In Pentaho's BI Platform, we access our schema files using a custom VFS<br>
provider so that it can access our solution repository, so we rely on<br>
VFS.<br>
<br>
Here is a link to Kettle's custom built VFS 2.0 jar if you want to see<br>
if it resolves the issues:<br>
<a href="http://source.pentaho.org/svnkettleroot/Kettle/trunk/libext/commons/commons-vfs-2.0-20090205.jar" target="_blank">http://source.pentaho.org/svnkettleroot/Kettle/trunk/libext/commons/commons-vfs-2.0-20090205.jar</a><br>
<font color="#888888"><br>
Will<br>
</font><div><div></div><div class="h5"><br>
On Fri, 2009-07-17 at 15:08 -0400, Matt Campbell wrote:<br>
> I did do a fair amount of searching when we first encountered this<br>
> problem and couldn't find much helpful information at all. When I get<br>
> a chance I'll see if there is a newer version of VFS.<br>
><br>
> On Fri, Jul 17, 2009 at 2:25 PM, Julian Hyde <<a href="mailto:jhyde@pentaho.com">jhyde@pentaho.com</a>><br>
> wrote:<br>
> Has anyone done a google search for the issue you are<br>
> experiencing? Is there a newer version of VFS that might fix<br>
> the problem?<br>
><br>
> Will, what was the other technology you used?<br>
><br>
> I'm OK with switching technology as long as it doesn't break<br>
> existing apps.<br>
><br>
> Julian<br>
><br>
><br>
> ______________________________________________________<br>
> From: <a href="mailto:mondrian-bounces@pentaho.org">mondrian-bounces@pentaho.org</a><br>
> [mailto:<a href="mailto:mondrian-bounces@pentaho.org">mondrian-bounces@pentaho.org</a>] On Behalf Of<br>
> Matt Campbell<br>
> Sent: Friday, July 17, 2009 8:16 AM<br>
> To: Mondrian developer mailing list<br>
> Subject: [Mondrian] VFS issue<br>
><br>
><br>
><br>
> Awhile back we discovered that Util.readVirtualFile()<br>
> can throw exceptions when large numbers of requests<br>
> for an HTTP resource happen. Awhile back I added a<br>
> call to file.close() at the end of that method, which<br>
> had seemed to make things a bit better in testing.<br>
> I'm still seeing socketConnect exceptions when<br>
> requesting more than a few hundred http requests. In<br>
> practice this can happen when we have as few as 15<br>
> concurrent users running reports.<br>
><br>
> There appears to be no such problem with the pre-VFS<br>
> method that Mondrian used for loading a URL. I<br>
> created a Unit test which loads 100,000 pages via the<br>
> old Util.readURL method. That runs fine with no<br>
> exceptions. The VFS method fails with fewer than 1000<br>
> requests.<br>
><br>
> Would anyone object to reverting back to the old<br>
> Util.readURL for http requests? Alternatively, I<br>
> think Will Gorman said at one point that they<br>
> abandoned VFS for other Pentaho projects in favor of<br>
> some other library--would that be worth considering<br>
> for Mondrian?<br>
><br>
><br>
><br>
><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>
><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>
_______________________________________________<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>
</div></div></blockquote></div><br>