You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@commons.apache.org by Serge Knystautas <se...@lokitech.com> on 2003/06/23 04:06:08 UTC
DBCP status?
Is anyone working on DBCP or planning another release anytime soon?
It's been almost a year, and the project seems pretty inactive.
I was trying to integrate DBCP into James this weekend to replace my
home-rolled DB connection, and after the fact realized that DBCP cannot
handle database restarts as without a validate SQL statement, DBCP
doesn't realize connections are corrupt and keeps putting them back in
the pool.
Would anyone be interested in me supplying some patches to do some extra
checking, get some examples and documentation straight (I found 3 or 4
different "basic" examples, none of which worked for me)? Are other
Apache projects using DBCP at this point, and is it reasonable to remove
methods that have not been implemented (like setLoginTimeout())?
--
Serge Knystautas
President
Lokitech >> software . strategy . design >> http://www.lokitech.com/
p. 1.301.656.5501
e. sergek@lokitech.com
---------------------------------------------------------------------
To unsubscribe, e-mail: commons-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-dev-help@jakarta.apache.org
Re: DBCP status?
Posted by Martin Cooper <ma...@apache.org>.
On Mon, 23 Jun 2003, Serge Knystautas wrote:
> Mark Lewis wrote:
> > Serge,
> >
> > I'm using DBCP in a production environment. It actually does support
> > validation queries to detect whether a connection is bogus or not.
>
> Yes, but that doubles the # of SQL statements. And I actually have
> probably no more than 8 SQL statements in total (all prepared), so the
> issue is not the SQL but the connection.
>
> > I can provide sample code if you'd like. But like David said earlier,
> > DBCP is pretty much a dead project. It works well enough for my needs,
> > but I'm not sure I'd integrate it into a project right now.
>
> Do you know of anything else in Apache that could handle this? Anybody
> know what Tomcat is using at this point?
This isn't an Apache project (although one of the admins is an Apache guy
;), but you might want to look at PoolMan:
http://sourceforge.net/projects/poolman/
--
Martin Cooper
>
> > On a related note, does anybody know what the status of
> > PreparedStatement pooling is in the latest DBCP release? It seems
> > broken to me, but I might be doing something wrong.
>
> We'd like that feature as well (since like I say we have so few SQL
> statements), but that's a bummer if it's broken. From the API it seems
> like it would work.
>
> --
> Serge Knystautas
> President
> Lokitech >> software . strategy . design >> http://www.lokitech.com
> p. 301.656.5501
> e. sergek@lokitech.com
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: commons-dev-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: commons-dev-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: commons-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-dev-help@jakarta.apache.org
Re: DBCP status?
Posted by Serge Knystautas <se...@lokitech.com>.
Mark Lewis wrote:
> Serge,
>
> I'm using DBCP in a production environment. It actually does support
> validation queries to detect whether a connection is bogus or not.
Yes, but that doubles the # of SQL statements. And I actually have
probably no more than 8 SQL statements in total (all prepared), so the
issue is not the SQL but the connection.
> I can provide sample code if you'd like. But like David said earlier,
> DBCP is pretty much a dead project. It works well enough for my needs,
> but I'm not sure I'd integrate it into a project right now.
Do you know of anything else in Apache that could handle this? Anybody
know what Tomcat is using at this point?
> On a related note, does anybody know what the status of
> PreparedStatement pooling is in the latest DBCP release? It seems
> broken to me, but I might be doing something wrong.
We'd like that feature as well (since like I say we have so few SQL
statements), but that's a bummer if it's broken. From the API it seems
like it would work.
--
Serge Knystautas
President
Lokitech >> software . strategy . design >> http://www.lokitech.com
p. 301.656.5501
e. sergek@lokitech.com
---------------------------------------------------------------------
To unsubscribe, e-mail: commons-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-dev-help@jakarta.apache.org
Re: DBCP status?
Posted by Mark Lewis <ma...@mir3.com>.
Serge,
I'm using DBCP in a production environment. It actually does support
validation queries to detect whether a connection is bogus or not.
You just need to call setValidationQuery() on the
PoolableConnectionFactory, and enable testOnBorrow on the ObjectPool you
pass to the DBCP init stuff.
I can provide sample code if you'd like. But like David said earlier,
DBCP is pretty much a dead project. It works well enough for my needs,
but I'm not sure I'd integrate it into a project right now.
On a related note, does anybody know what the status of
PreparedStatement pooling is in the latest DBCP release? It seems
broken to me, but I might be doing something wrong.
-- Mark Lewis
On Sun, 2003-06-22 at 19:06, Serge Knystautas wrote:
> Is anyone working on DBCP or planning another release anytime soon?
> It's been almost a year, and the project seems pretty inactive.
>
> I was trying to integrate DBCP into James this weekend to replace my
> home-rolled DB connection, and after the fact realized that DBCP cannot
> handle database restarts as without a validate SQL statement, DBCP
> doesn't realize connections are corrupt and keeps putting them back in
> the pool.
>
> Would anyone be interested in me supplying some patches to do some extra
> checking, get some examples and documentation straight (I found 3 or 4
> different "basic" examples, none of which worked for me)? Are other
> Apache projects using DBCP at this point, and is it reasonable to remove
> methods that have not been implemented (like setLoginTimeout())?
---------------------------------------------------------------------
To unsubscribe, e-mail: commons-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-dev-help@jakarta.apache.org
Re: jdbc2pool [was Re: DBCP status?]
Posted by Anton Tagunov <at...@mail.cnt.ru>.
Hello John!
I do think I see certain (serious) issues
with the code, and I have started to compose
a comprehensive mail on this, but let us
please first discuss the
"[dbcp] Do we need Referenceable?"
thread I'm starting now as the outcome
of the discussion will influence greatly
what my advice on improving jdbc2 will be.
Okay?
Please expect my detailed answer to your
mail in several days, a week at most.
- Anton
AT> Have looked a couple of weeks ago
AT> * jdbc2 part seemed out of operation to me (just can't go into a release)
JM> I've seen a couple statements like this. No one presents any reasons
JM> for their statement though. I started this pool and use it in
JM> production, so have dual interest in hearing what the problems are. I
JM> see one bug entered against it, but I would not classify it as a
JM> blocker.
---------------------------------------------------------------------
To unsubscribe, e-mail: commons-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-dev-help@jakarta.apache.org
jdbc2pool [was Re: DBCP status?]
Posted by John McNally <jm...@collab.net>.
>
> Have looked a couple of weeks ago
> * jdbc2 part seemed out of operation to me (just can't go into a release)
I've seen a couple statements like this. No one presents any reasons
for their statement though. I started this pool and use it in
production, so have dual interest in hearing what the problems are. I
see one bug entered against it, but I would not classify it as a
blocker.
john mcnally
---------------------------------------------------------------------
To unsubscribe, e-mail: commons-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-dev-help@jakarta.apache.org
Re: DBCP status?
Posted by Anton Tagunov <at...@mail.cnt.ru>.
Hello Serge!
SK> Is anyone working on DBCP or planning another release anytime soon?
SK> It's been almost a year, and the project seems pretty inactive.
Lurker's 0.02$
Have looked a couple of weeks ago
* jdbc2 part seemed out of operation to me (just can't go into a release)
* all the rest probably can (haven't investigated closely)
- Anton
---------------------------------------------------------------------
To unsubscribe, e-mail: commons-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-dev-help@jakarta.apache.org