From: S. A. M. L. <sa...@sa...> - 2008-07-29 18:22:23
|
Hi guys, Just wondering if Proxool has been abandoned at all? There haven't been any updates in a very long time, and the 0.x version leaves to believe that the author deemed it incomplete as of its last incarnation. Bill? Cheers. Alex |
From: Tom D. <td...@te...> - 2008-07-29 18:30:59
|
Hi Alex, On Jul 29, 2008, at 1:22 PM, S. Alexandre M. Lemaire wrote: > Just wondering if Proxool has been abandoned at all? There haven’t > been any updates in a very long time, and the 0.x version leaves to > believe that the author deemed it incomplete as of its last > incarnation. Can't speak for the development team but we're using it on a couple projects here and last time I submitted a patch it was accepted OK, although I don't think a new version was ever released... Tom |
From: Bill H. <bi...@lo...> - 2008-07-29 18:41:54
|
Hi Alex, It's not quite dead yet! You're right about the long time since the last update. The 0.x does reflect it not being feature complete but I do consider it stable. Things have moved on a fair bit since we last actively developed it - we haven't looked at compatibility with JDK1.6 for instance. One feature request that comes up every now and again is the ability to queue connections rather than just rejecting them when the maximum connection count is reached. The mailing list, although very quiet, is still monitored. Tom's right - we are still accepting patches and make those available on CVS. Rolling 0.9.0 out the door would take me a couple of hours (mostly to do with updating the website, documentation and building the binaries) and it never quite gets done... I would like to do it but don't think I should make any promises about when it will get done. If anyone feels strongly about getting stuff done then let's talk about it. Most of the time, people don't seem that bothered. Cheers, -- Bill Horsman http://www.logicalcobwebs.com/bill_horsman |
From: Glen P. <gl...@or...> - 2008-07-29 20:19:19
|
We have been using it in production with JRE1.6 for a few months now and it works very well, both in Linux (RHEL and a little bit on Xubuntu) and Windows (XP). We switched from c3p0 to Proxool because we wanted to distribute our product to a customer and couldn't abide by the LGPL. Proxool has all the features (especially the license) we need and has been very stable except for the issue you mention: when too many people connect at once it rejects connections (we only see this during security tests, not under actual load). While we're on the subject, does anyone know what the largest safe value is for jdbc-0.proxool.maximum-connection-count? What's the down-side of setting this to some fairly large value like 4,000? Is this even the right forum for asking such questions? - Glen Peterson On Tue, Jul 29, 2008 at 2:41 PM, Bill Horsman <bi...@lo...> wrote: > Hi Alex, > > It's not quite dead yet! You're right about the long time since the last > update. > > The 0.x does reflect it not being feature complete but I do consider it > stable. Things have moved on a fair bit since we last actively developed it > - we haven't looked at compatibility with JDK1.6 for instance. One feature > request that comes up every now and again is the ability to queue > connections rather than just rejecting them when the maximum connection > count is reached. > > The mailing list, although very quiet, is still monitored. > > Tom's right - we are still accepting patches and make those available on > CVS. Rolling 0.9.0 out the door would take me a couple of hours (mostly to > do with updating the website, documentation and building the binaries) and > it never quite gets done... I would like to do it but don't think I should > make any promises about when it will get done. > > If anyone feels strongly about getting stuff done then let's talk about it. > Most of the time, people don't seem that bothered. > > Cheers, > -- > Bill Horsman > http://www.logicalcobwebs.com/bill_horsman > > ------------------------------------------------------------------------- > This SF.Net email is sponsored by the Moblin Your Move Developer's challenge > Build the coolest Linux based applications with Moblin SDK & win great > prizes > Grand prize is a trip for two to an Open Source event anywhere in the world > http://moblin-contest.org/redirect.php?banner_id=100&url=/ > _______________________________________________ > Proxool-developer mailing list > Pro...@li... > https://lists.sourceforge.net/lists/listinfo/proxool-developer |
From: Bill H. <bi...@lo...> - 2008-07-29 20:26:54
|
Hi Glen, I'm glad Proxool is working well for you. I guess the proxool-user list is the best place for advice about maximum-connection-count, but since you're here... I'd choose a number such that: 1. Your database can cope with the load. There's no point having 4,000 connections if each simple query is going to take several seconds. 2. Your app can take the load too. Even if the database is fantastic and can execute whatever you can throw at it with ease, your app has still got to cope too. That second reason is partly why we made Proxool reject connections when we reached the maximum. We figured that by the time we'd used them all up our app was struggling to keep up and all we wanted to do was quickly respond with a "please try later" message. Otherwise everything ground to a halt. Cheers, -- Bill Horsman http://www.logicalcobwebs.com/bill_horsman |